Skip to Content
This question has been flagged
importv15
1 Respondre
4134 Vistes
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
Descartar
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
Descartar
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 Respostes Vistes Activitat
Import product variant's média
import variant v15
Avatar
Avatar
Avatar
Avatar
Avatar
6
d’ag. 24
5700
Import data from Odoo 13 EE to Odoo 15 CE Solved
import database v15
Avatar
Avatar
Avatar
2
d’oct. 23
2741
Import Time Off use employee barcode for Employee instead of employee name
import timeoff v15
Avatar
Avatar
1
d’oct. 23
2875
[Odoo 15] Import BOM from scratch (no variant) Solved
import bom v15
Avatar
Avatar
1
d’ag. 22
3366
Prevent navigation if records are not save
v15
Avatar
Avatar
Avatar
2
d’oct. 25
3142