A pharmaceutical distributor that cannot say which customers received a recalled batch has a serious problem. So does a food company that ships stock past its expiry date, or an electronics retailer that cannot match a warranty claim to the unit it sold. Odoo's lot and serial tracking solves all three, but only when products are set up correctly and the warehouse records the numbers at every move.
FlexCode Middle East is part of FlexCode Systems GmbH, an Odoo Silver Partner. We implement Odoo, so Odoo is the system we describe, next to an honest look at the topic itself.
Key points
- Lots for batches. A lot covers many units made or received together, such as a production batch of medicine.
- Serials for units. A serial number identifies one unit, such as a phone, a machine or a car.
- Expiry drives picking. With expiry dates, Odoo can pick the first-expiring stock first and warn before products expire.
- Traceability in one click. The traceability report shows where a lot came from and every customer who received it.
Lots or serial numbers
| Lot tracking | Serial tracking | |
|---|---|---|
| Identifies | A group of units | One unit |
| Typical products | Medicines, food, chemicals, cosmetics, building materials | Phones, laptops, appliances, machinery, vehicles |
| Main purpose | Recalls, expiry, quality | Warranty, after-sales, theft prevention |
| Effort per move | One number per line | One number per unit |
Tracking is set per product. Only track what you need: a supermarket does not need lots on every can of soft drink, but a pharmacy chain needs them on every medicine. Each tracked product adds a step to receiving, picking and counting, so the decision has a real cost in warehouse time.
Expiry dates and FEFO
With expiration dates enabled, each lot carries dates such as best before, removal and expiry, either entered on receipt or calculated from the product's shelf life. Odoo can then apply a first expiry, first out removal strategy: when a picker prepares an order, Odoo proposes the lot that expires soonest.
- Lot received with expiry date
- Stored in location
- Order picked: soonest expiry first
- Alert before removal date
- Expired stock blocked or scrapped
- Set shelf life on products so expiry dates are calculated automatically when possible.
- Use the FEFO removal strategy on product categories with expiry.
- Review a weekly report of lots reaching their removal date.
- Agree with customers the minimum remaining shelf life they accept, and respect it in picking.

Traceability and recalls
Because every receipt, transfer, manufacturing order and delivery records the lot or serial, Odoo can trace a number upstream to the supplier and receipt, and downstream to every customer delivery. In a recall, that turns days of searching through paper into a report you can export in minutes.
- Search the lot or serial number.
- Open the traceability report to see receipts, internal moves, production and deliveries.
- Export the list of customers and quantities.
- Block remaining stock of the lot in a quarantine location.
- Record returns against the lot and document the recall.
For regulated distribution, read Odoo for pharmaceutical and medical supplies distribution. Manufacturers who create lots in production should also read Odoo Manufacturing basics.
Capturing numbers without slowing the warehouse
The biggest risk with tracking is not the software; it is the warehouse skipping the step when it is busy. Barcodes solve most of this. GS1 barcodes can carry the lot number and expiry date in the same label, so one scan fills the product, lot and date. For serials, scanning each unit on receipt and delivery is fast with a handheld scanner.
See barcode scanning in the Odoo warehouse and, for Egyptian e-invoicing codes on the same products, GS1 and EGS item codes.
1 scan
Product, lot and expiry from a GS1 label
Minutes
To produce a recall list
FEFO
Removal strategy for expiring goods
Per product
Tracking is enabled individually
Common mistakes
- Tracking everything, which slows the warehouse without adding value.
- Entering a generic lot such as 0000 to get past the screen.
- Turning on tracking for products that already have stock, without assigning lots to existing quantities.
- Ignoring expiry alerts until stock has to be written off.
Expired stock that has to be written off affects your margins and VAT; our guide to inventory valuation in Odoo explains the accounting.
FlexCode sets up traceability in Odoo
We decide which products need lots or serials, configure expiry and FEFO, set up GS1 barcode capture and test a recall with you.
Frequently asked questions
What is the difference between lots and serial numbers?
A lot identifies a group of units; a serial number identifies a single unit.
Can Odoo pick the earliest expiring stock automatically?
Yes, with expiration dates enabled and the first expiry, first out removal strategy.
How do I find which customers received a batch?
Open the traceability report for the lot; it lists every delivery that included it.
Can lot numbers be read from barcodes?
Yes. GS1 barcodes can encode product, lot and expiry, captured in one scan.
Should I track every product?
No. Track products where recalls, expiry or warranty make it worthwhile.
Talk to us about how Odoo fits your business. Book a free call
Run invoicing, stock and accounts from one system.
FlexCode Middle East implements Odoo in Arabic and English for companies in Egypt, Saudi Arabia and the UAE.