What is days of inventory (DOH)?
Days of inventory estimates how many days stock takes to sell, or how many days current stock will last, as inventory divided by the pace of sales.
Direct answer
Days of inventory has two readings. Backward-looking: average inventory ÷ cost of goods sold × days in the period, which equals days in the period ÷ inventory turnover and shows how long stock takes to sell. Forward-looking: ending units ÷ average units sold per day, which is how Shopify's Inventory remaining per product report estimates how long current stock will last, using the last 28 days of sales.
Sources and review
Last checked: 2026-11-03- Inventory reports - Shopify Help CenterShopify · Official documentation · 2026-11-03
- Inventory remaining per product divides ending quantity by the average quantity sold per day over the last 28 days; variants with no sales show N/A.
- The column is labelled Days of inventory remaining; sell-through uses a 30-day period.
- Inventory turnover - WikipediaWikipedia · Reference · 2026-11-03
- Inventory turnover is cost of goods sold divided by average inventory at cost, and days to sell inventory is 365 divided by turnover.
- Ecomwith worked example and decision frame · The illustrative arithmetic and the common misreading on this page.
Applies to: Use this answer as a definition and worked example. Verify current platform, processor and account facts before acting.
Limitations: The page does not prove a ranking, approval, revenue, profit, or conversion outcome. Platform definitions, thresholds and report names can change.
Reviewed by: Ranfeng Wei · Next review: 2027-02-01
- Forward reading: ending quantity ÷ average units sold per day over 28 days → Inventory reports - Shopify Help Center
- Backward reading: 365 ÷ inventory turnover, with turnover at cost → Inventory turnover - Wikipedia
- Worked example and misreading (illustrative arithmetic) → Ecomwith worked example and decision frame
Why this matters
Days of inventory turns stock into time. Compare the forward reading with supplier lead time to see whether a reorder still arrives before you sell out, and the backward reading with payment terms to see how long cash sits in goods.
Formula
Backward: average inventory ÷ COGS × days in the period, or 365 ÷ annual inventory turnover. Forward: ending units ÷ average units sold per day.
Worked example
Backward: average inventory at cost of $27,000 and COGS of $18,000 for a 30-day month give 27,000 ÷ 18,000 × 30 = 45 days. Forward: 120 units in stock and 168 units sold over the last 28 days give 168 ÷ 28 = 6 units a day, so 120 ÷ 6 = 20 days of stock. If a reorder takes 35 days to arrive, ordering now is already late. The numbers are illustrative.
What to check
Use this term as an operating checkpoint, not just a glossary definition.
- State which reading you use and keep it fixed between reports.
- Value inventory at cost when you divide by COGS.
- Compare the forward reading with supplier lead time and shipping time.
- Review products with no sales separately; Shopify shows N/A for them.
Common mistake
Mixing the two readings or their windows. Shopify averages sales over 28 days for days remaining and uses 30 days for sell-through, and a seasonal spike inside the window can make stock look shorter or longer than it really is. A product with no sales shows N/A, which is a problem to review, not infinite stock.
FAQ
How do I convert inventory turnover into days of inventory?
Divide the days in the period by turnover for that period. With 8 turns a year, 365 ÷ 8 ≈ 45.6 days. With 0.67 turns in a 30-day month, 30 ÷ 0.67 ≈ 45 days. Pick one day-count convention and keep it.
Is a lower number of days always better?
Lower usually means stock sells faster and ties up less cash. Very low can mean thin stock and stockouts, so compare the forward reading with your supplier lead time before deciding.
Where do I find days of inventory in Shopify?
In Analytics > Reports, filter by the Inventory category and open Inventory remaining per product, where the column is labelled Days of inventory remaining. It divides ending quantity by the average quantity sold per day over the last 28 days.
What does N/A mean in the Shopify report?
A variant with no sales in the period shows N/A, because there is no sales rate to divide by. Treat those variants as a separate list to review for slow-moving or dead stock.
Useful page? Share it
Copy the link or share this page directly with a teammate, friend, or partner.