Skip to Content
This question has been flagged
mrpbom_importv17
1 Respondre
1929 Vistes
Avatar
Magnolia Technology Solutions

I am trying to import Bills of Material in bulk but the import keeps throwing the following error:

Missing required value for the field 'Product' (product_tmpl_id)


The Import file has been prepared in the following template as prescribed by Odoo:


External ID Reference Product Quantity BoM Type BoM Lines/Component BoM Lines/Quantity
mrp_bom_1 BOM_SC234 [FURN_7800] Desk Combination 1 Kit  [FURN_2100] Drawer Black 1
[FURN_5623] Drawer Case Black 1
[CONS_89957] Bolt 4
mrp_bom_2 BOM_LAP456 [FURN_78236] Table Kit 1 Manufacture this product [FURN_7023] Wood Panel 1
[CONS_89957] Bolt 4


Avatar
Descartar
Avatar
Ankit Tiwari (anti)
Best Answer

I have tried importing the given file into the demo.odoo.com database, and I can import it without any issues, here is a screenshot for your reference.

You can make sure the fields are mapped correctly, additionally, if multiple products exist with the same name, you can use the "Product.template External ID" for the BOM Product and  "Product variant External ID" for the Components.

Here is a video you can refer to - https://drive.google.com/file/d/1l_vcHG14vWvWR6XtoaQJL1GhZ578SFfp/view

Avatar
Descartar
Related Posts Respostes Vistes Activitat
Display extra fields inside BoM Overview web page
mrp BoM v17
Avatar
Avatar
1
d’oct. 24
3254
How to update component quantity in BOM (Ver15) Solved
mrp bom bom_import bom_lines
Avatar
Avatar
Avatar
Avatar
4
d’abr. 22
3753
Ya es posible hacer Upgrade de v17 a v17.1 ?
v17
Avatar
Avatar
1
d’oct. 25
1205
How to add a new Many2one field in res.config.settings? Solved
v17
Avatar
Avatar
Avatar
Avatar
4
d’oct. 25
3505
Add field to ALL models in Odoo
v17
Avatar
Avatar
Avatar
2
de set. 25
2210