How to find slow-moving stock without overreacting to one quiet week
Find slow-moving inventory by combining stock age, units available, sell-through, days since last sale, seasonality, and product lifecycle. Use several observation windows and distinguish new, seasonal, core, and discontinued items before marking stock for discount or removal.
From the field · Boutique manager
Review boutique stock before a seasonal markdown
The shop has summer dresses, year-round basics, and a new accessory range. A transfer between locations reset receipt dates for some older products, and one week of POS data is incomplete.
Columns used in the example
sku · category · first_receipt_date · last_receipt_date · on_hand · weekly_units_sold · season · location
Follow it with your own file
- Restore stock age using receipt and transfer lineage.
- Exclude the incomplete sales week from rate comparisons.
- Calculate sell-through and days of cover over appropriate product windows.
- Create action tiers and review high-value or seasonal exceptions.
Check: Flag counts and inventory value must reconcile to current stock, every excluded week or item needs a reason, and a sample should be checked against physical inventory and merchandising context.
What needs resolving first
A winter product can appear dead in summer, while a new item has no fair historical window. One quiet week or a missing sales file can trigger unnecessary discounting.
Doing these steps in Prepyr
Prepyr accepts CSV files only. Export the worksheet or table you need as a UTF-8 CSV first; workbook formulas, formatting, macros, charts, and other sheets will not be included. Describe the result you need: Identify slow-moving or dead stock using fair product-specific evidence. Check the columns selected, preview any proposed changes, and compare the output with the source before applying or exporting it.
Prepyr steps used here: Data profiling · Natural Language analysis · Charts · Reusable workflows
What changes the answer
- Choose original receipt, last receipt, or weighted age and retain transfer history.
- Separate new, seasonal, core, promotional, and discontinued inventory.
- Compare recent sales, longer-run sell-through, stock cover, and last-sale date.
- Use watch, transfer, reorder-stop, bundle, discount, or write-off actions with owner review.
Slow movement is relative to a product's job
The same sales rate can be acceptable for a high-margin seasonal item and problematic for a replenishable basic. Segmentation and several time windows prevent a single threshold from making expensive decisions.
Where this usually goes wrong
Do not call an item dead when stock was unavailable for much of the period. Distinguish no demand from no opportunity to sell.
Build the result step by step
- Define inventory age: Choose original receipt, last receipt, or weighted age and retain transfer history.
- Segment product context: Separate new, seasonal, core, promotional, and discontinued inventory.
- Measure several windows: Compare recent sales, longer-run sell-through, stock cover, and last-sale date.
- Tie flags to actions: Use watch, transfer, reorder-stop, bundle, discount, or write-off actions with owner review.
Choose the approach that matches the evidence and repetition
| Approach | When it works | What to verify |
|---|---|---|
| No sales this week | Immediate exception scan | Noise and missing data |
| Days since last sale | Inactivity monitoring | Seasonality and availability |
| Segmented sell-through | Markdown and range decisions | Lifecycle definitions |
Warning signs in the file
- Slow stock is defined only as zero sales this week.
- New and seasonal items use the same threshold as core products.
- Inventory age starts from the latest transfer rather than original receipt.
Make the output easy to check
- Stock age definition selected
- Product lifecycle segmented
- Data completeness checked
- Several windows compared
- Action tiers reviewed
A stock-aging and sell-through report that identifies genuine carrying risk and recommends proportionate actions without punishing new or seasonal products.
Questions readers usually ask next
How long before inventory is slow-moving?
There is no universal period. It depends on product lifecycle, lead time, season, margin, and the decision the threshold supports.
Is zero sales the same as zero demand?
No. Stockouts, poor availability, missing data, or a product not yet launched can also produce zero sales.