ClearStock is live on the Shopify App Store.Install free →

← All blogs

Guides8 min read

Too much inventory: the reorder freeze and cash-recovery sequence

Too much inventory that still sells? Build a no-reorder freeze list and run the cash-recovery sequence by months of cover — before it turns dead.

InventoryX is in development and not available today. ClearStock is the live Shopify app.

A founder in r/smallbusiness, August 2026: first production run, 5,000 units of a serum, and 2,800 of them are still in storage a month later. Notice what that stock is not: dead. It moved 2,200 units in a month. It's over-bought — a different problem from dead stock, with a different playbook, and the playbook's first page is not disposal. It's stopping the next PO. Too much inventory is exactly what this article owns: how to build a no-reorder freeze list, which recovery action each level of over-boughtness earns, and the arithmetic that tells you whether a SKU is recoverable or already dead-adjacent.

Where this article stops and its neighbors start

Four boundaries, so nothing gets re-taught. How to rank slow movers and the full intervention ladder live in the slow-moving inventory guide. Building the triage list from aging data is the inventory aging report's job, disposal and liquidation mechanics belong to the dead-stock guide, and the budget that prevents over-buying in the first place is open-to-buy — each linked where it's relevant below. What's left — the control that stops you making a pile worse — is the reorder decision itself.

The no-reorder freeze list

The artifact is deliberately boring: one column of SKUs you will not reorder until they clear a cover threshold.

Frozen — do not reorder
STAND-PH-03
PIN-ENAMEL-BEE
SOCK-HIKE-GRY-L
TOTE-CANVAS-BLK

Building it takes three steps:

  1. Compute months of cover for every SKU: on-hand ÷ average monthly sales, using a rolling 3–6 month average so one good week doesn't flatter a dog.
  2. Set your ceiling. That's the top of your replenishment target — the most cover you'd ever want on a normal SKU. The band table below starts at 4 months, which makes 4 a workable default ceiling for non-seasonal goods.
  3. Everything above the ceiling goes on the list and stays frozen until its cover falls below the ceiling. Not until you feel better about the pile. Not until a supplier emails about a minimum order quantity.

The freeze list exists because willpower fails exactly when it's tested. The temptation to reorder is strongest at peak over-boughtness: a decent selling month makes the pile look manageable, the supplier's MOQ reminder lands in your inbox, and "just one more PO" adds months of cover to a SKU that already has too many. The list is mechanical, and that's the point — a PO that touches a frozen SKU doesn't get reasoned with, it gets rejected. Cash that would have become a second pile stays cash.

Cash recovery: the order of operations for over-bought-but-not-dead

Slow is not dead. There's a window — roughly the first year of cover — where action is cheap and the recovery options are ordered from most to least margin-friendly:

  1. Sell-through offer to your own list. Email or post the offer to existing customers. No third party takes a cut; it's the cheapest push you can buy. (Manual action: you write the offer and set the discount.)
  2. Bundle with a strong seller. You pick the pairing, build the bundle, and set the price yourself — a manual merchant action, no bundle app or automation implied. A good companion can clear a slow SKU's tail while the strong seller sells at full margin.
  3. Marketplace discount channels. Broader reach, but you're giving margin to the platform. Worth it when your own audience has been exhausted.
  4. Liquidation. Recovers the least; it's the floor.

Each rung's mechanics — how to structure the offer, price the bundle, pick the channel, run the liquidation — are covered in the dead stock guide; this article adds the only decision that guide can't make for you: which rung a SKU has earned, by months of cover.

Months of cover Action Why
4–6 Wait and keep it frozen Velocity clears it within a normal season; discounting donates margin
6–9 Sell-through offer to your list Needs a push, but your own audience is enough
9–12 Bundle with a strong seller Organic velocity is too slow to exit the band in time
12+ The dead-stock ladder Sell-through has failed the arithmetic; recovery means disposal pricing

The logic underneath the table: cheaper actions first, escalation only when the band says velocity can't do the job alone. A SKU at 5 months of cover needs nothing but patience; a SKU at 14 needs a buyer of last resort. Most over-ordering mistakes get made in the middle bands, where merchants either panic-discount a 5-month pile or wait hopefully on a 14-month one.

Two worked examples, same warehouse

The dead-adjacent one. A phone stand variant, STAND-PH-03: 900 units on hand, selling 25 a month.

900 ÷ 25 = 36 months of cover

That's triple the top band — dead-adjacent by arithmetic, not opinion. To see why waiting isn't a plan: at current velocity, 36 − 12 = 24 months just to reach the 12-month band where real action begins. Freeze the SKU immediately — at 25 a month it must never see another PO — and take it to the dead-stock ladder rather than pretending a discount fixes three years of stock.

The recoverable one. An enamel pin, PIN-ENAMEL-BEE: 240 units on hand, selling 30 a month.

240 ÷ 30 = 8 months of cover

The 6–9 band: recoverable, and cheaply. Freeze it, then run a sell-through offer to your list this week. Even undiscounted, three months of sales leaves 240 − (30 × 3) = 150 units — 150 ÷ 30 = 5 months of cover, below the ceiling. Unfrozen, back to normal reordering. The list offer pulls that exit date earlier and keeps the pin out of the 9–12 band where a bundle becomes necessary. Compare the stand over the same three months: 900 − 75 = 825 units, still 33 months of cover. The pin recovers; the stand doesn't; the band told you before either action did.

One cost note while the piles sit: carrying cost accrues on both — what inventory carrying cost includes breaks down the rent, capital, and risk components. The freeze list doesn't eliminate that cost; it stops you from adding to it, which is the only part you control this week.

The serum case, resolved by band

Back to the founder with 2,800 serum units. If the first month's pace holds, cover is 2,800 ÷ 2,200 ≈ 1.3 months — under-bought if anything, and the freeze alone is the entire fix: don't reorder, let it clear, spend the cash on the next launch. But if that month was front-loaded launch traffic and the true rate is slower — say 400 a month, illustrative — cover is 7 months, the 6–9 band, and a list offer is the move. Same warehouse, same product, two different actions. The band decides, not the gut, and that's the entire value of computing cover before reacting to a scary-looking pile.

Prevention, in one paragraph

The freeze list treats the symptom; buying without a budget is the disease. Open-to-buy is the budget discipline that caps next season's purchases against planned sales — it's how the freeze list you're about to write never gets written again.

One honest tool note: InventoryX's weekly Buying List works from per-SKU velocity, and V1 has no open-to-buy budgets or freeze enforcement — it won't stop you from ordering a frozen SKU. Keep the freeze list where POs get approved, next to the approval button it's meant to outrank.

Common questions

What is a reorder freeze list? A one-column list of SKUs you will not reorder until their months of cover fall below a ceiling you set. It's built from on-hand ÷ average monthly sales, and it works as a mechanical rule: no PO touches a frozen SKU, regardless of how manageable the pile looks that week.

How do I calculate months of cover? On-hand units ÷ average monthly sales, from a rolling 3–6 month window. A pin SKU with 240 units on hand selling 30 a month has 240 ÷ 30 = 8 months of cover. Use the same average you'd trust for a reorder point, not last month alone.

What months-of-cover warrants a freeze? Anything above your replenishment target's ceiling — the most cover you'd ever want on a normal SKU. If you don't have a ceiling, the band table above starts at 4 months, which works as a default for non-seasonal goods. Seasonal SKUs need their own calendar logic.

Should I discount or bundle first? Discount to your own list before touching marketplace channels — your audience is the cheapest margin give-away there is. Bundle when the band is 9–12 months and organic velocity can't clear the pile in time; pair the slow SKU with a strong seller and set the price manually.

When is over-bought stock actually dead stock? Around 12 months of cover and beyond, sell-through stops being a plan — that's the 12+ band, where the move is the dead-stock ladder rather than another offer. The inventory aging report is how you find which SKUs have already crossed that line.

Next step

Build the freeze list today: export your inventory, add a months-of-cover column, sort descending, and freeze everything above your ceiling — about 30 minutes for a 300-SKU store. The decision rule that runs it from here: no PO touches a frozen SKU until its cover clears the ceiling, and every frozen SKU gets re-checked monthly, because exit is measured in cover, not in feelings. And once the freeze list is working, a quarterly Shopify inventory audit keeps the data that feeds it honest. For subscription sellers, the over-buy risk hides in components — subscription box inventory shows why churn leaves parts on the shelf. Strongly seasonal catalogs get the worst of this — toy store inventory covers the Q4-to-spring lifecycle where freeze decisions bite hardest.