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
- ABC analysis
- Aged inventory
- Bundle
- Consignment inventory
- Cycle count
- Days of supply
- Dead stock
- GTIN
- Inventory allocation
- Inventory shrinkage
- Inventory turnover
- Kitting
- Multichannel inventory management
- Negative inventory
- Product variants
- Sell-through rate
- Serial number tracking
- SKU (stock keeping unit)
- Stock transfer
- Stockout
Updated · All terms