Most retailers know their inventory is too old. They feel it when they walk the back room, see the same boxes month after month, or run a quarter-end count and watch the carrying cost line move the wrong direction. What they usually don't have is a system for catching that decay before it becomes a forced markdown — the kind that wipes out a season of margin in a single weekend sale.
Inventory aging analytics is the gap between "I think we have a slow-moving problem" and "this exact SKU is 47 days from being a write-off, and here's what to do about it." Used well, it gives small retailers a 60-90 day head start on decisions that, made late, only have one outcome: deep markdown.
Why Turnover Hides the Real Problem
Most operators rely on a single inventory metric: turnover. It's calculated category-wide, reviewed quarterly, and benchmarked against a vague industry average. The number looks fine, so the assumption is that inventory health is fine.
That assumption is wrong more often than not. Turnover is an average, and averages hide the SKUs that are quietly failing.
Consider a category with a stated turnover of 6x per year. On the surface, that's healthy — roughly 60 days of stock on hand. But within that category, the actual distribution often looks like:
- Top 20% of SKUs: Turning 12-18x per year (20-30 days of supply)
- Middle 60% of SKUs: Turning 5-7x per year (50-75 days of supply)
- Bottom 20% of SKUs: Turning under 2x per year (180+ days of supply)
The category average says "6x." The bottom-20% reality says "you have months of cash trapped in stock that isn't moving." A markdown event isn't a strategy here — it's the inevitable outcome of letting that bottom tier age in place.
The fix is to stop measuring inventory health by category averages and start measuring it by age cohort and velocity decay at the SKU level.
The Four Stages of Inventory Aging
Every SKU you carry moves through four stages between receiving and exit. Most retailers can't tell you which stage their stock is in right now.
Stage 1: Active (0-45 Days)
Newly received product is selling at or above forecasted velocity. Reorder logic is firing on schedule. Margin is intact at full price. This is what healthy inventory looks like — and what 80% of your stock should be at any given moment.
Stage 2: Watch (46-90 Days)
Velocity has decelerated by 15-30% from launch. The SKU is still moving, but more slowly than its launch curve predicted. This is the earliest point at which you can intervene cheaply: a merchandising adjustment, a placement change, a small promotional bump. At this stage, you can usually preserve full margin.
Stage 3: At-Risk (91-180 Days)
Velocity is now 50%+ below forecast. Days-of-supply is climbing instead of holding steady. This is the stage where most retailers first notice a problem — and by then, the cheap fixes no longer work. You're now choosing between a 10-15% promotional markdown or carrying the cost for another quarter.
Stage 4: Dead (180+ Days)
The SKU is no longer rotating. Carrying cost has consumed any remaining margin even at full price. The only realistic exit is a 25-50% markdown, a vendor return (if the contract allows), or a write-off. Most "clearance events" are just retailers liquidating stage-4 inventory in bulk.
The point of aging analytics is to shift more decisions to stage 2, where corrective action is still cheap, and prevent the slow drift into stage 3 and 4 entirely.
Building the Aging Buckets
You don't need new software to do this. You need three columns from your POS or inventory system:
- First-receipt date for each SKU (or per-lot if you receive multiple shipments)
- Current on-hand units
- Trailing 30-day units sold
From those, you can compute three derived metrics that drive every aging decision:
1. Days on Hand (DOH): Current units ÷ (trailing 30-day sales ÷ 30). This tells you how long your current stock will last at the current pace.
2. Velocity Decay: (Trailing 30-day units ÷ launch 30-day units) − 1. A −20% decay means the SKU is now selling 20% slower than its launch month.
3. Sell-Through Rate by Age Bucket: Units sold in the last 30 days ÷ total units received to date. Anything under 50% by day 90 is a meaningful warning signal.
Plot every active SKU against these three metrics and you get a four-quadrant view of your inventory health that no aggregate report will ever show you. The SKUs with high DOH and decelerating velocity and low sell-through are your stage-3 and stage-4 problems. They need action this week, not next quarter.
What to Do at Each Stage
Spotting the problem is half the work. The other half is knowing what action matches each stage — because the wrong action at the wrong stage burns either margin or future opportunity.
At Stage 2 (Watch): Merchandising Levers
Velocity decay at this stage is usually about visibility, not desirability. The SKU may have moved off the endcap, gotten buried in a planogram reset, or lost rotation in a featured-product slot. Your first interventions should be free or near-free:
- Move the product to a higher-traffic shelf position
- Pair it in a bundle or attach-rate display with a faster-moving complement
- Surface it in budtender or staff-recommendation training
- Add it to a category-spotlight email or in-store sign
Margin stays whole. Cash stays unlocked. Roughly 40-60% of stage-2 SKUs recover when given a visibility nudge.
At Stage 3 (At-Risk): Targeted Promotion
Once a SKU has crossed the 90-day mark with declining velocity, merchandising alone usually won't save it. The signal has moved from "low visibility" to "low pull-through demand." Now you're using promotion strategically — but with discipline:
- Cap discount depth at 15%. Going deeper signals desperation and trains customers to wait for markdowns.
- Time-bound the promotion. A 14-day window forces the velocity test; a permanent discount just resets the price.
- Measure recovery weekly. If sell-through doesn't accelerate by week two, the SKU is heading to stage 4 regardless of discount.
Roughly 50-70% of stage-3 SKUs clear at this discount band. The rest need a different approach.
At Stage 4 (Dead): Exit Strategy
By stage 4, the question isn't "how do I sell this at margin." It's "how do I get the cash out fastest with the least damage." Your options, in order of preference:
- Vendor return or rebate. Always check the contract first; many retailers leave this option on the table because they don't track return windows.
- Bundle it as a free-with-purchase. This protects your headline pricing and turns dead stock into an acquisition or attach-rate tool.
- Mark it down 30-50%. Last resort, time-boxed, communicated as a one-time event — never as your standard practice.
- Write it off. If carrying cost has already exceeded recoverable revenue, take the loss and free the shelf for something productive.
The discipline here is to not treat stage 4 as a strategy. If more than 10% of your inventory dollars are sitting in stage 4 at any given time, the upstream decisions — buying, forecasting, watching — are where the real fix lives.
The Carrying Cost Conversation
One reason retailers under-react to aging inventory is that the cost of carrying it is invisible. Cash trapped on the shelf doesn't show up as a line item on the P&L. It shows up as a loan you didn't take, an investment you didn't make, or an opportunity you didn't fund.
A reasonable rule of thumb: every dollar of inventory carries an annual cost of 20-30% when you account for capital, storage, insurance, shrinkage, and obsolescence risk. So $50,000 sitting in stage-3 and stage-4 inventory isn't just $50,000 you can't deploy — it's $10,000-$15,000 a year you're paying to keep it stuck.
That math changes the conversation. A 15% markdown that clears the stock isn't "losing 15 points of margin." It's paying once to stop a recurring carrying-cost bleed that would have cost more in 12 months. The aging framework lets you put real numbers on that trade-off instead of guessing.
Building the Review Cadence
Inventory aging analytics is only useful if it shows up in a recurring decision moment. The cadence we see work for small retailers:
- Weekly: A 10-minute scan of stage-2 SKUs. Cheap interventions, owner or manager-level call.
- Bi-weekly: A 30-minute review of stage-3 SKUs. Promotion decisions get made and time-bound.
- Monthly: A full aging review across all categories. Stage-4 cleanup, vendor-return tracking, and an upstream check on which buying decisions produced the slow movers.
The goal isn't to eliminate dead stock entirely — every retailer carries some, and that's the cost of running a varied assortment. The goal is to keep stage-3 and stage-4 combined under 15% of total inventory dollars, so the working capital trapped in non-rotating stock stays small enough to ignore.
The Bottom Line
Inventory aging is not a back-of-quarter problem. It's a weekly signal that, watched consistently, gives small retailers a real lever on margin and cash flow that almost nobody else in their competitive set is using.
The retailers who win at this don't have more sophisticated software — they have a disciplined cadence of looking at stock by age and velocity, and acting on the early signals when interventions are still cheap.
Three things to take away:
- Category-level turnover hides the SKU-level decay that actually causes markdowns
- Aging buckets (active, watch, at-risk, dead) give you four discrete decision moments instead of one annual reckoning
- The cheapest interventions live at stage 2, where merchandising fixes can preserve full margin
At Chapters Data, we help small retailers and dispensaries turn raw POS data into the aging dashboards and weekly review rhythms that catch dead stock 60-90 days early — before the markdown becomes the only option left.
