You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Bs Serge <se...@gmail.com> on 2021/10/25 14:29:44 UTC
Product and Store Relationship
Hi,
I was browsing through the catalog module and I could not find any product
and store relationship.
I would assume products are supposed to belong in a certain store!
Kindly enlighten me on how OFBiz handles products and stores relationships,
or point me to a link that explains it.
Thanks,
Best Regards,
Re: Product and Store Relationship
Posted by Bs Serge <se...@gmail.com>.
Hi Giulio,
Thank you soo much, the PHYSICAL INVENTORY makes it so easy I didn't know
it,
but also after ordering the product, I went to the created order page at
the right sidebar "Actions" and clicked "Quick Ship Order" and then a
shipment was created with a "shipped" status and the inventory *QOH* was
changed also with *AQT.*
I can not thank you enough guys, I owe you a beer or something :))
Best Regards,
On Wed, Oct 27, 2021 at 6:56 PM Giulio Speri - MpStyle Srl <
giulio.speri@mpstyle.it> wrote:
> Hello Serge,
>
> stock availability of products are defined by InventoryItem entity.
> An InventoryItem object can be created for a product from the INVENTORY tab
> of the target product and click on "Create new Inventory Item for this
> product" button in the lower panel of the screen (the one named "Inventory
> Items for ....").
>
> Stock is handled by two fields of this InventoryItem object:
> availableToPromiseTotal (also referred as ATP) and quantityOnHandTotal
> (QOH).
> The value of quantityOnHandTotal is the number of products you
> physically have in your warehouse regardless of how many of them are
> effectively available to customers for orders.
> The value of availableToPromiseTotal is, in short, the quantityOnHandTotal
> minus product reserved in other sales orders.
>
> For example:
> I have a product A with initial ATP/QOH of 2.
> A customer places a sales order of 1 quantity: the moment the order is
> created, the ATP value of the product is lowered by 1 (the quantity of the
> order) and that means that another 1 piece is available for a sales order.
> Until the order is "open" (created/approved) state the QOH is not changed:
> it will be updated in the moment you complete/ship the order.
>
> This is in short and in a very simple way an explanation of how stock is
> managed for sales orders in OFBiz.
>
> An InventoryItem is related to a Facility through a specific field
> *facilityId* : that is used to indicate that a specific product is
> available in a certain facility.
>
> To put stock in an InventoryItem, you can use the OOTB functionality
> provided in the PHYSICAL INVENTORY tab of Facility Manager, where you
> search for a specific product and then commit a plus or minus movement for
> ATP/QOH on an inventory item object.
>
> A Facility then is associated with a ProductStore and with this relation,
> orders placed on that store will reserve inventory from that facility
> (still here I simplified the thing).
>
> InventoryItem handling could be quite tricky, but I hope I gave you a good
> sight on how they work.
> As Micheal suggested, in the DataModel resource book you can find more
> details on how this entity was thinked.
>
> Regards,
> Giulio
>
> Il giorno mer 27 ott 2021 alle ore 18:13 Bs Serge <se...@gmail.com> ha
> scritto:
>
> > Hi Michael,
> >
> > These data models are amazing! You are a lifesaver! and I think I got my
> > answer!
> >
> > I hope this is my last question : How do you define how many products are
> > available in stock?
> >
> > Thank you again!
> >
> > Best Regards,
> >
> > On Tue, Oct 26, 2021 at 9:01 PM Michael Brohl <mi...@ecomify.de>
> > wrote:
> >
> > > Hi,
> > >
> > > in addition to the other recommendations, I strongly recommend to have
> a
> > > look at the OFBiz data model book which shows the data model in-depth.
> > >
> > > See
> > https://cwiki.apache.org/confluence/display/OFBIZ/Data+Model+Diagrams
> > >
> > > There you will see that the products are mapped to the ProductCategory
> > > through the ProductCategoryMember entity. The category structure is
> > > build by the productCategoryRollup entities and the top-most category
> is
> > > mapped to the ProdCatalog through ProdCatalogCategory and finally the
> > > ProdCatalog ist mapped to the productStore through ProductStoreCatalog.
> > >
> > > While you can reuse categories with different roll-ups, you cannot have
> > > the SAME category containing other products when used with another
> > > ProductStore.
> > >
> > > You surely can build up a SIMILAR category structure twice and map this
> > > to the catalog/store to achieve your goal.
> > >
> > > Best regards,
> > >
> > > Michael Brohl
> > >
> > > ecomify GmbH - www.ecomify.de
> > >
> > >
> > > Am 26.10.21 um 18:56 schrieb Bs Serge:
> > > > Thank you Jacques for the link,
> > > >
> > > > Kindly, can different stores use the same category structure with
> > > different
> > > > products, Or do categories have to be created for each store?
> > > >
> > > > Thanks again
> > > >
> > > > Best Regards,
> > > >
> > > >
> > > > On Tue, Oct 26, 2021 at 1:36 PM Jacques Le Roux <
> > > > jacques.le.roux@les7arts.com> wrote:
> > > >
> > > >> Hi Serge,
> > > >>
> > > >> This is old and in French, but I think it can still help
> > > >>
> > > >>
> > > >>
> > >
> >
> http://www.les7arts.com/assist/OFBiz/Creation%20Catalogue%20de%20produits.htm#_bookmark_551a190
> > > >>
> > > >> Jacques
> > > >>
> > > >> Le 26/10/2021 à 11:48, Bs Serge a écrit :
> > > >>> Lastly and most importantly I'd like to ask,
> > > >>>
> > > >>> Can different stores have the same category structure but with
> > > different
> > > >>> products?
> > > >>>
> > > >>> Best Regards,
> > > >>>
> > > >>> On Tue, Oct 26, 2021 at 11:04 AM Bs Serge <se...@gmail.com>
> > wrote:
> > > >>>
> > > >>>> Hi Giulio,
> > > >>>>
> > > >>>> You have been more than helpful to help me understand this,
> > > >>>>
> > > >>>> Regarding the “Browser Root”, it seems like there are different
> > > Product
> > > >>>> Category Types (Best Selling, Catalog, Search, …) which I see
> > defines
> > > >> the
> > > >>>> categories that are directly linked to catalogs in different
> Product
> > > >>>> Catalog Category Types (Browser Root, Promotion, Quick Add,
> Default
> > > >> Search)
> > > >>>> For Example in the “Demo Catalog”, in its Categories, there is a
> > > >> category
> > > >>>> called “CATALOG1” of Browser Root, and that category is of Product
> > > >> Category
> > > >>>> Type “Catalog”, and I see it act as a parent of two other
> categories
> > > of
> > > >> Ids
> > > >>>> 100 and 200 which both are also of Category Type “Catalog”, which
> > goes
> > > >> on
> > > >>>> to create a Tree of categories
> > > >>>>
> > > >>>> Does it mean that the Product Category Type of Catalog is also
> like
> > a
> > > >>>> group of categories per se ,.. ?
> > > >>>>
> > > >>>> If so, one would directly wonder what is the role of other Product
> > > >>>> Category Types (Best Selling, Search, Tax, Quick Add, Google Base,
> > > >>>> Industry, Internal, ... )?
> > > >>>>
> > > >>>> Thank you again,
> > > >>>>
> > > >>>> Best Regards,
> > > >>>>
> > > >>>> On Mon, Oct 25, 2021 at 7:20 PM Giulio Speri - MpStyle Srl <
> > > >>>> giulio.speri@mpstyle.it> wrote:
> > > >>>>
> > > >>>>> Hello Serge,
> > > >>>>>
> > > >>>>> in OFBiz there is not a direct association between a ProductStore
> > and
> > > >>>>> products, instead ProdCatalog, ProdCatalogCategory,
> > > >> ProductStoreCatalog,
> > > >>>>> ProductCategory and ProductCategoryMember entities are used to
> > > achieve
> > > >>>>> this
> > > >>>>> goal.
> > > >>>>>
> > > >>>>> You can see the ProdCatalog as a collector of categories: the one
> > > that
> > > >> is
> > > >>>>> physically associated with a product store is the ProdCatalog
> > through
> > > >> the
> > > >>>>> entity ProductStoreCatalog.
> > > >>>>> A product catalog is composed by a hierarchy of categories where
> > the
> > > >> first
> > > >>>>> (root category) always has to be of type "Browse Root"
> > > >> (PCCT_BROWSE_ROOT).
> > > >>>>> This is managed by the entity ProdCatalogCategory.
> > > >>>>> Under the "Browse Root" category you can then build your own
> custom
> > > >>>>> hierarchy of product categories and associate the product to each
> > one
> > > >> of
> > > >>>>> it; ProductCategory is the entity used to define a category and a
> > > >> product
> > > >>>>> is associated to a specific category through the entity
> > > >>>>> ProductCategoryMember.
> > > >>>>>
> > > >>>>> *In short*:
> > > >>>>>
> > > >>>>> ProductStore/Catalog assoc : ProductStore -> ProdCatalog ->
> > > >>>>> ProductCatalogCategory (Browse Root)
> > > >>>>>
> > > >>>>> Browse Root Category/Product categories:
> > > >>>>> - ProductCategory (Browse Root)
> > > >>>>> -- productCategory_1 -> Products (through
> > ProductCategoryMember);
> > > >>>>> -- productCategory_2 -> Products;
> > > >>>>> ---productSubCategory_2_1 -> Products;
> > > >>>>> ---productSubCategory_2_2 -> Products;
> > > >>>>> -- productCategory_3 -> Products;
> > > >>>>>
> > > >>>>> In the online backend demo of OFBiz you can start following this
> > > >> structure
> > > >>>>> from the Catalog Manager -> Stores, pick up a store and then open
> > the
> > > >> tab
> > > >>>>> "CATALOGS".
> > > >>>>> You will find different examples of stores and catalogs with
> > > different
> > > >>>>> categories associated, that can give you a good starting point on
> > the
> > > >>>>> store/catalog/category/product OOTB mechanism.
> > > >>>>>
> > > >>>>> I hope I have been helpful.
> > > >>>>>
> > > >>>>> Kind Regards,
> > > >>>>> Giulio
> > > >>>>>
> > > >>>>> Il giorno lun 25 ott 2021 alle ore 16:30 Bs Serge <
> > > sergebs10@gmail.com
> > > >>>>> ha
> > > >>>>> scritto:
> > > >>>>>
> > > >>>>>> Hi,
> > > >>>>>>
> > > >>>>>> I was browsing through the catalog module and I could not find
> any
> > > >>>>> product
> > > >>>>>> and store relationship.
> > > >>>>>>
> > > >>>>>> I would assume products are supposed to belong in a certain
> store!
> > > >>>>>>
> > > >>>>>> Kindly enlighten me on how OFBiz handles products and stores
> > > >>>>> relationships,
> > > >>>>>> or point me to a link that explains it.
> > > >>>>>>
> > > >>>>>> Thanks,
> > > >>>>>>
> > > >>>>>> Best Regards,
> > > >>>>>>
> > > >>>>> --
> > > >>>>> Giulio Speri
> > > >>>>>
> > > >>>>>
> > > >>>>> *Mp Styl**e Srl*
> > > >>>>> via Antonio Meucci, 37
> > > >>>>> 41019 Limidi di Soliera (MO)
> > > >>>>> T 059/684916
> > > >>>>> M 347/0965506
> > > >>>>>
> > > >>>>> www.mpstyle.it
> > > >>>>>
> > >
> >
>
>
> --
> Giulio Speri
>
>
> *Mp Styl**e Srl*
> via Antonio Meucci, 37
> 41019 Limidi di Soliera (MO)
> T 059/684916
> M 347/0965506
>
> www.mpstyle.it
>
Re: Product and Store Relationship
Posted by Giulio Speri - MpStyle Srl <gi...@mpstyle.it>.
Hello Serge,
stock availability of products are defined by InventoryItem entity.
An InventoryItem object can be created for a product from the INVENTORY tab
of the target product and click on "Create new Inventory Item for this
product" button in the lower panel of the screen (the one named "Inventory
Items for ....").
Stock is handled by two fields of this InventoryItem object:
availableToPromiseTotal (also referred as ATP) and quantityOnHandTotal
(QOH).
The value of quantityOnHandTotal is the number of products you
physically have in your warehouse regardless of how many of them are
effectively available to customers for orders.
The value of availableToPromiseTotal is, in short, the quantityOnHandTotal
minus product reserved in other sales orders.
For example:
I have a product A with initial ATP/QOH of 2.
A customer places a sales order of 1 quantity: the moment the order is
created, the ATP value of the product is lowered by 1 (the quantity of the
order) and that means that another 1 piece is available for a sales order.
Until the order is "open" (created/approved) state the QOH is not changed:
it will be updated in the moment you complete/ship the order.
This is in short and in a very simple way an explanation of how stock is
managed for sales orders in OFBiz.
An InventoryItem is related to a Facility through a specific field
*facilityId* : that is used to indicate that a specific product is
available in a certain facility.
To put stock in an InventoryItem, you can use the OOTB functionality
provided in the PHYSICAL INVENTORY tab of Facility Manager, where you
search for a specific product and then commit a plus or minus movement for
ATP/QOH on an inventory item object.
A Facility then is associated with a ProductStore and with this relation,
orders placed on that store will reserve inventory from that facility
(still here I simplified the thing).
InventoryItem handling could be quite tricky, but I hope I gave you a good
sight on how they work.
As Micheal suggested, in the DataModel resource book you can find more
details on how this entity was thinked.
Regards,
Giulio
Il giorno mer 27 ott 2021 alle ore 18:13 Bs Serge <se...@gmail.com> ha
scritto:
> Hi Michael,
>
> These data models are amazing! You are a lifesaver! and I think I got my
> answer!
>
> I hope this is my last question : How do you define how many products are
> available in stock?
>
> Thank you again!
>
> Best Regards,
>
> On Tue, Oct 26, 2021 at 9:01 PM Michael Brohl <mi...@ecomify.de>
> wrote:
>
> > Hi,
> >
> > in addition to the other recommendations, I strongly recommend to have a
> > look at the OFBiz data model book which shows the data model in-depth.
> >
> > See
> https://cwiki.apache.org/confluence/display/OFBIZ/Data+Model+Diagrams
> >
> > There you will see that the products are mapped to the ProductCategory
> > through the ProductCategoryMember entity. The category structure is
> > build by the productCategoryRollup entities and the top-most category is
> > mapped to the ProdCatalog through ProdCatalogCategory and finally the
> > ProdCatalog ist mapped to the productStore through ProductStoreCatalog.
> >
> > While you can reuse categories with different roll-ups, you cannot have
> > the SAME category containing other products when used with another
> > ProductStore.
> >
> > You surely can build up a SIMILAR category structure twice and map this
> > to the catalog/store to achieve your goal.
> >
> > Best regards,
> >
> > Michael Brohl
> >
> > ecomify GmbH - www.ecomify.de
> >
> >
> > Am 26.10.21 um 18:56 schrieb Bs Serge:
> > > Thank you Jacques for the link,
> > >
> > > Kindly, can different stores use the same category structure with
> > different
> > > products, Or do categories have to be created for each store?
> > >
> > > Thanks again
> > >
> > > Best Regards,
> > >
> > >
> > > On Tue, Oct 26, 2021 at 1:36 PM Jacques Le Roux <
> > > jacques.le.roux@les7arts.com> wrote:
> > >
> > >> Hi Serge,
> > >>
> > >> This is old and in French, but I think it can still help
> > >>
> > >>
> > >>
> >
> http://www.les7arts.com/assist/OFBiz/Creation%20Catalogue%20de%20produits.htm#_bookmark_551a190
> > >>
> > >> Jacques
> > >>
> > >> Le 26/10/2021 à 11:48, Bs Serge a écrit :
> > >>> Lastly and most importantly I'd like to ask,
> > >>>
> > >>> Can different stores have the same category structure but with
> > different
> > >>> products?
> > >>>
> > >>> Best Regards,
> > >>>
> > >>> On Tue, Oct 26, 2021 at 11:04 AM Bs Serge <se...@gmail.com>
> wrote:
> > >>>
> > >>>> Hi Giulio,
> > >>>>
> > >>>> You have been more than helpful to help me understand this,
> > >>>>
> > >>>> Regarding the “Browser Root”, it seems like there are different
> > Product
> > >>>> Category Types (Best Selling, Catalog, Search, …) which I see
> defines
> > >> the
> > >>>> categories that are directly linked to catalogs in different Product
> > >>>> Catalog Category Types (Browser Root, Promotion, Quick Add, Default
> > >> Search)
> > >>>> For Example in the “Demo Catalog”, in its Categories, there is a
> > >> category
> > >>>> called “CATALOG1” of Browser Root, and that category is of Product
> > >> Category
> > >>>> Type “Catalog”, and I see it act as a parent of two other categories
> > of
> > >> Ids
> > >>>> 100 and 200 which both are also of Category Type “Catalog”, which
> goes
> > >> on
> > >>>> to create a Tree of categories
> > >>>>
> > >>>> Does it mean that the Product Category Type of Catalog is also like
> a
> > >>>> group of categories per se ,.. ?
> > >>>>
> > >>>> If so, one would directly wonder what is the role of other Product
> > >>>> Category Types (Best Selling, Search, Tax, Quick Add, Google Base,
> > >>>> Industry, Internal, ... )?
> > >>>>
> > >>>> Thank you again,
> > >>>>
> > >>>> Best Regards,
> > >>>>
> > >>>> On Mon, Oct 25, 2021 at 7:20 PM Giulio Speri - MpStyle Srl <
> > >>>> giulio.speri@mpstyle.it> wrote:
> > >>>>
> > >>>>> Hello Serge,
> > >>>>>
> > >>>>> in OFBiz there is not a direct association between a ProductStore
> and
> > >>>>> products, instead ProdCatalog, ProdCatalogCategory,
> > >> ProductStoreCatalog,
> > >>>>> ProductCategory and ProductCategoryMember entities are used to
> > achieve
> > >>>>> this
> > >>>>> goal.
> > >>>>>
> > >>>>> You can see the ProdCatalog as a collector of categories: the one
> > that
> > >> is
> > >>>>> physically associated with a product store is the ProdCatalog
> through
> > >> the
> > >>>>> entity ProductStoreCatalog.
> > >>>>> A product catalog is composed by a hierarchy of categories where
> the
> > >> first
> > >>>>> (root category) always has to be of type "Browse Root"
> > >> (PCCT_BROWSE_ROOT).
> > >>>>> This is managed by the entity ProdCatalogCategory.
> > >>>>> Under the "Browse Root" category you can then build your own custom
> > >>>>> hierarchy of product categories and associate the product to each
> one
> > >> of
> > >>>>> it; ProductCategory is the entity used to define a category and a
> > >> product
> > >>>>> is associated to a specific category through the entity
> > >>>>> ProductCategoryMember.
> > >>>>>
> > >>>>> *In short*:
> > >>>>>
> > >>>>> ProductStore/Catalog assoc : ProductStore -> ProdCatalog ->
> > >>>>> ProductCatalogCategory (Browse Root)
> > >>>>>
> > >>>>> Browse Root Category/Product categories:
> > >>>>> - ProductCategory (Browse Root)
> > >>>>> -- productCategory_1 -> Products (through
> ProductCategoryMember);
> > >>>>> -- productCategory_2 -> Products;
> > >>>>> ---productSubCategory_2_1 -> Products;
> > >>>>> ---productSubCategory_2_2 -> Products;
> > >>>>> -- productCategory_3 -> Products;
> > >>>>>
> > >>>>> In the online backend demo of OFBiz you can start following this
> > >> structure
> > >>>>> from the Catalog Manager -> Stores, pick up a store and then open
> the
> > >> tab
> > >>>>> "CATALOGS".
> > >>>>> You will find different examples of stores and catalogs with
> > different
> > >>>>> categories associated, that can give you a good starting point on
> the
> > >>>>> store/catalog/category/product OOTB mechanism.
> > >>>>>
> > >>>>> I hope I have been helpful.
> > >>>>>
> > >>>>> Kind Regards,
> > >>>>> Giulio
> > >>>>>
> > >>>>> Il giorno lun 25 ott 2021 alle ore 16:30 Bs Serge <
> > sergebs10@gmail.com
> > >>>>> ha
> > >>>>> scritto:
> > >>>>>
> > >>>>>> Hi,
> > >>>>>>
> > >>>>>> I was browsing through the catalog module and I could not find any
> > >>>>> product
> > >>>>>> and store relationship.
> > >>>>>>
> > >>>>>> I would assume products are supposed to belong in a certain store!
> > >>>>>>
> > >>>>>> Kindly enlighten me on how OFBiz handles products and stores
> > >>>>> relationships,
> > >>>>>> or point me to a link that explains it.
> > >>>>>>
> > >>>>>> Thanks,
> > >>>>>>
> > >>>>>> Best Regards,
> > >>>>>>
> > >>>>> --
> > >>>>> Giulio Speri
> > >>>>>
> > >>>>>
> > >>>>> *Mp Styl**e Srl*
> > >>>>> via Antonio Meucci, 37
> > >>>>> 41019 Limidi di Soliera (MO)
> > >>>>> T 059/684916
> > >>>>> M 347/0965506
> > >>>>>
> > >>>>> www.mpstyle.it
> > >>>>>
> >
>
--
Giulio Speri
*Mp Styl**e Srl*
via Antonio Meucci, 37
41019 Limidi di Soliera (MO)
T 059/684916
M 347/0965506
www.mpstyle.it
Re: Product and Store Relationship
Posted by Bs Serge <se...@gmail.com>.
Never mind,
I see it is done in the facility/inventory module.
On Wed, Oct 27, 2021 at 6:12 PM Bs Serge <se...@gmail.com> wrote:
> Hi Michael,
>
> These data models are amazing! You are a lifesaver! and I think I got my
> answer!
>
> I hope this is my last question : How do you define how many products are
> available in stock?
>
> Thank you again!
>
> Best Regards,
>
> On Tue, Oct 26, 2021 at 9:01 PM Michael Brohl <mi...@ecomify.de>
> wrote:
>
>> Hi,
>>
>> in addition to the other recommendations, I strongly recommend to have a
>> look at the OFBiz data model book which shows the data model in-depth.
>>
>> See https://cwiki.apache.org/confluence/display/OFBIZ/Data+Model+Diagrams
>>
>> There you will see that the products are mapped to the ProductCategory
>> through the ProductCategoryMember entity. The category structure is
>> build by the productCategoryRollup entities and the top-most category is
>> mapped to the ProdCatalog through ProdCatalogCategory and finally the
>> ProdCatalog ist mapped to the productStore through ProductStoreCatalog.
>>
>> While you can reuse categories with different roll-ups, you cannot have
>> the SAME category containing other products when used with another
>> ProductStore.
>>
>> You surely can build up a SIMILAR category structure twice and map this
>> to the catalog/store to achieve your goal.
>>
>> Best regards,
>>
>> Michael Brohl
>>
>> ecomify GmbH - www.ecomify.de
>>
>>
>> Am 26.10.21 um 18:56 schrieb Bs Serge:
>> > Thank you Jacques for the link,
>> >
>> > Kindly, can different stores use the same category structure with
>> different
>> > products, Or do categories have to be created for each store?
>> >
>> > Thanks again
>> >
>> > Best Regards,
>> >
>> >
>> > On Tue, Oct 26, 2021 at 1:36 PM Jacques Le Roux <
>> > jacques.le.roux@les7arts.com> wrote:
>> >
>> >> Hi Serge,
>> >>
>> >> This is old and in French, but I think it can still help
>> >>
>> >>
>> >>
>> http://www.les7arts.com/assist/OFBiz/Creation%20Catalogue%20de%20produits.htm#_bookmark_551a190
>> >>
>> >> Jacques
>> >>
>> >> Le 26/10/2021 à 11:48, Bs Serge a écrit :
>> >>> Lastly and most importantly I'd like to ask,
>> >>>
>> >>> Can different stores have the same category structure but with
>> different
>> >>> products?
>> >>>
>> >>> Best Regards,
>> >>>
>> >>> On Tue, Oct 26, 2021 at 11:04 AM Bs Serge <se...@gmail.com>
>> wrote:
>> >>>
>> >>>> Hi Giulio,
>> >>>>
>> >>>> You have been more than helpful to help me understand this,
>> >>>>
>> >>>> Regarding the “Browser Root”, it seems like there are different
>> Product
>> >>>> Category Types (Best Selling, Catalog, Search, …) which I see
>> defines
>> >> the
>> >>>> categories that are directly linked to catalogs in different Product
>> >>>> Catalog Category Types (Browser Root, Promotion, Quick Add, Default
>> >> Search)
>> >>>> For Example in the “Demo Catalog”, in its Categories, there is a
>> >> category
>> >>>> called “CATALOG1” of Browser Root, and that category is of Product
>> >> Category
>> >>>> Type “Catalog”, and I see it act as a parent of two other categories
>> of
>> >> Ids
>> >>>> 100 and 200 which both are also of Category Type “Catalog”, which
>> goes
>> >> on
>> >>>> to create a Tree of categories
>> >>>>
>> >>>> Does it mean that the Product Category Type of Catalog is also like a
>> >>>> group of categories per se ,.. ?
>> >>>>
>> >>>> If so, one would directly wonder what is the role of other Product
>> >>>> Category Types (Best Selling, Search, Tax, Quick Add, Google Base,
>> >>>> Industry, Internal, ... )?
>> >>>>
>> >>>> Thank you again,
>> >>>>
>> >>>> Best Regards,
>> >>>>
>> >>>> On Mon, Oct 25, 2021 at 7:20 PM Giulio Speri - MpStyle Srl <
>> >>>> giulio.speri@mpstyle.it> wrote:
>> >>>>
>> >>>>> Hello Serge,
>> >>>>>
>> >>>>> in OFBiz there is not a direct association between a ProductStore
>> and
>> >>>>> products, instead ProdCatalog, ProdCatalogCategory,
>> >> ProductStoreCatalog,
>> >>>>> ProductCategory and ProductCategoryMember entities are used to
>> achieve
>> >>>>> this
>> >>>>> goal.
>> >>>>>
>> >>>>> You can see the ProdCatalog as a collector of categories: the one
>> that
>> >> is
>> >>>>> physically associated with a product store is the ProdCatalog
>> through
>> >> the
>> >>>>> entity ProductStoreCatalog.
>> >>>>> A product catalog is composed by a hierarchy of categories where the
>> >> first
>> >>>>> (root category) always has to be of type "Browse Root"
>> >> (PCCT_BROWSE_ROOT).
>> >>>>> This is managed by the entity ProdCatalogCategory.
>> >>>>> Under the "Browse Root" category you can then build your own custom
>> >>>>> hierarchy of product categories and associate the product to each
>> one
>> >> of
>> >>>>> it; ProductCategory is the entity used to define a category and a
>> >> product
>> >>>>> is associated to a specific category through the entity
>> >>>>> ProductCategoryMember.
>> >>>>>
>> >>>>> *In short*:
>> >>>>>
>> >>>>> ProductStore/Catalog assoc : ProductStore -> ProdCatalog ->
>> >>>>> ProductCatalogCategory (Browse Root)
>> >>>>>
>> >>>>> Browse Root Category/Product categories:
>> >>>>> - ProductCategory (Browse Root)
>> >>>>> -- productCategory_1 -> Products (through ProductCategoryMember);
>> >>>>> -- productCategory_2 -> Products;
>> >>>>> ---productSubCategory_2_1 -> Products;
>> >>>>> ---productSubCategory_2_2 -> Products;
>> >>>>> -- productCategory_3 -> Products;
>> >>>>>
>> >>>>> In the online backend demo of OFBiz you can start following this
>> >> structure
>> >>>>> from the Catalog Manager -> Stores, pick up a store and then open
>> the
>> >> tab
>> >>>>> "CATALOGS".
>> >>>>> You will find different examples of stores and catalogs with
>> different
>> >>>>> categories associated, that can give you a good starting point on
>> the
>> >>>>> store/catalog/category/product OOTB mechanism.
>> >>>>>
>> >>>>> I hope I have been helpful.
>> >>>>>
>> >>>>> Kind Regards,
>> >>>>> Giulio
>> >>>>>
>> >>>>> Il giorno lun 25 ott 2021 alle ore 16:30 Bs Serge <
>> sergebs10@gmail.com
>> >>>>> ha
>> >>>>> scritto:
>> >>>>>
>> >>>>>> Hi,
>> >>>>>>
>> >>>>>> I was browsing through the catalog module and I could not find any
>> >>>>> product
>> >>>>>> and store relationship.
>> >>>>>>
>> >>>>>> I would assume products are supposed to belong in a certain store!
>> >>>>>>
>> >>>>>> Kindly enlighten me on how OFBiz handles products and stores
>> >>>>> relationships,
>> >>>>>> or point me to a link that explains it.
>> >>>>>>
>> >>>>>> Thanks,
>> >>>>>>
>> >>>>>> Best Regards,
>> >>>>>>
>> >>>>> --
>> >>>>> Giulio Speri
>> >>>>>
>> >>>>>
>> >>>>> *Mp Styl**e Srl*
>> >>>>> via Antonio Meucci, 37
>> >>>>> 41019 Limidi di Soliera (MO)
>> >>>>> T 059/684916
>> >>>>> M 347/0965506
>> >>>>>
>> >>>>> www.mpstyle.it
>> >>>>>
>>
>
Re: Product and Store Relationship
Posted by Bs Serge <se...@gmail.com>.
Hi Michael,
These data models are amazing! You are a lifesaver! and I think I got my
answer!
I hope this is my last question : How do you define how many products are
available in stock?
Thank you again!
Best Regards,
On Tue, Oct 26, 2021 at 9:01 PM Michael Brohl <mi...@ecomify.de>
wrote:
> Hi,
>
> in addition to the other recommendations, I strongly recommend to have a
> look at the OFBiz data model book which shows the data model in-depth.
>
> See https://cwiki.apache.org/confluence/display/OFBIZ/Data+Model+Diagrams
>
> There you will see that the products are mapped to the ProductCategory
> through the ProductCategoryMember entity. The category structure is
> build by the productCategoryRollup entities and the top-most category is
> mapped to the ProdCatalog through ProdCatalogCategory and finally the
> ProdCatalog ist mapped to the productStore through ProductStoreCatalog.
>
> While you can reuse categories with different roll-ups, you cannot have
> the SAME category containing other products when used with another
> ProductStore.
>
> You surely can build up a SIMILAR category structure twice and map this
> to the catalog/store to achieve your goal.
>
> Best regards,
>
> Michael Brohl
>
> ecomify GmbH - www.ecomify.de
>
>
> Am 26.10.21 um 18:56 schrieb Bs Serge:
> > Thank you Jacques for the link,
> >
> > Kindly, can different stores use the same category structure with
> different
> > products, Or do categories have to be created for each store?
> >
> > Thanks again
> >
> > Best Regards,
> >
> >
> > On Tue, Oct 26, 2021 at 1:36 PM Jacques Le Roux <
> > jacques.le.roux@les7arts.com> wrote:
> >
> >> Hi Serge,
> >>
> >> This is old and in French, but I think it can still help
> >>
> >>
> >>
> http://www.les7arts.com/assist/OFBiz/Creation%20Catalogue%20de%20produits.htm#_bookmark_551a190
> >>
> >> Jacques
> >>
> >> Le 26/10/2021 à 11:48, Bs Serge a écrit :
> >>> Lastly and most importantly I'd like to ask,
> >>>
> >>> Can different stores have the same category structure but with
> different
> >>> products?
> >>>
> >>> Best Regards,
> >>>
> >>> On Tue, Oct 26, 2021 at 11:04 AM Bs Serge <se...@gmail.com> wrote:
> >>>
> >>>> Hi Giulio,
> >>>>
> >>>> You have been more than helpful to help me understand this,
> >>>>
> >>>> Regarding the “Browser Root”, it seems like there are different
> Product
> >>>> Category Types (Best Selling, Catalog, Search, …) which I see defines
> >> the
> >>>> categories that are directly linked to catalogs in different Product
> >>>> Catalog Category Types (Browser Root, Promotion, Quick Add, Default
> >> Search)
> >>>> For Example in the “Demo Catalog”, in its Categories, there is a
> >> category
> >>>> called “CATALOG1” of Browser Root, and that category is of Product
> >> Category
> >>>> Type “Catalog”, and I see it act as a parent of two other categories
> of
> >> Ids
> >>>> 100 and 200 which both are also of Category Type “Catalog”, which goes
> >> on
> >>>> to create a Tree of categories
> >>>>
> >>>> Does it mean that the Product Category Type of Catalog is also like a
> >>>> group of categories per se ,.. ?
> >>>>
> >>>> If so, one would directly wonder what is the role of other Product
> >>>> Category Types (Best Selling, Search, Tax, Quick Add, Google Base,
> >>>> Industry, Internal, ... )?
> >>>>
> >>>> Thank you again,
> >>>>
> >>>> Best Regards,
> >>>>
> >>>> On Mon, Oct 25, 2021 at 7:20 PM Giulio Speri - MpStyle Srl <
> >>>> giulio.speri@mpstyle.it> wrote:
> >>>>
> >>>>> Hello Serge,
> >>>>>
> >>>>> in OFBiz there is not a direct association between a ProductStore and
> >>>>> products, instead ProdCatalog, ProdCatalogCategory,
> >> ProductStoreCatalog,
> >>>>> ProductCategory and ProductCategoryMember entities are used to
> achieve
> >>>>> this
> >>>>> goal.
> >>>>>
> >>>>> You can see the ProdCatalog as a collector of categories: the one
> that
> >> is
> >>>>> physically associated with a product store is the ProdCatalog through
> >> the
> >>>>> entity ProductStoreCatalog.
> >>>>> A product catalog is composed by a hierarchy of categories where the
> >> first
> >>>>> (root category) always has to be of type "Browse Root"
> >> (PCCT_BROWSE_ROOT).
> >>>>> This is managed by the entity ProdCatalogCategory.
> >>>>> Under the "Browse Root" category you can then build your own custom
> >>>>> hierarchy of product categories and associate the product to each one
> >> of
> >>>>> it; ProductCategory is the entity used to define a category and a
> >> product
> >>>>> is associated to a specific category through the entity
> >>>>> ProductCategoryMember.
> >>>>>
> >>>>> *In short*:
> >>>>>
> >>>>> ProductStore/Catalog assoc : ProductStore -> ProdCatalog ->
> >>>>> ProductCatalogCategory (Browse Root)
> >>>>>
> >>>>> Browse Root Category/Product categories:
> >>>>> - ProductCategory (Browse Root)
> >>>>> -- productCategory_1 -> Products (through ProductCategoryMember);
> >>>>> -- productCategory_2 -> Products;
> >>>>> ---productSubCategory_2_1 -> Products;
> >>>>> ---productSubCategory_2_2 -> Products;
> >>>>> -- productCategory_3 -> Products;
> >>>>>
> >>>>> In the online backend demo of OFBiz you can start following this
> >> structure
> >>>>> from the Catalog Manager -> Stores, pick up a store and then open the
> >> tab
> >>>>> "CATALOGS".
> >>>>> You will find different examples of stores and catalogs with
> different
> >>>>> categories associated, that can give you a good starting point on the
> >>>>> store/catalog/category/product OOTB mechanism.
> >>>>>
> >>>>> I hope I have been helpful.
> >>>>>
> >>>>> Kind Regards,
> >>>>> Giulio
> >>>>>
> >>>>> Il giorno lun 25 ott 2021 alle ore 16:30 Bs Serge <
> sergebs10@gmail.com
> >>>>> ha
> >>>>> scritto:
> >>>>>
> >>>>>> Hi,
> >>>>>>
> >>>>>> I was browsing through the catalog module and I could not find any
> >>>>> product
> >>>>>> and store relationship.
> >>>>>>
> >>>>>> I would assume products are supposed to belong in a certain store!
> >>>>>>
> >>>>>> Kindly enlighten me on how OFBiz handles products and stores
> >>>>> relationships,
> >>>>>> or point me to a link that explains it.
> >>>>>>
> >>>>>> Thanks,
> >>>>>>
> >>>>>> Best Regards,
> >>>>>>
> >>>>> --
> >>>>> Giulio Speri
> >>>>>
> >>>>>
> >>>>> *Mp Styl**e Srl*
> >>>>> via Antonio Meucci, 37
> >>>>> 41019 Limidi di Soliera (MO)
> >>>>> T 059/684916
> >>>>> M 347/0965506
> >>>>>
> >>>>> www.mpstyle.it
> >>>>>
>
Re: Product and Store Relationship
Posted by Michael Brohl <mi...@ecomify.de>.
Hi,
in addition to the other recommendations, I strongly recommend to have a
look at the OFBiz data model book which shows the data model in-depth.
See https://cwiki.apache.org/confluence/display/OFBIZ/Data+Model+Diagrams
There you will see that the products are mapped to the ProductCategory
through the ProductCategoryMember entity. The category structure is
build by the productCategoryRollup entities and the top-most category is
mapped to the ProdCatalog through ProdCatalogCategory and finally the
ProdCatalog ist mapped to the productStore through ProductStoreCatalog.
While you can reuse categories with different roll-ups, you cannot have
the SAME category containing other products when used with another
ProductStore.
You surely can build up a SIMILAR category structure twice and map this
to the catalog/store to achieve your goal.
Best regards,
Michael Brohl
ecomify GmbH - www.ecomify.de
Am 26.10.21 um 18:56 schrieb Bs Serge:
> Thank you Jacques for the link,
>
> Kindly, can different stores use the same category structure with different
> products, Or do categories have to be created for each store?
>
> Thanks again
>
> Best Regards,
>
>
> On Tue, Oct 26, 2021 at 1:36 PM Jacques Le Roux <
> jacques.le.roux@les7arts.com> wrote:
>
>> Hi Serge,
>>
>> This is old and in French, but I think it can still help
>>
>>
>> http://www.les7arts.com/assist/OFBiz/Creation%20Catalogue%20de%20produits.htm#_bookmark_551a190
>>
>> Jacques
>>
>> Le 26/10/2021 à 11:48, Bs Serge a écrit :
>>> Lastly and most importantly I'd like to ask,
>>>
>>> Can different stores have the same category structure but with different
>>> products?
>>>
>>> Best Regards,
>>>
>>> On Tue, Oct 26, 2021 at 11:04 AM Bs Serge <se...@gmail.com> wrote:
>>>
>>>> Hi Giulio,
>>>>
>>>> You have been more than helpful to help me understand this,
>>>>
>>>> Regarding the “Browser Root”, it seems like there are different Product
>>>> Category Types (Best Selling, Catalog, Search, …) which I see defines
>> the
>>>> categories that are directly linked to catalogs in different Product
>>>> Catalog Category Types (Browser Root, Promotion, Quick Add, Default
>> Search)
>>>> For Example in the “Demo Catalog”, in its Categories, there is a
>> category
>>>> called “CATALOG1” of Browser Root, and that category is of Product
>> Category
>>>> Type “Catalog”, and I see it act as a parent of two other categories of
>> Ids
>>>> 100 and 200 which both are also of Category Type “Catalog”, which goes
>> on
>>>> to create a Tree of categories
>>>>
>>>> Does it mean that the Product Category Type of Catalog is also like a
>>>> group of categories per se ,.. ?
>>>>
>>>> If so, one would directly wonder what is the role of other Product
>>>> Category Types (Best Selling, Search, Tax, Quick Add, Google Base,
>>>> Industry, Internal, ... )?
>>>>
>>>> Thank you again,
>>>>
>>>> Best Regards,
>>>>
>>>> On Mon, Oct 25, 2021 at 7:20 PM Giulio Speri - MpStyle Srl <
>>>> giulio.speri@mpstyle.it> wrote:
>>>>
>>>>> Hello Serge,
>>>>>
>>>>> in OFBiz there is not a direct association between a ProductStore and
>>>>> products, instead ProdCatalog, ProdCatalogCategory,
>> ProductStoreCatalog,
>>>>> ProductCategory and ProductCategoryMember entities are used to achieve
>>>>> this
>>>>> goal.
>>>>>
>>>>> You can see the ProdCatalog as a collector of categories: the one that
>> is
>>>>> physically associated with a product store is the ProdCatalog through
>> the
>>>>> entity ProductStoreCatalog.
>>>>> A product catalog is composed by a hierarchy of categories where the
>> first
>>>>> (root category) always has to be of type "Browse Root"
>> (PCCT_BROWSE_ROOT).
>>>>> This is managed by the entity ProdCatalogCategory.
>>>>> Under the "Browse Root" category you can then build your own custom
>>>>> hierarchy of product categories and associate the product to each one
>> of
>>>>> it; ProductCategory is the entity used to define a category and a
>> product
>>>>> is associated to a specific category through the entity
>>>>> ProductCategoryMember.
>>>>>
>>>>> *In short*:
>>>>>
>>>>> ProductStore/Catalog assoc : ProductStore -> ProdCatalog ->
>>>>> ProductCatalogCategory (Browse Root)
>>>>>
>>>>> Browse Root Category/Product categories:
>>>>> - ProductCategory (Browse Root)
>>>>> -- productCategory_1 -> Products (through ProductCategoryMember);
>>>>> -- productCategory_2 -> Products;
>>>>> ---productSubCategory_2_1 -> Products;
>>>>> ---productSubCategory_2_2 -> Products;
>>>>> -- productCategory_3 -> Products;
>>>>>
>>>>> In the online backend demo of OFBiz you can start following this
>> structure
>>>>> from the Catalog Manager -> Stores, pick up a store and then open the
>> tab
>>>>> "CATALOGS".
>>>>> You will find different examples of stores and catalogs with different
>>>>> categories associated, that can give you a good starting point on the
>>>>> store/catalog/category/product OOTB mechanism.
>>>>>
>>>>> I hope I have been helpful.
>>>>>
>>>>> Kind Regards,
>>>>> Giulio
>>>>>
>>>>> Il giorno lun 25 ott 2021 alle ore 16:30 Bs Serge <sergebs10@gmail.com
>>>>> ha
>>>>> scritto:
>>>>>
>>>>>> Hi,
>>>>>>
>>>>>> I was browsing through the catalog module and I could not find any
>>>>> product
>>>>>> and store relationship.
>>>>>>
>>>>>> I would assume products are supposed to belong in a certain store!
>>>>>>
>>>>>> Kindly enlighten me on how OFBiz handles products and stores
>>>>> relationships,
>>>>>> or point me to a link that explains it.
>>>>>>
>>>>>> Thanks,
>>>>>>
>>>>>> Best Regards,
>>>>>>
>>>>> --
>>>>> Giulio Speri
>>>>>
>>>>>
>>>>> *Mp Styl**e Srl*
>>>>> via Antonio Meucci, 37
>>>>> 41019 Limidi di Soliera (MO)
>>>>> T 059/684916
>>>>> M 347/0965506
>>>>>
>>>>> www.mpstyle.it
>>>>>
Re: Product and Store Relationship
Posted by Bs Serge <se...@gmail.com>.
Thank you Jacques for the link,
Kindly, can different stores use the same category structure with different
products, Or do categories have to be created for each store?
Thanks again
Best Regards,
On Tue, Oct 26, 2021 at 1:36 PM Jacques Le Roux <
jacques.le.roux@les7arts.com> wrote:
> Hi Serge,
>
> This is old and in French, but I think it can still help
>
>
> http://www.les7arts.com/assist/OFBiz/Creation%20Catalogue%20de%20produits.htm#_bookmark_551a190
>
> Jacques
>
> Le 26/10/2021 à 11:48, Bs Serge a écrit :
> > Lastly and most importantly I'd like to ask,
> >
> > Can different stores have the same category structure but with different
> > products?
> >
> > Best Regards,
> >
> > On Tue, Oct 26, 2021 at 11:04 AM Bs Serge <se...@gmail.com> wrote:
> >
> >> Hi Giulio,
> >>
> >> You have been more than helpful to help me understand this,
> >>
> >> Regarding the “Browser Root”, it seems like there are different Product
> >> Category Types (Best Selling, Catalog, Search, …) which I see defines
> the
> >> categories that are directly linked to catalogs in different Product
> >> Catalog Category Types (Browser Root, Promotion, Quick Add, Default
> Search)
> >>
> >> For Example in the “Demo Catalog”, in its Categories, there is a
> category
> >> called “CATALOG1” of Browser Root, and that category is of Product
> Category
> >> Type “Catalog”, and I see it act as a parent of two other categories of
> Ids
> >> 100 and 200 which both are also of Category Type “Catalog”, which goes
> on
> >> to create a Tree of categories
> >>
> >> Does it mean that the Product Category Type of Catalog is also like a
> >> group of categories per se ,.. ?
> >>
> >> If so, one would directly wonder what is the role of other Product
> >> Category Types (Best Selling, Search, Tax, Quick Add, Google Base,
> >> Industry, Internal, ... )?
> >>
> >> Thank you again,
> >>
> >> Best Regards,
> >>
> >> On Mon, Oct 25, 2021 at 7:20 PM Giulio Speri - MpStyle Srl <
> >> giulio.speri@mpstyle.it> wrote:
> >>
> >>> Hello Serge,
> >>>
> >>> in OFBiz there is not a direct association between a ProductStore and
> >>> products, instead ProdCatalog, ProdCatalogCategory,
> ProductStoreCatalog,
> >>> ProductCategory and ProductCategoryMember entities are used to achieve
> >>> this
> >>> goal.
> >>>
> >>> You can see the ProdCatalog as a collector of categories: the one that
> is
> >>> physically associated with a product store is the ProdCatalog through
> the
> >>> entity ProductStoreCatalog.
> >>> A product catalog is composed by a hierarchy of categories where the
> first
> >>> (root category) always has to be of type "Browse Root"
> (PCCT_BROWSE_ROOT).
> >>> This is managed by the entity ProdCatalogCategory.
> >>> Under the "Browse Root" category you can then build your own custom
> >>> hierarchy of product categories and associate the product to each one
> of
> >>> it; ProductCategory is the entity used to define a category and a
> product
> >>> is associated to a specific category through the entity
> >>> ProductCategoryMember.
> >>>
> >>> *In short*:
> >>>
> >>> ProductStore/Catalog assoc : ProductStore -> ProdCatalog ->
> >>> ProductCatalogCategory (Browse Root)
> >>>
> >>> Browse Root Category/Product categories:
> >>> - ProductCategory (Browse Root)
> >>> -- productCategory_1 -> Products (through ProductCategoryMember);
> >>> -- productCategory_2 -> Products;
> >>> ---productSubCategory_2_1 -> Products;
> >>> ---productSubCategory_2_2 -> Products;
> >>> -- productCategory_3 -> Products;
> >>>
> >>> In the online backend demo of OFBiz you can start following this
> structure
> >>> from the Catalog Manager -> Stores, pick up a store and then open the
> tab
> >>> "CATALOGS".
> >>> You will find different examples of stores and catalogs with different
> >>> categories associated, that can give you a good starting point on the
> >>> store/catalog/category/product OOTB mechanism.
> >>>
> >>> I hope I have been helpful.
> >>>
> >>> Kind Regards,
> >>> Giulio
> >>>
> >>> Il giorno lun 25 ott 2021 alle ore 16:30 Bs Serge <sergebs10@gmail.com
> >
> >>> ha
> >>> scritto:
> >>>
> >>>> Hi,
> >>>>
> >>>> I was browsing through the catalog module and I could not find any
> >>> product
> >>>> and store relationship.
> >>>>
> >>>> I would assume products are supposed to belong in a certain store!
> >>>>
> >>>> Kindly enlighten me on how OFBiz handles products and stores
> >>> relationships,
> >>>> or point me to a link that explains it.
> >>>>
> >>>> Thanks,
> >>>>
> >>>> Best Regards,
> >>>>
> >>>
> >>> --
> >>> Giulio Speri
> >>>
> >>>
> >>> *Mp Styl**e Srl*
> >>> via Antonio Meucci, 37
> >>> 41019 Limidi di Soliera (MO)
> >>> T 059/684916
> >>> M 347/0965506
> >>>
> >>> www.mpstyle.it
> >>>
>
Re: Product and Store Relationship
Posted by Jacques Le Roux <ja...@les7arts.com>.
Hi Serge,
This is old and in French, but I think it can still help
http://www.les7arts.com/assist/OFBiz/Creation%20Catalogue%20de%20produits.htm#_bookmark_551a190
Jacques
Le 26/10/2021 à 11:48, Bs Serge a écrit :
> Lastly and most importantly I'd like to ask,
>
> Can different stores have the same category structure but with different
> products?
>
> Best Regards,
>
> On Tue, Oct 26, 2021 at 11:04 AM Bs Serge <se...@gmail.com> wrote:
>
>> Hi Giulio,
>>
>> You have been more than helpful to help me understand this,
>>
>> Regarding the “Browser Root”, it seems like there are different Product
>> Category Types (Best Selling, Catalog, Search, …) which I see defines the
>> categories that are directly linked to catalogs in different Product
>> Catalog Category Types (Browser Root, Promotion, Quick Add, Default Search)
>>
>> For Example in the “Demo Catalog”, in its Categories, there is a category
>> called “CATALOG1” of Browser Root, and that category is of Product Category
>> Type “Catalog”, and I see it act as a parent of two other categories of Ids
>> 100 and 200 which both are also of Category Type “Catalog”, which goes on
>> to create a Tree of categories
>>
>> Does it mean that the Product Category Type of Catalog is also like a
>> group of categories per se ,.. ?
>>
>> If so, one would directly wonder what is the role of other Product
>> Category Types (Best Selling, Search, Tax, Quick Add, Google Base,
>> Industry, Internal, ... )?
>>
>> Thank you again,
>>
>> Best Regards,
>>
>> On Mon, Oct 25, 2021 at 7:20 PM Giulio Speri - MpStyle Srl <
>> giulio.speri@mpstyle.it> wrote:
>>
>>> Hello Serge,
>>>
>>> in OFBiz there is not a direct association between a ProductStore and
>>> products, instead ProdCatalog, ProdCatalogCategory, ProductStoreCatalog,
>>> ProductCategory and ProductCategoryMember entities are used to achieve
>>> this
>>> goal.
>>>
>>> You can see the ProdCatalog as a collector of categories: the one that is
>>> physically associated with a product store is the ProdCatalog through the
>>> entity ProductStoreCatalog.
>>> A product catalog is composed by a hierarchy of categories where the first
>>> (root category) always has to be of type "Browse Root" (PCCT_BROWSE_ROOT).
>>> This is managed by the entity ProdCatalogCategory.
>>> Under the "Browse Root" category you can then build your own custom
>>> hierarchy of product categories and associate the product to each one of
>>> it; ProductCategory is the entity used to define a category and a product
>>> is associated to a specific category through the entity
>>> ProductCategoryMember.
>>>
>>> *In short*:
>>>
>>> ProductStore/Catalog assoc : ProductStore -> ProdCatalog ->
>>> ProductCatalogCategory (Browse Root)
>>>
>>> Browse Root Category/Product categories:
>>> - ProductCategory (Browse Root)
>>> -- productCategory_1 -> Products (through ProductCategoryMember);
>>> -- productCategory_2 -> Products;
>>> ---productSubCategory_2_1 -> Products;
>>> ---productSubCategory_2_2 -> Products;
>>> -- productCategory_3 -> Products;
>>>
>>> In the online backend demo of OFBiz you can start following this structure
>>> from the Catalog Manager -> Stores, pick up a store and then open the tab
>>> "CATALOGS".
>>> You will find different examples of stores and catalogs with different
>>> categories associated, that can give you a good starting point on the
>>> store/catalog/category/product OOTB mechanism.
>>>
>>> I hope I have been helpful.
>>>
>>> Kind Regards,
>>> Giulio
>>>
>>> Il giorno lun 25 ott 2021 alle ore 16:30 Bs Serge <se...@gmail.com>
>>> ha
>>> scritto:
>>>
>>>> Hi,
>>>>
>>>> I was browsing through the catalog module and I could not find any
>>> product
>>>> and store relationship.
>>>>
>>>> I would assume products are supposed to belong in a certain store!
>>>>
>>>> Kindly enlighten me on how OFBiz handles products and stores
>>> relationships,
>>>> or point me to a link that explains it.
>>>>
>>>> Thanks,
>>>>
>>>> Best Regards,
>>>>
>>>
>>> --
>>> Giulio Speri
>>>
>>>
>>> *Mp Styl**e Srl*
>>> via Antonio Meucci, 37
>>> 41019 Limidi di Soliera (MO)
>>> T 059/684916
>>> M 347/0965506
>>>
>>> www.mpstyle.it
>>>
Re: Product and Store Relationship
Posted by Bs Serge <se...@gmail.com>.
Lastly and most importantly I'd like to ask,
Can different stores have the same category structure but with different
products?
Best Regards,
On Tue, Oct 26, 2021 at 11:04 AM Bs Serge <se...@gmail.com> wrote:
> Hi Giulio,
>
> You have been more than helpful to help me understand this,
>
> Regarding the “Browser Root”, it seems like there are different Product
> Category Types (Best Selling, Catalog, Search, …) which I see defines the
> categories that are directly linked to catalogs in different Product
> Catalog Category Types (Browser Root, Promotion, Quick Add, Default Search)
>
> For Example in the “Demo Catalog”, in its Categories, there is a category
> called “CATALOG1” of Browser Root, and that category is of Product Category
> Type “Catalog”, and I see it act as a parent of two other categories of Ids
> 100 and 200 which both are also of Category Type “Catalog”, which goes on
> to create a Tree of categories
>
> Does it mean that the Product Category Type of Catalog is also like a
> group of categories per se ,.. ?
>
> If so, one would directly wonder what is the role of other Product
> Category Types (Best Selling, Search, Tax, Quick Add, Google Base,
> Industry, Internal, ... )?
>
> Thank you again,
>
> Best Regards,
>
> On Mon, Oct 25, 2021 at 7:20 PM Giulio Speri - MpStyle Srl <
> giulio.speri@mpstyle.it> wrote:
>
>> Hello Serge,
>>
>> in OFBiz there is not a direct association between a ProductStore and
>> products, instead ProdCatalog, ProdCatalogCategory, ProductStoreCatalog,
>> ProductCategory and ProductCategoryMember entities are used to achieve
>> this
>> goal.
>>
>> You can see the ProdCatalog as a collector of categories: the one that is
>> physically associated with a product store is the ProdCatalog through the
>> entity ProductStoreCatalog.
>> A product catalog is composed by a hierarchy of categories where the first
>> (root category) always has to be of type "Browse Root" (PCCT_BROWSE_ROOT).
>> This is managed by the entity ProdCatalogCategory.
>> Under the "Browse Root" category you can then build your own custom
>> hierarchy of product categories and associate the product to each one of
>> it; ProductCategory is the entity used to define a category and a product
>> is associated to a specific category through the entity
>> ProductCategoryMember.
>>
>> *In short*:
>>
>> ProductStore/Catalog assoc : ProductStore -> ProdCatalog ->
>> ProductCatalogCategory (Browse Root)
>>
>> Browse Root Category/Product categories:
>> - ProductCategory (Browse Root)
>> -- productCategory_1 -> Products (through ProductCategoryMember);
>> -- productCategory_2 -> Products;
>> ---productSubCategory_2_1 -> Products;
>> ---productSubCategory_2_2 -> Products;
>> -- productCategory_3 -> Products;
>>
>> In the online backend demo of OFBiz you can start following this structure
>> from the Catalog Manager -> Stores, pick up a store and then open the tab
>> "CATALOGS".
>> You will find different examples of stores and catalogs with different
>> categories associated, that can give you a good starting point on the
>> store/catalog/category/product OOTB mechanism.
>>
>> I hope I have been helpful.
>>
>> Kind Regards,
>> Giulio
>>
>> Il giorno lun 25 ott 2021 alle ore 16:30 Bs Serge <se...@gmail.com>
>> ha
>> scritto:
>>
>> > Hi,
>> >
>> > I was browsing through the catalog module and I could not find any
>> product
>> > and store relationship.
>> >
>> > I would assume products are supposed to belong in a certain store!
>> >
>> > Kindly enlighten me on how OFBiz handles products and stores
>> relationships,
>> > or point me to a link that explains it.
>> >
>> > Thanks,
>> >
>> > Best Regards,
>> >
>>
>>
>> --
>> Giulio Speri
>>
>>
>> *Mp Styl**e Srl*
>> via Antonio Meucci, 37
>> 41019 Limidi di Soliera (MO)
>> T 059/684916
>> M 347/0965506
>>
>> www.mpstyle.it
>>
>
Re: Product and Store Relationship
Posted by Bs Serge <se...@gmail.com>.
Hi Giulio,
You have been more than helpful to help me understand this,
Regarding the “Browser Root”, it seems like there are different Product
Category Types (Best Selling, Catalog, Search, …) which I see defines the
categories that are directly linked to catalogs in different Product
Catalog Category Types (Browser Root, Promotion, Quick Add, Default Search)
For Example in the “Demo Catalog”, in its Categories, there is a category
called “CATALOG1” of Browser Root, and that category is of Product Category
Type “Catalog”, and I see it act as a parent of two other categories of Ids
100 and 200 which both are also of Category Type “Catalog”, which goes on
to create a Tree of categories
Does it mean that the Product Category Type of Catalog is also like a group
of categories per se ,.. ?
If so, one would directly wonder what is the role of other Product Category
Types (Best Selling, Search, Tax, Quick Add, Google Base, Industry,
Internal, ... )?
Thank you again,
Best Regards,
On Mon, Oct 25, 2021 at 7:20 PM Giulio Speri - MpStyle Srl <
giulio.speri@mpstyle.it> wrote:
> Hello Serge,
>
> in OFBiz there is not a direct association between a ProductStore and
> products, instead ProdCatalog, ProdCatalogCategory, ProductStoreCatalog,
> ProductCategory and ProductCategoryMember entities are used to achieve this
> goal.
>
> You can see the ProdCatalog as a collector of categories: the one that is
> physically associated with a product store is the ProdCatalog through the
> entity ProductStoreCatalog.
> A product catalog is composed by a hierarchy of categories where the first
> (root category) always has to be of type "Browse Root" (PCCT_BROWSE_ROOT).
> This is managed by the entity ProdCatalogCategory.
> Under the "Browse Root" category you can then build your own custom
> hierarchy of product categories and associate the product to each one of
> it; ProductCategory is the entity used to define a category and a product
> is associated to a specific category through the entity
> ProductCategoryMember.
>
> *In short*:
>
> ProductStore/Catalog assoc : ProductStore -> ProdCatalog ->
> ProductCatalogCategory (Browse Root)
>
> Browse Root Category/Product categories:
> - ProductCategory (Browse Root)
> -- productCategory_1 -> Products (through ProductCategoryMember);
> -- productCategory_2 -> Products;
> ---productSubCategory_2_1 -> Products;
> ---productSubCategory_2_2 -> Products;
> -- productCategory_3 -> Products;
>
> In the online backend demo of OFBiz you can start following this structure
> from the Catalog Manager -> Stores, pick up a store and then open the tab
> "CATALOGS".
> You will find different examples of stores and catalogs with different
> categories associated, that can give you a good starting point on the
> store/catalog/category/product OOTB mechanism.
>
> I hope I have been helpful.
>
> Kind Regards,
> Giulio
>
> Il giorno lun 25 ott 2021 alle ore 16:30 Bs Serge <se...@gmail.com> ha
> scritto:
>
> > Hi,
> >
> > I was browsing through the catalog module and I could not find any
> product
> > and store relationship.
> >
> > I would assume products are supposed to belong in a certain store!
> >
> > Kindly enlighten me on how OFBiz handles products and stores
> relationships,
> > or point me to a link that explains it.
> >
> > Thanks,
> >
> > Best Regards,
> >
>
>
> --
> Giulio Speri
>
>
> *Mp Styl**e Srl*
> via Antonio Meucci, 37
> 41019 Limidi di Soliera (MO)
> T 059/684916
> M 347/0965506
>
> www.mpstyle.it
>
Re: Product and Store Relationship
Posted by Giulio Speri - MpStyle Srl <gi...@mpstyle.it>.
Hello Serge,
in OFBiz there is not a direct association between a ProductStore and
products, instead ProdCatalog, ProdCatalogCategory, ProductStoreCatalog,
ProductCategory and ProductCategoryMember entities are used to achieve this
goal.
You can see the ProdCatalog as a collector of categories: the one that is
physically associated with a product store is the ProdCatalog through the
entity ProductStoreCatalog.
A product catalog is composed by a hierarchy of categories where the first
(root category) always has to be of type "Browse Root" (PCCT_BROWSE_ROOT).
This is managed by the entity ProdCatalogCategory.
Under the "Browse Root" category you can then build your own custom
hierarchy of product categories and associate the product to each one of
it; ProductCategory is the entity used to define a category and a product
is associated to a specific category through the entity
ProductCategoryMember.
*In short*:
ProductStore/Catalog assoc : ProductStore -> ProdCatalog ->
ProductCatalogCategory (Browse Root)
Browse Root Category/Product categories:
- ProductCategory (Browse Root)
-- productCategory_1 -> Products (through ProductCategoryMember);
-- productCategory_2 -> Products;
---productSubCategory_2_1 -> Products;
---productSubCategory_2_2 -> Products;
-- productCategory_3 -> Products;
In the online backend demo of OFBiz you can start following this structure
from the Catalog Manager -> Stores, pick up a store and then open the tab
"CATALOGS".
You will find different examples of stores and catalogs with different
categories associated, that can give you a good starting point on the
store/catalog/category/product OOTB mechanism.
I hope I have been helpful.
Kind Regards,
Giulio
Il giorno lun 25 ott 2021 alle ore 16:30 Bs Serge <se...@gmail.com> ha
scritto:
> Hi,
>
> I was browsing through the catalog module and I could not find any product
> and store relationship.
>
> I would assume products are supposed to belong in a certain store!
>
> Kindly enlighten me on how OFBiz handles products and stores relationships,
> or point me to a link that explains it.
>
> Thanks,
>
> Best Regards,
>
--
Giulio Speri
*Mp Styl**e Srl*
via Antonio Meucci, 37
41019 Limidi di Soliera (MO)
T 059/684916
M 347/0965506
www.mpstyle.it