Technical
How to Detect Slow-Moving Shopify Inventory
A technical but practical guide to detecting slow-moving Shopify inventory using sales velocity, stock quantity, and days of supply.
Slow-moving inventory detection should be more than a list of old products. A useful system compares current stock with recent demand and separates overstock risk from stockout risk.
For Shopify stores, this can be calculated from product inventory, variant data, and order history.
Core inputs
The basic inputs are variant inventory quantity, recent units sold, product age, product price, and whether the variant tracks inventory. Without these, slow-moving reports can produce false positives.
New products also need special handling because they may not have had enough time to generate demand.
- Inventory quantity.
- Sales in the lookback window.
- Daily demand.
- Days of supply.
- Inventory value.
Days of supply
Days of supply estimates how long current inventory would last at the current demand rate. High days of supply means stock is likely moving slowly. Zero or very low days of supply can indicate stockout risk if demand exists.
Products with no sales and positive inventory should be treated as potential dead stock.
Turning detection into action
A report is only the first step. The system should help merchants decide what to do: promote, bundle, discount, reorder less, or hide the product.
Freddy connects the detection layer to storefront prompts so slow-moving inventory can be surfaced to relevant shoppers.
FAQ
What is days of supply?
Days of supply estimates how many days current inventory will last based on recent demand.
Should slow-moving detection happen at product or variant level?
Variant level is usually more accurate because sizes, colors, and options can move differently.
Freddy helps Shopify merchants move from inventory detection to storefront action.
See Freddy