Days-of-cover per SKU = on-hand / 30D velocity. Surfaces stockout risk before it bites.
At a glance
Per-SKU days-of-cover, computed as Available ÷ avg_units_sold_per_day_30D. The forecasting view of inventory: which variants will OOS in 5 days, 14 days, 30 days, given current velocity?
Calculation
Calculated automatically from your Shopify data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A US apparel DTC brand on Shopify, ~1,800 active variants. 30D window 12 Apr 26 to 12 May 26. Top-by-velocity variants:
Six things to notice:
- Sand M is the urgent fire. 1.0 day cover; OOS imminent. PO arrival or stock transfer needed today. Cross-reference Inventory Alerts for the live OOS list including this SKU within hours.
- Sand L is on borrowed time. 4.4 days cover at current velocity. Standard reorder lead time is typically 14-21 days; this SKU will OOS before reorder arrives unless emergency stock transfer is arranged.
- The “at risk” bucket is the planning-priority list. 9.3 days cover means OOS in ~10 days; with normal lead times, the action window closes today. This is where ops attention should focus.
- Surplus on Cream 12 is signal. 80 days cover at 90 units/30D means demand is asymmetric across colour-size combinations. Cream 12 is a slow-mover; allocate fewer units in next PO cycle.
- Linen tee Black S has 480 days cover. Either over-ordered (capital tied up) or genuinely a slow-mover that should be marked-down or de-listed. Pair with margin-per-unit to decide clearance vs hold.
- Velocity assumes recent demand continues. Marketing pushes, viral moments, or seasonal peaks invalidate the assumption. Sand M’s 240 units/30D could collapse to 80 next month if the marketing wave passes; cover would extend to ~3 days from a single day. Pair with marketing calendar to forecast better.
Sibling cards merchants should reference together
Stock vs Sales velocity is the forecasting cousin. Companions:Reconciling against the vendor’s own dashboard
Where to look in Shopify Admin: Shopify doesn’t expose days-of-cover natively. Closest reconstructions:- Reports → Inventory → Sell-through rate: shows what % of stock sold in a period; mathematically related but not days-of-cover.
- Apps like Stocky / Inventory Planner / Cogsy: typically expose days-of-cover and reorder forecasting.
- Reports → ABC analysis (Shopify Plus): SKU-velocity classification (A = top, B = middle, C = slow).
Cross-connector reconciliation:
Known limitations / merchant FAQs
What’s a healthy days-of-cover target? Depends on your reorder cadence and lead time:- Fashion DTC with 21-30 day lead times: target 30-45 days cover on top-velocity SKUs.
- Subscription consumables with 14-day fulfilment cycles: target 21-30 days cover.
- Slow-fashion with 60-90 day lead times: target 60-120 days cover.
- Fast-fashion with 7-14 day reorder: 14-30 days suffices.
- Daily ops: scan the Critical (≤7d) bucket. Reorder or transfer immediately.
- Weekly planning: scan At Risk (8-14d) bucket. Confirm POs are in flight; chase suppliers if not.
- Monthly review: scan Surplus (>60d) bucket. Decide markdown, clearance, or de-list.
- Quarterly forecasting: review velocity-by-SKU trends; tighten PO models for chronic over-orders or under-orders.
- Lead-time review: if Critical bucket is regularly populated, lead times are too long for your safety stock policy. Either widen safety stock or shorten lead times.
- Cross-reference with paid media: pause Google Ads / Meta on Critical-bucket SKUs, see Active Ads on OOS.