How do I import variants for an existing product?

Question

How do I import variants for an existing product?
a variant must be created with the following information:
color, size, ean, cost, image, quantity
The colors, sizes already created in attributes. I know the main product's external id (its __import__.product001)
I need a csv example
Odoo 17 ce

Abhay Rathore · Accepted Answer

To import variants for an existing product in Odoo 17 CE, follow these steps:
Export the product with its attributes (color, size, etc.) from the product.template model. This will show you the correct format for one product.
Use the exported CSV as a template. Add your other products, including their external IDs (e.g., __import__.product001) and attribute values (color, size, EAN, cost, image, quantity).
Ensure attributes (colors, sizes) are already created in Odoo and include their external ID

Norbert Hdis · Answer

in Clothing every variants has different EAN code, Barcode, quantity, and also images!
in your examples only the Template products can have these attributes...

srikesh infotech · Answer

To import variants for an existing product in Odoo17, you'll need to create a CSV file with specific columns.
Based on your requirements and the attributes you've already set up.

Here's an example structure:
image [1]

[1] /web/image/68466057-781538be/image.png?access_token=3af53da1-cf79-4089-82ff-e61c63737171

Related Posts	Replies	Views
Import product variants to an existing parent product import csv variant size colors variants	0 May 25	466
Incorrect Variant Count after importing Newly added Size/color on odoo 17?? sales product variant size colors	1 Sep 24	1718
How to import product variant values in Odoo 14 Solved export import csv variants v14	2 Feb 21	6602
Is it possible to batch import New Products with their New Variants at the same time? Solved import variants	1 Jul 25	1335
Importing product variants from Odoo 12 to Odoo 18 import variants	3 Jul 25	2617

This question has been flagged

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