How to Import and Export WooCommerce Reviews Using WP Ultimate CSV Importer

Customer reviews are crucial for building trust and improving conversions in any WooCommerce store. The reviews are associated with WooCommerce Products, so make sure you have products on your store to import reviews and associate them with Products.

Now let’s see the WooCommerce Reviews Import/Export steps in detail.

How to Import WooCommerce Reviews – Step-by-step #

Step 1: Create the Import File with WooCommerce Reviews Data #

First, prepare the import file(CSV, XML, or Excel) with the reviews data in it. Download our sample CSV for WooCommerce Reviews to know how to prepare the file for reviews.

Ensure you have installed and activated the WooCommerce plugin and WP Ultimate CSV Importer Pro plugin. Then follow the steps below:

• Navigate to the WP Ultimate CSV importer Pro > Import/Update. 
• Click on Browse to upload the import file or choose a different upload type. Select the post type as WooCommerce Reviews from the drop-down.

• Choose the import type “Fresh Import” for new reviews import, and select “Update content” to update your existing reviews.

• Now click on Continue.

Step 2: Map Import File Fields to WooCommerce Review Fields #

1. The plugin will display a field mapping interface.
2. You can choose the advanced mode for drop-down mapping. Or you can choose the drag & drop mode for drag-and-drop mapping.
3. Map the columns in your CSV file to the appropriate WooCommerce review fields (e.g., map review_author to the Reviewer Name field). Ensure to map the Product ID field.
4. Save your mapping template for future imports if needed.
5. Click on Continue.

Step 3: Configure the Import Settings  #

1. Enable the Safe prestate Rollback option to back up your data before import.
2. You can also enable the Maintenance mode based on the import needs.
3. For effective handling of duplicates on existing records, you can enable the option “Do you want to handle the duplicates on existing records” and select a field type to handle duplicate records based on the field.

4. (Optional)To schedule your data import, enable the “Do you want to schedule Import”. Enter the Schedule date, time, frequency, and time zone. Then click on Schedule.

Learn detailed import steps here.

5. Once done with the configuration, click the Import button to begin the process.

6. Monitor the progress bar to ensure the import is completed successfully.

Step 4: Verify Imported Reviews #

1. Navigate to Products > Reviews to verify the imported reviews.
2. Confirm that the reviews are correctly linked to the respective products.

WP Ultimate CSV Importer Pro

Get Ultimate CSV/XML Importer to import data on WordPress faster, quicker and safer.

Grab it Now $299/-

Topics to consider #

Match Reviews Based on Product IDs #

Matching reviews to products is a critical step when importing WooCommerce reviews. By default, WP Ultimate CSV Importer uses product IDs to associate reviews with their corresponding products. Ensuring the accuracy of product IDs in your import file is essential for a successful import process.

Key Steps to Match Reviews Using Product IDs #

1. Prepare the Import File: Ensure your CSV file includes a column for product IDs. Each product ID must correspond to an existing product in your WooCommerce store.
2. Verify Product IDs: Double-check that the product IDs in your file are valid and correctly formatted. Incorrect or nonexistent product IDs will result in skipped reviews.
3. Map Fields During Import: In the WP Ultimate CSV Importer mapping step, assign the appropriate column in your CSV to the “Product ID” field. This ensures the importer knows how to associate each review with its respective product.
4. Monitor Logs for Errors: Review the logs for skipped reviews or mismatches after running the import. Logs will show entries like:
   “Skipped due to Unknown Product ID”

Troubleshooting Common Issues #

• Product Not Found: Verify the product ID exists in your WooCommerce database.
• Mismatched Data: Ensure no formatting issues (e.g., extra spaces) in the product ID column of your CSV file.

By correctly utilizing product IDs, you can streamline the import process and ensure that reviews are accurately assigned to their corresponding products.

Steps to Export WooCommerce Reviews #

To export WooCommerce Reviews,

• Navigate to the WP Ultimate CSV importer pro and select the Export option.
• Choose the data type as WooCommerce Reviews.

• Click Continue.
• Enter the file name and file type(CSV/XML/XLSX/TSV/other).
• Use the advanced filters to export only the WooCommerce Reviews you want. To know more about the advanced filter, refer to the exporter guide.
• You can also schedule the export to export your record at your desired time interval.

• Click on Export.

FAQs: WP Ultimate CSV Importer for WooCommerce Reviews Import Export #

Related Guides #

How to Import, Update, Schedule WordPress data 

How to Import WooCommerce Products

WPML Import and Export

Generate Product Description with ChatGPT

Import WooCommerce Customers

Import WooCommerce Orders