How to import Product Variants if products are already in Odoo 14?

Question

Hello,
We imported our product data already. But we have not imported the variants yet. How can we update the existintg products but creating variants?
What I did:

I created  an  attribute :  "Attribute test: (I tried with  variant creation mode = Dynamically or Instant) with  2  values:  "Value 1" and "Value 2"
1/ Go to Export Variant > Export data (with internal ID, external ID, name)
2/ As the product does not have any variant, I created new lines in the  CSV /  Excel  file  with the followi

Balagopal R · Accepted Answer

Hello,
First, you can export the product you needed. So you will get the External ID of the product.
id
name
attribute_line_ids/attribute_id
attribute_line_ids/value_ids
__export__.product_template_41565_b5dbe71f
1 Application Body Fluid Clean-Up Spill Kit Refill 717
Type
S2,S3
Like the above table, "id" is the External Id of the product. "name" is the Product name
"attribute_line_ids/attribute_id" is the Variant Type.
"attribute_line_ids/value_ids" is the Variant Values. If you have multiple va

Related Posts	Replies	Zobrazenia
import products with attributes values Odoo Solved import attributes v14	2 okt 23	5070
Multiple Attributes in different columns but same row import variant attributes multiple_values	0 máj 16	5507
Remove Attribute (Variant List) variant attributes	1 nov 25	453
Import product with attributes from excel product import variant excel attributes	2 máj 24	6291
Many2many Fields import v14	1 júl 23	2860

This question has been flagged

Enjoying the discussion? Don't just read, join in!

id	name	attribute_line_ids/attribute_id	attribute_line_ids/value_ids
__export__.product_template_41565_b5dbe71f	1 Application Body Fluid Clean-Up Spill Kit Refill 717	Type	S2,S3