Inventory Upload Values
From NewHaven Software Wiki
When uploading product data to your website(s), CMS will include current stock levels to facilitate inventory control for sites that support it. This article will expose the logic and data CMS uses to provide that inventory availability data.
CommerceV3
There are actually four data points that will impact if and what data is uploaded:
- a) qty on hand
- b) qty on backorder (unfulfilled back orders)
- c) qty on order (open PO's)
- d) expected dates on above PO's (dates those PO's/items are expected to be received)
When CMS uploads stock to CV3 it uses the net of qty on hand less qty on back order (a-b). This is done to ensure that any stock received is available to fulfill existing back orders before they can be allocated to new sales. This facilitates FIFO allocation.
The qty on order and the expected dates (c and d) from the corresponding purchase orders will impact the CV3 "backorder date" that CMS uploads. To do this, CMS looks at all of the open PO's and compares their qty on order against the total qty on backorder until it finds the first PO which is expected to bring in stock not needed to fulfill existing back orders. It will use that PO's expected date as the CV3 backorder date.
As new orders are placed/verified in CMS for backordered items, the next time the product upload occurs that back order qty will have been updated and affect if/which open PO is identified for its backorder date. This will continue until you reach the point where all qty on order is accounted for by backorders at which point there would be no backorder date uploaded to CV3...which will remove it from being available for sale on the site.
When you take both solutions into account, in conjunction with regular product uploads to keep CV3 up to date, your exposure to overselling a product, even though CV3 does not have the qty on order value, should be quite small. If it still a concern we'd recommend bumping up the frequency of the product data uploads (which can be automated/scheduled with any desired frequency.)
