Skip to Content
Menu
This question has been flagged
1 Reply
3782 Views

Dear Odoo Community,

Is there a way to import new product templates with variants via CSV?

I have experimented and can import additional attribute values to an existing product template if the template already has an attribute values present, but if I make up new values for the columns...

attribute_line_ids/id
attribute_line_ids/product_template_value_ids/id

...it is rejected with error...


Missing required value for the field 'attribute_id'

How does create those values via CSV import method?

Or does this require code or a custom module / app?


Regards,

Anthony

Avatar
Discard
Author

Ok, thanks to this hint...
https://www.odoo.com/forum/help-1/how-to-create-product-variants-via-csv-import-in-odoo8-65614

I have got it working using these columns and adding addtional rows for the last two columns where the product has additional variant rows and subsequent values comma seperated.

id
sequence
default_code
responsible_id
list_price
standard_price
name
product_variant_ids/attribute_line_ids/attribute_id
product_variant_ids/attribute_line_ids/value_ids

However I do get warnings...

Found multiple matches for field 'Products' (2 matches) at 4 different rows:
Between rows 2 and 3
Between rows 2 and 3
Between rows 2 and 3
Between rows 2 and 3
Found multiple matches for field 'Products' (3 matches) at 2 different rows:
Between rows 2 and 3
Between rows 2 and 3

...but it does appear to be working.

Regards,
Anthony

Best Answer

Hi Anthony,

I think this video can help you: https://www.youtube.com/watch?v=VyhwkhnwIck&list=PLSKcWRTtEl5qzvRaI-VTGavfReiHS_EEb&index=6

Avatar
Discard
Related Posts Replies Views Activity
2
Dec 24
4938
1
Feb 22
2064
0
Jul 22
1222
0
May 22
1511
1
May 24
2192