bom-converter

Convert SolidWorks BOMs (Bill of Materials) to Odoo.

Setup

poetry install

Usage

poetry run bom-converter <path-to-solidworks.xlsx> [-o outputs]

Outputs:

• Odoo-formatted Excel written to <output-dir>/<input-stem>_Odoo.xlsx with sheet name BOM.
• If conversion fails, a JSON log is written alongside the output as <input-stem>_Odoo.log and the process exits non-zero.

Options

• --bom-type (default: Manufacture this product)
• --reference (default: PROD BOM)
• --status (default: In R&D)
• --uom (default: Units)
• --log-path override the error log location

Notes

• Only the required SolidWorks columns are used: NO., SKU, Internal ID, QTY.. Other columns are ignored.
• Hierarchy comes from the dot-separated NO. values; sequence equals the parent depth (root 0, children 1, etc.).
• Product labels are rendered as [SKU] Internal ID; missing pieces are replaced with N/A.