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 <[email protected]> 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 <[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 > > >>>>> > > > -- Giulio Speri *Mp Styl**e Srl* via Antonio Meucci, 37 41019 Limidi di Soliera (MO) T 059/684916 M 347/0965506 www.mpstyle.it
