One stock movement, two explicitly different ratios
Illustration: start with 100 units, receive 50 more, ship 90, and accept 10 matched returns back into saleable stock. With no other movements, closing stock is 70. A sold/(sold + closing stock) view gives 90/(90 + 70) = 56.25%. A separately defined net-retained/supply view gives (90 − 10)/(100 + 50) = 53.33%. The difference comes from definitions, not a calculation error. Neither number establishes margin or a reorder quantity.
Name the report’s calculation
Shopify documents its sell-through calculation as quantity sold divided by quantity sold plus ending inventory. Its documented sold quantity excludes adjustments such as returns and transfer receipts. Read the actual date range and processing delay in the report. Do not assume that another dashboard’s “sell-through” uses the same numerator, denominator or window.
Reconcile the stock movement before comparing
Choose a variant, location scope and period. List opening stock, external receipts, transfers, customer shipments, resaleable returns, write-offs and manual corrections. A location transfer changes one warehouse’s balance without creating new company-wide stock. A returned item that cannot be resold should not silently increase saleable availability.
Keep a simple reconciliation alongside the percentage. Opening units plus receipts, adjusted for the agreed movements, should explain the closing stock. Investigate discrepancies before treating a surprising rate as demand. Negative stock, missing inventory tracking or late updates can make a neat percentage misleading.
Keep net retained sales as a separate view
For a planning exercise, a team may also define net retained units as shipped units minus matched returned units. Divide by a clearly stated supply base and label this custom view separately. Do not replace one side of the platform formula with net units while leaving the other side unchanged and still call it the same report.
Record whether the review follows an intake batch or a rolling calendar. Replenishment creates different time at risk for each unit; stock arriving on the final day has not had the same selling opportunity as opening stock. Compare similar seasons and variant availability, not just identical calendar lengths.
Turn the pattern into a review, not an automatic reorder
Inspect the style-colour-size mix and the commercial result together. A high aggregate rate can conceal missing core sizes; a slow style can still contribute useful margin. Before ordering or discounting, review lead time, confirmed inbound units, season remaining, return behaviour and cash constraints with the responsible owners. No universal target fits every assortment.
Use this at work
- Write the numerator, denominator and exact period.
- Reconcile receipts, shipments, returns and closing stock.
- Label custom net-sales views separately.
- Review sizes, margin and lead time before action.
Reference material
Platform guidance checked 3 October 2026. Examples and working checklists are Faccelerate editorial illustrations.