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.
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.
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:
Firebear Studio GitHub – here you can get CSV, XML, Json, XLSX, and ODS sample files with Magento 2 page hierarchy.
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.
Can only contain numerals.
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.
Nickname of the person leaving a review. Note that this is not a customer’s name and surname.
Can contain any symbols
Title of the review
Can contain any symbols
The review itself
Can contain any symbols
This is a great product indeed! Thank you for your service!
Status of the review
Available values (mind the case):
Approved– approved review
Pending – pending approval
Not Approved – declined
The date the review has been created
Native Magento 2 date and time format. For example:
The average customer vote for product quality. If enabled.
Can only contain numerals
The average customer vote for product value. If enabled.
Can only contain numerals
The average customer vote for product price. If enabled.
Can only contain numerals
The average customer vote for product rating
Can only contain numerals
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:
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:
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.
How to import and export product reviews to Magento 2 automatically?
If you need to move product reviews between Magento 2 websites or your e-commerce store and third-parties regularly, use the Improved Import & Export extension. The module utilizes a cron scheduler to automate data transfers. As a store admin, you get the ability to import and export product reviews between Magento 2 and external destinations automatically after specifying a schedule of updates.
How to import product reviews with third-party attributes to Magento 2?
If data you are going to import to your e-commerce website doesn’t follow the Magento 2 requirements, the system will interrupt the data transfer. It often happens when the imported table contains third-party attributes. However, you can still transfer data files that contain unsupported designations with the help of the Improved Import & Export extension since it lets you create a mapping scheme where you match third-party attributes and values to ones used within Magento 2. As a result, any external data, including product reviews, is easily adapted to the native platform standards. As for export processes, you can also apply mapping to them to generate the output your partners need.
How to import and export product reviews to Magento 2 via API?
With the Improved Import & Export Magento 2 module, you are empowered to build a seamless bridge between your store and any external systems. The extension provides the ability to create API connections for transferring product reviews as well as other entities. The corresponding section is available in the module’s import/export jobs. There, you can specify the parameters necessary to sync the two systems.
How to import and export product reviews to Magento 2 via ODS files?
The Improved Import & Export module supports numerous file formats, including ODS. It means that you can move product reviews in ODS files without converting them to CSV. You can also export data using this file format.
How to import and export product reviews to Magento 2 via XLSX files?
The Improved Import & Export module supports numerous file formats, including XLSX. It means that you can move product reviews in XLSX files without converting them to CSV. You can also export data using this file format.
How to import and export product reviews to Magento 2 via JSON files?
The Improved Import & Export module supports numerous file formats, including JSON. It means that you can move product reviews in JSON files without converting them to CSV. You can also export data using this file format.
How to import product reviews to Magento 2 via compressed files?
If your files with product reviews are compressed, you can use the Improved Import & Export extension to transfer them to Magento 2. Remember that your file archive should be ZIP or TAR. As for the files stored within, they should be CSV, XML, ODS, JSON, or XLSX.
How to import product reviews to Magento 2 from Google Sheets?
If product reviews are stored in Google Sheets, the Improved Import & Export extension lets you move them straight from the remote table to your e-commerce website. It is only necessary to specify the address of the corresponding Google Sheets page. You can also export product reviews from Magento 2 to Google Sheets.
How to import and export product reviews between Magento 2 and Dropbox?
The Improved Import & Export module lets you transfer product reviews between Magento 2 and Dropbox in CSV, JSON, XML, ODS, or XLSX files or ZIP and TAR archives.
How to import and export product reviews between Magento 2 and Google Drive?
In addition to Google Sheets and Dropbox, the Improved Import & Export extension provides the ability to import and export product reviews between Magento 2 and Google Drive. You also should use CSV, JSON, XML, ODS, or XLSX files and ZIP and TAR archives.