Magento 2 Product Reviews Import Export

 

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

  1. Extension Installation Guide
  2. Product Reviews Export Settings
  3. Sample CSV File
  4. Product Reviews Import Settings
  5. Product Reviews Import Export in Backend
  6. Product Reviews Import Export in Frontend

 

  1. Extension Installation
  • 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.

 

  1. 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.


 

  1. 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.


  

  1. 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.


  

  1. 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.

 

  1. Product Reviews Import Export in Frontend
    You can see all the approved reviews on the related product pages with review and customer details.