Ecommerce operations glossary

What is lot tracking?

Also called Batch tracking, Lot and expiry tracking

Lot tracking records which production batch each unit of stock came from, usually with a batch number, manufacture date and expiry date. It lets you ship the batch that expires first, flag stock that is about to go out of date, and answer the recall question: which customers received the bad batch, and which supplier sold it to you.

Worked example

A coffee roaster holds two lots of the same 1 kg bag in one warehouse:

  • Lot CB-2041: 100 bags, received March 1, expires December 31.
  • Lot CB-2042: 60 bags, received March 20, expires September 30.

An order for 80 bags comes in.

Under FIFO (first in, first out), the warehouse takes the oldest receipt first: 80 bags from CB-2041. That leaves 20 bags of CB-2041 and all 60 of CB-2042, the lot that goes out of date three months sooner.

Under FEFO (first expiry, first out), it takes the soonest expiry first: all 60 bags of CB-2042, then 80 − 60 = 20 from CB-2041. That leaves 80 bags, all from the December lot, and nothing on the shelf that expires in September.

Now say the supplier recalls CB-2042. Because every shipment recorded its lot, the list of affected customers is the orders that shipped CB-2042, not every order that shipped this product.

FIFO vs FEFO

FIFO orders stock by when it arrived. FEFO orders it by when it expires. They agree most of the time, because the batch that arrived first usually expires first. They split when a later delivery has a shorter date, which happens with co-packers, short-dated clearance buys and returns. For anything perishable, FEFO is the safer rule. For goods with no expiry, such as glass bottles, a lot still carries a batch number and FIFO is fine.

Where it goes wrong

Lot tracking is not retroactive. Stock received before you switched it on has no lot, and a finished batch built from un-lotted ingredients traces back to itself and stops there. Turn it on for every ingredient before the first build, not only for what you sell.

The other gap is the shelf. A system can assign a lot to an order, but if a 3PL picks whatever is in front of it and never reports the lot back, the record is a guess. Ask your 3PL how it reports the lot on each shipment before you sign.

More terms: Inventory

Updated · All terms

Ready to see SKU.io in action?

Bring your real numbers and the messy questions — we'll walk the system against an operation like yours, not a slide deck.

Book a Demo

Founder-led demo · 2-day onboarding · no onboarding fees