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	Răspunsuri	Vizualizări
import products with attributes values Odoo Rezolvat import attributes v14	2 oct. 23	4254
Multiple Attributes in different columns but same row import variant attributes multiple_values	0 mai 16	4921
Import product with attributes from excel product import variant excel attributes	2 mai 24	5728
Many2many Fields import v14	1 iul. 23	2298
Import button is missing Rezolvat import v14	1 apr. 23	7641

Această întrebare a fost marcată

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