Lot tracking software for ecommerce brands: expiry, recalls and FEFO

Mirena Rumenova
Mirena Rumenova
November 19, 2026
Lot tracking software for ecommerce brands: expiry, recalls and FEFO

To trace product batches and expiry dates quickly during a recall or quality audit, capture the lot number and expiry date when stock arrives. Then carry both through every bin, pick and sales order, so the trace becomes one search across your channels.

Good lot tracking software does that linking for you. Spreadsheets sit apart from your orders, so they cannot.

This guide covers key terms, US and EU rules, a five-step setup, FEFO picking and a recall drill.

What is lot and batch tracking in ecommerce?

Lot and batch tracking in ecommerce is recording which group of units each product came from and which customer order each unit went to. A lot or batch is a group of units made or received together, while a serial number identifies one single unit.

Most brands use "lot" and "batch" for the same thing.

TermWhat it identifiesUse in a recall
Lot numberUnits received or made togetherFind every order that shipped from that lot
Batch codeUnits from one production run (often the same as a lot)Pull one run and keep the rest on sale
Serial numberOne single unitContact the exact owner of one unit
Expiry dateThe last date a batch is fit to sell or usePick and quarantine stock by date

Lot traceability in ecommerce adds the sales channel. One batch can ship through Shopify, WooCommerce, Amazon and wholesale in one week, and the record must follow each order.

Why do recalls take days with spreadsheets?

Recalls take days with spreadsheets because the lot log and the order history live in separate files. Someone matches them by hand while the clock runs.

The chain usually breaks in four places:

  • At receiving, the supplier lot is written on paper or skipped when the truck is late.
  • At putaway, two lots of the same SKU share one bin with no record of which is which.
  • At picking, the picker grabs the nearest unit and nobody notes the lot.
  • On channel orders, Shopify, Amazon and wholesale orders sit in different exports with no batch column.

Each gap forces a guess. In a recall, a guess means contacting too few customers or pulling far more stock than needed.

If you make your own products, the chain also runs through production, which the guide to ERP for manufacturing covers.

What do US and EU rules expect from a trace?

US and EU food rules expect a business to show quickly where each food lot came from and where it went.

In the US, the FDA Food Traceability Rule requires covered firms to provide traceability records within 24 hours of an FDA request. The rule applies to covered foods, and the compliance date is July 20, 2028.

In the EU, Regulation (EC) No 178/2002 Article 18 requires food businesses to apply at least the "one step back, one step forward" approach. In plain terms, you must know who supplied each lot and who you sold it to.

Both rules apply to food. Brands selling cosmetics or electronics can still use the 24-hour mark as a target for their own recalls.

How do you set up lot tracking software step by step?

You set up lot tracking software in five steps. Capture lots at receiving, store them in barcoded bins, pick by FEFO, link lots to sales orders and test with a mock recall.

StepWhat to recordWho owns it
1. ReceiveSupplier lot, internal lot, expiry date and PO numberReceiving team
2. StoreBin location and barcode for each lotWarehouse team
3. PickLot taken for each order linePickers
4. LinkLot or serial number on the sales order and shipmentOperations lead
5. TestTime to trace one lot back and forwardOperations lead

Step 1: Capture supplier lot and expiry at receiving

Capturing the supplier lot and expiry date at receiving is the base of every later trace. Record both against the purchase order before stock goes on a shelf.

Keep the supplier's lot number next to your internal lot number. Suppliers quote their own code in a recall.

Make it a hard rule: no lot, no putaway.

Step 2: Store lots in bins with barcodes

Storing each lot in a known bin with a barcode lets anyone find a batch in seconds. Scan the lot and bin barcodes at putaway.

Avoid mixing two lots of one SKU in a bin. If you must, scan both lots in.

Step 3: Pick by FEFO

Picking by FEFO (first expired, first out) means sending out the batch with the earliest expiry date first. Sort your pick lists by expiry date, then have pickers scan the lot they actually take.

A pick list can suggest a lot, but only the scan proves which one left.

Step 4: Link lot and serial to each sales order across channels

Linking lot and serial numbers to each sales order is the step that turns a warehouse log into a recall tool. Every order line should carry the lot or serial that shipped, whatever channel the order came from.

Orders from your webshop, marketplaces and wholesale must land in the same system as your stock. Prim.io connects these channels through native store and courier integrations, priced per connector. Store the courier tracking number on the order too.

Step 5: Run a mock recall

A mock recall is a timed drill where you pick one lot and trace it back to the supplier and forward to every customer. Run one each quarter and time it.

Choose a real lot from last month. Find its purchase order, bins, orders and remaining stock. Any step that needs a spreadsheet is your weak link.

Why is expiry date tracking important for product brands?

Expiry date tracking is important for product brands because short-dated stock turns into waste or an unhappy customer. Knowing each batch's date lets you sell, discount or pull it before it becomes a loss.

Waste is the obvious cost: expired stock you paid for and cannot sell. The quieter cost is a buyer who gets a near-dated product and returns it or leaves a poor review.

Expiry tracking pays off with a routine:

  • Set alerts at fixed windows before expiry, such as 90 and 30 days.
  • Review a short-dated stock report every week, sorted by bin location.
  • Move near-dated lots into a bundle or clearance offer before the last window.
  • Quarantine expired lots in a blocked bin so nobody can pick them.

How does FEFO inventory management work?

FEFO inventory management works by shipping the batch with the earliest expiry date first, whatever order the batches arrived in. FIFO (first in, first out) ships the oldest received batch first, which only matches FEFO when every delivery has the same shelf life.

Example: you stock one granola SKU in two batches.

  • Batch G-114 arrived on March 3 and expires on September 30.
  • Batch G-121 arrived on March 20 and expires on July 15.

FIFO ships G-114 first because it arrived first. FEFO ships G-121 first because it expires first. Under FIFO, G-121 waits behind the older batch and can expire on the shelf.

FIFOFEFO
Ships firstOldest received batchBatch with the earliest expiry
Data neededReceiving dateExpiry date per batch and bin
Best forGoods with no expiry or equal shelf lifeFood, cosmetics and other dated goods
Main riskShort-dated stock expires on the shelfWrong dates at receiving break the sort

How do you handle a product recall with inventory software?

You handle a product recall with inventory software by tracing the lot back to its supplier and forward to every customer order. Then you quarantine the stock that remains. With lots linked to orders, each of those steps is a query.

Say your almond butter supplier reports that its lot AB-77 may be contaminated. The recall runs in five moves:

  1. Find the purchase order that received lot AB-77 and the internal lots tied to it.
  2. List every sales order that shipped from those lots, across Shopify, WooCommerce, Amazon and wholesale, with courier tracking.
  3. Move the remaining units to a blocked bin and stop selling them on every channel.
  4. Contact only the customers who received the affected lot.
  5. Save the trace, dates and actions in your audit file.

If production runs in a separate tool, the trace can stop at the factory door. The guide on how MRP and ERP differ explains where each system's records end.

How does Prim.io handle lot traceability?

Prim.io handles lot traceability by keeping batch numbers, serial numbers and expiry dates in the same system as purchase orders, bins and sales orders. A recall trace runs inside one system, from supplier receipt to customer order.

Prim.io is a cloud ERP with built-in AI for ecommerce and multi-channel brands, running orders, stock, finance, CRM, production and BI in one system.

Inventory in Prim.io covers bins, batches, serial numbers, expiry dates and barcodes. Prim.io tracks expiry dates per batch and bin, so a short-dated report shows where each lot sits. FEFO picking and expiry alerts are practices your team sets up on top of that data.

Purchasing, landed cost, manufacturing with BOMs, multi-company and an API run in the same system as stock.

The Prim.io AI assistant answers from the company's own sales, stock and finance data. It also reads invoices, corrects addresses and matches payments. See how the full cloud ERP for ecommerce fits together.

Open a free demo account

Free demo account, no credit card needed, cancel anytime.

Why ecommerce brands choose Prim.io for lot tracking

Ecommerce brands choose Prim.io for lot tracking because batch data, sales channels and finance sit in one system.

  • OhGood manages 3 warehouses in one real-time view.
  • Prim.io processes 3.1M+ orders every month for the brands that run on it.
  • 50+ native integrations connect webshops, marketplaces and couriers to Prim.io.
  • Store, marketplace and courier connectors are priced per connector (€20 to €50 per month); finance connectors are free.
  • BI powered by Qlik turns stock and sales data into dashboards you can drill into.
  • Plans from €180 per month, billed annually, excluding VAT. See Prim.io plans and pricing.

Frequently asked questions about lot tracking

Frequently asked questions about lot tracking cover batch tracking, FEFO, serial numbers, expiry dates and cost.

What is batch tracking?

Batch tracking is recording which production run or delivery each unit belongs to, then linking that batch to every order it shipped on. When a quality problem appears, you can find the affected units and customers fast. Most brands treat batch tracking and lot tracking as the same practice.

How does FEFO work?

FEFO works by picking the batch with the earliest expiry date first, no matter when it arrived. Your pick list sorts available lots by expiry date, and pickers scan the lot they take. The method reduces spoilage for food, cosmetics and other dated goods, as long as dates are recorded at receiving.

Can cloud ERP track serial numbers and batches?

Yes, cloud ERP can track serial numbers and batches when inventory, purchasing and sales share one database. Prim.io inventory covers bins, batches, serial numbers, expiry dates and barcodes. Each lot or serial can then be tied to the purchase order that received it and the sales order that shipped it.

Can Prim.io track expiry dates?

Yes, Prim.io tracks expiry dates per batch and bin. That lets your team see where each dated lot sits and run a weekly short-dated stock review. FEFO pick rules and expiry alerts are practices your team sets up on top of this data, using the dates recorded at receiving.

How much does Prim.io cost?

Prim Plus is €180, Prim Pro €540 and Prim Enterprise €1,710 per month, billed annually, excluding VAT, with 3, 5 and 15 users included. Store, marketplace and courier connectors are priced separately. A free demo account lets you try Prim.io before you choose a plan.

Lot tracking checklist for recalls and audits

A lot tracking checklist for recalls and audits comes down to four habits that keep every batch tied to its orders.

  • Capture lot numbers at receiving supplier shipments.
  • Pick with FEFO to reduce spoilage.
  • Link serial numbers and batch codes to customer order records for recall readiness.
  • Monitor expiry dates through alerts and bin locations.

Then time your first mock recall to see which step to fix first.

Open a free demo account

Free demo account, no credit card needed, cancel anytime.

Categories

Business tips
News
Publications

Meet an expert

Assess your project & get a tailored demo

Prefer to talk? Call our team directly.

Mon–Fri, 9am–6pm EET

Ready to see it for yourself?

The best way to understand Prim.io is to try it. Start with a free demo account and explore at your own pace.