Key Takeaways
- Expired stock rarely shows up as one big loss. It shows up as small write-offs across dozens of SKUs, month after month, until it’s a meaningful dent in margin.
- Most supermarkets track expiry reactively, during a physical stock count or when a customer flags an issue, rather than proactively at the point of billing and receiving.
- Batch-level tracking, tied to billing and purchase data, is what makes proactive expiry management possible instead of a guessing game.
- A supermarket selling thousands of SKUs across perishables, packaged food, and FMCG needs a system, not a manual register, to catch expiry risk before it becomes waste.
- Supermarket billing software with batch tracking built in turns expiry control from a monthly cleanup into a daily, automatic check.
Every supermarket loses some stock to expiry. That’s not the problem. The problem is not knowing how much, where, or why until it’s already sitting in the write-off pile. For a store carrying dairy, packaged food, personal care, and FMCG across thousands of SKUs, expiry isn’t a single risk category, it’s dozens of small risks running in parallel, each with its own shelf life and its own blind spot if nobody’s watching closely.
This blog lays out a practical batch-tracking checklist for supermarket owners, why manual expiry tracking breaks down at scale, and what a system built for it actually looks like.
Why Expiry and Waste Control Is Harder Than It Looks
A single-category store can track expiry with a notebook and a bit of discipline. A supermarket can’t, not reliably. With thousands of SKUs moving at different velocities, sitting across different shelf lives, and arriving from different suppliers in different batches, expiry risk isn’t visible from a glance at the shelf. It’s visible from the data, if the data is being captured in the first place.
This is the same underlying problem covered in the hidden loss in every retail store: losses that don’t show up as theft or obvious error, but as slow leakage that’s only visible in aggregate, usually too late to act on.
The Batch-Tracking Checklist
1. Capture Batch Number and Expiry at the Point of Receiving
Expiry tracking starts before a product ever reaches the shelf. If batch and expiry data aren’t captured accurately when stock is received, everything downstream is built on incomplete information.
- Batch number logged against every incoming SKU, not just high-value or slow-moving items
- Expiry date recorded at receiving, not estimated later
- Supplier and purchase order linked to the batch for traceability
2. Sort Shelf Placement by Batch, Not Just SKU
Two batches of the same product can have different expiry dates. First-expiry-first-out only works if staff can actually tell which batch is which at the shelf, not just at the back office.
- Shelf stocking follows first-expiry-first-out, not first-in-first-out by default
- Batch identifiers are visible or scannable at the shelf, not buried in back-office records
- Staff have a simple way to check which batch is closer to expiry during restocking
3. Set Near-Expiry Alerts With Real Lead Time
An alert that fires the week something expires is too late to act on. Useful alerts fire early enough to actually do something, discount it, return it, or push it through promotion.
- Near-expiry alerts configured with enough lead time to act, not just to record
- Alerts segmented by category, since perishables and packaged goods need different lead times
- Alerts reach the person who can act on them, not just a report nobody checks
4. Track Waste and Write-Offs by Batch and Category
If write-offs aren’t tracked with enough granularity, the pattern behind them never becomes visible. A supermarket needs to know not just how much was lost, but which category, supplier, or shelf placement keeps producing it.
- Every write-off logged against its batch, not aggregated into a generic “wastage” line
- Waste reports broken down by category and supplier over time
- Recurring waste patterns reviewed periodically, not just noted and forgotten
5. Tie Expiry Data Back Into Purchasing Decisions
Expiry control isn’t just about catching stock before it goes bad, it’s about ordering less of what consistently goes bad in the first place. Without that feedback loop, the same waste repeats every cycle.
- Purchase quantities reviewed against historical waste for that SKU
- Slow-moving, expiry-prone SKUs flagged for smaller, more frequent orders
- Supplier performance reviewed where batches consistently arrive with shorter shelf life than expected
6. Make Billing and Inventory Share the Same Batch Data
Expiry tracking that lives separately from billing is expiry tracking that’s always a step behind. When a sale is recorded against the actual batch sold, stock and expiry data stay accurate without a manual reconciliation step.
- Billing records the specific batch sold, not just the SKU
- Stock counts update in real time as sales happen, batch by batch
- Expiry reporting reflects current, sold-adjusted stock, not a stale snapshot from the last physical count
Why This Needs a System, Not a Spreadsheet
Every item on this checklist is manageable in isolation. Running all of them together, across thousands of SKUs, multiple counters, and daily receiving, is where spreadsheets and manual registers fall apart. This is the same argument that applies to barcode-driven billing more broadly: the checklist itself isn’t complicated, but doing it consistently at supermarket scale requires the data to be captured automatically, not chased down after the fact.
It’s also connected directly to margin. Expired stock is a cost that’s already been paid for and never recovered, which is why waste control belongs in the same conversation as retail pricing strategy, not treated as a separate operational chore.
How Elixir Retail 360 Supports Expiry and Waste Control
Elixir Retail’s supermarket software ties batch tracking directly into billing and inventory, so expiry data updates automatically with every sale instead of waiting for the next physical count. It generates near-expiry alerts with usable lead time, breaks down waste and write-offs by batch and category, and feeds that data back into purchasing so the same SKUs stop repeating the same losses.
It’s built on the same platform covered in supermarket technology solutions and supermarket POS for a profitable store, so expiry control isn’t a bolt-on feature, it’s part of the same system running billing and stock.
If expired stock is still something your store catches during a physical count instead of before it happens, book a free demo and see how batch-level tracking changes that.
Frequently Asked Questions
Why is expiry control harder in supermarkets than in smaller stores?
Supermarkets carry thousands of SKUs across categories with very different shelf lives, arriving in separate batches from multiple suppliers, so expiry risk is spread thin and easy to miss without systematic, batch-level tracking rather than a general glance at the shelf.
What is batch-level tracking in a supermarket POS system?
It means every unit of stock is tied to a specific batch number and expiry date, captured at receiving and carried through to billing, so the system always knows which batch was sold, which is still on the shelf, and which is approaching expiry.
How much lead time should near-expiry alerts give a supermarket?
Enough time to actually act, whether that’s a discount push, a return to the supplier, or reallocating stock to a faster-moving counter. The right lead time varies by category, which is why alerts should be configurable rather than one-size-fits-all.
Can expiry tracking reduce purchasing costs, not just waste?
Yes. When waste data is tracked by SKU and fed back into purchasing decisions, supermarkets can order smaller, more frequent quantities of expiry-prone items instead of repeating the same over-ordering pattern every cycle.
Does billing software need to be linked to inventory for expiry tracking to work?
It should be. When a sale is recorded against the specific batch sold, stock and expiry counts stay accurate automatically. Without that link, expiry data drifts out of sync with actual shelf stock between physical counts.
Expiry and waste control isn’t about catching every loss, some amount is inevitable in any store carrying perishables and packaged goods at scale. It’s about making sure losses are visible early enough to act on, and small enough that they stop compounding month after month.
