Retail batch and expiration tracking software holds dated stock as batches rather than as a single quantity: which lot arrived when, what date it carries, how much of that lot is left and where it is. It drives selling and picking on a FEFO basis, first-expiring first out, warns before stock reaches its date, records what was marked down or removed, and makes a batch traceable in both directions. With Pentoggle, a retailer can describe how dated stock actually moves through the store and generate the starting application around it.
This page describes the operational workflow. What dates, labels, records or handling any particular product requires, and what a retailer must do in a recall, differ by product and by place and are revised from time to time. This page states none of them. Confirm what applies to your products and your locations with a suitable adviser and build the application around that.
Most retailers already run an accounting system such as QuickBooks, Tally or Xero, and a POS that deducts what it sells. Those stay where they are. What is often still managed outside them is the date: which units on the shelf are from which batch, which are closest to their date, and who is checking.
Key takeaways
- Dated stock has to be held by batch. A single quantity per item cannot say how much is close to its date, which is the only question that matters for this stock.
- The date is captured at receiving or not at all. A batch that enters stock without its date can never be sorted, warned about or traced.
- FEFO is not the same as FIFO. Stock received earlier can carry a later date, so the rule for dated goods is earliest-expiring first, not earliest-received first.
- The markdown window is where the money is. Stock marked down early often recovers part of its cost; stock discovered at its date usually recovers none.
- A useful number is the value of stock inside its warning window, and the value written off for date reasons each month.
The spreadsheet is often not the problem
A store where the person filling the shelf checks dates as they go, rotates the stock and pulls what is close, is running a real system, and in a small store with one person doing it consistently it works.
The trouble starts at identifiable points.
When the check depends on one person walking
The rotation is done well by whoever usually does it. On their week off, stock with later dates goes in front of stock with earlier ones in three aisles, and the effect appears a month later.
When the stock record has one number
The item record says 60 units. Some are from last week's delivery and some from a delivery two months ago, and the two may not carry the dates you would expect. The record cannot say how many of each, so nobody can plan a markdown.
When the date is only on the box
The delivery arrives with dates printed on the cartons. The cartons are opened and discarded at shelving. From that point the date lives only on the individual packs, which nobody is reading in bulk.
When a recall arrives
A supplier notifies a problem with a lot number. The store has no record of which lots it received or when, so the response is to pull everything of that item and hope, which costs far more than it should.
What retail batch and expiration tracking software holds
Batch record
Lot or batch identifier, the date it carries, the supplier, the purchase order and receipt it arrived on, and the quantity received.
Stock by batch
Remaining quantity per batch per location, so the item's total is the sum of batches with known dates.
Capture at receiving
Batch and date recorded at the door as part of the receipt, by scan where the code carries it and by entry where it does not.
FEFO rules
Picking, shelf replenishment and where practical the sale itself directed to the earliest-expiring batch, with exceptions recorded.
Warning windows
A lead period per category or item at which stock approaching its date is surfaced, set from how long a markdown needs to work.
Markdown and removal
What was marked down, when, at what price, and what was pulled from sale, with the quantity and value.
Write-off record
Stock removed for date reasons, by item, batch, reason and value, held for reporting and for supplier discussions.
Traceability
From a batch back to the supplier, order and receipt, and forward to what was sold, transferred or written off, so a recall can be scoped.
The batch is the stock unit
For dated stock, the item is not the right unit of record. Two units of the same item with different dates are not interchangeable: one may be sellable for three months and the other for three days.
Holding stock by batch means every receipt creates or adds to a batch, every sale or pick draws from a specific batch, and the item's total is the sum of its batches. That is more record-keeping than a single quantity, and it is what makes every other feature on this page possible.
The practical gain is that the question "how much of this is close to its date" has an answer. Without batches, the store can see it has 60 units and can walk the shelf to find out. With batches, the store can see it has 44 units with two months left and 16 with nine days, and it can act on the 16 while there is still time.
Batches also make the cost picture accurate. Stock bought at different times often has different costs, and holding cost with the batch means the write-off of the affected units is valued at what those units actually cost.
Where a store handles both dated and undated stock, and many do, only the items that need batches should carry them. Applying batch tracking to everything adds work at receiving for no benefit on items where it does not apply.
FEFO is a shelving discipline, and it is not FIFO
Selling the earliest-expiring stock first is the central rule for dated goods, and it is worth being precise about what that means.
FIFO, first in first out, sends out whatever arrived first. FEFO, first-expired or first-expiring first out, sends out whatever carries the earliest date. Most of the time the two agree. They come apart when a later delivery carries a shorter remaining life than an earlier one, which happens often enough to matter: a supplier ships older-dated stock this week, or two batches from different production runs arrive out of sequence. On those occasions a store following FIFO leaves the short-dated units at the back and writes them off. For dated goods the rule is the date, not the arrival order.
Where the system can help is in picking and replenishment. A pick list for an online order or a store transfer can name the batch to take. A replenishment instruction for the shop floor can say which batch to bring forward. A count by batch can reveal that a location holds a batch that should have gone weeks ago.
Where the store has to do the work is at the shelf. Stock with later dates has to go behind stock with earlier ones, which takes longer than putting it in front, and it is the step most often skipped when the floor is busy. No system detects this directly; what it detects is the consequence, when a short-dated batch is still showing stock while a longer-dated one is being sold.
At the counter, directing the sale to a batch is practical for some formats and not for others. A pharmacy or a store selling from behind a counter can pick the batch; a supermarket where the customer takes the pack from the shelf cannot. In that case the shelf rotation is the control and the system's job is to warn and to record.
The honest position for a store is to decide where batch selection is realistic and where it is not, and to build the warnings accordingly. A system that assumes perfect rotation will produce batch balances that drift from reality, and a count by batch is how that drift is corrected.
The markdown window is where the value is
Stock that reaches its date is usually a total loss. Stock marked down early often sells and recovers part of its cost. The difference between the two is a matter of timing, and timing is what the warning window provides.
Setting the window means asking how long a markdown needs to clear the quantity on hand. For a fast-selling item, a few days may be enough. For a slow one, several weeks. The window should reflect the item's sales rate and the size of the batch, not a single number applied across the store.
What the store does inside the window is a policy decision worth making in advance rather than at the shelf: a first markdown at the warning point, a deeper one closer to the date, a transfer to a busier location where the stock might move faster, a return to the supplier where the agreement allows it, or a decision to donate or dispose. Having the sequence decided means the person who sees the warning knows what to do without asking.
Recording the outcome is what makes the next decision better. Marked down at a given point, sold or not sold, written off at a given value: repeated across many items, this shows which categories respond to markdowns and which do not, and where the buying quantity may be too large for the sales rate. A pattern of date write-offs in one category is often a buying finding rather than a rotation finding, and it belongs back in Retail Replenishment Software.
Traceability runs in both directions
When a supplier reports a problem with a lot, the store needs two answers quickly: what did we receive of that lot, and where has it gone.
Backward traceability is the receipt record: which batches arrived, on which date, against which purchase order, from which supplier. Forward traceability is the movement record: how much of that batch was sold, transferred to another location, returned or written off, and how much is still on hand.
With both, the response to a supplier notification is a scoped action: pull the specific batch from the specific locations that still hold it, and know how many units left the store. Without both, the response is to pull everything of that item everywhere, which is slower, more expensive and less accurate.
What a retailer is required to do in these situations, what records must be kept and for how long, and how customers must be notified, all differ by product and by place. This page does not state any of it. The application can be built to hold whatever records your obligations require; establish what those are with a suitable adviser.
Where batch and date tracking look different by business type
- Grocery Store Software, where a large share of the range is dated, deliveries are daily and rotation is a continuous floor task.
- Supermarket Software, where dated stock spans several departments with different windows and markdown practices.
- Beauty Retail Software, where batch codes matter for traceability and testers and opened stock are handled separately.
- Convenience Store Software, where short-dated chilled and bakery items turn over daily and the write-off is a nightly task.
- Pet Store Software, where food carries dates and large bags are slow-moving enough to reach them.
- Liquor Store Software, where some categories carry dates and batch identification matters for supplier recalls.
Why retailers choose Pentoggle for batch and date tracking
Stock held by batch, not just by item
The total is the sum of batches with known dates, so the store can see what is close.
Dates captured at the door
Batch and date recorded as part of receiving, before the carton is opened and discarded.
FEFO, not just FIFO
Picking and replenishment directed by the earliest date rather than by arrival order, because the two are not always the same.
Warning windows sized to the item
Lead time set from how long a markdown needs, rather than one number for the whole store.
Traceable in both directions
From batch to supplier and receipt, and forward to what was sold, transferred or written off.
Sits around your accounting and your POS
QuickBooks, Tally, Xero and comparable systems continue holding stock value. Your POS continues selling. Pentoggle adds the batch, the date and the warning.
A useful number for batch and date tracking
Two: the value of stock currently inside its warning window, and the value written off for date reasons each month.
The first is the money still recoverable. It is a working list, and the point of it is that someone acts on it this week.
The second is the money already lost, and its trend is the measure of whether the process is working. Read it by category and by item. Persistent write-offs in one category often point at buying quantity rather than at rotation, though rotation, short dates on arrival and slow sales can each produce the same figure, so it is a prompt to look rather than a conclusion.
Worth also watching the date remaining on stock at receipt. A supplier consistently delivering goods with little life left is passing their problem to you, and that belongs in the supplier's performance record.
Ready to build retail batch and expiration tracking software?
You know how much of each item you have.
You may not be able to say how much of it has three days left, or which batch it came from.
Describe your dated products, how they arrive and how you rotate and mark down to Pentoggle in plain English and generate a working first version in hours, then refine it around your process.