Hi everyone!
I know how to create BOMs by importing plain text excel/csv and it works great. Until one of the components exists with different variants.
Example: We have a product "Paint" with attribute values "red" and "blue", it is a component of any main product.
If in excel/csv I give "Paint (red)" as a component for the main product it will raise an error, same for "Paint (blue)". If I give "Paint" only, odoo will accept but always add the first variant to the BOM. So I'm not able to tell which variant should be taken. If I go with IDs, everything is fine (of course).
How can I solve this?
I tried in V10 and V12, same behaviour.
This is an example of a BOM we can import, but for the highlighted column I get an error:
No matching record found for name 'Paint (red)' in field 'BoM Lines' between rows 2 and 4
Get all possible values
product_tmpl_id |
product_qty |
product_uom_id |
routing_id |
bom_line_ids/routing_id |
bom_line_ids/attribute_value_ids |
bom_line_ids/product_id |
bom_line_ids/product_qty |
bom_line_ids/product_uom_id |
bom_line_ids/product_tmpl_id |
Main Product |
1 |
Unit(s) |
Manufacturing |
Manufacturing |
Color: red |
Paint (red) |
1 |
Unit(s) |
Paint |
Manufacturing |
Color: blue |
Paint (blue) |
1 |
Unit(s) |
Paint |
||||
Manufacturing |
False |
Bolt |
4 |
Unit(s) |
Bolt |