Importing Bill of Materials in Bulk error "Missing required value for the field 'Product' (product_tmpl_id)"

Question

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_L

Ankit Tiwari (anti) · Accepted Answer

I have tried importing the given file into the demo.odoo.com [1]  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 [2

Powiązane posty	Odpowiedzi	Widoki
Display extra fields inside BoM Overview web page mrp BoM v17	1 paź 24	2228
How to update component quantity in BOM (Ver15) Rozwiązane mrp bom bom_import bom_lines	4 kwi 22	3104
How to get the active_id from get_view function in odoo 17? v17	4 maj 25	2499
Caused by: Error: "res.config.settings"."stock_move_sms_validation" field is undefined. v17	2 maj 25	5858
Odoo 17 Bom can't import with Produit / ID externe mrp	1 kwi 25	1278

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!

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