Lifetime Licenses Are Ending Soon, Get Yours Before They're Gone
 - 
Read More
Lifetime Licenses Are Ending Soon, Get Yours Before They're Gone
 - 
Read More
Pricing

You may have seen some references on our site to annual licensing or renewals.

All plugins currently come with a lifetime license, no matter what the site says.

We’re currently running tests before we make the switch to annual pricing. Check the Discounts tab to purchase our other plugins and get a lifetime license before they’re gone.

I Understand I Have a Lifetime License
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.

Table of Contents

Advanced Topics

Step 1: Create a New Import for WooCommerce Reviews

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: Review the 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 filters, Manage 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 Elements to the 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 the Import Settings

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 the 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 Manage 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, simply locate that import in the Manage Imports page, go to Edit Template, and modify the existing filters under Manage Filtering Options.

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

Import WooCommerce Reviews – Frequently Asked Questions

Where Are WooCommerce Reviews Stored?

WooCommerce reviews are stored in the wp_comments table along with other comments. Support for WooCommerce reviews is enabled via the WooCommerce Import Add-On. To import reviews, follow this guide.

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.
  3. Click the Add button to input new reviews.
  4. 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 Add Bulk Reviews in WooCommerce?

To add bulk reviews in WooCommerce, just follow this guide. Our plugin doesn't care whether you're importing one review or 100,000 — the process for handling them is exactly the same. The only difference with a very large import is that you might want to take advantage of our advanced settings to control batch processing sizes.

How Do I Export Reviews in WooCommerce?

  1. Create a new export in All ExportNew Export.
  2. Use the Manage Filtering Options to choose which reviews to export.
  3. Customize the export layout to include the desired columns.
  4. Run the export.
  5. Download the exported file.

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 Migrate WooCommerce Reviews?

  1. On 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, which includes import instructions.
  4. On the destination site, go to All Import › New Import.
  5. Upload the bundle file and click Skip to Step 4.
  6. 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.

What Add-Ons Do I Need to Import WooCommerce Reviews?

To import WooCommerce reviews, you need to have the WooCommerce Import Add-On active on your site, along with WP All Import.

Import WooCommerce 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.

Import WooCommerce Reviews – Related Videos

The best import export plugin for WordPress & WooCommerce.

Complete, granular control of your data with an easy to use drag & drop interface.
  • 90 Day Money Back Guarantee
  • Unlimited Installs
  • Lifetime Licence
  • Fast, World-Class Support
Get Started
90 Day Money Back Guarantee

Lifetime support. Lifetime updates. Pay once.

Packages
Standalone
Import
Pro Package
$299
one-time
  • Import Pro
Import Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
  • Export Pro
Export Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Pro Package
$399
one-time
  • Import Pro
Import Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
  • Export Pro
Export Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
WooCommerce Import Package
$199
one-time
  • Import Pro
Import Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
  • Export Pro
Export Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import Standalone
$99
one-time
  • Import Pro
Import Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
  • Export Pro
Export Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Standalone
$169
one-time
  • Import Pro
Import Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
  • Export Pro
Export Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Export Standalone
$99
one-time
  • Import Pro
Import Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
  • Export Pro
Export Add-Ons
  • Woo
  • ACF
  • Meta Box
  • JetEngine
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee

Lifetime support. Lifetime updates. Pay once.

Import
Pro Package
$199
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
Export
Pro Package
$199
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