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

Publications associées	Réponses	Vues
import products with attributes values Odoo Résolu import attributes v14	2 oct. 23	5068
Multiple Attributes in different columns but same row import variant attributes multiple_values	0 mai 16	5496
Remove Attribute (Variant List) variant attributes	1 nov. 25	448
Import product with attributes from excel product import variant excel attributes	2 mai 24	6289
Many2many Fields import v14	1 juil. 23	2855

Cette question a été signalée

Vous appréciez la discussion ? Ne vous contentez pas de lire, rejoignez-nous !

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