2 min Customer reviews are the fuel behind eCommerce success. They improve SEO, build trust, and drive conversions.
But if you’re managing a PrestaShop store, manually handling reviews can be tedious, especially when migrating products, launching new campaigns, or syncing with platforms like Amazon or AliExpress.
This guide shows you how to import and export reviews in PrestaShop in just minutes, using both manual and automated methods, including a streamlined method via WiserReview.
The fastest way: Using PrestaShop review modules
WiserReview is a tool that helps you collect, manage, and show reviews on your PrestaShop store.
You can upload reviews in bulk, organize them by tag, and display them using widgets such as carousels and pop-ups.
Firstly, installthe WiserReview PrestaShop module on your PrestaShop store.
Click to download the WiserReview module for PrestaShop:- Latest WiserReview PrestaShop module
Configuration Guide:- WiserReview + PrestaShop Integration Guide
All your reviews in one place
Collect reviews, manage every response, and display them where they matter most.
Steps to import reviews using WiserReview
1. Open your PrestaShop admin panel.
2. Click on WiserReview in the menu.
3. Go to the Manage Reviews section.
4. Click the “Import Reviews” button.
5. Upload your file (CSV or Excel).
6. Make sure the file includes:
- Product ID or Product Handle
- Reviewer Name
- Review Text
- Rating (1–5)
- Date (optional)
- Tags (optional)
7. Match the columns correctly.
8. Click Import.
Exporting reviews manually (Native product comments module)
PrestaShop has a built-in tool called Product Comments. This tool lets you collect and show product reviews.
But it does not have buttons to upload or download reviews in the admin panel. To export reviews, you need to go into your website’s database.
How to export reviews step-by-step
1. Log in to your hosting account.
2. Open phpMyAdmin (a database tool).
3. Select your PrestaShop database.
4. Find the table named ps_product_comment.
5. Click Export.
Choose CSV format and download the file.
This file will include all your reviews.
Common errors and how to fix them
Sometimes, reviews don’t upload correctly. Here are some common problems and how you can fix them.
1. Incorrect product IDs
When the product ID in your file is not correct, the review won’t show up in your store.
Make sure you use the correct product ID from your PrestaShop product list.
Do not use product names. You can find the ID in the product settings.
2. Non-UTF-8 Files
If your reviews contain strange characters or missing letters, the file was likely not saved in the correct format.
You should save the file as UTF-8 CSV.
- In Excel: Click “Save As” and choose “CSV UTF-8.”
- In Google Sheets: Click “File” → “Download” → “CSV (UTF-8)”
This will keep all letters and symbols correct.
3. Missing required fields
Some reviews won’t upload if essential details are missing.
Make sure each review in your file has these:
- Product ID
- Reviewer’s Name
- Rating (1 to 5)
- Review Text
If even one is missing, that review may not upload.
4. Wrong delimiter settings
CSV files use commas or semicolons to separate the data. If your file uses the wrong one, the upload might not work.
Check that your file uses commas ( , ) or semicolons ( ; ) and that it stays the same throughout the file.
WiserReview lets you select the correct separator during upload, making it easier to fix.
All your reviews in one place
Collect reviews, manage every response, and display them where they matter most.Conclusion
Importing and exporting reviews in PrestaShop doesn’t have to be hard. You can do it manually in your database, or save time with WiserReview.
With WiserReview, you can upload many reviews at once, tag them, filter out destructive content, and show them beautifully on your site using ready-made widgets.
This helps you build trust, improve sales, and make your store look more professional.
Start with what works best for your store. And if you want things to be faster and easier, give WiserReview a try. It’s simple to use, and there’s even a free plan to get started.
