A launch sells the same number of units this week, but a late receipt lowers its reported sell through rate. Before treating that change as weaker demand, reconstruct the inventory basis. For a sold-plus-ending-stock convention, divide units sold during the window by those units plus eligible ending inventory, then multiply by 100. Keep the product, location, window and movement rules beside the result.
Shopify documents that convention in its product inventory analytics. Other reports can use a receipt cohort or another declared available-stock basis. Agree on the question before comparing percentages: how much of a named receipt sold, or how much of the stock represented in this reporting window sold? Those populations can differ.
Keep units, locations and selling windows comparable
Choose the product variant and the locations included in the review. Retain the retailer item code, your item code and the unit conversion used to join them. A case in a distributor file and an individual unit in a store report cannot enter one ratio until the pack size is supported. Preserve the original quantity and its unit for later review.
Set the start and end of the observation window, the reporting time zone and the inventory snapshot time. A week of sales ending Saturday needs the corresponding stock position, not Monday's count after new receipts. Record extraction time separately from the date the data describes. A freshly downloaded file (even with a current extraction timestamp) can still contain an older stock snapshot.
Keep launch cohorts separate from mature assortment when that changes the decision. An item available for two days has had a different selling opportunity from an item available throughout the week. Show the days available and the period selected rather than annualizing or ranking the new item without that context.
The stock-to-sales ratio answers a different question about stock relative to sales value. This calculation follows physical units sold as a share of a declared stock population. A markdown changes revenue and valuation without necessarily changing the count of units sold, so those measures should not be substituted for one another.
Reconcile stock movements before choosing the denominator
Collect opening stock, receipts, sales, returns and other inventory movements for the same scope. Keep transfers, damage and adjustments visible as separate movement types. They may explain why opening inventory plus receipts does not equal units sold plus ending inventory. A disappearance from stock is not, by itself, evidence of a customer sale.
Shopify's inventory report documentation notes that inventory data is recorded while a variant tracks inventory. A missing history after tracking was disabled is a coverage gap, not a confirmed zero balance. Verify source coverage before describing the percentage as a complete account of the period.
The same Shopify documentation identifies an October 1, 2026 change from Available to On hand inventory, which includes committed and unavailable units. Earlier history retains the Available basis. Mark that break when comparing periods: a higher stock denominator can reflect the changed source definition without a new receipt or weaker sales.
Specify the sales numerator. Gross units sold and net units after customer returns produce different results. If the numerator nets returns but stock includes only sellable returned units, preserve the difference for damaged or unreleased returns. Have the inventory owner approve the convention and reconcile the movements under that convention before comparing products.
Keep receipt-cohort tracking explicit when it is the real question. A total variant balance does not identify which receipt supplied a sale if stock is commingled. Use supported lot or cohort relationships where available; otherwise label an allocation rule as an assumption. Do not imply that a ratio reconstructed from totals proves physical receipt-level consumption.
Calculate a launch with an additional receipt
Assume an illustrative launch begins with 100 units, receives 50 more during the window and sells 60. There are no returns, transfers, losses or adjustments, and all stock remains eligible for the selected product and locations. Ending inventory is therefore 100 + 50 - 60 = 90 units. These are teaching inputs, not measured brand performance.
| Calculation | Inputs | Result |
|---|---|---|
| Sold plus ending stock | 60 / (60 + 90) × 100 | 40% |
| Opening stock alone | 60 / 100 × 100 | 60%, on a different denominator |
| Inventory reconciliation | 100 + 50 - 60 | 90 ending units |
The 40% result includes the additional receipt under the declared convention. The 60% result divides by opening stock only; it does not answer the same question once the extra stock arrives. Preserve both the formula and the receipt dates when explaining the change. A lower sold share after replenishment does not establish that the sales pace slowed.
Now assume a second product sells 30 units and ends with 20 under the same convention and a comparable window. Its sell-through is 30 / 50 × 100 = 60%. Across the two products, the combined result is 90 / 200 × 100 = 45%. The unweighted average of 40% and 60% is 50%, which gives their unequal stock populations equal influence.
Keep the counts beside each percentage. A small stock population can produce a high rate after a few sales, while a large replenishment can lower the rate on an item with substantial movement. For a combined report, add compatible sold units and denominator units before dividing. Do not average percentages across mismatched periods or locations.
Check a sold-share result against the movements
Bring approved sales and inventory extracts for one product and reporting window.
Separate sales pace from stock and assortment changes
Compare the same product and location cohort over matching windows before attributing a change to demand. New store distribution, a late delivery or a status reclassification can change the denominator. Mark those events on the review and retain the prior definition. If the report changes its inventory convention, restate the comparison or show the break.
Investigate stockouts beside high sell-through. An item can sell most available stock while unmet demand remains invisible in the sales file. Conversely, low sell-through can reflect a recent replenishment or a short selling window. Check availability, receipt timing and promotion dates before selecting a reorder or markdown response.
Use retail sales velocity for movement per eligible store-week and keep the input population aligned. The sold share and the pace can move in different directions after a receipt. Neither measure alone chooses the next order quantity, which also needs the planning owner's demand assumptions and supply constraints.
How Permute keeps the sales and stock evidence together
Permute sells connected business data and custom applications. We can combine approved Shopify sales and inventory records with retailer extracts in Excel or Google Sheets, reconcile variant and location identities, and retain the source rows behind a calculation. An unresolved item mapping stays visible rather than being assigned to a similar description.
We can apply your declared observation window, return policy and stock denominator across repeated reporting. A retail operations lead can ask which products changed rate after receipts and inspect the movements and snapshot dates within their permissions. The result can expose a missing inventory period instead of filling it with a zero.
Keep purchase decisions and source corrections with their owners
This analytical review does not observe shelf availability, forecast demand or authorize a purchase. We are not a forecasting engine. Missing sales or stock history remains a limit, and a source correction requires its own supported, approved action path. The merchant and inventory owner decide which evidence supports a buying or markdown change.
Accept the percentage with its stock basis
A useful sell through rate preserves the sold units and the inventory population used to calculate it. Reconcile late receipts, returns and other movements before interpreting a change. Compare like windows and roll up compatible counts rather than averaging percentages. The launch review can then distinguish a changed stock denominator from a changed selling pace.
Review a disputed sell-through result
Bring the sales window, stock snapshots and movement references behind one conflicting percentage.
Questions about sold inventory percentages
What should the report show when the denominator is zero?
Leave the percentage undefined and show the underlying counts. A zero population does not establish perfect or failed selling performance. Investigate whether the item was unavailable, outside the selected scope or missing source history.
Is there one sell-through target for every product?
Set targets against a comparable product lifecycle, selling window and stock policy. A replenished staple and a limited seasonal launch have different decisions behind their inventory. A benchmark without the same denominator convention cannot establish the right action.
What if a late receipt changes a published result?
Preserve the earlier report version and record the source correction and its effective date. Recalculate under the same rules and explain the changed denominator. Do not present the restatement as a new observation of customer demand.