Calculating Item Inventory Quantity
CyberStore starts with a SYSPRO warehouse quantity, applies the configured warehouse scope, subtracts an inventory buffer, and then subtracts qualifying in-progress quantities from other active shoppers. The result is the quantity available to the current storefront shopper.
In simplified form:
Available storefront quantity = selected SYSPRO quantity basis - inventory buffer - in-progress allocation
Inventory Quantity Basis defines the supported SYSPRO source values and formulas.
In-progress allocation
In Progress Allocation Basis in Site Manager > Catalog Configuration > Quantity Settings determines when quantities in other shoppers’ carts reduce availability.
| Setting | Quantities reserved from the current shopper |
|---|---|
| All Active Carts | Includes items in every other active cart, including carts currently in checkout. |
| Carts Only in Checkout | Includes only items in carts that are actively in checkout. |
Abandoned-cart quantities are always ignored. Under All Active Carts, an item begins reducing availability when another shopper adds it to the cart. The quantity is released if that shopper removes the item, signs out, or allows the session to expire.
Once checkout begins, the order-line quantities reduce availability under either allocation basis. After order completion, normal SYSPRO quantity results reflect the sales order as back-office processing advances.
Inventory buffers
An inventory buffer withholds units from storefront availability. For example, a buffer of 5 applied to a source quantity of 100 leaves no more than 95 units available before in-progress allocations are considered.
Set a site-wide buffer in Catalog Configuration > Quantity Settings or an item-specific value in Item Maintenance > Options. Buffers are useful when stock must be reserved for exchanges or other non-storefront demand.
Avoid displaying warehouse subtotals while using an inventory buffer. CyberStore subtracts the buffer from each displayed warehouse quantity, which can make the subtotals misleading.
Warehouse scope
CyberStore can query only warehouses granted to the CyberStore web operator in SYSPRO e.net operator settings. With All Available Warehouses, it aggregates the selected quantity basis across accessible warehouses where the item is stocked.
With Prevailing Customer/Item Warehouse, CyberStore limits the calculation to the warehouse selected by the prevailing Customer or item rules. Prevailing-warehouse logic applies to every supported inventory quantity basis. See Warehouse Selection for the precedence used to identify a warehouse.
Kits
For a kit, the limiting component determines how many complete kits can be offered. If a lamp kit requires a stand and a shade, and availability is 100 stands but 75 shades, no more than 75 complete kits are available.
Limited and back-ordered items
When an item is limited to available inventory, CyberStore reduces a requested cart quantity to the maximum available and displays the configured quantity-exceeded message. If no units are available, the item cannot be added.
When the item permits sales above available inventory, the excess can be back-ordered. CyberStore can notify the shopper before checkout using the default back-order message from Catalog Configuration. Configure item limitation behavior in Item Options and site messages in Quantity Settings.
Available to Promise
When ATP is enabled, CyberStore also evaluates the requested ship date or range against synchronized ATP data. This projection is separate from the current inventory calculation. See Available to Promise (ATP).