Se rendre au contenu
Cette question a été signalée
importv15
1 Répondre
2825 Vues
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
Ignorer
Avatar
Waleed Ali Mohsen
Meilleure réponse

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
Ignorer
Eauzon
Auteur

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
Auteur

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.

Publications associées Réponses Vues Activité
Import product variant's média
import variant v15
Avatar
Avatar
Avatar
Avatar
Avatar
6
août 24
4008
Import data from Odoo 13 EE to Odoo 15 CE Résolu
import database v15
Avatar
Avatar
Avatar
2
oct. 23
1595
Import Time Off use employee barcode for Employee instead of employee name
import timeoff v15
Avatar
Avatar
1
oct. 23
1820
[Odoo 15] Import BOM from scratch (no variant) Résolu
import bom v15
Avatar
Avatar
1
août 22
2205
Import from Winbooks Résolu
import
Avatar
Avatar
Avatar
Avatar
Avatar
4
mai 25
3415