Practical analytical guidance
How to Identify Slow-Moving Inventory
Identify slow-moving inventory using sales velocity, availability, stock exposure and product lifecycle. Build a review queue before making purchasing or markdown decisions.
Low sales are a starting signal, not a final verdict.
Slow-moving inventory is stock whose movement is low relative to the business’s relevant selling expectations and review period. Those expectations differ between a core replenishment item, a seasonal style and a high-value jewelry piece. A fixed rule such as “no sale in 30 days” can help identify candidates for review, but should not automatically determine an exit decision.
Begin by stating the decision: reduce the next purchase, investigate a category, rebalance stock or evaluate a markdown. Then define a review period appropriate to the product lifecycle and selling season. The result should be a manageable queue of products to assess, with evidence and next steps.
Build the queue in five checks.
- Confirm the stock position. Use an as-of date, saleable units and a stable SKU identifier. Separate damaged, reserved or otherwise unavailable units if the source provides them.
- Measure movement. Calculate units sold over the chosen period and average weekly unit sales. State whether sales are net of returns. A longer window can help interpret intermittent sales; a shorter window can reveal recent deterioration.
- Check the opportunity to sell. Review launch timing, unavailable days, channel placement and seasonal relevance. Low recorded sales while out of stock do not demonstrate weak underlying demand.
- Evaluate exposure. Review units on hand, inventory at cost when available, recent receipts and outstanding orders. High unit exposure and high capital exposure may identify different priorities.
- Add the commercial context. Consider lead time, minimum orders, the remaining selling window and the product’s role before recommending action.
Handle zero sales and aging correctly.
If a SKU has positive stock but no unit sales in the review period, stock cover cannot be calculated by dividing by a zero weekly rate. Label it “no sales in the review period” and investigate. Zero weeks of cover would incorrectly suggest there is no stock exposure.
Days since the last sale and the age of the stock are different measures. Recent stock may have no sales yet; an older item may have sold yesterday. Actual aging requires receipt, batch or inventory-age records. A current stock snapshot and six months of sales do not establish the receipt date of the units still held.
Prioritize by exposure and evidence strength.
Illustrative example with fictional data
A product sold 12 units in 12 weeks and has 72 saleable units on hand. The observed weekly rate is 1 unit and current stock cover is 72 weeks. At an assumed unit cost of $25, the inventory at cost is $1,800.
That combination warrants review before another purchase. It does not establish that all $1,800 is a loss. A coming selling season, an existing wholesale commitment or an intentionally maintained range could change the decision. Confirm those factors and any open purchase orders before recommending a pause or reduction.
A useful review queue records the SKU, category, unit movement, stock position, cost exposure where available, data limitations, suggested next action and a reassessment condition. Rank by the business’s priorities rather than by an unexplained composite score.
Choose a response that fits the finding.
Possible responses include pausing additional purchases, reducing planned depth, reviewing product placement, reallocating units where a supported channel opportunity exists, testing a commercial change or reviewing exit options. Each requires different evidence. A price reduction should consider margin and brand context; a replenishment pause should account for committed supply.
Use SKU performance analysis to compare the flagged items with their peers. For broader stock exposure and replenishment questions, see inventory analytics consulting. Elarva’s approach carries findings through to implications, priorities and evidence-supported actions.
Start with your decision
Review the inventory issue in context.
Start with one primary business question if you need a focused assessment. Scope is confirmed before work begins.