Features

• Multi-step wizard — a single bom.excel.import.wizard transient model drives four steps: upload, import operations, import BOM lines and a final summary screen.
• Workcenter auto-creation — every workcenter name in column 6 that is not already present in mrp.workcenter is created automatically before any operation is linked to it.
• BOM and operation creation — for each unique product in column 1 one mrp.bom is created (skipped if a BOM already exists for the template) and one mrp.routing.workcenter per distinct operation in the rows, with a default cycle time of 60 minutes.
• Subcontracting awareness — column 7 sets the BOM type to subcontract, and the comma-separated names in column 8 are matched against res.partner and attached as subcontractors.
• Component bootstrapping — components and produced products are searched by name and by default_code; if no match is found a new storable product is created with the spreadsheet name as default code.
• UoM resolution — column 4 is matched case-insensitively against uom.uom; when it cannot be resolved, the component product's default UoM is used and a warning is added to the log.
• Detailed import log — every row, every created record and every error is captured in two text fields (operations_import_log, bom_import_log) shown on the wizard's final tab.
• External dependency — relies on the openpyxl Python library, which must be installed in the Odoo environment.

Configuration

The module ships no setup screen of its own — once installed, a single menu entry exposes the wizard. Configuration is limited to preparing the Excel file and making sure the Python dependency is available.

1. Install the openpyxl dependency

The wizard refuses to start unless the openpyxl library is reachable from the Odoo server. Install it in the environment used to run Odoo:

pip install openpyxl

If it is missing, opening the wizard raises a user error pointing back to this command.

2. Prepare the Excel file

The wizard expects a column-positional layout. Header row aside, each row must use these columns:

By default the wizard reads the sheet named Sheet1 and starts at row 2 (one header row). Both values are editable on the upload screen.

3. Open the wizard

Go to Manufacturing → Products → BOM Excel Import. The wizard opens on the upload step.

4. User access

The wizard is exposed via bom.excel.import.wizard with read/write access for mrp.group_mrp_user (see security/ir.model.access.csv). Any Manufacturing user can run the import; component and product creation happens through the same user.

5. Optional sheet/start-row override

If the spreadsheet does not follow the default layout:

1. Fill in Sheet with the actual sheet name (must exist in the workbook, otherwise the wizard lists available sheets in the error message).
2. Set Start Row to the first data row (e.g. 1 if there is no header).

How it works

The wizard drives a fixed four-step flow. Each transition rewrites the same wizard record and re-opens the form, so the log accumulates as you progress.

1. Upload

Open Manufacturing → Products → BOM Excel Import, attach the .xlsx file, optionally adjust Sheet and Start Row, then click Start Import. The wizard:

• Loads the workbook with openpyxl in data-only mode.
• Verifies the sheet exists, otherwise lists the available sheets.
• Moves to the Operations step.

2. Import operations

Click Import Operations to run action_import_operations. The wizard scans every row from the start row downwards and:

• Collects unique workcenter names; missing ones are created in mrp.workcenter.
• Groups rows by produced product and creates one BOM per product (skipping products that already have a BOM).
• Creates one mrp.routing.workcenter per distinct operation in the group, sequenced in steps of 10 with a 60-minute cycle time.
• Sets the BOM type to subcontract and attaches matching partners when column 7/8 are filled.

Counters for workcenters, operations and BOMs created are stored on the wizard and shown on the next screen.

3. Import BOM lines

Click Import BOMs to run action_import_boms. The wizard:

• Re-reads the sheet and groups component rows by produced product.
• Resolves each component via name or internal reference, creating a new storable product when nothing matches.
• Resolves the UoM by name; falls back to the component's default UoM with a warning.
• Creates one mrp.bom.line per component, linked to the right operation when column 2 matches. Components already present in the BOM are skipped.

4. Review the summary

The final screen shows the count of workcenters, operations, BOMs and BOM lines created, the total error count, and both logs on separate tabs. Click Import Another File to reset the wizard to the upload step.

Versions

19.0.1.0.1 (2026-05-25)

• Changelog tracking starts at this release.