Starting September 1, 2026, Shopify inventory reports use on-hand quantity instead of available quantity. On hand includes every unit physically recorded at a location: available units, committed units and unavailable units. As a result, inventory reports can show higher quantities and values after the change even when no new stock arrived. Shopify has not rewritten earlier data, so dates before September 1 still use the previous available-inventory basis.
This reporting change affects standard inventory reports and custom analytics built on Shopify inventory data. It does not make committed or unavailable stock sellable, and it does not include incoming inventory that has not yet been received. Merchants should annotate the September 1 reporting boundary, reconcile the three on-hand components and review any dashboards, forecasts or month-end procedures that assumed reported inventory meant “available to sell.”
Last reviewed: September 2, 2026. Inventory data can affect purchasing, fulfillment and financial reporting. Confirm your store’s figures in Shopify Admin and review accounting treatment with your finance professional before changing a formal valuation process.
What Changed in Shopify Inventory Reports on September 1, 2026?
Shopify changed its inventory analytics models so that reports reflect on-hand quantity rather than available quantity. The change applies from September 1 onward. Historical reporting before that date remains on the previous basis.
The reason matters: “available” answers how many units can currently be sold, while “on hand” answers how many units are physically recorded at a location, including stock already reserved for orders or intentionally withheld from sale. Both are useful, but they answer different business questions.
If a report rises on or after September 1, do not immediately conclude that Shopify duplicated inventory or that a receiving event was missed. First compare the location’s available, committed and unavailable states. The apparent increase can simply be the newly included quantities.
What the change does
- includes committed inventory in the reported on-hand total;
- includes unavailable inventory, such as damaged, quality-control or safety stock;
- keeps available inventory as a separate operational state;
- leaves data before September 1, 2026 unchanged;
- changes reports and custom explorations powered by Shopify’s inventory analytics models.
What the change does not do
- It does not make committed or unavailable units available for sale.
- It does not add incoming units before they are received.
- It does not by itself correct inaccurate stock counts.
- It does not mean a physical delivery occurred on September 1.
On Hand vs Available, Committed, Unavailable and Incoming Inventory
The safest way to interpret the new reports is to separate physical ownership from sellable availability. Shopify defines on-hand inventory as the sum of available, committed and unavailable units at a location.
| Inventory state | What it represents | Included in on hand? | Available for a new sale? |
|---|---|---|---|
| Available | Units ready to sell and not reserved or held back | Yes | Yes |
| Committed | Units reserved for placed orders, qualifying draft orders or transfers ready to ship | Yes | No |
| Unavailable | Units held for reasons such as damage, quality control, safety stock or an app reservation | Yes | No |
| On hand | All units physically recorded at the location | It is the total | Only its available portion |
| Incoming | Units moving to the location but not yet received | No | No |
The core relationship is:
On hand = Available + Committed + Unavailable
Incoming inventory becomes part of on hand only after it is received and moved into an on-hand state. This distinction is especially important when purchase orders, transfers or inventory apps are involved.
A Practical Example: Why the Report Can Rise Without a Delivery
Assume a warehouse has 100 units of one variant physically present:
- 60 are available to sell;
- 25 are committed to unfulfilled orders;
- 15 are unavailable because 10 are safety stock and 5 are under quality control.
Under an available-quantity view, the report would emphasize 60 units. Under the new on-hand basis, it shows 100 units. The 40-unit difference is not new inventory. It is stock that was already present but excluded from the available figure.
| Measure | Quantity | Operational meaning |
|---|---|---|
| Available | 60 | Can accept new demand |
| Committed | 25 | Reserved for existing demand |
| Unavailable | 15 | Present but intentionally not sellable |
| On hand | 100 | Total physically recorded |
How the same number can support two decisions
Purchasing and warehouse teams may need on-hand quantity to understand physical stock and working capital. Merchandising and availability teams still need available quantity to decide whether products can be sold. A single dashboard should not silently use one measure for both decisions.
Which Shopify Inventory Reports Are Affected?
Shopify says reports powered by its inventory analytics models now reflect on-hand quantity from September 1. The affected set includes several reports merchants use for replenishment, valuation and performance analysis.
| Report or analysis | What to recheck |
|---|---|
| Products by sell-through rate | Confirm how the larger on-hand denominator changes the rate and comparisons. |
| Products by days of inventory remaining | Do not treat unavailable units as immediately sellable cover. |
| ABC product analysis | Review whether classification shifts reflect demand or the measurement change. |
| Inventory sold daily by product | Check any calculated ratios that divide sales by inventory quantity. |
| Month-end inventory value | Reconcile committed and unavailable stock by location before sign-off. |
| Month-end inventory snapshot | Document the reporting basis when comparing August with September. |
| Inventory adjustment changes | Separate real adjustments from the new display basis. |
| Inventory transfer orders and shipments | Distinguish received on-hand stock from units still incoming. |
Availability decisions still require available quantity
A report showing high on-hand inventory does not prove that a variant can accept more orders. Large committed or unavailable balances can leave very little sellable stock. Low-stock workflows should continue to use the state that matches the action they trigger. If you automate alerts, review the examples in our Shopify Flow automation guide.
How to Compare Shopify Inventory Data Across September 1
The reporting series has a measurement boundary. Shopify states that data before September 1 remains unchanged, while data from September 1 onward uses on hand. A chart spanning both periods can therefore contain two different definitions.
Do not interpret the boundary as an operational event
A jump between August 31 and September 1 might come from the definition change rather than a purchase order, transfer, count or adjustment. Add an annotation to internal dashboards and month-end workpapers. If a BI tool imports Shopify data, add a field such as inventory_measurement_basis with values like available_pre_2026_09_01 and on_hand_from_2026_09_01.
Use like-for-like comparisons
- Compare available quantity with available quantity when analyzing sellable stock.
- Compare on-hand quantity with on-hand quantity when analyzing physical holdings.
- Avoid calculating a September growth rate against an August value unless the basis is aligned.
- Keep the source date, timezone and location filters with every exported snapshot.
Build a bridge for management reporting
For an August-to-September bridge, show the prior available figure, add committed inventory, add unavailable inventory and arrive at on hand. Then show genuine receipts, sales, returns, transfers and adjustments separately. This prevents the definition change from being reported as operational growth.
What to Check in Month-End Inventory Value and Snapshot Reports
The timing makes the change especially important for September reporting. On-hand data is often closer to a physical-stock view, but a Shopify report is still only as accurate as product costs, location assignments, inventory states and transaction timing.
Reconcile by location, not only storewide
Export or review each active location separately. A storewide total can hide a large unavailable balance at one warehouse or committed units waiting at another. Locations that do not fulfill a variant can still hold on-hand stock, even when available is not shown for new orders.
Review unavailable reasons
Unavailable stock can include damaged units, quality-control holds, safety stock or app-managed reservations. Confirm that each balance still has a valid reason. Old app reservations and forgotten quality-control holds can overstate useful stock even if the physical count is correct.
Check product costs and deletions
Quantity accuracy does not guarantee value accuracy. Confirm cost data for important variants and document how deleted products, deleted variants or inactive locations affect the report. Shopify’s Help Center lists specific limitations for historical inventory reporting, so preserve exports required by your retention policy.
Do not use the report as the only accounting record
Reconcile Shopify with your inventory ledger, warehouse system and accounting platform. The Shopify Payments activity report addresses money movement rather than stock; our Shopify Payments reconciliation guide explains that separate workflow.
How to Review ShopifyQL and BI Dashboards
Shopify specifically notes that custom analytics using its inventory models are affected. Review queries, calculated fields and downstream dashboards rather than assuming the visual report is the only place where the meaning changed.
Audit the metric, denominator and label
- Identify every query or export that reads inventory or inventory-by-location data.
- List calculated metrics that use inventory quantity as a denominator.
- Change vague labels such as “stock” to “on hand” or “available.”
- Flag charts that cross September 1, 2026.
- Validate results for a few known SKUs and locations before refreshing executive dashboards.
Example ShopifyQL validation query
The current ShopifyQL developer documentation provides inventory-by-location fields for on-hand units and value. A simple validation exploration can group the ending units by location and variant:
FROM inventory_by_location
SHOW ending_inventory_units_at_location,
ending_inventory_value_at_location
GROUP BY inventory_location_name, product_variant_id
SINCE -7d UNTIL today
ORDER BY ending_inventory_units_at_location DESC
LIMIT 200Field availability and naming can evolve. Use the ShopifyQL editor’s current schema and official documentation instead of copying an old saved query without validation.
Test downstream tools
If an analytics, ERP or inventory app consumes Shopify data, ask whether it uses available quantity, on-hand quantity or both. Confirm its refresh schedule and whether it preserves the pre-September definition. An app update or reservation can also change unavailable stock; our guide to auditing Shopify apps and conflicts provides a wider review process.
A Safe Inventory Reconciliation Workflow
1. Preserve a dated snapshot
Export the relevant report and record the date, timezone, locations, filters and measurement basis. Do not overwrite the only copy of an August month-end export with a September report.
2. Select a controlled sample
Choose high-value variants, fast sellers, items with reservations and products managed by apps. Include at least two locations if you operate a multi-location store.
3. Rebuild the on-hand total
For each sampled variant and location, verify that available plus committed plus unavailable equals on hand. Investigate any unexpected state rather than adjusting the total merely to make the report look familiar.
4. Trace committed inventory
Review open and draft orders that reserve inventory. An old unfulfilled order can keep units committed longer than expected. Resolve the order workflow before manually changing quantities.
5. Trace unavailable inventory
Review damaged, quality-control, safety-stock and app-held quantities. Confirm that staff know who can release each state and what evidence is required.
6. Separate incoming inventory
Verify that purchase orders and transfers still in transit are not treated as on hand. If you are replacing Stocky or rebuilding receiving procedures, use our Stocky migration checklist.
7. Validate reports and dashboards
Compare Shopify Admin, exported data and any connected BI tool for the same date and filters. Record expected differences and owners for unresolved exceptions.
8. Approve adjustments carefully
Make inventory adjustments only after the reason is known. Use adjustment reasons and notes where available so the next audit can distinguish a physical correction from a reporting-definition change.
Common Problems After the Reporting Change
“My inventory increased overnight”
First calculate committed plus unavailable units on August 31. If the increase is close to that amount, the new on-hand basis is the likely explanation. Then check real receipts and adjustments before concluding.
“The report says we have stock, but the product is sold out”
On-hand units can be committed or unavailable. Check the available state by variant and fulfilling location. Also review location assignment and the “continue selling when out of stock” setting.
“Days of inventory remaining looks healthier”
The calculation may now reflect more physical units. That does not mean all units can satisfy new orders. Review the metric definition and compare it with available inventory, order backlog and the age of unavailable stock.
“Month-end inventory value jumped”
Build a bridge from available to on hand and validate costs. Separate the measurement change from real receipts, returns, transfers and write-offs. Escalate unexplained differences to the inventory and finance owners.
“Shopify and our ERP no longer match”
Confirm that both systems use the same inventory state, timestamp, location scope and cost basis. One system may still report available inventory while the other now displays on hand.
“An app appears to reserve too much stock”
Review the app’s configuration and unavailable quantities before uninstalling or changing data. Preserve evidence, test one SKU and confirm the app’s documented release behavior. Large unexplained reservations can be a configuration or integration issue, not a Shopify reporting defect.
Improve Inventory Discipline After the Change
The reporting update is a useful reason to define which metric owns each decision:
- Available for sellability, low-stock alerts and short-term demand coverage;
- Committed for backlog, fulfillment workload and reservation aging;
- Unavailable for damage, quality control, safety stock and app holds;
- On hand for physical holdings, warehouse control and stock reconciliation;
- Incoming for expected receipts and transfer planning.
Assign owners and review intervals for each state. Document receiving, reservations, quality holds, transfers and write-offs. If your catalog structure is also changing, our guide to Shopify’s new collections model can help separate merchandising organization from the inventory-location model.
For hands-on help validating inventory reports, ShopifyQL dashboards or a multi-location workflow, contact SmallDeskApps through the Shopify support blog.
Frequently Asked Questions
When did Shopify inventory reports switch to on-hand quantity?
The change applies from September 1, 2026. Shopify says data before that date remains unchanged.
What is the difference between on hand and available in Shopify?
Available inventory can be sold. On-hand inventory is the total physically recorded at a location and equals available plus committed plus unavailable units.
Does on-hand inventory include incoming stock?
No. Incoming units are not on hand until they are received and moved into an on-hand state.
Why is on-hand inventory higher than available inventory?
The difference consists of committed and unavailable units. These items are physically recorded but reserved for orders or withheld from sale.
Did Shopify rewrite historical inventory data?
No. Shopify states that reporting before September 1, 2026 remains on the previous basis, which creates a definition boundary in charts spanning that date.
Which reports should I review?
Review inventory snapshots and values, sell-through, days remaining, ABC analysis, sold-daily reports, adjustments, transfers and any custom ShopifyQL or BI dashboards that use inventory data.
Does a higher on-hand number mean I can accept more orders?
Not necessarily. Only the available portion can accept new demand. Committed and unavailable units are included in on hand but are not available for a new sale.
Should I change inventory quantities to match the old report?
No. First reconcile the inventory states and confirm whether the difference is only the reporting-basis change. Adjust quantities only when a verified physical or transactional discrepancy exists.
