Review import does not work

Thanks for trying our plugin!

As I can see on the screenshot that you shared, you merged all the columns in just a single column. This is why import doesn’t work. Please use the template provided with the plugin. Also, please don’t try to import “xls” or “xlxs” because the plugin supports only “csv” format.

I did not merge it… This is the sample review file I downloaded…Can you share with me the sample file here? I do not know why my sample file is wrong…

The template file can be downloaded from the “Import” page in the plugin’s menu. Please download it and compare with the file that you shared. You will see why I wrote that the columns are merged.

I downloaded the template and only changed the product ID and uploaded it back and the problem is still not solved. I got this error message:

Line 2 >> Error: incorrect file format. Only 1 column(s) found. Please open the input file in a text editor (e.g., in Notepad on Windows) and verify that columns are correctly separated by commas.
Line 3 >> Error: incorrect file format. Only 1 column(s) found. Please open the input file in a text editor (e.g., in Notepad on Windows) and verify that columns are correctly separated by commas.
Line 4 >> Error: incorrect file format. Only 1 column(s) found. Please open the input file in a text editor (e.g., in Notepad on Windows) and verify that columns are correctly separated by commas.

I did not do anything with the formating

Can you please share a screenshot of the file that you tried to upload?

Sure: https://ibb.co/gPx1yXt

Thanks for sharing the screenshot.

What error do you receive if you import this file without any modifications?

Without any modification I got the error that this product ID does not exist, when I change only the product ID I got this error message:

Line 2 >> Error: incorrect file format. Only 1 column(s) found. Please open the input file in a text editor (e.g., in Notepad on Windows) and verify that columns are correctly separated by commas.
Line 3 >> Error: incorrect file format. Only 1 column(s) found. Please open the input file in a text editor (e.g., in Notepad on Windows) and verify that columns are correctly separated by commas.
Line 4 >> Error: incorrect file format. Only 1 column(s) found. Please open the input file in a text editor (e.g., in Notepad on Windows) and verify that columns are correctly separated by commas.

Ok, thanks for providing additional information. Can you please open the file in the Notepad as the error message suggests and share a screenshot? I think that you might be saving the file in a wrong format (not CSV) when modifying it in MS Excel.

Sure: https://ibb.co/FXbcYv4

Thanks for sharing the screenshot.

As I can see from the screenshot, this is not a valid CSV format. Only the first row of the file is formatted correctly. In other rows, you have double quotes in wrong places. For example, the 2nd row:

"This product is great, 5,""2018-07-01 15:30:05"",10150,""Example Customer"",[email protected],"

In CSV format, columns must be separated by commas. However, you put commas inside double quotes instead. The correct CSV format of the 2nd row will look like this (please look at the commas):

"This product is great, 5","2018-07-01 15:30:05","10150","Example Customer","[email protected]",

I hope it helps!

We haven’t heard from you for more than two weeks. For this reason, I’ll assume that either you are not interested in this question/problem anymore or it has been resolved. If this is not the case, please let us know and we’ll be happy to help.