How to import my reviews from another review system?
You can import your product ratings and reviews from any review platform that allows a CSV format file export, such as "Verified Reviews" or "TrustPilot". So you keep your history of ratings and comments!
Import from the "Product Comments" module (versions 1.6 or ≥ 220.127.116.11 of PrestaShop)
This section only concerns e-merchants with a PrestaShop version 1.6 or a version higher than or equal to 18.104.22.168.
IMPORTANT NOTE: only reviews made by REAL PrestaShop customer accounts can be imported. Our module doesn't allow guest checkout account. Please check in the "ps_product_comment" table that the "id_guest" column is filled out with "0" and "null" values. If not, then the concerned reviews won't be imported.
To import your product reviews from the PrestaShop "Product Comments" module, follow the following procedure:
- First of all, make sure that the reviews you want to import have been approved in the PrestaShop module
- Deactivate the PrestaShop "Product Comments" module
- Activate our module and click on the "Configure" button
- A pop-up is automatically displayed offering you to import your reviews from the PrestaShop native module. You have the choice to import either moderated or unmoderated or both reviews. You also have define a default rating which will be associated with comments that don't have one.
- Click on "import" button
- Once the import is complete, the pop-up will update and show you the number of reviews that have been imported. Also, a list of reviews that have not been imported may appear with, for each of them, the reason why the import failed.
Import from a third system other than PrestaShop native module
The module allows you to import your old reviews from any review collection system, provided it allows the export of previously collected reviews into a CSV file.
Once you have retrieved your CSV file containing your old reviews, open it with OpenOffice Calc or Microsoft Excel.
With OpenOffice Calc:
- Right click on the CSV file -> Open with -> OpenOffice Calc
- Test the separators and select the one that allows to display columns in the preview.
- Select the correct character set (encoding) so that the text is correctly encoded in the preview and that there is not character breaks (don't hesitate to use the different scroll bars to check well all the preview). In general, OpenOffice Calc automatically detects the appropriate encoding but you may adapt it. Test all character sets until you find the one that matches.
- Then, click "OK"
With Microsoft Excel (2016 version but it's the same principle with the other versions):
- Open Microsoft Excel
- Click on "Data" and select the button related to the import from a text/CSV file
- Fetch your CSV file and import it
- In general, Excel detects the correct separator (delimiter) and the correct encoding (file origin), but if it's not the case, adapt the configuration: select the right separator (delimiter) so that the text is in separate columns and the correct encoding (file origin) for the text to appear correctly in the preview (the text shouldn't contain any character breaks). Don't hesitate to use the different scroll bars to check well all the preview.
- Load the file
Once your file is open, start by counting the number of columns your file contains, then go to the "Customer Ratings and Reviews Pro + Google Rich Snippets" module and click on the "Import your reviews" tab:
A new tab opens. Indicate the total number of columns of the CSV file and click on "Go matching":
A table is displayed with, in the first column, the information that the module needs to import your product reviews. In the second column you have to indicate which column of the CSV file matches with the required information. Finally, you can use the third column to give a default value to the required information if the file doesn't contain it (however, this is not always possible, since, for example, it's impossible to provide default values for your customers' comments...).
Make the matching as in the following example (the matched pieces of information have been circled in same color):
In this example, you see that the column number 3 contains product ID's, therefore you have to indicate into the module that the "product ID's" are in "Column #3", and so on. Since some pieces of information ("Language ID" and "Review title") aren't specified in the file, default values have been given ("English" for the language ID and "First 30 comment chars as title" for the review title).
Once you've finished the matching, click on the "Choose a file" button and fetch your CSV file. Be careful, the file must be in .csv format so you have to take either the original file that has been exported from your old review collection plateform (this is by the bye the solution we recommend), or, if you really want to take the one which has been opened with Excel or OpenOffice, check that you have well saved it in CSV fomat.
Select the separator used in the file (if you import the original file coming from the review plateform, the separator is the one that you had to indicate in the Open Ofiice Calc or Microsoft Excel software when you opened it).
Check the "Do not process the first line (headers)" case if the first line of your CSV file contains the column titles.
Check the "Is a Microsoft Excel CSV?" case if you took a file previously opened with the Microsoft Excel software.
Try to import your file firstly without selecting any input and output encoding (click on "Import").
If the list of your imported reviews appears, the import was successful. Some reviews may not have been imported for any reason and in this case, the reason will be displayed next to the related review.
If no review is displayed ans that the module shows you this message (with or without a red error message) :
This means that the module was not able to import.
- If a red error message is displayed, read the indicated reason, click "Reload", make the matching again by correcting the error and re-import your file.
- If no red message is displayed (only the previous blue background message is displayed), it's:
- that the chosen CSV file is empty
- that the matching wasn't done correctly and that the module doesn't read the expected values (either beacuse they are missing or because they are invalid)
- that the reviews don't matched with your customers or with your shop products
In this case, click "Reload" and re-import a valid file.
This also may be an encoding issue. In this case, note that the module allows you to select an input and an output encoding (charset). Click "Reload", re-do the previous steps and try to give encoding values in order to help the module to read your file text correctly. In general, input encoding will be the one found when you opened the file with OpenOffice or Excel (see above). Output encoding should normally always be UTF-8:
And click again on "Import".