How to import WooCommerce products reviews with verified user tag - Featured image

How to Migrate WooCommerce Product Reviews with Verified User Tag? Using a Free Plugin

In today’s world, many individuals rely heavily on ‘reviews’ of products and services before making a purchase. As a result, reviews play a crucial role in the success of an online store, not only for driving sales but also for enhancing the quality of the products.

That said, people do not trust all the reviews on the website. They look for some sort of signs to ensure that those reviews are genuine. A verified user tag is one way to bring genuineness to customer reviews.

If you plan to migrate your WooCommerce store from one store to another, you can use the free Product Import Export Plugin for WooCommerce to migrate product reviews from your store site. In this article, we will explain the steps involved in importing product reviews with the verified user tags with this plugin.

Having said that, let’s get started.

How to Migrate WooCommerce Product Reviews with Verified User Tag?

To migrate WooCommerce product reviews, first, you need a CSV file to import product reviews. You can use the same Product Import Export plugin to export the product review CSV file. It may be difficult if you are using any other plugin since you may need to edit the CSV file to match the verified fields.

Follow the below steps to migrate WooCommerce product reviews using the Product Import Export Plugin by WebToffee.

  1. Install and activate the plugin

    From your WordPress dashboard, navigate to Plugins > Add New.
    Search for the Product Import Export Plugin by WebToffee. 


    Product Import Export Plugin by WebToffee

    Once you’ve found the plugin, click on Install Now. Then activate the plugin.

  2. Select Product reviews to export

    Go to WebToffee Import Export (Basic) and select Export.
    Now, from the dropdown, select Product Review as the post type to export. 

    Select Product Review as the post type to export

    Then proceed to the next step.

  3. Select Advanced export method

    Here you have two export options; Quick export and Advanced export.
    You can go with either method, but we will show you the options with the Advanced export. 

    Select Advanced export option for exporting product reviews

    Select Advanced export as the export method and proceed to the next step.

  4. Filter Product reviews

    In this step, you have some advanced options to filter product reviews from being exported into the CSV. 
    The following are the available options:
    Choose the total number of product reviews to export. If you leave this blank, no number will be selected, and all product reviews will be exported. 
    Choose to skip the first ‘n’ number of reviews. 
    Select a date range to export the product reviews within a specific date range.
    Choose reviews of specific products.
    Select to export reviews of specific ratings.
    Choose to export reviews of customers or guests or both.
    Select whether to include replies along with the reviews.
    Export reviews by product status.
    Then choose how you want to sort the product reviews.
    Filter Product Reviews
    After choosing the necessary filters, proceed to the next step. 

  5. Map and reorder export columns

    By default, the plugin exports all the related data of product reviews. If you don’t want to include any specific field, uncheck the checkbox corresponding to the field name. Also, make sure that the verified column is enabled.

    Map and reorder export columns

    Then proceed to the next step.

  6. Advanced export options

    Here you can select to export product reviews in batches. If you have a large number of product reviews on your store site, you can use the batch export option to reduce the server load. Reduce the batch count if the export fails due to timeout. 

    Then click on Export to export the product reviews into a CSV file. 

    Advanced export options
    Below is a sample of the product review exported using this plugin. You can see the verified column with the value 1 for verified users.

    product review csv
    Now, let’s import this data to our second site. 

  7. Import Product Reviews to WooCommerce

    Now go to the Import page of the WebToffee Product Import Export Plugin. 
    Select Product Review as the post type to import.

    Select Product Review as the post type to import

    Then select an import method to import the product reviews to your store. Here we can select the Quick import option, as we have exported the product reviews using the same plugin. If you used a different plugin, you may need to proceed with Advanced import for column mapping. 

    Upload product review CSV file

    Now, upload the CSV file we exported earlier and click on the Import button. 

    Import Progress log

    Your product reviews will be successfully imported, and you can view the Import progress log.
    Below is a preview of the product reviews with verified user tags

    Verified user tag

Conclusion

This article aims to show you how to migrate WooCommerce product reviews using a free plugin. With the plugin mentioned in this article, you can migrate product reviews for simple, grouped, and external products. To include variable products, you may need to upgrade to the premium version of this WooCommerce Product Import Export plugin.

The premium version of this plugin has some additional features like support for multiple file formats and scheduling import-export actions. For more information, check out the product page of the plugin below:

Article by

Associate Product Manager @ WebToffee

Comments (14)

Got any query? Please leave a comment or reach out to our support

Your email address will not be published. Required fields are marked *