Magento 2 Product Reviews Import Export by Meetanshi is an easy way to import and export reviews and its related data via CSV file.
Table of Content
- Extension Installation Guide
- Product Reviews Export Settings
- Sample CSV File
- Product Reviews Import Settings
- Product Reviews Import Export in Backend
- Product Reviews Import Export in Frontend
- Extract the zip folder and upload our extension to the root of your Magento 2 directory via FTP.
- Login to your SSH and run below commands step by step:
- php bin/magento setup:upgrade
- For Magento version 2.0.x to 2.1.x - php bin/magento setup:static-content:deploy
- For Magento version 2.2.x & above - php bin/magento setup:static-content:deploy –f
- php bin/magento cache:flush
- That’s it.
- Product Reviews Export Settings
For configuring the extension, log in to Magento 2, move to System > Product Reviews Import Export where you can find various settings to enable the import and export functionality for reviews.
- Select from Date: Select date from which you want to export the product reviews. Leave empty to export all the reviews.
- Select to Date: Select date till which you want to export the product reviews. Leave empty to export all the reviews.
- Export Customer Details with Reviews: Set YES to export customer details along with the product reviews.
Click “Export Reviews” to start exporting product reviews with selected settings.
- Sample CSV File
Once you export the product reviews, you can see all the review details in a CSV file. The sample CSV file is attached in the backend to check the format of reviews to be imported.
- Product Reviews Import Settings
Upload the review file in CSV format to import the product reviews. You can download the sample CSV file to have a look at the format of the review file.
- Product Reviews Import Export in Backend
Once you have imported the reviews, you can see them enlisted at Marketing > User Content > Reviews with customer details if added and review status.
Note: Even after the reviews import success message, if you can’t find reviews, make sure you have selected the store view for each rating type from Stores > Attributes > Rating.
- Product Reviews Import Export in Frontend
You can see all the approved reviews on the related product pages with review and customer details.