Skip to Content
Menú
This question has been flagged
2 Respostes
1265 Vistes

Hi,

I'm trying to import the values matching with each product. I successfully imported all my products as well as my attributes and corresponding values. 

The problem is that some of my values are a text string containing a comma. Therefore Odoo separates the value in different values and can't match it with the existing value.

How can I import my values, including the commas as part of the value? Without Odoo splitting it?

I.e. value = 'Vermentino, Grenache' and not 'Vermentino' 'Grenache' 

I tried using semi-columns, double quotations, single quotations, xls, csv, removing the thousand separator, but can't get around it

Let me know if it is clear

Thanks in advance!!

Avatar
Descartar

From which file type are you importing the data? (CSV or Excel)

Best Answer

Hi Jean-Marie,

I think this video can help you (starting at 30:00 in this video):

https://www.youtube.com/watch?v=Auaqj6WtdcM&list=PLSKcWRTtEl5qzvRaI-VTGavfReiHS_EEb&index=5

Avatar
Descartar

mmh this video does not help or i cannot see it! :-( Is no way to import product and its attribute easily using Excel files?

Hi Alexander Karg,
The above video has an illustration about importing many2many type in Odoo, the product attribute is also a many2many field type. If you want to watch a video directly about importing products, you can watch the following video:
https://www.youtube.com/watch?v=VyhwkhnwIck&list=PLSKcWRTtEl5qzvRaI-VTGavfReiHS_EEb&index=6

Autor Best Answer

Hey Josep,

I have all my data in excel. But I tried with CSV. nothing works.

Thanks for you help


Avatar
Descartar
Related Posts Respostes Vistes Activitat
1
de març 15
5318
3
de jul. 25
1974
1
d’abr. 25
1473
0
d’oct. 24
1228
2
de maig 24
4040