In this tutorial, you’ll learn how to import and export WooCommerce reviews to easily migrate, back up, or manage customer feedback. We’ll cover how to format your files correctly and transfer reviews between stores quickly and safely.
How to Import WooCommerce Reviews
CusRev plugin has a built-in utility that facilitates import and export of WooCommerce reviews and replies to reviews using a CSV file. You can use this utility to import reviews from another WooCommerce store or from a third-party reviews platform. All you need is a CSV file with the reviews that need to be imported and basic spreadsheet editing skills.
How to Create a CSV File
You will need an empty CSV file to get started. You can create one yourself but we recommend using our import template, which you can find on the Import page of the plugin (Reviews > Import / Export). Regardless of the option you choose, your CSV file must have the following headers:
The headers must be in the first row of the CSV file.
Column | Description |
|---|---|
| id | This is an optional field used to assign a numeric ID to a review. Include this value if you plan to import replies and need an ID to reference the original review in the parent column (see below). |
| review_title | This is an optional field that can be used to import titles of reviews. This field can accept alpha-numeric characters. If a review doesn't have a title, keep this field blank. |
review_content | This is the content of the review you got from your customer. This field can accept alpha-numeric characters. |
review_score | This is the rating your customer gave you. This field is numeric and accepts a value from 1 to 5. |
| parent | This is an optional field that must be filled in when importing replies to reviews. It should contain the ID of the review that the reply refers to. |
date | This is the date the review was originally posted. The timezone is the same as your WordPress installation, but where that is unavailable, it fallbacks to GMT. The date format is MM/DD/YYYY HH:MM (i.e. Month/Day/Year Hour:Minute). |
product_id | The is how the plugin identifies the product that should be associated with the reviews. You can find WooCommerce products IDs from your 'edit product' URL, which usually looks like this '/wp-admin/post.php?post=665&action=edit', in this case, 665 is the product_id.
If you want to import a general store review, kindly use -1 as the product_id. |
| product_sku | This is an optional field used to specify the SKU of the WooCommerce product being reviewed. Use this field when transferring reviews between stores where product IDs differ, but product SKUs remain the same. |
display_name | This is the name of the reviewer, usually, full names are best. |
This is the email address of the reviewer. | |
order_id | This is an optional field that refers to the ID of the order that produced the review. Please only use this if you exported the reviews from a store that already uses our plugin and the domain that you are importing to matches the domain you exported the reviews from. Please also make sure that the orders that were on the former website are also on the new website. |
| media | This is an option field that can be used to import images or videos (media files) with reviews. You need to provide a comma-separated list of URLs for the media files that you would like to import. After import is completed, the media files will be attached to the review. |
| location | This is an optional field that can be used to import information about geolocation of reviews. The location field combines: 1. Country code 2. Additional geolocation information such as state, city or any other geographical entity Both values should be stored in a single column using the "|" delimiter. For example: US|New York US|San Jose, California IN|Karnataka GB|London GB|England JP|Tokyo Country codeThe plugin will recognize two-character country codes according to the ISO standard. Additional geolocation informationProviding detailed geolocation information is optional. You can import just the country code if that’s all you need. If you wish to include more details, feel free to use any format and combine elements such as state, region, or city names as needed. |
Your CSV file should follow this structure, but filled in with your own review data:
How to Import Reviews from CSV File
The import process includes three steps. Please navigate to the Reviews > Import / Export page and:
Create a CSV file according to the template.
Populate the CSV file with the reviews. Adhere to the headers, i.e. only populate your review scores under the review_store column, etc. Also, make sure to provide valid product IDs that exist on your WooCommerce site. To import general shop reviews (not related to any particular product), use -1 as a product ID. Please keep the column 'order_id' blank unless you are importing a file created with the export utility of this plugin.
Upload the edited CSV file to the plugin's import tool and click "Upload"
Common Errors
- Make sure that columns are separated with commas (,) and not semicolons (;). MS Excel in certain languages (e.g., German) might use semicolons (;) instead of commas (,) as a default separator for CSV files. Please make sure that you save the CSV file using the format with commas (,).
How to Import Reviews to CusRev.com
We do not currently support importing reviews to CusRev.com. Reviews imported as described above will appear on your WooCommerce website and product pages, but their verified copies will not be published on your store’s page at CusRev.com. This limitation exists because we have no way to automatically verify the authenticity of imported reviews.
We are actively exploring options for automatic verification of reviews imported from external sources and hope to make this feature available in the future.
Video Tutorial
How to Export WooCommerce Reviews
You can have the full export of your WooCommerce reviews in just two clicks. Visit Reviews > Import / Export > Export and:
- Click on the Export button
- Click on the Download button
Yes, it's that simple.
Video Tutorial
More Questions?
We hope that this tutorial was helpful. If you have any questions about the plugin, please don't hesitate to post them on our support forum or submit a ticket for our support team (available for customers with Pro licenses).