You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Vikas Gupta <vi...@hotwaxmedia.com> on 2009/03/24 15:31:36 UTC
To locate productstores on the basis of the postalcode given
Hello All,
Facility entity has its ownerPartyId. A facility can have many
ProductStores. I need to get postal address of the ProductStore. I think
Postal address can be got through ContactMech, but that again would
require PartyId. Is it possible that different ProductStores have
different ownerPartyIds, so that I could have respective PostalAddresses
for these productstores. Productstore entity has payToPartyId and not
any ownerPartyId.
Please suggest me, I want to locate productstores on the basis of the
postalcode given.
Thanks,
--
Vikas Gupta
Re: To locate productstores on the basis of the postalcode given
Posted by BJ Freeman <bj...@free-man.net>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
The only step that may be missing is how to look up the POS terminal
which has its own productstore.
if you have followed
http://docs.ofbiz.org/display/OFBIZ/POS+System
This of course is if you have a configuration similar to
http://docs.ofbiz.org/display/OFBTECH/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-POSSetupProcess
http://docs.ofbiz.org/display/OFBIZ/Sync+Setup+Notes+and+Example
and you looking up data in the Master Central Server (MCS)
you can find the productstore for the Per-Store Server (PSS)
Vikas Gupta sent the following on 3/26/2009 10:32 AM:
> Hello David,
>
> Yes, the physical stores using OFBiz for their POS system. But how I can
> locate these productstores on the basis of the postalcode given.
>
> Regards
> --
> Vikas
>
> David E Jones wrote:
>>
>> Are the physical stores using OFBiz for their POS system? If so then
>> it makes sense to have a ProductStore record for each, otherwise it
>> doesn't really make any sense at all... they would just be Facility
>> records.
>>
>> If you have a Facility record for each location you can just use the
>> FacilityContactMech to go directly from the Facility to its address.
>>
>> -David
>>
>>
>> On Mar 25, 2009, at 12:05 AM, Vikas Gupta wrote:
>>
>>> Hello David,
>>>
>>> Thanks for considering my problem.
>>>
>>> Yes Sure, I am talking about physical retail stores. A facility can
>>> have different physical productstores (retailers) which are locating
>>> at different places. My case is this, there are many retailers over
>>> different places and having their respective owners. These retail
>>> stores should be searched on the basis of postal code given of that
>>> area, like "how many retail stores (belonging to a particular
>>> facility) are available corresponding to given postal code". But I
>>> could not find any attribute in ProductStore entity to serve my purpose.
>>>
>>> So, please tell me how I can associate ProductStores with their
>>> different owners or postal address.
>>>
>>> Regards,
>>> --
>>> Vikas Gupta
>>>
>>> David E Jones wrote:
>>>>
>>>> There are certainly structures in place for this sort of thing, but
>>>> the detail here is not sufficient to select one.
>>>>
>>>> To start out... Are you talking about physical stores (like a
>>>> physical retail store), or are you talking about different ecommerce
>>>> stores that serve different parts of the world?
>>>>
>>>> The main point is, you have to have the business case really solid
>>>> before you start doing any sort of design or gap analysis with
>>>> existing software. Without that, it's like a casual conversation
>>>> over dinner and you can't expect any rubber to hit the road.
>>>>
>>>> -David
>>>>
>>>>
>>>> On Mar 24, 2009, at 8:31 AM, Vikas Gupta wrote:
>>>>
>>>>> Hello All,
>>>>> Facility entity has its ownerPartyId. A facility can have
>>>>> many ProductStores. I need to get postal address of the
>>>>> ProductStore. I think Postal address can be got through
>>>>> ContactMech, but that again would require PartyId. Is it possible
>>>>> that different ProductStores have different ownerPartyIds, so that
>>>>> I could have respective PostalAddresses for these productstores.
>>>>> Productstore entity has payToPartyId and not any ownerPartyId.
>>>>>
>>>>> Please suggest me, I want to locate productstores on the basis of
>>>>> the postalcode given.
>>>>>
>>>>>
>>>>> Thanks,
>>>>> --
>>>>> Vikas Gupta
>>>>
>>>
>>
>
>
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFJy8Y6rP3NbaWWqE4RAkhlAJ4ug53R7znpnO6ffTQnWRbLrr171ACcD6Rr
0ZnKSpLe1Veug+kU5C9sj0k=
=bSXc
-----END PGP SIGNATURE-----
Re: To locate productstores on the basis of the postalcode given
Posted by Bilgin Ibryam <bi...@iguanait.com>.
On Mar 26, 2009, at 7:32 PM, Vikas Gupta wrote:
> Yes, the physical stores using OFBiz for their POS system. But how I
> can locate these productstores on the basis of the postalcode given.
You can create one main facility for the whole building or floor and
child facilities with contact mechs for every pos store.
These child facilities may represent the rooms or the areas (if there
are no rooms) for the store.
Bilgin
Re: To locate productstores on the basis of the postalcode given
Posted by David E Jones <da...@hotwaxmedia.com>.
Vikas,
You really need to take a peek at the data model. I think this is to
the point where the general information I've offered is enough to take
the next step, but instead of trying that yourself you seem to want to
ask questions here. There is nothing "bad" about that, but in general
the better researched your question is, and the more detail you offer,
the more likely someone will be able to help you. You may have noticed
that this back-and-forth between us could go on for a LONG time with
me guessing at questions one at a time based on your answers.
On the ProductStore there is a facilityId that is used when the
ProductStore represents a physical store, and physical locations are
represented in OFBiz using the Facility entity (that's a basic data
model thing, see The Data Model Resource Book, Revised Edition, Volume
1 for more info about this concept).
With that and what I wrote before about the Facility you should have
all you need to go from the ProductStore to a ContactMech.
-David
On Mar 26, 2009, at 11:32 AM, Vikas Gupta wrote:
> Hello David,
>
> Yes, the physical stores using OFBiz for their POS system. But how I
> can locate these productstores on the basis of the postalcode given.
>
> Regards
> --
> Vikas
>
> David E Jones wrote:
>>
>> Are the physical stores using OFBiz for their POS system? If so
>> then it makes sense to have a ProductStore record for each,
>> otherwise it doesn't really make any sense at all... they would
>> just be Facility records.
>>
>> If you have a Facility record for each location you can just use
>> the FacilityContactMech to go directly from the Facility to its
>> address.
>>
>> -David
>>
>>
>> On Mar 25, 2009, at 12:05 AM, Vikas Gupta wrote:
>>
>>> Hello David,
>>>
>>> Thanks for considering my problem.
>>>
>>> Yes Sure, I am talking about physical retail stores. A facility
>>> can have different physical productstores (retailers) which are
>>> locating at different places. My case is this, there are many
>>> retailers over different places and having their respective
>>> owners. These retail stores should be searched on the basis of
>>> postal code given of that area, like "how many retail stores
>>> (belonging to a particular facility) are available corresponding
>>> to given postal code". But I could not find any attribute in
>>> ProductStore entity to serve my purpose.
>>>
>>> So, please tell me how I can associate ProductStores with their
>>> different owners or postal address.
>>>
>>> Regards,
>>> --
>>> Vikas Gupta
>>>
>>> David E Jones wrote:
>>>>
>>>> There are certainly structures in place for this sort of thing,
>>>> but the detail here is not sufficient to select one.
>>>>
>>>> To start out... Are you talking about physical stores (like a
>>>> physical retail store), or are you talking about different
>>>> ecommerce stores that serve different parts of the world?
>>>>
>>>> The main point is, you have to have the business case really
>>>> solid before you start doing any sort of design or gap analysis
>>>> with existing software. Without that, it's like a casual
>>>> conversation over dinner and you can't expect any rubber to hit
>>>> the road.
>>>>
>>>> -David
>>>>
>>>>
>>>> On Mar 24, 2009, at 8:31 AM, Vikas Gupta wrote:
>>>>
>>>>> Hello All,
>>>>> Facility entity has its ownerPartyId. A facility can have
>>>>> many ProductStores. I need to get postal address of the
>>>>> ProductStore. I think Postal address can be got through
>>>>> ContactMech, but that again would require PartyId. Is it
>>>>> possible that different ProductStores have different
>>>>> ownerPartyIds, so that I could have respective PostalAddresses
>>>>> for these productstores. Productstore entity has payToPartyId
>>>>> and not any ownerPartyId.
>>>>>
>>>>> Please suggest me, I want to locate productstores on the basis
>>>>> of the postalcode given.
>>>>>
>>>>>
>>>>> Thanks,
>>>>> --
>>>>> Vikas Gupta
>>>>
>>>
>>
>
Re: To locate productstores on the basis of the postalcode given
Posted by Vikas Gupta <vi...@hotwaxmedia.com>.
Hello David,
Yes, the physical stores using OFBiz for their POS system. But how I can
locate these productstores on the basis of the postalcode given.
Regards
--
Vikas
David E Jones wrote:
>
> Are the physical stores using OFBiz for their POS system? If so then
> it makes sense to have a ProductStore record for each, otherwise it
> doesn't really make any sense at all... they would just be Facility
> records.
>
> If you have a Facility record for each location you can just use the
> FacilityContactMech to go directly from the Facility to its address.
>
> -David
>
>
> On Mar 25, 2009, at 12:05 AM, Vikas Gupta wrote:
>
>> Hello David,
>>
>> Thanks for considering my problem.
>>
>> Yes Sure, I am talking about physical retail stores. A facility can
>> have different physical productstores (retailers) which are locating
>> at different places. My case is this, there are many retailers over
>> different places and having their respective owners. These retail
>> stores should be searched on the basis of postal code given of that
>> area, like "how many retail stores (belonging to a particular
>> facility) are available corresponding to given postal code". But I
>> could not find any attribute in ProductStore entity to serve my purpose.
>>
>> So, please tell me how I can associate ProductStores with their
>> different owners or postal address.
>>
>> Regards,
>> --
>> Vikas Gupta
>>
>> David E Jones wrote:
>>>
>>> There are certainly structures in place for this sort of thing, but
>>> the detail here is not sufficient to select one.
>>>
>>> To start out... Are you talking about physical stores (like a
>>> physical retail store), or are you talking about different ecommerce
>>> stores that serve different parts of the world?
>>>
>>> The main point is, you have to have the business case really solid
>>> before you start doing any sort of design or gap analysis with
>>> existing software. Without that, it's like a casual conversation
>>> over dinner and you can't expect any rubber to hit the road.
>>>
>>> -David
>>>
>>>
>>> On Mar 24, 2009, at 8:31 AM, Vikas Gupta wrote:
>>>
>>>> Hello All,
>>>> Facility entity has its ownerPartyId. A facility can have
>>>> many ProductStores. I need to get postal address of the
>>>> ProductStore. I think Postal address can be got through
>>>> ContactMech, but that again would require PartyId. Is it possible
>>>> that different ProductStores have different ownerPartyIds, so that
>>>> I could have respective PostalAddresses for these productstores.
>>>> Productstore entity has payToPartyId and not any ownerPartyId.
>>>>
>>>> Please suggest me, I want to locate productstores on the basis of
>>>> the postalcode given.
>>>>
>>>>
>>>> Thanks,
>>>> --
>>>> Vikas Gupta
>>>
>>
>
Re: To locate productstores on the basis of the postalcode given
Posted by David E Jones <da...@hotwaxmedia.com>.
Are the physical stores using OFBiz for their POS system? If so then
it makes sense to have a ProductStore record for each, otherwise it
doesn't really make any sense at all... they would just be Facility
records.
If you have a Facility record for each location you can just use the
FacilityContactMech to go directly from the Facility to its address.
-David
On Mar 25, 2009, at 12:05 AM, Vikas Gupta wrote:
> Hello David,
>
> Thanks for considering my problem.
>
> Yes Sure, I am talking about physical retail stores. A facility can
> have different physical productstores (retailers) which are locating
> at different places. My case is this, there are many retailers over
> different places and having their respective owners. These retail
> stores should be searched on the basis of postal code given of that
> area, like "how many retail stores (belonging to a particular
> facility) are available corresponding to given postal code". But I
> could not find any attribute in ProductStore entity to serve my
> purpose.
>
> So, please tell me how I can associate ProductStores with their
> different owners or postal address.
>
> Regards,
> --
> Vikas Gupta
>
> David E Jones wrote:
>>
>> There are certainly structures in place for this sort of thing, but
>> the detail here is not sufficient to select one.
>>
>> To start out... Are you talking about physical stores (like a
>> physical retail store), or are you talking about different
>> ecommerce stores that serve different parts of the world?
>>
>> The main point is, you have to have the business case really solid
>> before you start doing any sort of design or gap analysis with
>> existing software. Without that, it's like a casual conversation
>> over dinner and you can't expect any rubber to hit the road.
>>
>> -David
>>
>>
>> On Mar 24, 2009, at 8:31 AM, Vikas Gupta wrote:
>>
>>> Hello All,
>>> Facility entity has its ownerPartyId. A facility can have
>>> many ProductStores. I need to get postal address of the
>>> ProductStore. I think Postal address can be got through
>>> ContactMech, but that again would require PartyId. Is it possible
>>> that different ProductStores have different ownerPartyIds, so that
>>> I could have respective PostalAddresses for these productstores.
>>> Productstore entity has payToPartyId and not any ownerPartyId.
>>>
>>> Please suggest me, I want to locate productstores on the basis of
>>> the postalcode given.
>>>
>>>
>>> Thanks,
>>> --
>>> Vikas Gupta
>>
>
Re: To locate productstores on the basis of the postalcode given
Posted by Vikas Gupta <vi...@hotwaxmedia.com>.
Hello David,
Thanks for considering my problem.
Yes Sure, I am talking about physical retail stores. A facility can have
different physical productstores (retailers) which are locating at
different places. My case is this, there are many retailers over
different places and having their respective owners. These retail stores
should be searched on the basis of postal code given of that area, like
"how many retail stores (belonging to a particular facility) are
available corresponding to given postal code". But I could not find any
attribute in ProductStore entity to serve my purpose.
So, please tell me how I can associate ProductStores with their
different owners or postal address.
Regards,
--
Vikas Gupta
David E Jones wrote:
>
> There are certainly structures in place for this sort of thing, but
> the detail here is not sufficient to select one.
>
> To start out... Are you talking about physical stores (like a physical
> retail store), or are you talking about different ecommerce stores
> that serve different parts of the world?
>
> The main point is, you have to have the business case really solid
> before you start doing any sort of design or gap analysis with
> existing software. Without that, it's like a casual conversation over
> dinner and you can't expect any rubber to hit the road.
>
> -David
>
>
> On Mar 24, 2009, at 8:31 AM, Vikas Gupta wrote:
>
>> Hello All,
>> Facility entity has its ownerPartyId. A facility can have
>> many ProductStores. I need to get postal address of the ProductStore.
>> I think Postal address can be got through ContactMech, but that again
>> would require PartyId. Is it possible that different ProductStores
>> have different ownerPartyIds, so that I could have respective
>> PostalAddresses for these productstores. Productstore entity has
>> payToPartyId and not any ownerPartyId.
>>
>> Please suggest me, I want to locate productstores on the basis of the
>> postalcode given.
>>
>>
>> Thanks,
>> --
>> Vikas Gupta
>
Re: To locate productstores on the basis of the postalcode given
Posted by David E Jones <da...@hotwaxmedia.com>.
There are certainly structures in place for this sort of thing, but
the detail here is not sufficient to select one.
To start out... Are you talking about physical stores (like a physical
retail store), or are you talking about different ecommerce stores
that serve different parts of the world?
The main point is, you have to have the business case really solid
before you start doing any sort of design or gap analysis with
existing software. Without that, it's like a casual conversation over
dinner and you can't expect any rubber to hit the road.
-David
On Mar 24, 2009, at 8:31 AM, Vikas Gupta wrote:
> Hello All,
> Facility entity has its ownerPartyId. A facility can have
> many ProductStores. I need to get postal address of the
> ProductStore. I think Postal address can be got through ContactMech,
> but that again would require PartyId. Is it possible that different
> ProductStores have different ownerPartyIds, so that I could have
> respective PostalAddresses for these productstores. Productstore
> entity has payToPartyId and not any ownerPartyId.
>
> Please suggest me, I want to locate productstores on the basis of
> the postalcode given.
>
>
> Thanks,
> --
> Vikas Gupta