Skip to content

"Which lot did that come from?" should not take days and a box of delivery notes to answer.

Your factory makes good product, but the paper trail behind each batch stops at the warehouse door. When a customer, an auditor or a supplier asks which lot went where, the answer lives in delivery notes, shift logs and someone's memory. That works until the day the question is urgent.

—— Sound familiar?

You know this problem by these symptoms.

  • A supplier flags one defective batch, and the only safe response is to quarantine everything they ever delivered.

  • A customer complaint turns into days of matching delivery notes against handwritten production logs.

  • Lot numbers get written on the bag at receiving, then never typed into any system again.

  • Audit week means pulling production staff off the line to reconstruct batch histories from paper.

  • Material expires on the shelf because no one can see which pallet came in first.

This is not carelessness — it is what happens when each stage of production got its own tool. Receiving logs lots in one file, the shop floor runs on paper travellers, and the accounting system only ever counted quantity, not identity. Each tool does its own job well, but none of them passes the lot number to the next. The chain of custody breaks at every handover, and no amount of discipline at one station can repair the whole line.

—— The way out

How Odoo closes this gap.

The way out · 01

One lot number from receipt to delivery

Odoo Inventory tracks products by lot or serial number as a standard setting, not an add-on. The lot is captured once at goods receipt and follows the stock through every internal transfer and delivery, so identity travels with the pallet instead of staying behind in a spreadsheet.

The way out · 02

Batch genealogy through manufacturing

Odoo Manufacturing records which component lots each manufacturing order consumed and which finished lot it produced. The built-in traceability report then walks the chain in either direction — from a supplier lot down to every affected delivery, or from a customer complaint back to the raw material — in seconds rather than days.

The way out · 03

Scanning instead of end-of-shift typing

The Odoo Barcode app puts lot capture where the work happens — at receiving, at the workstation, at the loading dock. Scanning a label takes less time than writing it down, so the record gets made because it is the easiest path, not an extra chore.

The way out · 04

Expiry dates and quality holds on the lot itself

Each lot in Odoo carries its own expiration and alert dates, and the FEFO removal strategy makes pickers take the oldest usable stock first. The Quality module adds check points at receipt or during production and can block a suspect lot from moving until someone signs it off.

—— How we run it

The transition, managed properly.

  1. Start with one product family

    We switch on lot tracking for the highest-risk product family first, with a fixed written scope for that phase. The rest of the catalogue follows once the first is proven on the floor.

  2. Opening stock migrated in validated batches

    Existing lot records — labels, spreadsheets, delivery notes — are loaded in batches your warehouse team counts and confirms before the next batch moves. Every batch keeps a rollback point until you sign it off.

  3. Parallel run, trained on your real lots

    For the first weeks the existing paper trail keeps running beside Odoo, so nothing depends on a system the team has only used for days. Training runs on your live products and lot numbers, with the same consultant from the first call through go-live.

—— FAQ

Questions teams ask about this problem.

How long until we have working traceability?

For a single site tracking lots through receiving, production and delivery, typically six to ten weeks from scoping to go-live. Multi-site operations or serial-level tracking take longer. You get the phased timeline in writing after scoping, not a guess before it.

Can we keep our current system and paper travellers during the transition?

Yes, and we recommend it. The paper trail runs in parallel until the Odoo records have matched it for a full cycle — usually a month. Turning the old system off is your decision, made on evidence, not a date on a project plan.

Our historical lot data is incomplete. Is that a problem?

No — traceability starts from a clean opening count, not from perfect history. We load what you have, flag what is missing, and every lot received after go-live is complete by construction. History fills in naturally as old stock is consumed.

What does this cost, and what is the licence position?

Implementation is quoted as a fixed fee per phase after scoping — no hourly billing. Lot tracking and manufacturing run on Odoo Community, which is a $0 licence; if your case needs Enterprise features such as Quality or Barcode, that licence is billed by Odoo directly and we never mark it up.

Ready?

Let's find out whether Odoo actually fits your business.

A short call, an honest answer. If it isn't the right system for you, we'll say so.

LINE myprofitbook · WhatsApp · Bangkok · New York · Delhi NCR
Fix Missing Lot Traceability in Production with Odoo