Inventory reports can change meaning even when the numbers look familiar. Shopify announced that starting October 1, 2026, its inventory analytics models measure stock by on-hand quantity instead of available quantity. On hand includes physical units at a location, including inventory committed to open orders or currently unavailable. Available quantity covers only units available to sell.
For an ecommerce business, this distinction affects planning, purchasing, reporting, and marketing. A higher number does not necessarily mean more products can be promised to customers. This guide explains how to update definitions, dashboards, workflows, and team decisions around Shopify on-hand inventory reports.
What changed in Shopify inventory analytics
Shopify’s official update says that reports powered by inventory and inventory-by-location models now use on-hand quantity for October 1 onward. Affected reporting includes sell-through, days of inventory remaining, adjustments, daily units sold, ABC analysis, month-end value, transfers, shipments, and month-end snapshots.
Historical data before October 1 remains based on available quantity. That creates a deliberate break in metric meaning. A trend line crossing the date may compare two different inventory concepts. Businesses should label that change rather than interpreting the movement as a physical gain or loss.
On hand and available answer different questions
On-hand quantity answers a physical question: how many units are at the location? Available quantity answers a selling question: how many units can currently be offered? Committed units may already belong to open orders. Unavailable units may be damaged, reserved, under inspection, or otherwise blocked.
Both measures are useful. Problems begin when employees, dashboards, or automations treat them as interchangeable. A purchasing workflow may use on hand to understand physical exposure, while a paid campaign or customer-facing availability check should depend on sellable inventory and business rules.
Audit every downstream use of inventory data
Dashboards and exports
List reports, ShopifyQL queries, spreadsheets, business-intelligence models, emailed summaries, and accounting exports that use Shopify inventory data. Record the underlying measure and reporting date. Add a note to charts that span October 1 so readers understand why the basis changed.
Replenishment rules
Review reorder points, safety stock, and days-of-cover formulas. If a rule formerly received available inventory and now receives on hand, it could postpone purchasing even when most units are committed. Make every calculation explicit rather than relying on a field label that can change.
Marketing and merchandising
Campaigns, collection placement, product badges, and email recommendations should not infer sellability from physical inventory alone. Confirm which source powers each promise. If an item is on hand but unavailable, customer-facing messaging must not present it as ready to ship.
Customer response workflows
Phone, chat, and SMS teams need precise language. “We have five units on hand” is different from “five units are available to order.” A managed system such as Maya can support configured customer-response workflows, but the underlying inventory state and approved wording must be defined for the business.
A practical SMB example
A specialty retailer has 30 units of a popular product at one location. Twelve are committed to open orders, three are unavailable pending inspection, and 15 are available. A dashboard showing 30 on hand may look healthy, yet a promotion planned for 25 new orders would exceed sellable inventory.
The retailer changes its campaign approval checklist. Merchandising reviews available quantity, open-order commitments, expected transfers, and a safety buffer. Purchasing reviews on hand and inbound quantities. Customer service sees a simple state: available, limited, backordered, or needs confirmation. Each view uses the measure needed for its decision.
If the product falls below the campaign threshold, an integration creates a review task rather than automatically pausing every ad. The task includes product, location, on-hand quantity, available quantity, committed quantity, inbound transfer, and owner. A human decides whether to reduce spend, change the offer, or wait for receiving.
Implementation plan
Start by building a data dictionary. Define on hand, available, committed, unavailable, incoming, reserved, and safety stock in plain language. Name the system of record and owner for each field. Make the dictionary accessible to operations, finance, marketing, and support.
Next, inventory all formulas and integrations. Review ShopifyQL, exports, webhooks, connectors, warehouse systems, accounting systems, and custom apps. Check whether each process uses a named inventory state or a generic quantity. Update mappings and documentation where needed.
Then, test representative conditions. Include a normal item, committed stock, unavailable stock, a product at two locations, an incoming transfer, a partial shipment, a return, and a manual adjustment. Compare Shopify reports with location-level reality and customer-facing storefront behavior.
Finally, introduce change control. Every report or automation should have an owner, expected refresh timing, validation sample, and rollback or manual procedure. DIGIMAR automation services can help connect Shopify with reporting and operational systems while preserving clear states and exception ownership.
Measurement guidance
Track the percentage of reports with documented inventory definitions, variance between physical counts and on-hand values, variance between storefront availability and available quantity, stockouts, oversells, canceled orders, expedited purchases, and campaign changes caused by inventory exceptions.
Also monitor data freshness and integration failures. A perfect formula applied to stale data still produces an unreliable decision. Reconcile samples after product launches, large receipts, returns, and major promotions.
Protect the customer journey
An inventory analytics change should lead to clearer internal decisions, not confusing customer promises. Product pages, ads, email, checkout, support scripts, and CRM notes should share accurate, approved availability language. DIGIMAR web development can help test storefront logic and integrations across mobile and desktop journeys.
The practical rule is to preserve the distinction between physical possession and sellable availability. Use on hand for the questions it answers, use available quantity for sellability, and make every automated action reveal which state it used.
Next step
Choose one high-volume product and trace its inventory values across Shopify reports, storefront availability, advertising, customer service, purchasing, and accounting. Document every mismatch and owner. That focused audit provides a safer foundation than changing every dashboard without first understanding the business decisions behind it.
