How to Import & Export Product Reviews in Magento 2?

How to Import & Export Product Reviews in Magento 2?
To understand the enormous importance of product reviews, let’s look at a few statistics.
  • About 92% of prospective customers read reviews before making a purchase.
  • 92% of B2B buyers are more likely to purchase after reading a trusted review.
  • When a product gets 5 reviews, the likelihood of it being purchased increases by 270%.

Reviews are valuable assets of any ecommerce store which take months and years to build. They increase customer’s trust over a product and help increase its sales. Almost all ecommerce store owners have reported a substantial increase in a product’s sales after getting positive reviews. This is obvious because when a prospective customer reads good about a product from those who have actually used it, their purchase decision becomes easier.

Magento 2, although replete with powerful and out of the box features, still lacks in some areas. One of them is the absence of the functionality to import and export product reviews into the store. This is an essential feature that online merchants need in case they decide to revamp or migrate their store. They simply can’t afford to lose their hard-earned product reviews.

Thanks to Magento’s powerful echo system and strong community, there are alternatives to every problem that not only cover the default limitations but also solve it more vigorously. Our Magento 2 Import/Export Product Reviews Extension has been designed to cater to the default limitation of importing and exporting customer reviews.

The extension makes it extremely easy to import and export Magento 2 product reviews in bulk via a CSV file. You can also choose to export customer details with reviews. With the module, you can import the following data.
  • Review Title and Description: The extension exports and imports the two core components of a review i.e. the review title and description. Thousands of reviews can be imported with all the content within a jiffy.
  • Review Status: A review can be approved or pending. The extension allows you to choose whether you want to export all the reviews or the pending reviews only. The pending reviews will be moved to the admin section but won’t be displayed on the frontend until approved by the admin.
  • Review Ratings: If you have allowed customers on your store to give you ratings along with reviews, the extension easily transfers this data too.
  • Review Date & Time: There is nothing associated with a review that you can’t export or import with this extension. It exports the date and time of every review without you even having to do anything.
  • Product SKU: You most probably have hundreds or even thousands of products in your Magento 2 store. In such a case, you would also want to know which review has been posted for which product. The extension caters to this and exports the product SKU against all product reviews.
  • Customer Type: Whether the review was posted by a guest user or a logged in user. This shows you the user name and tells you whether the customer was a new or a regular one.
  • Now that you know that the extension can easily export and import reviews with all possible data, it’s time to see how to do this using the extension.

How to Export Magento 2 Product Reviews?

After installing the extension, click on System -> Export Product Reviews. Configure the self explanatory fields.
  • Entity Type: By default, it’s set to Product Reviews.
  • File Format: By default, it’s set to CSV - Comma Separated Values
  • From Date & To Date: If you want to export reviews submitted in a specific duration, select the date range. For example, From October 16, 2020 To October 31, 2021.
  • File Name: Give the CSV file to be exported a name.
export product reviews in magento 2
  • Export Customer Details with Reviews: Choose whether or not you want to export customer details with reviews.
  • Export Only Pending Reviews: Choose whether you want to export pending reviews only or both approved and pending reviews. Choosing ‘No’ will export all the reviews.
  • Click Export.
magento 2 product reviews export

How to Import Magento 2 Product Reviews?

After installing the extension, go to System > Import Product Reviews.
  • Entity Type: By default, it’s set to Product Reviews.
  • File Format: By default, it’s set to CSV - Comma Separated Values
  • Import Mode: Choose whether you want to merge or replace the existing product reviews with the imported ones.
magento 2 product reviews import
  • Show progress message: If you choose ‘Yes’, it will display an import progress bar and the number of reviews that have been successfully imported and the ones that have been rejected.
  • Error Message For Non-existing Review Id: If you select ‘No’, a new random Id is assigned by the system and then place it in the database. It ignores your assigned Id.
  • Attachment: Upload the CSV file that you had exported.
  • Click the Import Product Reviews button to import the reviews via CSV file.
import product reviews in magento 2

Sample Magento 2 Import and Export File

The file imported or exported using the extension has the following set of attributes that represent the reviews customers have left for the products sold at your Magento 2 store. product reviews import csv file sample If you've any issue regarding our extension, feel free to contact our support team for an instant solution.