Most retailers handle markdowns by feel. A manager walks the floor, notices a sleepy shelf, and signs off on a discount — often weeks after the SKU stopped pulling its weight and usually deeper than the data justified. Markdown cadence analytics turns that ad-hoc instinct into a structured rhythm: scheduled, tiered price reductions that surface from your POS and inventory data instead of from gut feel. The payoff is real cash freed from dead stock, less margin given away unnecessarily, and a calmer back-office routine. Here's how to build the cadence and run it.

Why Markdowns Quietly Drift Off-Cadence

Most small retailers don't have a markdown problem because they discount too much. They have one because they discount too late and then too deep to catch up. Three patterns drive that drift:

  • Attention bias. A SKU has to bother somebody before it gets reviewed. By the time you notice the third gathering-dust week, you've already paid carrying cost on capital that should have been recycled into faster-moving stock.
  • Reactive depth. A delayed markdown almost always has to be steeper. A 15% reduction in week 6 often does the work that a 35% reduction has to do in week 14 — because the longer stock sits, the more your customer base has self-selected past it.
  • No exit. Without a defined floor and a clearance step, slow stock stays in your normal assortment indefinitely, taking shelf space, planogram attention, and cash you can't reinvest.

The cost is concrete. With annualized inventory carrying cost typically running 20-30% of unit value — capital, insurance, shrinkage, opportunity cost combined — every 30 days a unit sits unsold at full price burns roughly 2% of its landed cost in pure carry. Multiply that across a typical aging bucket and a measurable share of your gross margin — often 2-4% of revenue — quietly evaporates before any markdown is even taken. Cadence analytics is how you stop paying that tax.

The Two Timers That Should Drive Every Markdown

A markdown trigger has to answer two questions at once: how long has it been here? and how is it actually moving? Picking one timer and ignoring the other is the single most common mistake.

The age timer counts days since the unit arrived — or, more accurately, days since it first hit the floor. It's a simple aging bucket — 0-30, 31-60, 61-90, 91-120, 121+ — and it's the discipline that prevents stock from going invisible.

The velocity timer compares actual sell-through to expected sell-through for that SKU's category. If a fragrance line typically sells 8 units per 30 days at one location and a new launch is at 2 units, that's a 75% velocity gap — independent of age — and it deserves an early intervention.

Why both? Because each catches a different failure:

  • Slow-launching SKUs show velocity gaps long before they're "old." Pulling them into the cadence early prevents a markdown crisis at day 120.
  • Steady-moving SKUs that age can still look fine on velocity but be losing relevance. A midweight jacket selling one unit per week in March is statistically healthy and operationally a problem.

A real markdown trigger flags any SKU that crosses either threshold, then routes both into the same tiered response. The reporting view is one report with two trigger columns, not two separate workflows.

Building the Cadence Ladder

Once you have triggers, the next question is the ladder — the sequence of discount depths you walk a SKU down through. A workable starting cadence for a non-perishable retail category looks like this:

  • Tier 1 — Soft Markdown: 10-15% off, applied at the first trigger (age 60+ days OR velocity gap ≥50% by day 30). Goal: lift sell-through enough to confirm whether the slowness is price-sensitive or assortment-sensitive.
  • Tier 2 — Active Markdown: 25-30% off, applied if Tier 1 doesn't produce a 30-day velocity improvement of at least 50%. Goal: meaningfully reset the SKU's customer pool.
  • Tier 3 — Promotional: 40-50% off, applied at age 120+ days if the SKU still hasn't cleared. Goal: free the cash, even if you concede most of the margin.
  • Tier 4 — Clearance: 60%+, or bundle/donate, applied at age 150+ days. Goal: get it off the floor.

The numbers shift by category. Apparel typically runs a faster, deeper ladder — a 30-day Tier 1, a 60-day Tier 2. Hardline goods, books, and durable categories can carry a longer, shallower ladder. Cannabis flower and edibles, given freshness windows and shelf-life regulations, usually demand an accelerated cadence with Tier 1 starting at 45 days and Tier 4 hitting at 90.

The honest calibration test: pull two years of your own data and ask, "At what price reduction did units actually clear?" For most categories, you'll see a bimodal distribution — a bump around the 25-30% mark and another around 40-50%. Those bumps are your real ladder. Your job is to hit them on a schedule instead of stumbling into them under pressure.

Calculating the Right Depth for Each Tier

A useful rule of thumb for setting the first tier's depth is the 30-day sell-through target. If your average healthy SKU clears 60% of its remaining inventory within 30 days, your Tier 1 markdown should be deep enough to put a slow-mover on roughly that pace. In practice that's usually 10-15% for soft-goods and durables, more for fashion or food.

A simple way to test depth before rolling it out:

  1. Split the candidate SKU's remaining inventory into two roughly equal pools, or pick two comparable locations if you're multi-store.
  2. Apply two different discount depths for 14 days — say 10% and 20%.
  3. Compare 14-day units sold and gross margin dollars between the two.
  4. Pick the depth where margin dollars are highest, not where unit velocity is highest.

The last point is the trap most operators fall into. Going deeper almost always moves more units. What you care about is whether the extra units more than offset the margin you gave up to get them. A discount that doubles velocity but cuts unit margin by 40% can be worse than the prior week's full price.

A second guardrail: watch cannibalization on full-price siblings. If your Tier 2 SKU is now selling faster than the equivalent full-price item next to it, you may have repriced the whole shelf without meaning to. Either pull the discount or accept that the full-price sibling is the next markdown candidate.

The Reporting View You Need

You don't need a BI platform to run markdown cadence. You need one report, refreshed weekly. The view has three axes:

  • Rows: active SKUs, sorted by aging bucket.
  • Columns: age bucket (0-30 / 31-60 / 61-90 / 91-120 / 121+), current tier, current discount, 30-day units sold, 30-day velocity vs. category baseline.
  • Highlights: SKUs that crossed a tier threshold since last week.

Two derived numbers belong at the top of the report:

  • Margin-at-risk: the dollar value of inventory currently sitting in age bucket 60+ at full price. This is what you'll lose to deeper markdowns if you don't act.
  • Margin-realized: the dollar value of inventory cleared in the past 30 days at each tier's actual realized price — so you can see whether your ladder is bringing in the recovery you expected.

A weekly cadence review of this report — 15 minutes, same time each week — does more for margin than any one-off pricing initiative. The discipline isn't analytical; it's behavioral. The report has to be opened. Decisions have to be made and logged. If you skip a week, the SKUs that should have moved to Tier 2 sit at Tier 1 for an extra cycle, and the curve you're trying to manage gets steeper.

Four Operational Rules That Keep the Cadence Honest

A cadence breaks the moment it starts negotiating with itself. Four rules prevent that:

  • One-direction rule. Prices only come down through the ladder, never back up. Re-elevating a marked-down SKU resets customer trust and corrupts your cadence data. If something marked down rebounds in demand, it was a mispriced SKU, not a markdown candidate — learn the lesson and move on.
  • Threshold rule. Don't mark down sub-$3 unit items individually. The labor cost of repricing exceeds the recovered margin. Bundle them, donate them, or write them off.
  • Bundle rule. Pair an aging SKU with a full-price companion in a "complete the look" or "starter set" bundle. The bundle moves the slow unit at a smaller effective discount than a standalone markdown would require, and it pulls a full-margin companion along with it.
  • Stop-loss rule. Once a SKU hits Tier 4, it has 30 days. After that it's clearance-priced, donated, or returned to vendor if your terms allow. Stock that won't clear at 60% off won't clear at all — and every additional week of carry is pure loss.

The Bottom Line

Markdowns aren't an admission that something went wrong. They're a scheduled mechanism for recovering cash from inventory that didn't perform as predicted — which, statistically, will be 15-25% of the SKUs you buy in any given season. The retailers who do this well aren't smarter buyers. They have a tighter cadence.

Three takeaways:

  • Trigger on both age and velocity — either alone misses half the failures.
  • Build a tiered ladder calibrated to your own data — your real clearance points are already in your POS history.
  • Run a 15-minute weekly review — the analytics matter only if someone opens the report.

At Chapters Data, we help retailers build markdown cadences from their own POS and inventory data — so price decisions stop happening by accident and start happening on schedule.