Import serials and lots in bulk with a validated preview
Drop a CSV or Excel file onto any delivery, receipt, or transfer and let the app match products, assign lot/serial numbers to the right lines, and show you exactly what will change before you commit.
The problem
Warehouse teams still key in serial and lot numbers one line at a time inside Odoo’s detailed-operations screens. For a business shipping 20+ orders and 800+ tracked products a day, that manual entry burns hours, invites transcription errors, and stalls validation — especially when the source data already exists in a scanner export or supplier packing list with no fast path into Odoo.
The solution
Import Serial Numbers on Delivery Orders adds a one-click import button directly on the picking form. Upload a CSV or Excel file, or paste rows directly, get automatic header detection and triple product lookup, preview every row before anything writes, and let the app auto-create missing lots/serials while logging a full audit trail.
Everything a high-volume warehouse needs
Every capability below is implemented in the module.
On-form import button
A visible “Import Serials/Lots” button sits right on the delivery, receipt, or transfer form — no hunting through detailed-operations sub-windows to find it.
CSV, Excel, or paste
Upload a CSV or.xlsx file, or paste rows straight from a spreadsheet — no external Python library to pre-install, no format lock-in.
Header auto-detection
Column headers are read automatically and mapped to product, serial/lot, quantity, and date fields — no counting columns by hand.
Triple product lookup
Each row is matched to a product by name, internal reference, or barcode — whichever identifier your source data carries.
Dry-run preview grid
Every row is validated and shown with its matched product, target line, and status before anything writes to your pickings.
Auto-create lots & serials
Numbers that do not already exist are created on the fly, so you never have to pre-seed lot/serial records before importing.
Expiry & shelf-life dates
Import best-before, removal, expiration, and alert dates alongside each row — built for pharma, food, and cosmetics buyers.
Duplicate detection & partial import
Duplicate serials are flagged against the file and existing stock; on a failure you get a line-by-line error report and can import the valid rows while you fix and resume the rest.
Persistent audit trail
Every import is logged — who ran it, when, and the outcome of every row — so managers can trace serial provenance after the fact.
How it works
Open the picking
Click the “Import Serials/Lots” button on any delivery, receipt, or transfer form — or start a batch import from the picking list.
Upload or paste
Drop a CSV or Excel file, or paste rows directly; headers and columns are detected and mapped automatically.
Review the preview
Check the validated preview grid for matched products, target lines, and any flagged errors or duplicates.
Import & track
Confirm to write the valid rows to your picking lines; every run is recorded in the audit log for later reference.
Frequently asked
No sales fog. If your question isn't here, email us and we'll answer it the same way.
Deliveries, receipts, and internal transfers — the import button appears on any stock picking form, and you can also launch a batch import from the picking list’s Actions menu.
Buy it on the Odoo App Store
Purchase, download and install directly from the official Odoo Apps Store — you'll always get the latest supported build.
Import Serial Numbers on Delivery Orders
Import lot and serial numbers onto deliveries, receipts and transfers from CSV, Excel or paste, with a dry-run preview grid and auto-created lots — including expiry dates and duplicate detection.
Buy on Odoo App Store