Skip to Content
This question has been flagged
importonlinevalidatecsvproducts
3 Replies
5135 Views
Avatar
Adam Moonen

Hi all,

After finally getting my csv file right to import my products, I run through the validation procedure and all is good - no errors.

I then hit import - it seems to do the same as the validate option (look and feel and time it takes), and after it appears to have finished, I click on products and nothing is there.

With the online version, there are around 52 required fields that I export to a csv file. I then add a few other fields that I require for my POS products. 

Any ideas on why this simple task would not be working?

Avatar
Discard
Baiju KS

Did you checked about active field,,?? check whether product goes to non-active area using advanced filters..........

Adam Moonen
Author

Hi, yes I have the Active field in the table and have each product set to TRUE in this field.

Avatar
Adam Moonen
Author Best Answer

Hi all,

as an update, I have now got this working.

When the validation appeared to be working, there was a small/thin pink bar that ran along the top, the same colour as when you get an error. I modified the csv file to only have a subset of the whole contents of the file (around 1000 rows). 

I did the validation on this and saw I had around 1000 errors!! So obviously the original file with several thousand rows was just generating too many errors (the same one error for every item) to show up, so I only got the thin bar at the top.

Once I fixed the sheet, I got a blue bar saying "Everything seems valid".

The online version of the software is still new I guess so there is not a great deal of documentation regarding errors etc. I am thinking I will write a doco for the import of products as I see it as it is a little different from the way Odoo recommend doing it and my experience has given me more insight.

Thanks all

Avatar
Discard
Related Posts Replies Views Activity
Cannot import valid CSV
import validate csv
Avatar
1
Jul 15
6105
Products import via Shell
import csv products shell
Avatar
0
Feb 23
2085
Import product varients from csv with price
import csv products varients
Avatar
0
Mar 16
3770
How to solve CSV import validate error (unsupported format character)?
error import validate csv
Avatar
Avatar
2
May 15
12209
URGENT!!!! Import products, compared by default_code URGENT!!!!
import csv products noob
Avatar
Avatar
1
Mar 15
4642