Lot, Batch and Expiry Tracking for Ecommerce Inventory

Lot, batch and expiry tracking works only when the identifier follows inventory through receiving, storage, allocation, picking, returns and recall. Recording a lot number at inbound is useful, but it is not a complete control unless you can identify which customer received which unit.

Decide what you need to trace

Different products create different control needs. Food, supplements, cosmetics, health products and regulated goods may require formal records under applicable law or customer agreements. Other brands adopt lot tracking voluntarily to manage quality issues, supplier variation or warranties.

Define the traceability unit before configuring the system:

• Lot or batch: a manufacturer-assigned production group.
• Expiry or best-before date: the date used for shelf-life decisions.
• Serial number: a unique identifier for one unit.
• Inbound receipt: the shipment or purchase-order event that introduced the stock.

Do not invent new warehouse lot numbers when the supplier’s identifier is needed for a recall. If an internal identifier is necessary, preserve the mapping to the original manufacturer lot.

Capture data at receiving

The safest point to capture the lot and expiry is before stock becomes available. The receiver should compare the purchase order, physical label and advance shipment data, then record quantity by SKU, lot and date. If one carton contains mixed lots, split the receipt accordingly.

Set clear rules for missing, illegible or conflicting labels. A reasonable default is to quarantine the affected quantity and prevent allocation until the brand or quality owner decides. Receiving speed should not outrank traceability.

Our 3PL inbound checklist covers the broader appointment, carton and purchase-order information needed for a clean receipt.

Store and allocate with FEFO

First-expired, first-out (FEFO) allocates the inventory with the earliest acceptable expiry date before later-dated stock. It is usually more useful for dated goods than simple first-in, first-out because production and transit timing can cause a newer receipt to expire sooner.

FEFO needs a minimum remaining shelf-life rule. A unit may be unexpired but unsuitable for a wholesale customer that requires 180 days remaining on delivery. Record the rule by channel or customer, then block lots that do not qualify.

A hypothetical shelf-life example

Assume a Canadian supplement brand has one SKU across three lots:

A wholesale order requires at least 180 days of remaining shelf life. FEFO across all stock would choose A102 first, but that lot fails the customer’s rule. The correct allocation is A101, then A103 if more units are needed. A102 may remain eligible for DTC orders if the brand’s DTC rule allows 90 days.

This example is hypothetical. It shows why “ship the oldest lot” is incomplete: allocation must consider both expiry sequence and the receiving customer’s minimum shelf life.

Preserve lot identity during picking and packing

Pickers should confirm the lot or use a system-directed location that contains only the allocated lot. Avoid mixing lots in one pick face without a scan or physical control that prevents substitution. If a short pick forces a change, record the new lot before the order ships.

The shipment record should retain SKU, quantity, lot or serial, order number, customer and ship date. That record supports targeted customer notification and stops a narrow quality issue from becoming a full-catalogue recall.

Handle returns as a new quality decision

A returned product should not automatically rejoin sellable stock just because the lot is known. Check seal integrity, damage, storage conditions where relevant, remaining shelf life and the brand’s disposition rules. Record whether the unit is restocked, quarantined, destroyed or returned to the vendor.

The operational sequence in our returns-to-restock guide can be extended with lot and expiry fields.

Run a traceability test

At least periodically, choose one lot and test both directions:

1. Backward trace: identify the supplier, purchase order, receipt date and received quantity.
2. Forward trace: identify on-hand quantity, every order that received the lot, remaining locations and return dispositions.
3. Reconcile: received units should equal shipped, on-hand, destroyed, adjusted and returned quantities after documented variances.
4. Time the exercise: record how long a complete, exportable answer takes.

If the test depends on one employee’s memory or a spreadsheet that cannot link shipments to lots, the process is not recall-ready.

Monitor ageing before expiry becomes waste

Create alerts at business-relevant intervals: for example, 270, 180, 120, 90 and 60 days remaining. Pair them with an action owner—promotion, channel transfer, wholesale restriction, donation review or disposal. Our inventory ageing report guide shows how to turn age bands into decisions.

Control checklist

• Supplier lot captured exactly as labelled
• Expiry captured in a consistent date format
• Mixed-lot cartons split at receipt
• Quarantine status blocks allocation
• FEFO and minimum shelf-life rules defined by channel
• Lot confirmed at pick or pack
• Shipment history links customers to lots
• Returns receive a documented disposition
• Traceability test completed and timed

247 Fulfillment can help brands map these controls into receiving, storage, picking and reporting requirements before inventory arrives.