Rating 0 stars - 0 votes

How to Import Reviews to WooCommerce

Do you want to import reviews to WooCommerce from Amazon, eBay, AliExpress, Etsy, or other sales channels? Below you'll find a guide on how to prepare the import file and upload the reviews to WooCommerce step by step.

Prepare a File to Import Reviews to WooCommere

Usually, you get reviews by exporting them to a file (if a platform provides such an option) or scraping them with a web scraper tool or service. Regardless of the way you get a file with reviews, you should check if it fits the structure of the WooCommerce database before you import it. So, to import reviews to WooCommerce, your file must include the following fields:

  • Product name or SKU.
  • Comment Date or Comment ID (*comment ID is used to update existing reviews via import).
  • Author name.
  • Author email (if available).
  • Comment itself.
  • Type - review or comment (the "Review" type presumes the display of rating stars along with the comment).
  • Rating (if available, enter as a number).
  • Status (if the status is not specified in the file, comments will be imported as approved).

As you've noticed, the list above has two entities: comments and reviews. That's because WooCommerce is a plugin for WordPress. Therefore, a comment is a WordPress entity and a review is a WooCommerce entity although basically, they mean the same thing. A type (comment or review) only impacts the display of rating stars. To show a rating, the type must be specified as "Review".

Here is a file sample to import reviews from Amazon to our test store. As you can see, the first product has three reviews. Therefore, they are listed in three separate rows:


Important: to import multiple comments/reviews to a product, the product name or SKU must be imputed in each row along with the comment details.

WooCommerce Review Import File
Prepare the Import File with Reviews

Import WooCommerce Reviews via the Store Manager Wizard

As WooCommorce doesn't have an option to import reviews, you have to use a third-party tool to accomplish the task. Such a tool is provided by Store Manager for WooCommerce.


Store Manager is a downloadable application that enhances the default functionality with tools for bulk edits, advanced import/export, database backup, data generation, and others.

If you don’t have Store Manager yet, download a free trial and install it on your computer. Connect the application to your store database and enjoy the simplicity of your store administration.


With Store Manager open, navigate to the Side Menu > Catalog > Comments. Press Import Data on the toolbar to launch the import wizard:


WooCommerce Reviews Import
Press "Import Data" to Upload Reviews

The import wizard will open. Follow the steps to complete the import successfully.

  1. Specify the source of import and select the file. In our example, we’re importing reviews from Google Sheets:
  2. Read a tutorial on how to import data to WooCommerce from Google Sheets.


    WooCommerce Review Import Source Selection
    Select Import Source

  3. Select a sheet and preview data:

  4. WooCommerce Review Import Select Sheet
    Select Sheet to Import Data From

  5. Link database fields to the fields from the source file.
  6. In this step, you’ll specify the Identification Field that you use in your file to identify comments. In our sample file, we use Date as an identifier, and therefore, we specify it in this step.

    Next, you should link fields from the file to the WooCommerce database fields. In the left pane, the first column shows a list of WooCommerce database fields. In the second column, you should specify corresponding columns from your import file. Preview your import file on the right pane to pick a matching column:


    WooCommerce Import Reviews Field Links
    Link Database Fields to The Columns in the Import File

  7. Import options. Firstly, choose one of the four import methods:
    • Add and Modify - if the import file contains new and existing comments/reviews, new ones will be imported and existing ones will be updated.
    • Add only - if the import file contains new and existing comments/reviews, new ones will be imported and existing ones will be skipped.
    • Modify only - existing comments/reviews will be updated and new ones will be skipped.
    • Just add - all comments/reviews from the file will be added as new without checking for the existing comments.

    Next, expand Advanced options and select a Product Identification field. In our file, products are identified by their name, so we select this field in the drop-down. When you are done with the setting, press Import.


    WooCommerce Review Import Options
    Specify Options for Reviews Import

The reviews have been imported and now are visible in the Comments section.


WooCommerce Reviews Imported
Check Imported Reviews

Let’s now go to the product and check the reviews on the product page at the storefront:


WooCommerce Reviews Imported Storefront
WooCommerce Reviews Imported

Summing up

Using the Store Manager import tool, you can import reviews to WooCommerce from any external platform. For the successful import, remember to do the following:

  • Include in the import file an identification field like product name or SKU
  • To import rating stars, specify "Review" as a type.
  • To import several reviews for a product, repeat a line with the product for every review.
  • In the import wizard, map the WooCommerce fields to the columns from your file correctly.

If you have any questions or are still hesitant if your file with reviews is configured correctly, write us in the comments below and we'll try to help you!

Import Reviews to WooCommerce with Store Manager!

Try now FREE

Related Articles:
Card image
How to Add WooCommerce Reviews

Learn how to enable the WooCommerce review form, add reviews from the backend, manage reviews via import/export.Read More...

Card image
How to Integrate Etsy to WooCommerce

Connect your Etsy store to your WooCommerce store by importing products and reviews and generating image meta. Read More...

Card image
WooCommerce Custom Fields

Generate WooCommerce custom fields with no coding skills in the Edit Product window and without switching between numerous windows or grids. Read More...

Card image
How to Upload Images to WooCommerce From URLs

Store Manager for WooCommerce allows uploading images to Woocommerce using links to the external location via flexible built-in Export/Import Wizard. Read More...

COMMENTS
Be the first to comment.