How to spot products that sit too long in inventory

Take a mental walk through your store. Somewhere — a shelf, a corner, a bottom rack — the same products have been waiting for weeks. You’ve stopped noticing them; they’ve become part of the furniture. Yet every one of those items is money already paid to a supplier, and it only comes back if the product sells.

Slow-moving stock is one of retail’s quietest costs: it makes no noise, shows up on no invoice, but it locks up cash, space, and attention. Here’s how to find it methodically, and how to decide what to do with it.

Why a sleeping product costs you money

An immobile product costs you three ways. First, frozen cash: what you paid the supplier sits on the shelf instead of funding products that turn. Second, space: every foot of shelf taken by a product that doesn’t move is a foot denied to one that would. Third, risk: best-before dates creep closer, packaging fades, trends pass. The longer a product waits, the less it’s worth.

How to find them in your data

The usual instinct is the eyeball test: you “know” what isn’t moving. But the eye is unreliable, especially for products you’ve stopped seeing. Your sales data does better. The question is simple: which products recorded zero — or almost zero — sales over the last 30, 60, or 90 days?

1. Pull a list of your products with their sales over the past 60 days, from your Clover register or an export.
2. Sort by quantity sold, ascending: the zero-and-one-sale products rise to the top.
3. Remove the false positives: seasonal items out of season, recent arrivals still finding their audience, special orders for specific customers.
4. What remains is your sleeper list. For each one, note the quantity on hand and, if you know it, the purchase cost.

Three ways to act on a sleeper

Finding them isn’t enough — you have to decide. For each slow mover, three reasonable options exist, in order of effort:

• Move it: change the location, bring it to eye level, or pair it with a popular complementary product. Some products sleep simply because nobody sees them.
• Mark it down: cut the price honestly and make it visible. The goal is no longer margin — it’s recovering the cash and the space. A discounted sale always beats a write-off.
• Drop it: if the product won’t move even on clearance, stop reordering. Write down the lesson — which supplier, which category, what quantity — for the next buying decision.

How long is “too long”, exactly?

It depends on the category. For fresh goods, a week without movement is already a signal. For dry grocery and drinks, 30 to 60 days is a reasonable threshold. For seasonal or specialty items — accessories, gift products — 90 days can be acceptable, provided the season is coming and not just gone. The exact number matters less than having one per category, written down, and checking it against the data on a regular schedule.

Keeping slow stock from coming back

Sleepers are usually born from optimistic buying: a full case to get a better price, a tempting catalogue novelty, one more format “just to try.” The antidote is connecting purchases to actual sales: before ordering, check how many units genuinely sold last month.

Give new products a fair shot, but with a check-in date: “I’ll test this for eight weeks, then look at the numbers.” That’s the difference between experimenting and accumulating.

The takeaway

Your sales floor is a limited resource — likely the most expensive one you pay for each month. Sleeping products occupy it and give nothing back. Check the non-movers in your sales data regularly, apply a simple rule — move, mark down, drop — and you’ll free up cash and shelf space for the products that actually deserve the spot.