Logo Dark
Get In Touch

FEFO in Odoo for Cosmetics: Lot Expiry, Shelf Life and Recall Trace

/
ERP

A distributor calls about a face cream that has separated on the shelf. QA suspects one preservative lot. Two questions follow within the hour: which batches used that lot, and which customers received them?

If the answer lives in purchase files, batch sheets and dispatch registers, tracing it takes days. If every lot was recorded at receipt, in production and at dispatch, it takes minutes.

This guide explains what FEFO means, how FIFO, LIFO and FEFO differ, and how to set up FEFO, lot expiry dates, alerts and a recall trace in Odoo 19. It also marks the three places where standard Odoo stops and custom work starts.

Key Takeaways

  • FEFO (first expiry, first out) ships or consumes the lot with the earliest expiry first.
  • Odoo 19 supports FEFO, lot expiry dates, expiry alerts and lot traceability as standard.
  • Odoo skips lots past their removal date when reserving stock. The physical stock stays until someone moves it.
  • A one-click customer recall list needs a custom report.

New to running a cosmetics plant on an ERP? Start with our complete guide to cosmetics manufacturing software, then come back here for expiry and recall.

What does FEFO mean?

FEFO stands for first expiry, first out. It's a stock rotation rule: whichever lot expires soonest leaves the warehouse first, whether it's going to a customer or into a mixing vessel. The expiry date sets the order, whatever the receipt date.

That matters in cosmetics because the oldest receipt is often not the shortest-dated one. A preservative lot received in March can carry a later expiry than one received in May, depending on when the supplier made it. Pick by receipt date and the May lot sits at the back until it expires.

FIFO vs FEFO vs LIFO in plain language

FIFO, LIFO and FEFO are three rules for deciding which stock leaves first.

MethodRuleGood for
FIFOFirst in, first out: the oldest receipt ships firstGoods without a meaningful shelf life
LIFOLast in, first out: the newest receipt ships firstRarely used for physical picking
FEFOFirst expiry, first out: the earliest expiry ships firstCosmetics, food, pharma

The FIFO vs FEFO choice comes down to one question. Does the product carry an expiry date that varies by lot? For creams, serums, shampoos and most of their raw materials, yes. FEFO is the right default for those.

Our view: Apply FEFO to packaging as well. Printed cartons and labels don't spoil, but they carry regulatory text and batch formats that change. Treating them as lot-tracked stock with an expiry keeps old artwork from surfacing six months after a label revision.

How do you set up FEFO in Odoo 19?

Odoo 19 supports the FEFO method through standard Inventory settings. There's no extra app to buy. Four steps:

  1. Turn on the features. In Inventory ‣ Configuration ‣ Settings, enable Lots & Serial Numbers and Expiration Dates under Traceability.
  2. Track by lots. On each raw material, bulk product and finished good, set tracking to By Lots.
  3. Enable expiry on the product. Tick Expiration Date on the product form and fill in the shelf-life days (covered in the next section).
  4. Set the removal strategy. Choose First Expiry First Out (FEFO) in the Force Removal Strategy field on the product category, or on the warehouse location.

Odoo applies the product category's strategy first. If the category has none, it uses the location's. If neither is set, FIFO applies by default. In practice, we set FEFO on the product categories that carry expiry, so a location shared with non-expiring stock doesn't need a separate rule.

What happens after FEFO is on?

When a delivery or manufacturing order reserves stock, Odoo picks the lots with the nearest removal date first. If an order needs six cartons and the earliest lot holds five, Odoo takes all five and the sixth from the next-earliest lot. Your stores team stops choosing lots by memory.

How your bills of materials consume those lots is covered in our guide to Odoo manufacturing for cosmetics formulations and BoMs.

How does Odoo handle shelf life and expiry dates?

Odoo works out four dates for every lot from day counts you set once on the product form. Each count is measured from the date the goods are received or produced, so a lot of face cream made today gets its own dates automatically.

DateWhat it means in Odoo
Expiration DateThe date after which the goods may become unsafe to use
Best Before DateThe point at which quality starts to decline, set as days before expiry
Removal DateThe point at which the lot should leave normal stock, set as days before expiry
Alert DateThe point at which Odoo raises an alert, set as days before expiry

Supplier lots are different. A preservative arrives with the supplier's own expiry on the certificate of analysis. Enter that date on the lot at receipt. Odoo's computed date is a starting point, and the supplier's printed date is the one an auditor will check.

What does the removal date actually do?

The removal date is the date FEFO uses for sorting. Once it passes, Odoo stops reserving that lot for new deliveries and manufacturing orders.

The stock itself doesn't move. It stays in its bin, and it still shows on hand, until someone transfers it to a quarantine location or scraps it. That gap is where expired stock gets used by hand, so close it with a weekly check or an automation (see what needs a customisation).

Best practice: Set the removal date weeks ahead of the real expiry. Many distributors and modern-trade buyers refuse inbound stock below a minimum remaining shelf life. Your removal date should pull a lot out of normal stock before it falls under that threshold, which leaves time to consume it in production or plan a clearance sale.

Expiry alerts

On the alert date, if the lot still has stock, Odoo creates an Alert Date Reached activity for the user responsible for the product. Lots past their expiration date show a red Expiration Alert on the lot form. In Inventory ‣ Products ‣ Lots/Serial Numbers, the Expiration Alerts filter lists every lot that needs attention.

Where does PAO fit?

The period-after-opening symbol (the open-jar icon with "12M" or "6M") describes how long a product lasts once the consumer opens it. It's a label claim. Odoo's dates track unopened shelf life in your warehouse. Under EU cosmetics rules, a product with a minimum durability above 30 months can show a PAO symbol on the label and skip the best-before date. Keep PAO on the product's label data and keep Odoo's expiry dates for stock rotation.

How does lot tracking connect raw materials to finished batches?

Batch traceability only works if a lot number is recorded at every handover. In a cosmetics plant on Odoo, the chain runs in four steps:

  1. Purchase receipt. Record the supplier's lot number and expiry for every raw material and packaging component.
  2. Manufacturing. The manufacturing order records which component lots were consumed to make each bulk lot.
  3. Filling and packing. A second manufacturing order consumes the bulk lot and produces the finished-goods lot.
  4. Delivery. The delivery order records which finished lots went to which customer, and how many units.

Odoo links these moves, so you can go both ways. Upstream, you trace a finished lot back to every raw material in it. Downstream, you trace a raw material lot forward to every finished lot and customer it reached.

The same records feed your batch file. Our guide to the BMR format for cosmetics shows how they print as a single batch manufacturing record. For how bulk and filling stages map to manufacturing orders, see Odoo MRP for cosmetics process manufacturing.

How do you run a recall trace in Odoo?

With lot numbers recorded at every stage, Odoo's Traceability report answers the recall questions directly. Take the suspected preservative lot, PRS-2611:

  1. Open Inventory ‣ Products ‣ Lots/Serial Numbers.
  2. Search for PRS-2611 and open it.
  3. Click the Traceability smart button to see every move of that lot.
  4. Find the manufacturing orders that consumed it. Say two bulk batches of face cream.
  5. Open each bulk lot and trace it forward to the finished lots filled from it.
  6. Open the delivery orders for those finished lots to see customers, dates and quantities.
  7. Move any remaining stock of the affected lots to a quarantine location.

Each finished lot answers its own question in one click. The full trace for one raw material lot takes a few clicks per branch. If PRS-2611 went into two bulk batches and five finished lots, that's a short afternoon at worst. On paper, the same trace means pulling purchase files, batch sheets and dispatch registers and matching them by hand.

What is a mock recall, and how do you run one?

A mock recall is a planned drill. You pick a lot, trace it end to end against the clock and check that the records hold up. It tests your data before a real complaint does.

We run one with every cosmetics client before go-live. The steps:

  1. Choose one raw material lot that has already moved through production and dispatch.
  2. Without warning the team, ask for every affected batch, customer and quantity.
  3. Time the trace and note every gap: a missing supplier lot, a manual consumption entry, a delivery without lots.
  4. Fix the configuration or the process behind each gap.
  5. Repeat until the trace is complete with no gaps.

The most common failure we find is opening stock. If stock was migrated as a single quantity with no lots, every trace dead-ends at go-live. We migrate opening stock lot by lot, with expiry dates, even when that needs a physical count first.

Can Odoo produce a customer recall list?

Odoo holds every fact a recall notice needs: customer, delivery date, lot number and quantity. What it doesn't give you as standard is one consolidated list that starts from a raw material lot and ends at every affected customer.

In standard Odoo, someone walks the branches by hand and copies the results into a spreadsheet. That's workable for one lot in two batches. It gets slow when a common ingredient, say a fragrance or an emulsifier, feeds a dozen products.

A custom recall report closes that gap. You enter the suspected lot. The report walks every branch and returns one table of affected batches, finished lots, customers, delivery dates and quantities, ready to export for the recall notice.

What needs a customisation in Odoo?

Standard Odoo 19 covers stock rotation, expiry and traceability. Reporting and automation on top of that may need development.

RequirementStandard Odoo 19Customisation
FEFO stock selectionAvailableNot required
Lot expiry dates and alertsAvailableNot required
Lot traceability, upstream and downstreamAvailableNot required
One-click recall report from a raw material lotManual trace per branchRequired
Automatic move of expired lots to quarantineNot standardRequired
30/60/90-day expiry dashboardExpiration Alerts filterCustom dashboard

The automatic quarantine move is the one we'd prioritise. It closes the gap between "Odoo won't reserve it" and "nobody can pick it by hand." A scheduled action can move every lot past its removal date to a quarantine location overnight.

How 7Span implements FEFO and recall trace in Odoo

We configure lot tracking, expiry dates and FEFO across raw materials, bulk, packaging and finished goods, and we migrate opening stock lot by lot.

Before go-live, we run a mock recall with your team. We trace a real supplier lot through manufacturing and delivery to the customer, and fix every gap it exposes. Where you need it, we add the recall report, the quarantine automation and the expiry dashboard.

We'll tell you which of those your Odoo edition covers and which need custom work before any estimate. For Ruelia Professional, a haircare and skincare maker on Odoo 19 Community, we built packaging BoMs for 14 finished SKUs and a pre-production view that flags packaging shortfalls before purchase is due.

Looking to Hire Certified Odoo Developers
Hire Odoo Developers

Frequently asked questions

What is the difference between FIFO and FEFO?

FIFO ships the oldest receipt first. FEFO ships the lot with the earliest expiry date first. The two often match, but supplier lots arrive with different shelf lives, so the oldest receipt isn't always the shortest-dated. For cosmetics and their raw materials, FEFO is the safer rule.

Does Odoo support FEFO?

Yes. Odoo 19 supports FEFO as a standard removal strategy. Enable Lots & Serial Numbers and Expiration Dates, track products by lots, and set First Expiry First Out on the product category or location. The category setting takes priority. With neither set, Odoo uses FIFO.

Does Odoo stop expired stock from being shipped?

Odoo stops reserving a lot once its removal date passes, so it won't be picked for new deliveries or manufacturing orders. The stock stays on hand until someone moves or scraps it. Moving it to quarantine automatically needs a scheduled action or a small customisation.

How fast can Odoo trace a recall?

With lots recorded at receipt, production and delivery, a trace from one raw material lot to every affected customer takes minutes per branch. Standard Odoo shows each branch through the Traceability report. A single consolidated recall list across all branches needs a custom report.

What is a mock recall?

A mock recall is a planned drill that traces one lot from supplier to customer against the clock. It shows whether your lot records are complete before a real complaint tests them. We run one with every cosmetics client before go-live.

Shyam Vasoya
Odoo Developer
Shyam is an Odoo developer who customises and extends ERP systems across CRM, HRMS, Manufacturing, and Project Management modules. He specialises in turning business requirements into automated workflows, secure portal integrations, and custom reports. His practical, detail-focused approach makes him a reliable voice for complex, multi-module Odoo projects.
India (HQ)

201, iSquare Corporate Park, Ahmedabad-380060, Gujarat, India

+91 77 97 977 977
Canada

24 Merlot Court, Timberlea, NS B3T 0C2, Canada

+1 902-333-0067

For Sales

YO@7SPAN.COM

Looking For Jobs

Apply Now
Making It Possible Light