Lifetime licenses are only available for a short time!

Now is your last chance to buy a lifetime license before we switch to annual pricing. Existing lifetime licenses will be unaffected so get in while you can!
  • 90-Day Money-Back Guarantee
  • Fast World Class Support
  • Unlimited Sites
  • Free Lifetime Updates
  • Easy to Use
  • Developer Friendly
Risk free! Cancel at any time with our 90-day guarantee
Get a lifetime license now for only 
$99
"All Import/Export is an awesome suite of tools. It gets me out of some tough challenges."
Eric Karkovack, Freelance Writer
"WP All Import - Versatile, and I have saved so much time with it over the years."
Matt Andrews, Full Stack Web Developer
"@WPAllImport just let me import 3000 products from some arbitrary Excel to WooCommerce w/ a few clicks, including images and categories."
Joris Witteman, Developer / Designer

Wait, Don’t Miss Your Chance for a Lifetime License!

@glitzformals
"This plugin is a game changer for my situation. I’m stunned at how fast and effortless the import process is."
@adatfalo
"I have never experienced such a quick and helpful support experience with any plugin, and by the way, the knowledge of the support colleagues is professional!"
@jessedw44
"Even if you just use this plugin once, it will save you time. If you work on several sites its invaluable. Constantly developed, and continuously supported. Great job."

90-Day Guarantee

Not 100% happy? Let us know and we’ll promptly send you a refund.

Free Updates For Life

Pay once for unlimited installs, even client sites. No renewal fees.

World Class Support

Over 9 years experience with WordPress imports and exports.

Your Last Chance for a Lifetime License!

We are soon moving to yearly licenses only. Once lifetime licenses are gone, they're gone forever.
@adatfalo
"I have never experienced such a quick and helpful support experience with any plugin, and by the way, the knowledge of the support colleagues is professional!"
@jessedw44
"Even if you just use this plugin once, it will save you time. If you work on several sites its invaluable. Constantly developed, and continuously supported. Great job."

90-Day Guarantee

Not 100% happy? Let us know and we’ll promptly send you a refund.

Free Updates For Life

Pay once for unlimited installs, even client sites. No renewal fees.

World Class Support

Over 9 years experience with WordPress imports and exports.
Now is your last chance to buy a lifetime license before we switch to annual pricing. Existing licenses will be unaffected.
Read More

How to Import Reviews to WooCommerce

To import WooCommerce reviews, navigate to All Import › New Import, choose your import file, and select WooCommerce Reviews from the dropdown list. Map the incoming data elements to the appropriate data fields, then run the import.

Step 1: Create a New WooCommerce Reviews Import

Navigate to All Import › New Import, load the import file, and select WooCommerce Reviews from the dropdown list.

Import Reviews to WooCommerce New Import

Click Continue to Step 2.

Step 2: Check the WooCommerce Reviews Import File

The Review Import File screen lets you check the WooCommerce reviews data that you are about to import. If the data is not correct, fix the import file and try again.

Import Reviews to WooCommerce Review File

Near the bottom of this page, there's a section to Add Filtering Options, where you can selectively choose which reviews to import.

After verifying your import file, click Continue to Step 3.

Step 3: Map Incoming Data to WooCommerce Review Fields

You'll now see the Drag & Drop interface, which lets you map the data elements from your import file to the WooCommerce reviews target fields. To do this, just drag the data elements from the right to the target fields on the left.

Review Content

You'll first need to map the review content, the rating, the product it's linked to, and the review date.

Import Reviews to WooCommerce Review Content

Below, you'll see the Advanced Options section, where you can handle Approval Status, Verified Status, Karma, and Parent Review.

Import Reviews to WooCommerce Content Advanced Options

Review Author

Here, you can map Author Name and Author Email. You can add additional author information under Advanced Options:

Import Reviews to WooCommerce Review Author

Review Meta

You can import review metadata (i.e., custom fields) using this section:

Import Reviews to WooCommerce Meta

After mapping all the review import elements, click the Continue to Step 4 button at the bottom (not shown).

Step 4: Configure Settings to Import WooCommerce Reviews

The Import Settings interface appears next. This allows you to configure key import settings.

First, click on Auto-detect to generate a unique identifier. This identifier is used internally by WP All Import to keep track of your imported reviews.

Import Reviews to WooCommerce Import Settings

You can also modify the behavior that occurs whenever the import runs again, i.e., if it should create new records, remove existing ones, or update existing ones.

Below this, there are two other panels: Scheduling Options and Configure Advanced Settings, which you can leave alone for now.

Click Continue at the bottom to move on to the next step.

Step 5: Run the Import and Check Imported Reviews

Next up is the Confirm & Run interface, where you can review the import with a summary:

Import Reviews to WooCommerce Confirm and Run

As long as everything looks correct, click on Confirm & Run Import to execute the import. This is the screen you'll see once the import is done:

Import Reviews to WooCommerce Import Complete

Make sure to check the reviews using the WooCommerce interface to ensure that the import worked as expected.

Import WooCommerce Reviews – Advanced Topics

Review Skipped Due to Product Match Not Found

If a review is skipped because no product match is found, you'll see a message like the following in the history logs:

[15:59:10] SKIPPED: Review product not found by id `ROSÉ FAVORI 2020 - FAVORI - IGP MEDITERANEE`

To solve this, you need to first verify that there is a valid and existing product available to match with your newly imported review. If the product exists but the match still wasn't successful, you may have to change how you're matching to products.

Match Reviews Using Product SKUs

Even though there aren't options to match using the product's SKU, you can still use the SKU to pair reviews with products. You can do this by using custom code and an internal WooCommerce function that retrieves the product ID by using the SKU. See:

[wc_get_product_id_by_sku({yourSku[1]})]

Here's that code in action:

Import Reviews to WooCommerce Match with SKU

Selectively Choose Which Reviews to Import

You can define which reviews should be included in the import by adding a filter. Filters are added when setting up the import process in Step 2 by clicking on Add Filtering Options. In that section, you need to specify an element, a rule, and a value.

Import Reviews to WooCommerce Filter

In the example above, we are creating a rule that says, "Only import reviews with a product identifier of 40."

To modify the filter for an existing import, simulate a new import process and use the XPath generated there to replace the one specified in the import settings. But first, make sure to back up the XPath that already exists in case you need to go back to it.

We explain a bit more about filtering here: Filtering with XPath.

Import WooCommerce Reviews – Frequently Asked Questions

How Do I Export Reviews in WooCommerce?

  1. Create a new export in All ExportNew Export.
  2. Use the Add Filtering Options to choose which reviews to export.
  3. Click on Customize Export File and include the desired export columns.
  4. Run the export and download the exported WooCommerce reviews.

You can create this export in any of our available formats to export (CSV, XML, or Excel). Read the full documentation at How To Export WooCommerce Reviews.

How Do I Add Product Reviews Manually?

  1. Navigate to the target product in your WordPress site via Products › All Products.
  2. Locate the Reviews section and use the Add button to input new reviews.
  3. Once added, the reviews will appear in this same section.

That's how you add WooCommerce reviews using the WordPress dashboard. If you have many reviews to add, it might be better to import them.

How Do I Migrate WooCommerce Reviews?

  1. In the source site, go to All Export › New Export.
  2. Choose WooCommerce Reviews from the dropdown list.
  3. Use the Migrate Reviews button and download the exported bundle file. The bundle file includes an import template in addition to the export data.
  4. In the destination site, go to All Import › New Import.
  5. Upload the bundle file and click Skip to Step 4.
  6. Everything will be set up for you thanks to the import template, so simply continue and run the import.

With our plugins, migrating WooCommerce reviews from one site to another is a simple task that requires only a couple of clicks. This process can also be used to bulk edit reviews.

Related Docs

Learn how to import WooCommerce products into your WordPress site.

Shows you how to import WooCommerce customers to your site.

Provides instructions on exporting WooCommerce reviews from WordPress.

Related Videos

Lifetime support. Lifetime updates. Pay once.

Packages
Standalone
Import
Pro Package
$249
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Pro Package
$299
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
WooCommerce Import Package
$149
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import Standalone
$99
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Standalone
$169
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Export Standalone
$99
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
cross