How Do I Store Products With Different Expiry Dates Without Losing Stock?

Stock can look healthy on a spreadsheet while the oldest batches quietly become unsaleable at the back of a shelf. Effective expiry date stock management means tracking each batch separately, picking the earliest suitable date first and acting before products run out of selling time. You do not necessarily need a complicated system, but you do need reliable records and clear rules that everyone follows.

The starting point is to stop treating every unit of the same product as interchangeable. Two identical cartons may need different storage positions, dispatch deadlines and sales decisions.

Understand which date controls the stock

Before setting up shelves or alerts, establish what each product’s date actually means.

For food, use-by dates concern safety, while best-before dates concern quality. The Food Standards Agency’s guidance on date labels explains this distinction. Food must not be sold after its use-by date. Food past a best-before date may still be suitable for sale, but safety, quality and applicable labelling requirements still need checking.

Neither date overrides the stated storage conditions. A product kept at the wrong temperature may become unsuitable before its printed date.

For cosmetics, supplements and other dated goods, follow the relevant product requirements and manufacturer’s instructions. Do not assume that food date-label rules apply to every category.

Good expiry date stock management also distinguishes the printed date from your last acceptable dispatch date. A retailer may require a minimum amount of shelf life remaining when goods arrive. Transit time and an agreed contingency therefore need to come off the available selling window.

Record those customer requirements before accepting orders, not when the picker discovers that the remaining stock is too short-dated.

Check and separate batches when deliveries arrive

The easiest time to prevent a date problem is at goods-in. Check the actual cartons against the delivery paperwork rather than assuming every pallet contains one batch.

Record the product code, supplier, batch number, date type, date and quantity received. If one delivery contains three dates for the same product, create three batch records. Where a batch occupies several locations, retain a quantity record for each location.

Agree a minimum remaining shelf life with suppliers where appropriate. If a delivery falls below that requirement, hold it separately while you decide whether to reject it, seek a credit or accept it under a documented exception.

Keep newly received stock unavailable for picking until these checks are complete. Missing dates, unreadable batch codes and damaged packaging should trigger a hold, not an educated guess.

Physical separation matters too. Separate bays or clearly divided shelf positions make it harder to mix batches accidentally. If different dates must share a location, every carton needs an identifiable batch and pickers need a reliable way to select the correct one.

Build a usable expiry date stock management record

A spreadsheet can work for a small range with straightforward movements. Use one row per product, batch, location and stock status, rather than one row per product alone.

Set up the following columns as a practical starting template:

For expiry date stock management, a quantity change needs an explanation. Keep a separate movement log rather than repeatedly overwriting totals without a history.

Use consistent date formatting, such as YYYY-MM-DD, and restrict who can edit formulas. Check that dates are stored as dates, not text, so sorting and alerts work correctly.

Pick the earliest eligible batch, not simply the oldest delivery

FEFO means first expired, first out. It prioritises the batch with the earliest relevant date. FIFO means first in, first out and follows arrival order instead. Our guide to choosing between FIFO and FEFO stock rotation explains that distinction in more detail.

For day-to-day picking, the crucial word is eligible. The earliest-dated batch should only be selected if it is released for sale and meets the customer’s shelf-life requirement.

For example, a later delivery might have an earlier best-before date than stock already on the shelf. Picking by arrival order would leave the shorter-dated batch behind. Equally, that shorter-dated batch might suit a direct customer but fail a retailer’s minimum shelf-life requirement.

Make expiry date stock management part of order allocation, not just shelf arrangement. The picking instruction should identify the permitted batch, and the picker should confirm that batch when removing stock.

Avoid placing fresh deliveries in front of older eligible stock. Where full pallets cannot be rearranged easily, use clearly identified locations and controlled picking instructions rather than relying on physical access alone.

Set alerts around the time needed to take action

An alert seven days before a date is little use if arranging a supplier return takes three weeks. Work backwards from the point at which the stock stops being suitable for its intended customer.

A practical calculation is:

First action alert = required shelf life on delivery + expected transit time + time needed for the chosen action + contingency.

For illustration, suppose a customer requires 60 days of shelf life on arrival. Allowing three days for transit and seven days of contingency creates an internal dispatch cut-off 70 days before the printed date. If a clearance decision and execution need another 21 days, the first review should happen 91 days before that date.

Those figures are examples, not standard settings. Short-life products need a different timetable from goods with a two-year shelf life.

Useful expiry date stock management alerts should identify the batch, remaining quantity, last dispatch date and named person responsible. A notification without an owner can sit unanswered while stock loses value.

Review alert periods when supplier terms, delivery routes or customer requirements change. Also distinguish a review warning from a hard dispatch block: one prompts action, while the other prevents an unsuitable order from leaving.

Give short-dated stock a decision, not just a warning

Once a batch reaches its action date, compare the quantity remaining with realistic demand before the dispatch cut-off. Do not assume that normal sales will clear it because the product usually sells well.

Possible routes include an agreed supplier return, a suitable promotion or allocation to customers whose shelf-life requirements it meets. Donation may be possible where the product, recipient and applicable rules allow it. None of these options removes the need for safety checks and accurate product information.

Set a deadline for the decision and record the outcome. If a promotion is approved, make sure the sales team knows which batch it is intended to clear.

Keep held or unsuitable stock out of the available-to-sell figure. The same principle underpins preventing overselling when stock runs low: units physically present in the building are not always units you can promise to a customer.

Keep returns, recalls and disposal traceable

Returned goods should go into a hold area until checked. Confirm their batch, date, packaging condition and any relevant storage history before deciding whether they can return to saleable stock. A customer return should not automatically increase available inventory.

For supplier returns, retain the authorisation, collection reference, batch details and quantity. Record whether a credit is expected so that a physical stock movement does not disappear from the financial follow-up.

A recall needs a different response from an ordinary short-date review. Block the affected batches, identify their locations and establish which customer orders received them. Follow the applicable recall instructions and regulatory process for the product concerned.

Expiry date stock management should leave an auditable trail even when stock is written off. Record the reason, quantity, authorisation, date and disposal route. Use a suitable waste contractor where required and retain the relevant paperwork.

Do not erase a batch record once its balance reaches zero. Its receipt and movement history may still be needed to investigate a complaint, reconcile a supplier credit or demonstrate what happened to affected goods.

Audit dates as well as quantities

A count can be numerically correct and still miss the real problem. Finding 100 units does not help if the system assigns them to the wrong batch or treats held stock as available.

During checks, compare the physical quantity, batch, printed date, location and status with the record. Give extra attention to mixed-date locations, returned goods and products approaching their action dates.

The most useful expiry date stock management measures are straightforward: stock value approaching its dispatch cut-off, batches awaiting a decision and units written off because they ran out of selling time. Track the reasons, not just the totals.

If losses keep recurring, investigate whether the cause is excess purchasing, short-dated supplier deliveries, missed alerts or picking errors. Each needs a different correction. Buying less will not solve a warehouse process that repeatedly selects the wrong batch.

Preserve the records when stock moves premises

A warehouse move can undo good controls if pallets arrive without usable batch records. Send the receiving site a stock file showing quantities, dates, locations and held stock, then reconcile what actually arrives before releasing it for orders.

If the transfer forms part of a wider premises move with uncertain dates, this guide to booking removals with storage before your move date is fixed covers useful questions about provisional bookings, access, costs and changing dates. Separately, confirm that any proposed stock storage meets your products’ handling requirements.

Protect the remaining selling window during the move. Agree when picking stops, when the receiving site can restart dispatch and who will deal with short-dated batches during the handover.

When managed warehousing becomes the better option

Spreadsheets become difficult to control when several people update stock, batches are split across locations or orders arrive through multiple channels. Warning signs include unexplained adjustments, missed holds and staff checking cartons manually because they no longer trust the record.

When comparing providers, ask how they capture batch dates, prevent unsuitable allocations and report stock approaching your agreed cut-offs. Request an explanation using one of your actual products rather than accepting a general promise of stock rotation.

Gus Logistics provides pallet and bulk warehouse storage in Nantwich, Cheshire, with racked and floor storage, real-time WMS tracking through a client portal and batch, serial number and best-before date tracking available.

For expiry date stock management, agree the required date fields, reporting and handling rules before stock arrives. Also confirm suitability for any temperature-controlled or regulated products rather than assuming general warehousing covers them. Gus Logistics has no minimum volume requirements, so the discussion can start with your actual stockholding and operational needs.

Frequently asked questions

Can I store different expiry dates together? Yes, provided each batch remains identifiable and picking follows the correct date and customer requirements. Separate locations are often easier to control. Mixing loose units without dependable identification creates avoidable errors.

Is stock still safe three months after its expiry date? There is no universal three-month allowance. Food must not be sold after its use-by date. A best-before date concerns quality, but suitability still depends on the product, storage history and applicable requirements. For non-food goods, follow the relevant product rules and manufacturer’s guidance.

How often should I check dated stock? Base the frequency on shelf life, movement rate and the time available to act. Fast-moving short-life goods may need daily review. Longer-life stock can use a less frequent planned review, supported by checks whenever goods are received, moved or returned.

Can a small business start with a spreadsheet? Yes, if batch records stay accurate and every movement is recorded. Move to stronger controls when simultaneous updates, multiple locations or manual checks make the spreadsheet unreliable.

Put clear controls around your dated stock

If expiry date stock management is becoming difficult to maintain in-house, discuss your batches, shelf-life requirements and storage needs with Gus Logistics. Call 01270 335014 to find out whether its Nantwich warehousing service is right for your business.