Preventing Expired Medicines with FEFO and Batch Tracking in Odoo

Expired medicines are not only a problem after the date has passed. The risk develops earlier: batch numbers are not recorded, expiry dates sit in a separate notebook, and cashiers select products based on shelf position. As product volume grows, manual checks become harder to maintain.

Why do manual expiry checks fail?

A pharmacy may hold the same product from several receipts, each with a different batch number and expiry date. If inventory is recorded as one total quantity, the team cannot identify which batch should be prioritized.

• Older batches are hidden behind newly received stock.
• Expiry dates are reviewed only during stock counts.
• Cashiers must remember which batch to sell first.
• Owners lack a reliable list of products nearing expiry.
• Inventory adjustments do not identify the affected batch.

FEFO is not the same as FIFO

FIFO prioritizes the first goods received. FEFO prioritizes the batch with the earliest expiry date. A batch received later may expire sooner, so receipt order alone is not always sufficient for medicines.

For FEFO to work, the system needs three pieces of information: product, batch number, and expiry date. They should be captured when goods are received—not after a problem appears.

How does Odoo support batch and expiry workflows?

1. Capture batches during receipt

When goods arrive from a vendor, the administrator records the batch number, quantity, and expiry date. Inventory for the same product remains separated by batch.

2. Apply FEFO priority

The removal strategy can prioritize the batch with the earliest expiry date. The team no longer depends entirely on memory.

3. Identify products that require attention

Expiry data can be filtered by period, such as 30, 60, or 90 days. Owners can then choose an appropriate action: accelerate sales, arrange a return according to vendor policy, or transfer stock to a location with higher demand.

4. Separate products that must not be sold

Damaged or expired products should move to a quarantine location so they are unavailable at the POS. Every adjustment should record a reason and the responsible user.

FEFO implementation checklist

1. Identify products that require batch tracking.
2. Capture expiry dates during every receipt.
3. Define FEFO and quarantine rules.
4. Train administrators on receipts and cashiers on batch selection.
5. Schedule routine reviews of products nearing expiry.
6. Test returns, disposal, and inventory adjustment workflows.

Technology does not replace pharmacy procedures. It makes those procedures more visible, consistent, and traceable.