Inventory reports now show on hand quantity

Published

This summary was written by ShopDigest AI from Shopify Changelog’s report. Read the full story ↗

Starting October 1, 2026 On hand quantity includes all units physically at a location, including units committed to open orders and units currently unavailable. Available quantity includes only units that are available to sell. What to expect 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 Month-end inventory snapshot Your past data won't change. Reporting before October 1, 2026 still shows available quantity, so historical numbers and trends stay exactly as they were. Only October 1 and later use on hand.

Overview

Starting October 1, 2026, Shopify inventory analytics models will measure stock by on hand quantity instead of available quantity. On hand quantity includes all units physically at a location, including units committed to open orders and units currently unavailable, while available quantity includes only units that are available to sell. Historical data before October 1, 2026 will remain unchanged and still reflect available quantity.

What Changed

  • Inventory analytics models now use on hand quantity instead of available quantity.
  • On hand quantity includes all units physically at a location, including committed and unavailable units.
  • Available quantity includes only units that are available to sell.
  • Reported inventory may be higher than before by the number of committed and unavailable units.
  • ShopifyQL queries using FROM inventory or FROM inventory_by_location will reflect the change.

Affected Reports

  • 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
  • Month-end inventory snapshot

Frequently asked questions

When do Shopify inventory reports start showing on hand quantity?

Starting October 1, 2026, Shopify inventory analytics models measure stock by on hand quantity instead of available quantity. Reporting before that date still shows available quantity, so historical numbers and trends stay exactly as they were.

What is the difference between on hand quantity and available quantity in Shopify inventory reports?

On hand quantity includes all units physically at a location, including units committed to open orders and units currently unavailable. Available quantity includes only units that are available to sell.

Which Shopify reports are affected by the switch to on hand quantity?

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. Any reports powered by the inventory or inventory_by_location models will reflect the change.

Will my past Shopify inventory data change after October 1, 2026?

No, past data won't change. Reporting before October 1, 2026 still shows available quantity, so historical numbers and trends stay exactly as they were. Only October 1 and later use on hand quantity.

How does the on hand quantity change affect ShopifyQL queries?

When writing ShopifyQL, the change can be seen when you query FROM inventory or FROM inventory_by_location. Any reports powered by these models will reflect the switch to on hand quantity.

Why might reported inventory be higher after October 1, 2026?

Reported inventory may be higher than before by the number of committed and unavailable units. This is because on hand quantity includes all units physically at a location, not just what's sellable.

About this story

Published
14 Aug 2026
Originally published at