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
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 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
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.sp...@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 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
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 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.sp...@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 >> 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
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 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.sp...@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 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
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.r...@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 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.sp...@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 > > >>> 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
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.r...@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 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.sp...@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 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*
Re: Product and Store Relationship
> 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 < > sergeb...@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
>> >> >>>>> 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 < >> sergeb...@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
> > >>> > > >>> On Tue, Oct 26, 2021 at 11:04 AM Bs Serge > 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.sp...@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 < > > sergeb...@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
erent > > > > 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.r...@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 > > 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.sp...@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 > custo