Importing Product File Error

Question

Odoo Community Version 11

Hi Odoo Community! I am attempting to import a product data set (in CSV and Excel formatting) and I am receiving an error in the name column it looks like. Our developers recommended us to 'Encode' the files as Unicode (UTF-8) (accessed through Save As>Tools>Web Options>Encoding) then saving the document as Unicode (UTF-8). This is the error I am receiving:

null value in column "name" violates not-null constraint DETAIL: Failing row contains (140215, null, null, 62825

Ashish Singh · Answer

Hi, Adam

Seems like "*name*" *column *is not present in your *CSV *or there is false value for "*name*" *column *due to this you are getting "*null column*" issue. So please check and update these values as "*name*" field is *required *for the *product*.
*In case you still have the same issue then please share your CSV in order to check this issue.*
Thanks, Ashish Singh (Team Lead) Webkul Software Private Limited

Adam Noll · Answer

Ashish Singh - I can share the file but unfortunately I don't have enough 'coins' if you will to do so. I need to gain Karma to comment or share anything with you. I can certainly email you directly the file in CVS format? My direct email below.
I can certainly try that Mustufa Rangwala but I have over 1,000 and I still find trouble exporting data and re-uploading the data set back in troubling.
anoll@mingleteam.com

Mustufa Rangwala · Answer

Hello,
It is not issue of Odoo 11 setup but format of your excel file.
You may try to first export from product and try to use same csv/excel to import - may be it can help.
Regards,
Mustufa Rangwala

Bài viết liên quan	Trả lời	Lượt xem
V17 .sh import excel file: time data '2025-01-31' does not match format '%m.%d.%Y' importing	3 thg 7 25	2002
Odoo journal entry modification after posting by import importing	1 thg 4 25	1498
Import mehrerer Artikel mit Varianten importing	0 thg 10 24	1234
Importing Excel/CSV using custom unique field instead of XML ID importing	2 thg 5 24	4058
Product export then import duplicates everything importing	0 thg 4 24	1354

Câu hỏi này đã bị gắn cờ

Thanks,

Ashish Singh (Team Lead)

Webkul Software Private Limited

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!