This question has been flagged
3 Replies
5081 Views
productimportingattributes
Avatar
WMSSoft Pty Ltd Sales

We are using Odoo V14. And we've already created the Products with variants. All our products have Size as attribute and attribute values will be like size 5,6,7,8 etc. 


This season, we might only be selling size 5 and 6, next season I will need to add in size 7 and 8. Is there a way to export then import the product file back to add in more attribute values?


I already tried export an import-conpatible export format and then modify the file then import it back, but i am facing various error to update the attribute values.


But the error does not make any sense, as my sizes were set correctly.



My questions: 1st is it doable to import to update product attribute values? 2nd What exact fields I will need to export so that I can update the attribute vaules? And how should I put in the values?


Avatar
Discard
Ricardo Gross

I suggest these two videos to clarify the necessary fields and where to find it:

https://www.youtube.com/watch?v=wc_OqMtgGSM

https://www.youtube.com/watch?v=DxjC5W_rnmY

WMSSoft Pty Ltd Sales
Author

The video is only for importing to create new products with attirbutes. I have no problem importing to create new products with attributes, my problem is there is no way to export then import to update the existing product and adding more attribute values to it.

Ricardo Gross

On this forum you will find a good step-by-step: https://www.odoo.com/de_DE/forum/hilfe-1/how-to-import-products-with-variants-and-attribute-prices-185874

Avatar
Margo Lipping
Best Answer

Did you find a solution to the problem? I currently battling with the same need.

Avatar
Discard
Avatar
Online Marketing AG
Best Answer

Hi

I know the thread is already a little older.
I just managed to import the variants (including a custom external id).

You go to inventory > configuration > attributes

Import

Now, the file I uploaded has these 4 columns:

id -> matches external_id
prod_attr_spice

name -> matches attribute
spice

value_ids/id -> matches value/external_id
prod_attr_val_salt
prod_attr_val_pepper
 
value_ids/name -> matches value/value
salt
pepper


Hope, this helps anybody :)


Cheers

Jan

Avatar
Discard
Marc Bink

Hi, I have a similar problem when I use the same attribute value in different attributes. Creating these values is no problem but when importing articles with the attributes and values, the system generates errors as long as a "value" is used more than one time somewhere in the attributes. If I change the values to unique values the import errors are gone.
See also my question of today in the forum.
Regards
Marc

Avatar
Balagopal R
Best Answer

This is doable. See the following video.


https://www.youtube.com/watch?v=DjU8Hm_SdLo

Avatar
Discard
WMSSoft Pty Ltd Sales
Author

The video is only for importing to create new products with attirbutes. I have no problem importing to create new products with attributes, my problem is I want to update the existing product and adding more attribute values to it.