To locate productstores on the basis of the postalcode given

[Vikas Gupta-7]

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

[David E Jones-3]

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

[Vikas Gupta-7]

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
>

[David E Jones-3]

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
>>
>

[Vikas Gupta-7]

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
>>>
>>
>

[David E Jones-3]

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
>>>>
>>>
>>
>

[BJ Freeman]

-----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-----

[Bilgin Ibryam]

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