Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

How to create product variants via csv import in odoo8?

By
af
on 10/15/14, 3:27 PM 1,682 views

I have a list of attributes per product template.

What would be the structure of a csv file to create a product with variants. 

I just need the name, type, ean (per variant) and 1 attribute (color). I dont understand the structure of a product. When I export a template or a list of variants there is no field with attribute value per variant instead it is all values of a template in every row.

Hi, did you get feedback on this question? Thanks

William Beverly
on 2/4/15, 4:31 PM
1
af
On 2/5/15, 1:53 PM

You need more than 1 step.

First I imported the attributes with the corresponding values

This csv would import an attribute 'color' with 2 colors and there hex code. Name and type only in the first row.

name,value_ids/name,value_ids/color,type

color,red,#123456,Color

,blue,#123457,

Now you can create a product with variants

name,product_variant_ids/attribute_line_ids/attribute_id,product_variant_ids/attribute_line_ids/value_ids

"Tshirt","color","red,blue"

If you want to add for example an EAN to the variants you would have to export the variants now, add the EAN and reimport.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

Asked: 10/15/14, 3:27 PM
Seen: 1682 times
Last updated: 3/16/15, 8:10 AM