---
title: "How to Import WooCommerce Product Reviews from CSV"
url: "https://wpimportexport.com/import-woocommerce-product-reviews-csv/"
description: "Import product reviews into WooCommerce from CSV: keep stars, dates, verified owner labels and store replies, and update product ratings without duplicates."
type: post
published: 2026-11-08T19:21:01+00:00
modified: 2026-11-14T10:41:46+00:00
categories: ["Import Guides", "Tutorials", "WooCommerce"]
tags: ["CSV import", "Import Export by RockStarLab", "WooCommerce", "WordPress import"]
docs_topics: ["Import guides", "WooCommerce"]
---

# How to Import WooCommerce Product Reviews from CSV

When you move a store to WooCommerce, the products come over easily. The reviews often don’t. Your old platform or review app can export them to a CSV file, but WooCommerce has no import for reviews. If you skip them, every product starts at zero stars.

[Import Export by RockStarLab](https://wordpress.org/plugins/import-export-by-rockstarlab/) imports them from a CSV file. Each review keeps its stars, date, author and “verified owner” label. Store replies stay under the review they answer, and the product rating updates by itself. Importing reviews needs the PRO add-on, which you can [get for free](https://wpimportexport.com/get-pro-for-free/).

## What the reviews file needs

You need one row per review. The column names don’t matter, but each row needs:

- **Something that identifies the product**. The SKU is best. A product slug, a product name or a product ID from an earlier import also work.
- **The review text**. This is the only required field.
- **Rating** from 1 to 5. Values like `4`, `4.0`, `4/5` and `4 stars` all work.
- Optional columns: a review ID from the old system, author name and email, review date, verified buyer (`yes`/`no`), status and the review this row replies to.

Here is the file used in this guide: ten reviews exported from an old store. R-1003 is the store’s reply to R-1002. R-1008 is spam. R-1009 is waiting for moderation. R-1010 is for a product this store no longer sells.

![reviews.csv with columns Review ID, Product SKU, Reviewer Name, Reviewer Email, Rating, Review Date, Review, Verified Buyer, Status, Reply To: ten reviews R-1001 to R-1010, R-1003 is a store reply to R-1002, R-1008 spam, R-1009 pending, R-1010 for old-tote-bag](https://wpimportexport.com/wp-content/uploads/2026/11/01-reviews-csv-from-old-store-scaled.webp)

_Reviews exported from the old store, one row per review._

Products must exist before their reviews can be imported. If you are moving a whole store, import products first (see [importing WooCommerce products from CSV](https://wpimportexport.com/how-to-import-woocommerce-products-from-csv-or-excel/) or [moving products from Shopify](https://wpimportexport.com/shopify-to-woocommerce-import-products-csv/)), then reviews. Keep the same SKUs so each review finds its product.

## Step 1: Upload the file and map the columns

Go to **Import Export → Import**, choose **WooCommerce Reviews** and click **Next Step**.

The import changes data on your live store. Make a backup before you continue. In the admin, open UpdraftPlus and click **Backup Now**; the importer also shows a reminder at this point. If an AI agent manages the site, it can start a backup with the `rsl-ie/updraftplus-backup-start` ability. See [how to create a WordPress backup and restore it](https://wpimportexport.com/how-to-create-a-wordpress-website-backup-and-restore-it/).

Upload the CSV, check the preview and go to **Field Mapping**. Click **Auto Map**. It recognizes common review export headers like Review ID, Product SKU, Reviewer Name, Reviewer Email, Rating, Review Date, Review, Verified Buyer, Status and Reply To. All 10 columns were mapped here.

![Field Mapping for WooCommerce Reviews after Auto Map: 10 of 10 fields mapped, Review ID to source_comment_id, Product SKU to product_sku, Reviewer Name to comment_author, Reviewer Email to comment_author_email, Review Date to comment_date, Review to comment_content, Rating, Verified Buyer to verified](https://wpimportexport.com/wp-content/uploads/2026/11/02-auto-map-review-columns-scaled.webp)

_Auto Map recognizes the usual review export headers._

If your file uses other headers, drag each column onto its field. The fields that matter most:

| Field | What it does |
| --- | --- |
| Source Review ID | The review’s ID in the old system. Text IDs like `R-1001` or UUIDs are fine. Used to find the review again on the next import. |
| Product SKU / Product Slug / Product Title | Finds the product. If none of them matches, the row is reported as an error. It is never attached to a random product. |
| Review Date | Keeps the original date. `2025-01-12 09:41`, `01/12/2025` and ISO dates with a time zone all work. |
| Verified Owner | `yes`, `true`, `1` or `verified` adds the “verified owner” label. `no`, `false` or `0` leave it off. |
| Status | `approved`, `pending`/`hold`, `spam` or `trash`. |
| Parent Review ID | For replies: the old ID of the review being answered. The reply is attached to that review after import. |

If a reviewer’s email belongs to a customer account on your store, the review is linked to that account. Otherwise it is saved as a guest review.

## Step 2: Choose how existing reviews are matched

In **Import Options**, leave **Check for Existing Items by Field** on **Source Review ID**. When you import the same file again, each row updates its own review and creates no duplicates.

![Import Options: Check for Existing Items by Field set to Source Review ID (for updates), If Match Found Update, If No Match Found Create](https://wpimportexport.com/wp-content/uploads/2026/11/03-match-by-source-review-id.webp)

_Match existing reviews by the old review ID._

If your file has no review ID column, choose **Author Email**. A review then counts as existing when the product, the reviewer’s email and the review date are the same. Without a date column, the review text is compared instead.

## Step 3: Run the import

Click **Start Import**. Nine reviews were created. The tote bag review failed because there is no product with that SKU. The error names the row, so you can fix the SKU or delete the row and run the import again.

![Import Completed with Errors: Successful 9, Created 9, Failed 1, error Could not match the review to a product (rows: 10)](https://wpimportexport.com/wp-content/uploads/2026/11/04-import-result-9-reviews-created.webp)

_Nine reviews created; the row for a missing product is reported._

Under **Products → Reviews** the reviews show their original dates and stars. The store’s reply says “In reply to Daniel Reyes”, the pending review waits for moderation, and the spam review went straight to Spam.

![Products > Reviews list: imported reviews with star ratings and original dates from January to April 2025, Store Team reply shown as In reply to Daniel Reyes, Nina Rossi review pending](https://wpimportexport.com/wp-content/uploads/2026/11/05-imported-reviews-in-admin.webp)

_Imported reviews in the admin with their original dates._

On the product page, the average rating and review count are already up to date: 4.5 stars from 2 reviews for the hoodie. The reply is not counted as a review. Each review keeps its verified owner label and date, and the store’s answer appears under the review it replies to.

![Hoodie with Logo product page: 4.5 stars from 2 customer reviews, Megan Carter and Daniel Reyes marked verified owner with original dates, Store Team reply under Daniel's review](https://wpimportexport.com/wp-content/uploads/2026/11/06-product-page-rating-and-reply.webp)

_The rating updates, and the store reply sits under its review._

Pending and spam reviews don’t count toward the rating. When you approve the pending review later, WooCommerce updates the average as usual.

## Importing the file again

Review apps keep collecting reviews after you export them. To bring the new ones over before launch, export again from the old system and import the full file. Set **If Match Found** to **Skip** to keep reviews that are already in WooCommerce exactly as they are. Choose **Update** if the old reviews may have changed (for example, a review that was edited or approved).

![Second import of the same file with If Match Found Skip: Successful 0, Skipped 9, Failed 1, Import Completed with Errors](https://wpimportexport.com/wp-content/uploads/2026/11/07-reimport-9-skipped.webp)

_Importing the file again skips reviews that are already there._

Here the nine reviews already on the site were skipped and none were duplicated. The tote bag row is still reported because its product is still missing.

When you update with only some columns, such as Review ID and Rating, the unmapped fields (author, date, verified label) stay as they are.

## Moving reviews between two WooCommerce stores

If both stores run WooCommerce, you don’t need another tool. [Export the reviews](https://wpimportexport.com/how-to-export-all-woocommerce-reviews/) from the first store and import that file into the second. In the export, add Source Review ID, Product SKU, Author, Author Email, Date, Content, Rating, Verified Owner, Status and Parent Review ID. Auto Map then maps every column on the other store. The export lists the newest reviews first, so a reply comes before the review it answers. That’s fine: the reply is attached as soon as its review is imported. To move reviews together with products, orders and customers, see [migrating WooCommerce store data to another site](https://wpimportexport.com/how-to-migrate-woocommerce-store-data-to-another-site/). For orders and customer accounts on their own, see [importing orders](https://wpimportexport.com/import-woocommerce-orders-csv/) and [importing customers](https://wpimportexport.com/import-woocommerce-customers-csv/).

## Troubleshooting

- **“Could not match the review to a product”**: the SKU, slug or title in that row doesn’t match any product. Check for spaces or a changed SKU. A bare product ID from another store is not used once a SKU, slug or title is given, so reviews never land on the wrong product.
- **The reply shows up as a normal review**: map the column with the parent review’s ID to **Parent Review ID**, and import the parent review in the same file or before the reply.
- **Every review got today’s date**: the date column wasn’t mapped to **Review Date**, or the cell was empty.
- **Stars are missing**: map the rating column to **Rating**. Values must be between 1 and 5; half stars are rounded.

## With an AI agent

With PRO, an AI agent connected through the WordPress MCP Adapter (see [connecting Claude Code to WordPress](https://wpimportexport.com/connect-claude-code-to-wordpress-mcp/)) can run the same import. It uploads the file with `rsl-ie/upload-create`, `rsl-ie/upload-chunk` and `rsl-ie/upload-complete`, reads the review fields with `rsl-ie-pro/import-prepare` (content type `woo_review`), starts the import with `rsl-ie-pro/import-start` and follows it with `rsl-ie/job-get`. A prompt:

```
Back up the store first. Then import reviews.csv as WooCommerce product
reviews: match products by SKU, keep the rating, verified-buyer flag and
status from the file, attach replies to their reviews, and update reviews
that were imported before instead of duplicating them. Report every row
that failed and why.
```

In our run with the same 10-row file, the agent mapped Review ID to the source review ID, Product SKU, Reviewer Name and Email, Rating, Review Date, Review, Verified Buyer, Status and Reply To, and enabled updating existing reviews. The job finished with 9 created and 1 failed. The agent reported row 10 with the message “Could not match the review to a product”: the tote bag SKU doesn’t exist on the store. The store team’s reply was attached under Daniel Reyes’s review, the spam row was saved as spam and Nina Rossi’s review stayed pending.

## FAQ

### Do I need the PRO add-on?

Yes. Importing WooCommerce reviews is part of the PRO add-on. New users get the first month free.

### Can I import reviews before the products?

No. Each review is attached to an existing product, found by SKU, slug or name. Import the products first, keeping the same SKUs.

### Will importing the same file twice create duplicate reviews?

No. Reviews are matched by the review ID from the old system. Without an ID column, a review with the same product, reviewer email and date counts as the same review.

### Can I import the store’s replies to reviews?

Yes. Map the column with the ID of the answered review to Parent Review ID. The reply is attached even if it comes before the review in the file.

### Do pending and spam reviews affect the star rating?

No. Only approved reviews count toward the average rating and the review count.

## Related Guides

- [How to Export All WooCommerce Reviews](https://wpimportexport.com/how-to-export-all-woocommerce-reviews/)
- [How to Import WooCommerce Products from CSV or Excel](https://wpimportexport.com/how-to-import-woocommerce-products-from-csv-or-excel/)
- [How to Migrate WooCommerce Store Data to Another Site](https://wpimportexport.com/how-to-migrate-woocommerce-store-data-to-another-site/)
- [WebToffee Product Import Export Alternative for WooCommerce](https://wpimportexport.com/webtoffee-product-import-export-alternative/)
