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	Views
import products with attributes values Odoo Solved import attributes v14	2 Oct 23	2757
Multiple Attributes in different columns but same row import variant attributes multiple_values	0 May 16	3760
Import product with attributes from excel product import variant excel attributes	2 May 24	4772
Many2many Fields import v14	1 Jul 23	984
Import button is missing Solved import v14	1 Apr 23	6341

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