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 <[email protected]> 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 < > > [email protected]> 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 <[email protected]> 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 < > >>>> [email protected]> 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 < > [email protected] > >>>>> 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 > >>>>> >
