A lot of people these days make purchases solely based on the reviews a product or service has garnered over time. Hence reviews are important for an online store to sell their products or services and for improving their product quality to a better standard.
Having said that people do not trust all the reviews that appear on the website. They look for some sort of signs that say those reviews are genuine. Verified user tag is one such way to bring genuineness to customer reviews.
If you are running a WooCommerce store and looking for an easy way to import product reviews with verified user tags, Product Import Export Plugin for WooCommerce would be a great choice. This article focuses on explaining to you the steps involved in importing product reviews with the verified user tags with this plugin.
Once you have installed and set up this plugin in your WooCommerce store, you can get started with the product review import process. At first, you need to go to your WordPress dashboard and navigate to WooCommerce > Product Reviews Im-Ex tab.
The opening window takes you to product review import/export settings of the plugin. The product review import settings page looks as shown below.
The first two options are for uploading CSV formated file containing product reviews, you can either import them via,
- Selecting a file from your computer or
- by providing FTP details
But, for the import process to take place, there is a pre-requisite that the CSV file should contain details in the structured format as given below.
- The first row must contain the column headers which are used for mapping the fields. The details about WooCommerce mapping field is given as below:
Column Heading Explanation Accepted value or format Comments ID Identification Number of the Comment Numerical Product SKU Stock Keeping Unit of Product Alphanumeric Comments Post ID Identification number of the Product Numerical Comments Author Name Name of the Comment Author Text Comments Author Email Email ID of Comment Author Text e.g. test1@gmail.com
Comments Date Date on which the comment is posted MM/DD/YYYY H:i:s
e.g 9/6/2016 6:29:00Comments Date(GMT) Date on which the comment is posted with Greenwich Mean Time MM/DD/YYYY H: i e.g. 9/6/2016 6:29
Comments Content Content of comment Text Comments Approved or Not? Indicates whether the comment is approved by the authorized person. 1 means the comment is approved and 0 means the comment is not approved. Numerical Comments Parent The parent comment’s ID. And it will be empty for the normal comment. Numerical User ID The comment author’s ID if he is registered (0 otherwise) Numerical Rating Indicates the star rating of the product. Numerical Range is 1 to 5
Verified or Not? Indicates whether a commenter is a registered customer who has bought the product or not. 1 means verified user and 0 means not a verified user. Numerical
Following is a screenshot of the CSV to be imported. The highlighted column denotes whether a customer is verified or not.
The rest of the options include selecting a mapping file for import if you have any saved ones. The update reviews if exists option, if selected will import reviews having the same ID as given in the CSV. You can leave it empty if you do not want to import reviews having the same Ids as in the CSV. The next option allows you to choose a Delimiter that separates field values within the CSV. The plugin takes “,” as default. The final option Use SKU can be used to link products and reviews using SKU instead of product ID.
Now when you click the Upload file and import button, you will be taken to the import mapping window as shown below.
Proceed to Submit the mapping to get over with the import task.
Following is a screenshot of a comment displaying verified user tag on the front-end of your website.
Conclusion
I hope this article was clear enough for you in understanding the verified review import process of the above plugin. You will be able to save a lot of your time if you chose to go with the import option provided by this plugin.
- Was this article helpful?
- Yes, thanks!Not really
Comments (12)
Rusty
October 6, 2021
Hi,
We accidentally duplicated a review and now it’s showing twice. How do we delete a review? I tried just editing the review but was unsuccessful. Please let me know how to delete a review with the CSV file. Thank you!
Mark
October 9, 2021
Hi,
Sorry to say that there is no option to delete the reviews using a CSV file. You will have to delete them manually from the comments list.
Virendra Kumar
August 19, 2021
Sir I am using you plugin for one of my client but when we import it stop after few and in log it says
2021-08-19T09:38:03+00:00 CRITICAL syntax error, unexpected ‘…’ (T_ELLIPSIS), expecting ‘;’ in /home/****/******/*****/wp-content/plugins/wt-import-export-for-woo/admin/modules/import/import.php(1493) : eval()’d code on line 1
Can you please provide what should we do
Thanks
Mark
August 25, 2021
Hi,
Please reach us via support and share your import file.
Arsilan Tahir
August 7, 2021
Hi, I want to import more than 1 review to my single product. It may be 20 reviews per product. But I am confused about how I can do that. Can you please explain it for me with file structure? Thanks
Mark
August 12, 2021
Hi,
You can import multiple reviews to a product by creating a CSV file with one row for each review. Eg: If you are required to import 5 reviews to a single product then you may please create 5 separate rows for each review.
Oasis
September 18, 2020
Can you import reviews to a specific product?
Alan
September 19, 2020
Hi,
Yes, you can import reviews to a particular product.
Alexandre
May 28, 2020
Hello, I did exactly as described in this article, but the text “verified owner” does not appear in the reviews I have imported. I tested twice. Do you have any idea why ? Is this option only possible in the paid version ? Thanks
Alan
May 29, 2020
Hi,
Importing the reviews as verified is one of our premium features. You may please purchase the premium version of the plugin to import reviews as verified.
Volker Forster
April 22, 2020
I am not sure if I understand the purpose of this tool. I want to import reviews our customers left for our products on other websites like eBay and Amazon. This is a lot of copy & paste work, of course. But when I import reviews from somewhere else than a WooCommerce export, than I will neither have “Comments ID” nor “Comments Post ID” or the commenters email address.
How can I make this happen?
Alan
April 22, 2020
Hi,
In order to import a review to the product, it is necessary to have Comment Post ID data and authors’ email addresses in the CSV file. In the comment_post_ID column, you may please provide the ID of the product to which you are trying to import comments. Also, make sure that you provide the author’s email address in the comment_author_email column. You can leave the comment_ID column blank. WordPress will automatically assign an ID to the imported reviews.