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
- 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
Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!
Daftar| Post Terkait | Replies | Tampilan | Aktivitas | |
|---|---|---|---|---|
|
1
Feb 26
|
1390 | ||
|
1
Nov 25
|
931 | ||
|
0
Okt 25
|
1004 | ||
|
1
Sep 25
|
1774 | ||
|
2
Sep 25
|
1471 |
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