Risk Free, Backed By Our 90-Day Money Back Guarantee
 - 
Read More
Lifetime Licenses Are Ending Soon, Get Yours Before They're Gone
 - 
Read More
Risk Free, Backed By Our 90-Day Money Back Guarantee
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
200,000+ Active Installs
1500+ 5 Star Reviews
Pricing
Now is your last chance to buy a lifetime license before we switch to annual pricing. Existing licenses will be unaffected.
Read More
200,000+ Active Installs
1500+ 5 Star Reviews
Pricing

The Fastest Way to Import WooCommerce Reviews

Importing WooCommerce reviews allows store owners to preserve customer feedback when migrating stores, consolidating catalogs, or transferring reviews from another platform. A successful import must preserve the review content, ratings, and association with the correct products.

WooCommerce's built-in CSV importer handles product data but doesn't support product reviews. To import reviews in bulk, you need a dedicated import plugin.

In this guide, we'll show you how to import WooCommerce reviews using WP All Import.

What Makes Importing WooCommerce Reviews Complex?

Under the hood, WooCommerce stores product reviews inside the core WordPress wp_comments table with a custom comment_type set to review. Numerical star ratings and verification badges are stored separately inside wp_commentmeta.

Because review data relies on this split relational structure, basic import plugins introduce several database bottlenecks:

  • Review exports rarely contain the target WordPress post ID of your products. Instead, review spreadsheets reference products by SKU, product handle, or old database IDs. If an importer cannot match reviews to parent products dynamically by SKU or title, the imported reviews become orphaned records detached from your store catalog.
  • WooCommerce displays stars on category pages and Google search snippets by caching calculations inside _wc_average_rating and _wc_review_count in wp_postmeta and wp_wc_product_meta_lookup. Basic database insertions upload comment text but fail to trigger WooCommerce recount hooks, leaving product pages showing zero stars.
  • Trust badges rely on a specific binary flag stored under the verified meta key in wp_commentmeta. Omitting this field during an import strips legitimate buyer credibility from migrated reviews.
  • Customer feedback accumulated over years requires exact historical timestamps in comment_date and an approved status in comment_approved. Generic comment importers often overwrite these values with the current import timestamp or drop every review into the pending moderation queue.

Preventing these database issues requires an import workflow that maps parent SKUs, writes rating meta keys, and updates product review counts on upload.

How To Quickly Import WooCommerce Product Reviews

WP All Import

WP All Import handles complex WooCommerce product reviews database relationships automatically using its dedicated review import workflow. The plugin analyzes incoming files on upload, matches customer reviews to parent catalog SKUs, and triggers WooCommerce rating recalculations without requiring manual database configuration. Here is how to import your product reviews using Automatic Setup.

Step 1: Upload Your WooCommerce Reviews File

To start the import process, navigate to All Import › New Import inside your WordPress admin dashboard and click the Set up automatically banner. This opens the automated import wizard directly on your screen.

The setup screen presents four flexible file source options:

  • Upload a file: Upload a CSV, Excel (.xlsx or .xls), or XML export directly from your computer (supporting files up to 256 MB).
  • Download from URL: Enter a direct link to an external customer feedback feed or paste a shareable Google Sheets link.
  • Existing file: Pick a review file that has already been uploaded to your server's /wp-content/uploads/wpallimport/files/ directory.
  • FTP/SFTP: Enter your server host, port, username, and password to download review data directly from a remote storage server.

Once your review file is loaded, guide the setup wizard toward the correct data type. Under Choose What to Import, select WooCommerce, then pick Reviews from the dropdown menu.

Before initiating the automated scan, you can provide extra context if your spreadsheet uses non-standard column headers. Expand the optional Add Setup Instructions box to enter plain English instructions:

  • "Match reviews to products using the SKU column"
  • "Set the Rating column as the numerical star rating"
  • "Mark all reviews as approved and verified"
additional instruction woocommerce review import

Click Start Automatic Setup. The plugin analyzes your file rows, detects reviewer data, and maps your review fields automatically.

Step 2: Inspect the Automapped Product Review Fields

When the automated analysis finishes, the screen displays the Your Import Is Ready card. At a glance, it confirms the number of fields mapped from your file and the total count of review records ready to be imported.

WP All Import automatic mapping final step

Directly below the record count, click the Field Mappings section to expand the mapped data checklist. This lets you verify how your review columns were interpreted before writing data to your database:

  • Review Content & Author Details: Confirm that reviewer names, email addresses, and review text were mapped to their corresponding WordPress comment fields.
  • Parent Product Linking: Verify that your file's product identifier column (such as {product_sku[1]} or {product_title[1]}) was detected to associate each review with the correct WooCommerce item.
  • Ratings & Verification: Check that numerical rating values (1 through 5) and verified buyer statuses were mapped into WooCommerce review metadata.
product reviews mapped automatic woocommerce

At the bottom of the card, the interface provides three straightforward options: Manual Setup if you need to open the template editor, Preview to inspect your data, and a blue Run Import button to execute the import immediately.

If the mappings look accurate, you do not need to click through multiple configuration screens. Click the blue Run Import button at the bottom to import your WooCommerce reviews immediately.

Advanced WooCommerce Product Review Settings in the Template Editor

While Automatic Setup configures standard review columns on upload, custom vendor feeds occasionally require granular adjustments. If you click Manual Setup from the summary card, you can navigate through the template editor to customize how review fields are handled.

1. Parent Product Matching Options

The most critical part of any review import is attaching feedback to the correct catalog item. Inside the WooCommerce Add-On review settings, the plugin allows you to match incoming reviews to existing products using three methods:

Parent Product Matching Options

Selecting Product SKU matches reviews against your store's inventory codes, which provides the most reliable link when migrating between platforms. Selecting Product Title searches for matching item names, which works well if your spreadsheet lacks SKUs. If you are migrating reviews between two identical WordPress sites, selecting Product ID matches comments directly against existing post IDs.

2. Star Ratings and Feedback Content

WooCommerce requires review scores to be stored as whole integers from 1 to 5. Inside the rating settings, you can drag your spreadsheet rating element into the designated field. WP All Import automatically registers this review number inside wp_commentmeta and recalculates WooCommerce average product ratings when the import completes. For review titles and detailed feedback, drag the corresponding spreadsheet elements into the standard review content boxes.

3. Reviewer Identity and Verified Buyer Status

Authentic reviews require proper customer attribution. In the reviewer details section, you can map author names, reviewer emails, and original IP addresses. If the reviewer already has a registered customer account on your store, the plugin can match their email address to link the review directly to their WordPress user ID. You can also toggle the verified buyer status to automatically display the "Verified Owner" badge on the storefront.

Reviewer Identity and Verified Buyer Status

4. Review Dates and Moderation Status

To maintain authentic review histories, map your spreadsheet's date column to the comment date field. The plugin recognizes standard date formats (such as YYYY-MM-DD or MM/DD/YYYY) and preserves original submission timestamps. In the review status settings, you can set imported feedback to Approved so reviews appear on your store immediately, or set them to Pending if you prefer to moderate customer comments manually before publishing.

Final Thoughts: Fastest Way to Import WooCommerce Reviews

The traditional way to import product reviews into WooCommerce requires tedious database preparation. When review records are inserted without preserving their product relationships and associated metadata, star ratings disappear, verified buyer badges fail to display, and reviews become orphaned from products.

WP All Import handles the entire review architecture automatically by identifying customer feedback columns on upload, pairing each review with its parent product SKU, and registering both the comment record and its rating metadata in a single pass. Because it natively triggers WooCommerce product recalculations, average scores and star counts display accurately across your catalog without manual intervention.

If you need to verify or fine-tune incoming fields, clicking Manual Setup opens the template editor where you can check comment moderation statuses, verified buyer flags, and product matching rules before committing any data to your database. Once confirmed, running the import executes the process directly, making it the most dependable way to import WooCommerce reviews without post-import cleanup.

Frequently Asked Questions - Import WooCommerce Reviews

Can I import WooCommerce reviews from a CSV file?

Yes. WP All Import imports WooCommerce reviews from CSV, Excel, and XML files directly into your store by mapping reviewer names, review content, star ratings, and publication dates automatically on upload, then connecting each imported review to its corresponding product.

Where does WooCommerce store product reviews in the database?

WooCommerce stores product reviews in the core WordPress wp_comments table with the comment type set to review. Numerical star ratings and verified buyer flags are stored in the wp_commentmeta table under the rating and verified meta keys.

How do I link imported reviews to existing WooCommerce products?

WP All Import links imported reviews to existing products using the product SKU, product title, or WordPress post ID. Matching by product SKU is the most reliable method because it prevents broken links if product names change between platforms.

Will imported reviews automatically display star ratings on product pages?

Yes. WP All Import writes numerical scores directly into WooCommerce review metadata and recalculates the product's average rating and total review count. This ensures star ratings display properly on single product pages, shop archives, and Google search rich snippets.

Can I import reviews as verified owner purchases?

Yes. WP All Import allows you to set the verified buyer status during the import process. You can apply the verified flag to all incoming records or use conditional spreadsheet values to grant verified owner badges only to confirmed buyers.

Related Information

Editorial Staff
WP All Import’s Editorial Staff creates the tutorials, playbooks, and product guidance that help import, export, and migrate WordPress data with ease.

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

Unlimited Installs.
World-Class Support. Money Back Guarantee.

Packages
Standalone
Import
Pro Package
$199
.00
/yr
Save $494, 71% Discount
  • 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
$693 If Purchased Individually
Buy Now
90 Day Money Back Guarantee
Import + Export Pro Package
$299
.00
/yr
Save $1087, 78% Discount
  • 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
$1386 If Purchased Individually
Buy Now
90 Day Money Back Guarantee
WooCommerce Import Package
$169
.00
/yr
Save $29, 15% Discount
  • 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
$198 If Purchased Individually
Buy Now
90 Day Money Back Guarantee
Lifetime License
$1299
One-Time Payment
  • Import Pro + Export Pro
  • All Current Add-Ons
  • All Future Add-Ons
  • Lifetime Support
  • Lifetime Updates
  • No Renewal Fees
Buy Now
90 Day Money Back Guarantee
Import Standalone
$99
.00
/yr
  • 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
Buy Now
90 Day Money Back Guarantee
Import + Export Standalone
$169
.00
/yr
  • 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
Buy Now
90 Day Money Back Guarantee
Export Standalone
$99
.00
/yr
  • 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
Buy Now
90 Day Money Back Guarantee
Packages
Standalone
Import
Pro Package
$16.58
per month, billed annually
Save $494/yr, 71% Discount
  • 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
$693/yr If Purchased Individually
Buy Now
90 Day Money Back Guarantee
Import + Export Pro Package
$24.92
per month, billed annually
Save $1087/yr, 78% Discount
  • 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
$1386/yr If Purchased Individually
Buy Now
90 Day Money Back Guarantee
WooCommerce Import Package
$14.08
per month, billed annually
Save $29/yr, 15% Discount
  • 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
$198/yr If Purchased Individually
Buy Now
90 Day Money Back Guarantee
Lifetime License
$1399
One-Time Payment
  • Import Pro + Export Pro
  • All Current Add-Ons
  • All Future Add-Ons
  • Lifetime Support
  • Lifetime Updates
  • No Renewal Fees
Buy Now
90 Day Money Back Guarantee
Import Standalone
$8.25
per month, billed annually
  • 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
Buy Now
90 Day Money Back Guarantee
Import + Export Standalone
$14.08
per month, billed annually
  • 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
Buy Now
90 Day Money Back Guarantee
Export Standalone
$8.25
per month, billed annually
  • 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
Buy Now
90 Day Money Back Guarantee
linkcross