Revenue Analytics
Store demand and stock analytics
Read variant orders alongside orderable time and saleable stock before making replenishment, transfer or range decisions.
Store demand and stock analytics combines orders with availability to guide replenishment, transfers and range decisions. Orders record what customers placed under the store's selling rules. By themselves, they cannot show how many purchases might have occurred while a variant was unavailable.
Start with the stock decision
Start with the saleable variant when size or colour determines what a shopper can buy. Keep the sales channel, delivery area and review period visible before rolling results up to a product.
| Decision | Evidence to read together | Limit |
|---|---|---|
| Replenish a variant | Qualifying orders, orderable time, current saleable stock and expected receipts | Orders during a stock gap understate possible demand. |
| Transfer stock | Orderability in the relevant area and stock at locations able to fulfil those orders | Stock elsewhere may not be available to these shoppers. |
| Review a slow seller | Orders and observed interest while the variant was visible and orderable | Low sales alone do not establish weak demand. |
| Revise a forecast | The forecast issued before the period, later orders and availability gaps | Constrained orders are an incomplete measure of demand. |
Establish what shoppers could buy
Check whether the variant was published, selectable and orderable for the relevant shopper. Physical stock answers only part of that question. In Shopify, on hand includes committed and unavailable units; available excludes them and incoming stock. A location may hold stock without fulfilling orders for that variant.
Selling rules also matter. Shopify normally prevents purchase when tracked stock reaches zero, but merchants can enable continued selling while out of stock. A zero balance therefore does not always mean a blocked purchase.
A month-end stock snapshot cannot establish when a variant was orderable during the month. Use dated changes where available and label intervals that cannot be reconstructed.
Variant Orderability and Availability Timeline
- Variant published
- Yes
- Variant selectable
- Yes
- Variant orderable
- Yes (during period)
Check the boundaries of historical stock data
Shopify's inventory reports have limits that affect period comparisons. Historical data for inventory-based metrics is available only from 1 October 2023. Historical reporting shows inventory from active locations only; deleted locations do not appear.
The Month-end inventory snapshot is a point-in-time quantity report, not a record of every change during the month. It includes variants adjusted or ordered in the last three years. Its Available inventory excludes committed units for pending fulfilment and incoming transfer units. Treat it as a month-end stock position, not evidence of availability throughout the period.
Deleted products and variants also have a reporting boundary. If deleted on or before 14 January 2026, their inventory data displays up to that date; if deleted after that date, it does not display beyond the deletion date. Check these conditions before treating a missing variant as having no stock history.
Key Inventory Metrics from Shopify Reports
- 1Inventory data availability start date
- 3yearsMonth-end snapshot includes variants adjusted in last
- 14Deleted products: data visible up to
Read orders alongside opportunity
Put qualifying order units, confirmed orderable time and any observed shopping signals on a common variant timeline. State the order measure and its selection rule, and apply that rule consistently across comparisons. Shopify sales reports define Orders as the number of orders placed on a given date; Gross sales has separate inclusion rules.
Compare order rates only across reasonably comparable orderable periods. Keep traffic, price, placement and promotions beside the comparison. An order rate during available time describes what happened; it is not a demand forecast by itself.
Separate recorded orders from observed interest that did not produce an order. A recorded selection of an unavailable size may warrant investigation, but it is not a lost sale. Interest that left no record, including interest in a product hidden from view, remains unmeasured.
Keep period comparisons comparable
Sales reports are updated to within about one minute, so a refreshed report can show newer data than an earlier export. Record when the data was extracted. Use a consistent review window when comparing order activity with inventory evidence.
Inventory and sales reports answer different questions and may not share the same time grain. Pair a dated order view with the best available dated stock evidence. Make clear when the stock evidence is only a month-end snapshot or when earlier history is unavailable.
Make a bounded decision
For replenishment, show saleable stock, expected receipts, orders during confirmed orderable periods and uncertainty from stock gaps. Recent sales can be a useful input. However, stockouts, promotions or seasonal changes can make the observed rate unsuitable for an order decision.
The next analysis depends on the question: join orders to dated availability, diagnose low sales, count observed blocked variant interest, or compare an issued forecast with later orders. Record the action and the evidence that could change it.
Maintain a reliable stock record
A centralised stock record can give staff a shared view of what is recorded and where it is located. Recorded quantities can differ from what is physically available. Sabel recommends regular stock counts rather than relying only on an end-of-financial-year stocktake; RFID is one tool it describes for counting stock and tracking products through the supply chain.
Set a regular time to review stock levels and define how required items move into a purchasing process. Automatic mobile point-of-sale alerts can flag low stock. A receiving check compares ordered inventory with what arrives and identifies damaged items. These checks help establish whether the stock evidence used in a trading decision reflects the stock actually received and held.
Maintaining a Reliable Stock Record – Best Practices
- Conduct regular stock countsRecommended by Sabel Australia; avoid relying only on end-of-financial-year stocktakes
- Use RFID for trackingSupports accurate product movement and real-time visibility across supply chain
- Set regular review timesDefine when stock levels are reviewed and required items enter purchasing process
- Enable mobile POS alertsAutomatically flag low stock levels at point of sale
- Perform receiving checksCompare ordered inventory with received goods; identify damaged items
In this guide
- Connecting sales analysis with stock availabilityJoin variant order lines to dated orderability intervals and keep uncertain stock periods visible before comparing sales rates.
- Distinguishing weak demand from an out-of-stock problemCheck variant orderability, visibility and observed interest before deciding that low ecommerce sales reflect weak demand.
- Measuring lost shopping opportunities from unavailable variantsDefine and count observed unavailable-variant actions while keeping later purchases and unobserved demand separate from lost sales.
- Comparing forecast demand with actual order patternsCompare issued variant forecasts with qualifying orders, flag stock-constrained periods and read forecast errors within their limits.
