Export & import native woocommerce reviews

🛍️ Google Shopping eligibility

CSV imports are eligible for the Google Shopping Product Ratings feed only during your first 60 days on WiserReview (the onboarding window). To qualify, include an Order ID column in your CSV and map it during field mapping. WiserReview matches each Order ID and reviewer email against your store’s live transaction records before adding the review to the Google feed. Imports without a verifiable Order ID, or made after the 60-day window, still display on your storefront and widgets but are not syndicated to Google. Native WiserReview reviews are eligible automatically.

See: Which Reviews Are Syndicated to Google →

If your store uses native WooCommerce reviews and you want to move them through a plugin, follow these steps.

Step 1: Install a review export plugin & Export Reviews

Install this plugin on your WooCommerce store to export your existing reviews:

Plugin: Product Import Export for WooCommerce – Import Export Product CSV Suite

Install a review export plugin & Export Reviews

Download this plugin and install in wordpress.

After installation:

Open your WordPress dashboard Install a review export plugin & Export Reviews Go to the WebTofee import export plugin dashboard. Click on export and select product review. Then click on “select an export method”. Install a review export plugin & Export Reviews If you want to export all fields, then select quick export. Otherwise, for filtered fields, select advanced export. Then click on “Export”. Install a review export plugin & Export Reviews Now, click on the download file for the CSV file. Install a review export plugin & Export Reviews Now you have a CSV file with exported reviews. Note:

  • Change comment_post_id to product_id.
  • Remove the comment_id and comment_alter_id fields.
  • Also, ask to add the rating value in the review if it is missing.

Step 2: Import Reviews via CSV in WiserReview

Use the CSV import tool to import WooCommerce reviews into WiserReview—fast and easy.

1. Go to “Import Reviews via CSV”

Go to "Import Reviews via CSV

  • Go to your WiserReview Dashboard.
  • Navigate to: Manage Reviews → Import Reviews.
  • Choose Import Reviews Via CSV from the dropdown list, and click on the Integrate button.

2. Fill in Import Details and Upload File

Fill in Import Details and Upload File

  • Select Source – Choose Custom
  • Enter Task Name – Example: Woocommerce Reviews
  • Select Encoding – Keep as UTF-8 unless you’re using a different format.
  • Upload CSV File – Click Choose downloaded Woocommerce reviews file, then Upload & continue.

Fill in Import Details and Upload File Once you choose your source and file, the Field Mapping screen appears. For each Review field listed on the left, select the corresponding CSV column from your file on the right. Required fields include:

  • ⭐ Rating (1 to 5)
  • 📅 Review Date (YYYY-MM-DD)
  • 👤 Reviewer Name

You can also map:

  • Product info
  • Image/video URLs
  • Location and custom fields

Make sure your CSV includes required fields such as rating and date (in the YYYY-MM-DD format).

3. Check Import Status

After uploading, you’ll see the import job listed with:

  • Task Name
  • Source
  • Upload Status (e.g., Completed)
  • Trash icon to delete if needed

✅ Once the status is Completed, the imported reviews will appear under Manage Reviews.

Note: Imported reviews display on your storefront. For Google Product Ratings feed eligibility rules, see: Google Product Ratings, Which Reviews Are Syndicated.