Expiry Management in Retail: A 10-Minute Daily Routine

The routine breaks down long before the store does

Stores don't usually lose money on expiry because the owner stopped caring. They lose it because the routine that worked at 80 SKUs quietly falls apart at 300 — and nobody notices until a health inspector does, or until the month-end write-off is bigger than expected.

The fix isn't a new system on day one. It's a routine with four distinct checkpoints: receiving, daily rotation, a daily at-risk list, and a weekly markdown review. Each one is doable with a clipboard. The honest part comes at the end — where the clipboard stops being enough.

Step 1: The receiving dock (5 minutes per delivery)

Expiry problems are easiest to catch here, before a product ever touches a shelf. When a delivery comes in, check three things before signing anything.

First, confirm the shelf life remaining meets your minimum threshold. A common working rule: refuse any perishable with less than two-thirds of its total shelf life left on arrival. Second, log the batch number and expiry date against the invoice — one line per batch, not one line per product. Third, physically separate new stock from existing stock before it goes to the back room. If the new delivery goes straight onto the shelf in front of older stock, FEFO (first-expired, first-out) is already broken.

If you want to understand why FEFO matters more than FIFO for perishables, the FEFO inventory management guide covers the mechanics in detail.

Step 2: The daily shelf walk (10 minutes, same time every day)

Pick a time — opening works well because the store is quiet — and walk every section that holds perishables or near-expiry stock. The goal is not to check every product. It's to find anything expiring within your action window.

Your action window is the number of days before expiry at which a markdown or pull still has a chance of working. For dairy, that might be three days. For packaged snacks, two weeks. Set it once per category and write it on the shelf-walk sheet.

Mark anything inside the window with a colored sticker or move it to a designated clearance spot. Front-face it. Don't leave it mixed with full-price stock — customers won't find it, and staff will forget it.

Two things make this step fail: inconsistent timing (the walk happens "when there's time") and no written record. A written record matters because it's the only way to spot a pattern — the same product showing up on the at-risk list every Tuesday, for instance, usually points to a purchasing or rotation problem upstream.

Step 3: The daily at-risk list (built during or after the walk)

This is the list that tells you what needs to move today. It should have four columns: product name, batch/lot, expiry date, and units on hand. That's it.

For a store under 200 SKUs, you can build this list by hand in five minutes. For a store with 400–600 SKUs, the walk alone takes longer than ten minutes, and the list starts to have gaps — things get missed because there's too much ground to cover before the morning rush.

The list drives two decisions: what gets a markdown today, and what gets pulled and documented for return or disposal. Neither decision should wait until the end of the week. A product with four days left has a reasonable chance of selling at a discount. The same product with one day left is a write-off.

For a broader look at what expired stock actually costs — beyond the product itself — the post on hidden costs of overstocked perishables is worth reading alongside this routine.

Step 4: The weekly markdown review (20–30 minutes, same day each week)

The daily walk catches urgent cases. The weekly review catches slow-moving stock that isn't urgent yet but will be.

Pull the last seven days of at-risk list entries. Look for products that appeared more than twice. Those are the candidates for a scheduled markdown — a price reduction that starts early enough to actually move units, rather than a panic discount on the last day.

For example, suppose a packaged hummus SKU keeps showing up with ten-plus units still on hand at the five-day mark. That's a signal: either the order quantity is too high, or the product needs a standing discount starting at day ten before expiry. Both are fixable. Neither is visible without the weekly review.

A markdown schedule for perishable products explains how to set the discount depth and timing so you recover margin instead of just clearing shelf space.

Where the clipboard stops working

The routine above is real and it works. But it has a ceiling.

Past roughly 300–400 SKUs, the daily walk takes longer than the time you have before the store opens. The at-risk list gets built from memory as much as from observation. Batches with the same product name but different expiry dates get merged into one line. The weekly review becomes a rough estimate rather than a full picture.

The structural problem is that expiry risk lives in your inventory records — batch numbers, quantities, cost — not on the shelf. A shelf walk can catch what's visible. It can't tell you that you have 40 units of a slow-moving SKU in the back room with 11 days left, or that the batch you received last Tuesday has a shorter shelf life than the one before it.

This is the gap a daily inventory agent addresses. Instead of you building the at-risk list by walking the floor, the agent reads your stock and expiry records once a day and surfaces what needs attention — ranked by money at risk, with the arithmetic shown. Say a batch has 14 units and is selling at 0.4 units per day: the agent flags that roughly 12 of those 14 units won't clear by the expiry date and recommends a markdown. You see the projected loss and the suggested action. You approve or adjust. The agent doesn't change anything on its own.

What to do with the routine right now

Start with the four checkpoints above. Write them on a single sheet and tape it to the back-room door. Run the routine for two weeks and track what shows up on the at-risk list. That data alone will tell you where your expiry losses are concentrated — usually two or three categories, not the whole store.

If you want a ready-made template to run the daily log, the expiry-tracking spreadsheet template gives you the column structure without building it from scratch.

Once the routine is running and you have a sense of the pattern, the question becomes whether the manual list is keeping up. For stores past 300 SKUs, the answer is usually no — not because the routine is wrong, but because the volume of records is too high for a daily walk to catch reliably.

ShelfSense by ShelfLifePro is the daily agent that writes that at-risk list from your inventory records instead of from a shelf walk. The Watch tier is free at 30 SKUs — a daily scan and a health report. If you want to see what it surfaces across your full catalog before committing to anything, start at /shelfsense.