Hello, I'm using the internal reference field to store our company's part number for parts (SKUs). Our part numbers are unique.
I have a BOM that I exported from SolidWorks, where the components in an assembly are reference by our inter part number.
How can I import a BOM with our part numbers as the key for the product in Odoo, which has a matching part number in its "internal reference" field.
Thanks,
Hi Rugged,
If your part numbers are already stored in Internal Reference (default_code) and they are unique, you can actually use them directly during the BOM import without needing a separate app.
In the BOM import file, map the component product using:
Component / Product → Internal Reference
For example:
| Product | Quantity | Components/Internal Reference | Components/Quantity |
|---|---|---|---|
| ASSY-100 | 1 | PART-001 | 2 |
| ASSY-100 | 1 | PART-002 | 4 |
As long as the Internal Reference (default_code) of the product matches the part number from your SolidWorks export, Odoo will correctly resolve the product during import.
A practical workflow:
Ensure all parts exist in Odoo with the correct Internal Reference.
Export a sample BOM from Odoo with import-compatible fields.
Adapt your SolidWorks BOM to match the same column structure.
Import it via Manufacturing → Bills of Materials → Import.
This avoids custom modules and keeps everything using the standard Odoo importer.
Only if your SolidWorks export format is very different would a custom import script/module be needed.
Regards,
Santosh S
Thanks to all for the replies. We have developed a system where we're able to take a BOM export from solid works, then map all the components to Odoo products via their internal reference, and name and use that to convert the SW BOM to an Odoo MRP BOM. It's a multi-step process, but it is working well enough.
I still have question regarding BOM ECOs, and importing large change sets from solid works as an ECO, but I'll leave that for another post. Thanks again for all the feedback and suggestions.
- https://apps.odoo.com/apps/modules/18.0/import_bill_of_materials_in_mrp
- https://www.odoo.com/sl_SI/forum/pomoc-1/importing-list-of-components-to-a-bom-218432
Hope it helps
Créez un compte dès aujourd'hui pour profiter de fonctionnalités exclusives et échanger avec notre formidable communauté !
S'inscrire| Publications associées | Réponses | Vues | Activité | |
|---|---|---|---|---|
|
1
févr. 26
|
1542 | ||
|
1
nov. 25
|
1085 | ||
|
0
oct. 25
|
1111 | ||
|
1
sept. 25
|
1909 | ||
|
2
sept. 25
|
1595 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
Hello,
Please check this app by Cybrosys:
https://apps.odoo.com/apps/modules/18.0/import_bill_of_materials_in_mrp
Hope this help
info@codespheretech.in
We are not using odoo.sh, or on premise unfortunately, only Odoo online
For odoo online you can only use import records functionality given by Odoo default. Customization is not possible on this.
Codesphere Tech confirmed that for Odoo Online, you can only use import records functionality that is given by default by Odoo, customization is not possible