Error when downloading the “review-import-template.csv” file

Hi,

Thanks for using our plugin.

I would like to inform you that error came may be file is not download properly can you please try to download that file in different browser and different location of computer. Mostly that part file generated when any connection break at time of file download.

Please test again provide your feedback to us.

Thank you for your answer,

I indeed managed to download the file using an other browser…but now I’m getting errors when uploading it ! The utility seems to correctly find the amount of reviews I added to the csv file, so my guess is that there is something wrong with the syntax.
Also I checked and re-checked product IDs, I don’t see that as the problem.

Thanks for helping !

Can you please update the plugin to version 3.45? It adds a detailed log for import of reviews.

I updated the plugin and got the following error details when importing reviews :

Line 2 >> Error: review score = 0. Review scores must be between 1 and 5.
Line 3 >> Error: review score = 0. Review scores must be between 1 and 5.
Line 4 >> Error: review score = 0. Review scores must be between 1 and 5.

Here’s the line 2 of my file:
Jupe très agréable à porter. Tissu fluide. Taille conforme aux instructions. Se porte aussi bien au travail qu’en soirée.,5,”2018-08-30 19:20:00″,145,”élodie C.”,[email protected]

The review score is marked as 5, not 0.
The review content is in french, could the accents be the problem ?

Also I removed the example line of the template but I haven’t removed the first line, do I have to ?

Are you using MS Excel to save your CSV file? Can you please check content of the file using some simple text editor (e.g., Notepad on Windows)?

Also, please update the plugin to version 3.46. It has additional logic for errors with empty lines.

Ok it finaly worked using another text editor !

But the review content is not imported, which is not a terrible issue since I can add it by modifing the review once it’s imported.

Thanks a lot !

I tried importing the review string in French that you shared earlier and it worked for me. Although the string had accents, all fields (including review content) were successfully imported.

Can you please share the file that you tried to upload? You can send it to [email protected].

Here is an update about this issue for people who might have similar problems. The problem was with the file. The French accents weren’t saved correctly by the software where the file was created and were displayed as “gibberish” characters. This caused problems with the import.