Expiry Date Tracking and FEFO for Food Distributors

Short answer: For a food ingredients supplier, expiry date tracking starts with recording every lot together with its expiry date, origin and customer. When the FEFO rule (first expired, first out) is enforced by the system rather than by the storekeeper, write-offs fall and a recall list can be pulled in minutes. In Odoo ERP this works out of the box through lot tracking, expiration dates and the FEFO removal strategy.

Flour, sugar, cocoa powder, milk powder, spices, flavourings, starch, dry yeast. For a distributor supplying all of this to bakeries, confectionery shops, dairies and meat processors, the most expensive mistake looks trivial: the new lot sits by the aisle, the old one stays at the back of the rack, and a month later it is written off as expired. The second risk is worse. A manufacturer calls and says "there is a problem with lot 14". Finding out which customers received that lot, when and in what quantity takes the storekeeper, the accountant and the sales manager several days of digging through paper. This article explains how expiry date tracking should work, how FEFO differs from FIFO, and what changes in numbers after automation.

What is expiry date tracking and why is it a core problem for distributors?

Expiry date tracking is a system where the production date and expiry date of every lot are captured at receipt, and warehouse, sales and purchasing decisions are based on those dates.

What makes ingredient distribution special is that the buyer is not a consumer but a manufacturer. They put the ingredient into their own product and plan their own shelf life around it. That is why B2B customers often set terms like "at least 70% remaining shelf life" or "certificate of analysis with every lot". Checking these terms by hand in Excel for every shipment is close to impossible.

The scale of the problem is global. FAO estimates that in 2023, 13.3% of the world's food was lost between harvest and retail (FAO, SDG 12.3.1). Every link in the chain, warehouses and distributors included, carries part of that loss on its own books.

What is FEFO and how is it different from FIFO?

FEFO (First Expired, First Out) is a picking rule that ships the lot with the earliest expiry date first.

FIFO ships whatever arrived first. Usually the two give the same result, but with ingredients they often do not: cocoa powder that arrived yesterday may expire sooner than a lot received a month ago, simply because the mill produced it earlier. A storekeeper working by FIFO ships the old receipt while the new one quietly runs out of shelf life.

What FEFO needs in practice:

Every receipt is booked with a lot number.
The lot carries an expiry date and, where possible, a production date.
At picking, the system tells the storekeeper exactly which lot to take from which bin.
Purchasing and sales get early warnings about lots nearing expiry.

We covered the general principles of stock control in our guide to warehouse accounting.

How do lot traceability and recalls work?

Traceability is the ability to show instantly which supplier a lot came from and which customers it went to.

A recall is one of the most expensive events in the food industry. A joint FMI and GMA industry study put the average direct cost of a recall for a food company at $10 million, before brand damage and lost sales (Food Dive, 2016). An ingredient distributor in Uzbekistan works with smaller sums, but the principle holds: the faster you find the problem lot, the less product comes back and the fewer customers are hurt.

The speed gap can be huge. Walmart's food safety chief Frank Yiannas told the US Congress that tracing sliced mangoes from store to farm took 7 days with traditional methods and 2.2 seconds with a digital traceability platform (Yiannas, 2018). Requirements are also tightening: the new FDA traceability rule requires firms to provide traceability records within 24 hours of a request (FDA, FSMA 204). If your customers export, that requirement reaches you indirectly.

How much profit do write-offs eat?

According to UNEP, 1.05 billion tonnes of food were wasted worldwide in 2022, almost one fifth of the food available to consumers, with 12% of it in retail. The global economic cost of food loss and waste is estimated at roughly $1 trillion (UNEP, 2024).

For example, take a distributor holding 3 billion so'm of stock on average. If just 1% of that stock is written off each month, that is 30 million so'm a month and 360 million so'm a year in direct losses. The calculation is an assumption; the real rate differs from company to company. But many owners do not know their number, because write-offs disappear into general expenses instead of showing up in their own report.

Money spent on reducing loss pays back. A WRI and Champions 12.3 study of 1,200 sites at 700 companies in 17 countries found that companies saved $14 in operating costs for every $1 invested in reducing food loss and waste (WRI, 2017).

What changes after automation: in numbers

Tracing speed: 7 days on paper versus 2.2 seconds in a digital system (Yiannas, 2018).
Return on loss reduction: on average $14 saved for every $1 invested (WRI, 2017).
Inventory levels: early adopters of AI-enabled digital supply chain management cut inventory by 35% and logistics costs by 15%, and raised service levels by 65% (McKinsey, 2021).
Recall exposure: an average direct recall cost of $10 million; fast tracing narrows the volume you have to pull back (Food Dive, 2016).
Reporting speed: a 24-hour deadline for traceability records is only realistic with digital lot tracking (FDA, FSMA 204).

How do you set up expiration dates and FEFO in Odoo?

In Odoo Inventory this is switched on without custom code:

Enable the "Lots & Serial Numbers" and "Expiration Dates" settings.
Set the shelf life in days on each product: Odoo calculates the expiration, best before, removal and alert dates from the receipt date.
Choose the FEFO removal strategy for a product category or warehouse: the pick list automatically proposes the lot that expires first.
The Traceability report follows a lot upstream (supplier) and downstream (customers) in one click.
A certificate of analysis file is attached to the lot, and the lot number prints on the delivery slip.

For some food categories, Asl Belgisi digital marking and e-invoicing through Didox connect to the same system. Read more about the warehouse module in our Odoo Inventory article and about wholesale processes in Odoo ERP for wholesale.

How does Deep Vision approach this?

Deep Vision is an official Odoo Gold Partner in Tashkent. According to its Odoo partner page, the team has 7 Odoo-certified experts, most of its 24 client references are in wholesale, retail and manufacturing, and customer retention is 89%. Our team also produced Odoo's Uzbek translation, so storekeepers and managers can work in their own language.

In the projects of Deep Vision founder Amon Olimov's team, one pattern comes up again and again with ingredient distributors: expiry data exists, but it lives in the storekeeper's notebook or a separate Excel file. So we work in this order:

Stock count with lots and expiry dates.
Receiving, picking and shipping reconfigured for FEFO.
A weekly near-expiry report tied to the purchase plan.
Our ready-made modules for Didox and Asl Belgisi connected.

Standard Sales and Inventory often go live in 6–8 weeks; a full project takes 2–6 months. To discuss your case, fill in a short brief or see our Odoo implementation service.

Frequently asked questions

Can FEFO be run in Excel?

At small volumes, yes, but the storekeeper has to check the sheet by hand on every pick. With hundreds of SKUs and lots, mistakes are inevitable. An ERP shows the right lot on the pick list automatically.

What is the difference between expiry date and best before?

The expiry date is the last date the product is safe to use. Best before is the period of best quality. Odoo stores both, plus removal and alert dates, as separate fields.

Can the system respect a customer's minimum remaining shelf life?

Yes, with a little more than standard setup. Remaining shelf life is visible on every lot, and a per-customer minimum rule is added through a small customisation so that a non-compliant lot is not shipped.

In a recall, how fast do we get the customer list?

If lots are tracked correctly, the Traceability report shows within seconds which customers received the lot and when.

How long does implementation take?

Standard sales and inventory setup usually takes 6–8 weeks; a full project with accounting and manufacturing takes 2–6 months.

Sources

Ready to move lot and expiry control into one system? Leave a brief or call +998 77 093 00 07.

Back to blog