Platform update · Shopify
Shopify inventory reports will show on-hand quantity
Starting October 1, 2026, Shopify inventory analytics models will measure stock by on-hand quantity instead of available quantity. Reports for dates before October 1 will remain unchanged.
Shopify is updating the stock measure used in its inventory reports. The reports will be based on all units physically held at a location.
On-hand quantity vs. available quantity
Starting October 1, 2026, inventory analytics models will show on-hand quantity. This includes all units physically at a location, including units committed to open orders and units currently unavailable.
Available quantity includes only units that can be sold. As a result, the new reports may show higher inventory totals by the number of committed and unavailable units.
Reports affected by the update
The change will appear in ShopifyQL queries using “FROM inventory” or “FROM inventory_by_location.” Reports powered by these models will also reflect the update.
Affected reports include Products by sell-through rate, Products by days of inventory remaining, Inventory sold daily by product, ABC product analysis, Month-end inventory value, Inventory transfer orders and shipments, and Month-end inventory snapshot.
Historical inventory data will not change
Reports for dates before October 1, 2026, will continue to show available quantity. Historical data and trends based on it will remain unchanged.
In short, Shopify inventory reports for October 1, 2026, and later will use the quantity physically on hand, while historical reports will retain their existing measure.
