This tutorial explains how to import and export reviews stored in the standard WooCommerce format.
How to Import WooCommerce Reviews
Customer Reviews plugin has a built-in utility that facilitates import and export of WooCommerce reviews and star ratings 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 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.
Header | Product Review Information |
|---|---|
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. |
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. |
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 fields 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. |
Your CSV file should look like this:
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
Unfortunately, it is not possible to import reviews to cusrev.com at this moment. The reviews imported as explained above will show up on your WooCommerce website and product pages, but their verified copies will not be published on your store's page at cusrev.com. This is because the plugin doesn't have any means to automatically verify the authenticity of imported reviews.
We are currently developing tools for automatic verification of reviews imported from other sources and hope to be able to offer this option 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
Conclusion
If you are experiencing difficulties using our plugin or website, you are encouraged to post your queries on our support forum or if you have a professional license, please open a ticket and our support team will promptly assist you to resolve any issues.