How to Import & Export Product Reviews in Magento 2

Although Magento gets new and new features providing its customers with multiple opportunities that have been previously available only via third-party extensions, the platform still lacks some vital data transfer functions. For instance, you cannot import and export product reviews to/from Magento 2. However, there is always a possible resolution in a huge ecosystem of modules. Below, we shed light on how to import and export product reviews in Magento 2 in the most user-friendly manner with the help of the Improved Import & Export Magento 2 extension. You will discover a sample import and export table for product reviews with all its attributes explained. After that, we will teach you how to automatically import product reviews to Magento 2 on a regular basis. The corresponding export processes are described too. These and other nuances are available below. But before going any further, let’s emphasize several aspects of our extension that take place in the Magento 2 product reviews import and export. 

‘

Improved Import of Magento 2 Product Reviews

Meet the Improved Import & Export Magento 2 extension – this module is designed to transfer customer reviews and all related information between your e-commerce store and other external systems. The data flow can be established in two directions. It means that you can either migrate from another e-commerce platform to Magento 2 or extend your business by transferring the existing data to new systems. Buy what exact features are under your disposal?

The Improved Import & Export Magento 2 extension is designed to streamline both import & export processes by letting you automate all data transfers. The first aspect of automation is support for all possible types of customer reviews and related information. With our module, you can freely transfer the following data:

• Review Title and Description. The two core parts of every review can be imported or exported without any headaches via the Improved Import & Export plugin.
• Review Status. A review can be approved or not, and this information is fully transferable which makes data migration much more admin-friendly: unapproved reviews will be moved to the admin section but won’t be available on the frontend until you enable them there.
• Review Summary. This aspect of every review is not a problem for Improved Import & Export as well.
• Review Ratings. If a rating system is implemented within your store and reviews are a part of it, you can freely transfer this data from one location to another using our Magento 2 extension.
• Multiple Review Types. The Improved Import & Export Magento 2 module provides the ability to migrate all types of reviews: product, customer, category, etc.

Now, when you know that our extension can easily import and export all possible reviews and related data to/from Magento 2, we can proceed to its multiple features that improve data transfers even more.

Get Improved Import & Export Magento 2 Extension

Product Reviews Magento 2 sample import and export table and attributes explained

The product reviews import and export files come with the following set of attributes that represent the reviews customers have left for the products sold at your Magento 2 store. You can get the sample files for import and export with every attribute value set from:

Attribute name	Reference	Values	Value example
review_id	ID of the URL review. Can be found under Marketing>All Reviews, in the ID column. Use this if you want to update a particular review.	Optional attribute. Can only contain numerals.	347
sku	SKU of the product the review is left for. Make sure to specify the SKU of the existing product(s).	Can be any value supported by the SKU field.	SKU001
nickname	Nickname of the person leaving a review. Note that this is not a customer’s name and surname.	Can contain any symbols	John Doe
title	Title of the review	Can contain any symbols	Great product
detail	The review itself	Can contain any symbols	This is a great product indeed! Thank you for your service!
status	Status of the review	Available values (mind the case): Approved – approved review Pending – pending approval Not Approved – declined	Approved
created_at	The date the review has been created	Native Magento 2 date and time format. For example: 2019-07-24 9:08:36	2019-07-24 9:08:36
vote:Quality	The average customer vote for product quality. If enabled.	Can only contain numerals	2
vote:Value	The average customer vote for product value. If enabled.	Can only contain numerals	3
vote:Price	The average customer vote for product price. If enabled.	Can only contain numerals	4
vote:Rating	The average customer vote for product rating	Can only contain numerals	5

NOTE: the only way to identify review is to use review_id attribute. Meaning that if you just want to import old review – you can leave this attribute and do not use it, Magento 2 will automatically assign ID to all the imported reviews. However, if you want to update a particular review(s), – you need to specify the ID(s) of the review(s) you want to update.

Import & Export Product Reviews Automatically

The Improved Import & Export Magento 2 extension lets you transfer reviews and corresponding data in a fully automated manner. The extension supports cron so that you can create any custom schedule of data import/export processes. For instance, product reviews are regularly posted on one of your web-stores, but you want to share them with others. Just create an update schedule using the standard cron syntax. At the same time, you can freely select one of the predefined intervals provided by the Improved Import & Export Magento 2 extension. Note that these intervals are fully customizable; consequently, you can tailor them according to your business needs.

If you product reviews migration is a one-time procedure, our module lets you create a new import or export process that doesn’t have a schedule. You will launch it manually whenever you want. At the same time, all scheduled updates support a manual run in an asynchronous mode. Thus, there is no need to create a new import/export profile if an update has been provided before schedule.

The following gif image illustrates how to configure a new schedule:

Import & Export Product Reviews in Multiple File Formats

Since Magento supports CSV only, you should convert files of other formats into it; otherwise, it won’t be possible to import data into the system. However, the Improved Import & Export Magento 2 extension dramatically enhances the default functionality of the platform. The module allows you to work not only with CSV files but also with data in XML, JSON, ODS, and Excel. For instance, Shopify creates an output with product information in JSON. By default, you cannot import it into Magento – it is necessary to convert the format to CSV. Luckily, there is Improved Import & Export that extends the boundaries. It means that you can import and export product reviews as CSV, XML, JSON, ODS, and Excel files.

Another important aspect we’d like to draw your attention to is the ability to use multiple file sources to import data files with product reviews. The Improved Import & Export Magento 2 extension allows you to leverage a local or remote server for both import & export processes due to the FTP/SFTP support. At the same time, you can use a Dropbox account to move product reviews to/from your e-commerce website. When it comes to import processes, our extension even enables you to run direct URL uploads. Just provide a file address, and the plugin will import it into the system. Even compressed data is no longer a problem since the Improved Import & Export Magento 2 extension will unpack it automatically.

Import & Export Product Reviews Without Data Files

In addition to the standard process of data files import/export, our extension provides several alternative ways of transferring the necessary information. First of all, you can leverage Google Sheets to import data into your e-commerce store. The process is illustrated below:

Besides, the Improved Import & Export Magento 2 extension lets you create SOAP API, REST API, and GraphQL API integrations. All three connection types are used for establishing various complex connections and transferring more complex data than product reviews, but no one forbids you to import & export them avoiding the use of data files.

Import Product Reviews Without Data Files Editing

Another stunning feature of the Improved Import & Export Magento 2 extension is represented by the ability to avoid manual data files editing. Since different systems implement different standards to the way information is stored in their databases, you cannot take the external output and move it to Magento 2 without making third-party attributes suitable for ones used inside your e-commerce store.

Thus, it is always necessary to review a data file and edit it replacing external attributes with the default ones. The more information they include, the more work should be done. Luckily, the Improved Import & Export Magento 2 extension enables you to import product reviews without advance editing. The module provides the ability to apply mapping presets that match all external attributes to ones used internally. Below, you can see how to apply a preset for a seamless data migration from Magento 1 to Magento 2:

In case a preset is not available for your particular information (contact our support regarding your specific business case), you can do the same procedure manually. The process is still much more comfortable than manual data files editing and looks as follows:

You select a third-part attribute and match it to the corresponding one used in Magento. Besides, you can add a hardcoded value that will be specified to all items in the corresponding column. For instance, it is possible to add the same rating to all reviews by using the third column from the interface shown above.

Advanced Mapping Features

Since we are talking mapping introduced in the Improved Import & Export Magento 2 extension, it is necessary to say a few more words describing other opportunities introduced in the module. In addition to attributes, you can freely match their values or even edit them in bulk. Let’s take a look at each feature separately.

The ability to match attribute values is based on the same principle as we’ve just mentioned above. You just take an external value and match it to the one used internally. It is possible to map multiple external values to a single one. As for presets, they are not available, since attribute values may be unique in the case of each business. For further information, check this post: Attribute Values Mapping.

As for attribute values editing, the Improved Import & Export Magento 2 extension enables you to add a prefix or suffix to multiple values in bulk. Besides, you can merge or split the data if necessary. Our module lets you create various conditions to apply changes in the most precise manner. For further information, check this post: How to Modify Attribute Values During Import and Export in Magento 2.

And don’t forget that the Improved Import & Export Magento 2 extension enables category mapping. If imported data includes product categories that are not suitable for yours, you can freely match everything or even create new categories to assign imported products to. For further information, check this post: Category Mapping.

And due to the ability to create attributes on the fly, you will forever forget about headaches caused by the missing data. Specify the necessary parameters and the extension will add attributes automatically. For further information, check this post: Product attributes import.

To get a better understanding of the extension features, watch the following video:

[embedded content]

Final Words

The Improved Import & Export Magento 2 extension provides an intuitive way to import and export product reviews in Magento 2. You can freely transfer all related information between your store and external systems using multiple file formats in a fully automated manner. If you have any questions, please, follow the link below and contact our support:

Get Improved Import & Export Magento 2 Extension

Magento 2 Product Reviews Import & Export FAQ

Let’s take a look at other nuances of importing and exporting product reviews in Magento 2 with the help of the Improved Import & Export Magento 2 extension.

‘