Bulk import Bills of Materials, validated before they are created
Upload CSV or Excel BOM data, catch every missing product and bad quantity in a dry-run preview, then commit with confidence — row-level diagnostics and a full import history included.
The problem
A Bill of Materials is nested data — a parent product with many component lines, each carrying its own quantity, unit of measure, and optional routing. Odoo's native import handles flat records well but struggles with this structure, and rebuilding hundreds of BOMs by hand at go-live is slow and error-prone. Problems like a missing product or a barcode Excel silently turned into a number are usually discovered only after the import has already run.
The solution
This importer resolves every product, unit of measure, and quantity in a dry-run preview before anything is created. Numeric-vs-text corruption is auto-corrected, problems are reported row by row with the offending value, and you can fix flagged rows in place and reprocess just those — no full re-upload, no orphaned BOMs.
Everything you need for accurate BOM migrations
Every capability below is implemented in the module.
Validate Before You Commit
A dry-run resolves every product, UOM, and quantity before any BOM is created, so nothing is written until you have reviewed the result.
Row-Level Error Diagnostics
Errors point to the exact row and field, show the offending value, and suggest a fix — never a bare "Product does not exist".
Numeric-vs-Text Auto-Correction
Detects Internal Reference and Barcode codes that Excel silently stored as numbers (like 12345.0) and restores them automatically.
Fix and Reprocess Failed Rows
Correct a flagged row directly in the preview grid and reprocess just that row — no need to re-upload the whole file.
Multi-Line, Multi-Level BOMs
Each parent product can carry any number of component lines, and sub-assemblies with their own BOMs resolve correctly regardless of import order.
Match by Name, Code, or Barcode
Components resolve by product name, internal reference, or barcode, matching whichever identifier your source system used.
Operations & Work Center Import
Optional operation and work center columns attach routing steps to the created BOM lines.
Background Processing
Queue large files to a scheduled job so bulk imports never lock up the Odoo interface.
Auditable Import History
Every run is a persistent record with row counts, error summaries, and a link to the BOMs it created.
How it works
Upload Your File
Attach a CSV or Excel export from your legacy system or spreadsheet.
Validate
A dry run resolves every product, UOM, and quantity, flagging errors by row and field.
Review & Fix
Correct any flagged rows right in the preview grid, then reprocess just those.
Import
BOMs and operations are created, completion is posted to chatter, and the run is kept in history.
Frequently asked
No sales fog. If your question isn't here, email us and we'll answer it the same way.
CSV and Excel (.xlsx) files. Legacy .xls is not supported — export or save your source file as .xlsx first.
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 Bills of Materials
Bulk import Bills of Materials from CSV or Excel with a validate-before-commit dry-run preview, row-level error diagnostics, and a searchable import history.
Buy on Odoo App Store