Free AuditEnterprise AIShelfSense
Back to Blog
ShelfSense by ShelfLifeProNov 13, 20267 min read

When to Discontinue a Product: A New-Line Stop Rule

A new product isn't selling and you keep reordering it. Set a trial window and a sell-through bar before launch, then clear the last units before they date.

SE

ShelfLifePro Editorial Team

Inventory management insights for retail and pharmacy

Why new lines get reordered on hope

You brought in a new line. Maybe a rep pitched it, maybe a customer asked for it twice, maybe it looked good at the trade show. The first case went on the shelf, a few units sold, and then the reorder came up. You placed it, because pulling a product after one case feels like you never gave it a chance.

Then you reorder again, and again. Six cases in, nobody has decided anything. The product is still there because nobody ever said what "working" was supposed to look like.

That's how a slow new product turns into dead stock. Nobody makes one bad call. It's a string of small reorders, each one easy to justify, and none of them measured against anything.

How the reorder habit takes over

New products get treated differently from everything else on the shelf, and it's worth seeing exactly why.

There's no history. Your reorder point for an established line comes from what it actually sold. A new SKU has no sell-through yet, so the reorder gets sized from the rep's forecast or the case minimum.

Early sales are noisy. The first week mixes curious one-time buyers, staff trying it, and maybe a launch display. Then the display comes down and the real rate shows up, but by then you've already reordered off the launch week.

Nobody owns the decision. Whoever buys the line wants it to work. Whoever stocks the shelf sees it isn't moving but doesn't place orders. The two never compare notes.

Expiry turns slow into lost. On a non-perishable, a slow product just ties up cash. On anything dated, slow means part of every case expires on the shelf. The longer you wait to decide, the more of the decision gets made for you by the date code.

Set the bar before the product lands

The fix happens before the first case arrives. Write down three things on the day you agree to stock it:

  • The trial window. How long the product gets to prove itself. Make it long enough to cover a couple of full reorder cycles, and shorter than the shelf life of the first delivery.
  • The sell-through bar. The minimum rate of sale that justifies the shelf space, in units per day or per week.
  • The exit plan. What you'll do with the remaining units if it misses: return to supplier, markdown, bundle, or donate.

Writing it down before launch matters because once the product is on the shelf, you'll argue for it. Before it lands, you're still neutral.

For example, here's how a store might set the bar for a new refrigerated snack line:

  • Trial window: 4 weeks from first shelf day.
  • Bar: at least 2 units a day averaged over weeks 3 and 4, ignoring the launch display weeks.
  • First order: one case of 24, with nothing reordered until week 2.
  • Exit: ask the rep about a return window at signing, and plan a markdown for whatever's left.

Picking a sell-through bar that means something

The bar shouldn't be a gut number. Tie it to what the shelf space earns now.

Say you're replacing a line that sold 3 units a day at a $1.20 margin. That's $3.60 a day of margin from that facing. If the new product earns $1.50 margin per unit, it needs about 2.4 units a day just to match what you gave up. So in this worked example your bar is somewhere near 2.4, not "it sold a few."

Then add the expiry check. If a case of 24 has 21 days of shelf life when it arrives, it has to sell at more than 24 Γ· 21, about 1.15 units a day, or part of every case dates out. In this example the margin bar (2.4/day) is the stricter one, so that's the one to use. On short-dated lines it often flips the other way.

For a deeper look at deriving rates from your own sales export, the sell-through reorder point method walks through the arithmetic.

Free template

Get the free expiry-tracking spreadsheet

Batch-level rows, days-left and status formulas, colour-coded alerts, and a live value-at-risk summary. Works in Excel and Google Sheets. See what's inside.

Instant download. No spam, unsubscribe in one click.

The trial window, week by week

Weeks 1–2: don't judge, just watch. Launch buzz, displays and staff purchases make these weeks unreliable. Note the sales, but don't place a big reorder off them.

Week 2: the first reorder is a small one. If you must reorder before the read, order the minimum. Don't let the case minimum or a volume deal talk you into a bigger commitment.

Weeks 3–4: this is the real read. Average the units sold after the launch push ends. Compare that number against the bar you wrote down.

End of window: decide, out loud. Keep, fix, or delist. A decision that isn't made defaults to "reorder."

Keep, fix, or delist

When the window closes, there are three honest outcomes.

Keep. It cleared the bar. Move it onto your normal reorder routine and size orders from its real sell-through, not the launch week.

Fix. It missed, but there's a specific, testable reason: wrong shelf position, wrong price point, a pack size that's too big for your customers. Give it one short extension with one change. If it misses again, it goes. "Maybe it just needs more time" isn't a fix.

Delist. It missed and there's no specific reason to think it'll change. Stop reordering today, then deal with what's on hand.

The hard part of delisting a product in a small store is admitting a buying call didn't work. It helps to remember the bar was set when you were neutral. You're not overruling your judgement, you're following it.

It's also worth knowing the difference between a product that's slow and one that's truly finished. The slow movers vs dead stock breakdown covers how to tell the two apart before you write anything off.

Clearing the last units before they date

Once you've decided to delist, the clock that matters is the date code on the remaining stock, not your reorder schedule.

Do it in this order:

  • Check the return window first. If the supplier takes back unsold product, that's usually the cleanest exit, and those windows close. The expired-goods RTV pack has a return letter and a deadline tracker.
  • Work out what won't sell at the current rate. Divide units on hand by daily sales and compare that with the days left to expiry.
  • Mark down early, not on the last day. A modest discount with two weeks left moves more than a deep one with two days left.
  • Have a final route. Bundle it, donate it, or move it to staff sales before it's unsellable.

Worked example: you've got 30 units left, selling 1 a day, with 14 days to expiry. At that rate about 14 sell and 16 date out. If a markdown lifts sales to 2 a day, you clear about 28, leaving 2 to donate or bundle. The markdown costs you margin on the units that would have sold anyway, but it saves most of the 16 that would have been thrown out.

The post on when to start a markdown, by category goes further into timing markdowns against the date.

Keeping the record on paper

You can run all of this in a notebook or a spreadsheet. One page per new product: launch date, trial window, bar, weekly units sold, decision, and exit. The expiry-tracking spreadsheet template gives you a starting layout for the dates side.

What paper won't do is remind you. The page only works if someone opens it at week 4, and in a busy store week 4 tends to slip by. A paper log also can't easily check a product's units on hand against its batch dates every day, which is when the "won't clear" problem shows up.

Where a daily agent fits

That reminding and checking is the gap ShelfSense by ShelfLifePro is built for. Once a day it reads your stock, batch, cost and expiry records and flags slow movers losing margin and batches at risk of dating out. It shows the arithmetic and recommends an action, and a person approves it. It doesn't change prices or place orders by itself. You can start with a CSV export from the system you already run.

ShelfSense's free audit reads one CSV export, no account needed. The Watch tier is free forever at 30 SKUs β€” a daily scan and a health report. If your last few new lines are still on reorder and you can't say why, run the audit and see what the records say.

SE

ShelfLifePro Editorial Team

The ShelfLifePro editorial team covers inventory management, expiry tracking, and waste reduction for pharmacies, supermarkets, and retail businesses worldwide.

One question, optional

What would stop you from trying ShelfLifePro?

See what batch-level tracking actually looks like

ShelfLifePro tracks expiry by batch, automates FEFO rotation, and sends markdown alerts before stock expires. 14-day free trial, no credit card required.

Prefer to talk it through? Book a 30-min call

Newsletter

The monthly expiry-tracking brief

One short email a month, only when there is something worth reading. FEFO tactics, markdown math, and real-world waste-reduction wins. Unsubscribe anytime.

No spam. Unsubscribe in one click.