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

관련 게시물	답글	화면
import products with attributes values Odoo 해결 완료 import attributes v14	2 10월 23	4304
Multiple Attributes in different columns but same row import variant attributes multiple_values	0 5월 16	4948
Import product with attributes from excel product import variant excel attributes	2 5월 24	5793
Many2many Fields import v14	1 7월 23	2320
Import button is missing 해결 완료 import v14	1 4월 23	7655

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!

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