Direct answer
How do you spot Shopify inventory risk early?
Spot Shopify inventory risk by converting units on hand into days of cover and comparing that figure with sales velocity, supplier lead time, and a safety buffer. Adjust for planned campaigns and recent demand changes. Review low-cover products for stockout risk and slow movers for cash exposure, then assign each exception a specific action and review date.
Move from units to days of cover
Units on hand are difficult to interpret without sales velocity. Divide available inventory by a representative daily sales rate to estimate days of cover, then compare it with supplier lead time and the desired safety buffer.
Use more than one velocity window for seasonal or fast-changing products. A recent seven-day pace and a steadier 30-day pace can expose acceleration before a stockout.
Include planned demand
Campaigns, creator posts, retail events, and discounts can change demand faster than historical averages predict. Flag products scheduled for promotion and estimate whether stock can support the expected lift.
When cover is tight, choose deliberately between replenishing, reducing promotion, shifting spend, recommending substitutes, or accepting a controlled stockout.
Find overstock with context
Slow-moving stock is not automatically a discount candidate. Check margin, product role, seasonality, bundle affinity, and whether poor visibility rather than weak demand is the problem.
Prefer actions that preserve value: improve merchandising, pair complementary products, target a relevant segment, or adjust replenishment before defaulting to a broad markdown.
Create a weekly inventory queue
- Review products below the lead-time-plus-buffer threshold.
- Flag promoted products with insufficient cover.
- Rank overstock by cash tied up and realistic actionability.
- Assign each exception an action, owner, and next review date.
Frequently asked questions
How do I identify products at risk of stockout?
Convert units on hand into days of cover, then compare that against sales velocity, supplier lead time, and a safety buffer. A product whose cover is shorter than its replenishment lead time is already at risk, regardless of how healthy the unit count looks.
How do I find overstock and bundle opportunities?
Look for slow movers with long days of cover and meaningful cash exposure, then check margin, seasonality, product role, and recent visibility before labeling them overstock. For bundle opportunities, look for complementary products that customers already buy or use together and test a relevant pairing instead of forcing unrelated stock into a discount.
What is days of cover and why use it instead of units?
Days of cover expresses stock as how long it will last at current velocity rather than as a raw count. Units on hand describe the past. Days of cover looks forward, which is what a replenishment or markdown decision actually needs.
How should planned campaigns change inventory risk?
Adjust expected demand before the campaign runs, not after. A promotion applied to a product already near its lead time turns a manageable position into a stockout, and that becomes visible too late if cover was calculated on unadjusted velocity.
How often should inventory risk be reviewed?
Weekly, as an exception queue rather than a full catalogue report. Review low-cover products for stockout risk and slow movers for cash exposure, and give each exception a specific action and a review date.