Skip to Content
This question has been flagged
importv15
1 Odpoveď
5444 Zobrazenia
Avatar
Eauzon

I want to change a lot of Internal reference codes of my Product Variants.

But i am getting this error: (Also on runbot with demo data)


To reproduce:

Go to Inventory/Product Variants

Select all, action/export, check' i want to update data'

Keep defaults.

Edit a few fields like the internal reference of a few products in the xlsx file

Upload the file again via Favorites/ Import records /Upload the xslx and then Test.



What am I doing wrong ?




Avatar
Zrušiť
Avatar
Waleed Ali Mohsen
Best Answer

You need to remove the attribute name with colon symbol so the "Legs: Custom,Color: White" will be "Custom,White" and you will be able to do the import. 

Also you can remove fields you don't need to change from template and keep only the fields you need to change with External ID.  

Avatar
Zrušiť
Eauzon
Autor

So this is a bug ? I checked the box that i want to use it for updating ?

Waleed Ali Mohsen

It's not a bug, You need to remove attribute name with colon symbol. So "Legs: Custom,Color: White" Should be Custom,White

Waleed Ali Mohsen

Since you want to update the internal reference so you can remove the product_template_variant_value_ids from excel or during upload click on x beside variant values

Eauzon
Autor

I understand ... but that sounds like a workaround to me.

It really feels like a bug.

If i export a file in a format for re-importing (By checking that box, so the id's get added). And without changing ANYTHING, i cannot re-import it without removing the prefix before the ':' , then that for me is not the intended behavior.

Related Posts Replies Zobrazenia Aktivita
Import product variant's média
import variant v15
Avatar
Avatar
Avatar
Avatar
Avatar
6
aug 24
7041
Import data from Odoo 13 EE to Odoo 15 CE Solved
import database v15
Avatar
Avatar
Avatar
2
okt 23
3975
Import Time Off use employee barcode for Employee instead of employee name
import timeoff v15
Avatar
Avatar
1
okt 23
3818
[Odoo 15] Import BOM from scratch (no variant) Solved
import bom v15
Avatar
Avatar
1
aug 22
4587
BUT your request violates my safety rules, because:
v15
Avatar
0
mar 26
16