Skip to Content
Menu
This question has been flagged
2 Replies
3248 Views

I would like to create dymanic product variants by bulk, is there is a possibility to import an excel sheet with dynamic variants?

Avatar
Discard
Author

Thank you for the reply Alouna. There is no way to easily add attributes to products dynamically besides Products > Attributes & Variants > Add attributes? We have a lot of products that need dynamic variants and it would be helpful to add them in batch on a spreadsheet.

Hi
do you mean by word "dynamically" -> create product with variant by importing them and create only one product template -> then when creating purchase / sale order it will create product variant?
OR you mean "dynamically" -> create product with variant by importing them and create only multiple variant for one /multiple product template ?

Author

Exactely this one:
"do you mean by word "dynamically" -> create product with variant by importing them and create only one product template -> then when creating purchase / sale order it will create product variant?"

I edited my ansewr you could check it!

Author Best Answer

I did use the suggested method dozens of times the last days with no succes. To be sure I did test again with the values you suggest, but also with these fields I get the same error.




The attributes I created previous to trying the import:


The attributes of Product1 were added manually in Odoo itself, the attributes of Product2 are only on the import file.


/EDIT 

With the help of Alouna I found out a way to import.

First export using the next values:


Next I removed the rows that already had the correct attributes, copied the values of attribute_line_ids/attribute_id_id and attribute_line_ids/attribute_id/name into the row that needed the attributes, and added the attributes to attribute_line_ids/value_ids

Notice the change of notation in attribute_line_ids/value_ids between export and import!


/EDIT2

When you want to remove certain attributes from a product, on the relevant row clear the cell in columns attribute_line_ids/value_ids, attribute_line_ids/attribute_id/id and attribute_line_ids/attribute_id/name.


/EDIT3 

When multiple attributes have corresponding values (for example 3 attributes have the value 2m), the column attribute_line_ids/value_ids should be replaced by column attribute_line_ids/value_ids/id. This way the values are identified with their unique ID instead of a name.


Avatar
Discard

some tips to fix the issue:
1. try to add Product / ID value for first "Product1".
2. try to import without Product / ID column.
3. if it does not work try to except column by column while testing import in order to check which column causes the problem.

if Product1 attributes is already on the system, why do you want to update it? it will double values ! ->it will add (1m,2m,3m..... even if they already there!

Best Answer

Hello,


Product with dynamic creation variant will only created after purchasing/ selling that specific variant.

Edited:

you can import bulk of product with variants by simply separate Attribute values with comma 
Note: before starting to import -> create attributes with values or import them too.

use these excel template -> you can add more fields




hope this will help.

Avatar
Discard
Related Posts Replies Views Activity
1
Jan 24
4234
1
Jun 22
2237
0
Dec 21
94
6
Aug 24
3140
2
Mar 24
1075