Hi,
If I understood correctly, you can update a product with its ID...
Suppose I import this product .csv :
External ID;name;purchase_ok;sale_ok;standard_price
A1_0001;test1;TRUE;FALSE;10
And then, I import another .csv to modify or add details to the same product
External ID;product_variant_ids/seller_ids/name;product_variant_ids/seller_ids/currency_id;standard_price
A1_0001;Gentec;CAN;20 |
Why does it create a 2nd variant for this product, and how can I avoid it?
Thanks
I'm using odoo 9, localhost db.
According to Ray Carnes (https://www.odoo.com/fr_FR/forum/help-1/question/what-is-an-external-id-and-what-is-its-uses-95070), importing an UPDATE with an External ID of an existing record should not create an INSERT (or in this case VARIANT?)... But it actually does, also reported by E.M. (https://www.odoo.com/fr_FR/forum/help-1/question/does-reimporting-same-external-id-a-product-create-a-variant-95243#). In my settings - products - product variants - no variants on products is checked.
Do not re-import the "NAME" column.
I have found that re-importing the "NAME" creates a product variant. It should not do this but poor programming means it does.
Make sure you set the "NAME" column to "do not import".
The External_ID column should be enough to carry out the update on your product.
It has taken me years to realise this simple fact as ODOO do not mention it anywhere!!