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