3.8.1. Import Comments and Reviews
Using Store Manager, you can import reviews, comments, and ratings to your WooCommerce store.
The import wizard allows importing reviews from the following sources:
Local file in CSV format
The import file structure
The import file should include the following data:
Product Name or SKU (for product identification)
Date or ID of the comment (for the comment identification)
Author email (if available)
Type (review or comment)
Rating (if available, enter as a number)
Status (if the status is not specified in the file, comments will be imported as approved)
Steps to import reviews
To import reviews, on the side menu navigate to Catalog > Comments. Press Import Data on the toolbar:
Specify the source of import and select the file.
3. Link database fields to the fields from the source file.
Specify the Identification Field: date or comment ID.
Next, link fields from the file to the WooCommerce database fields.
Find a WooCommerce database field in the left column and specify the corresponding field from the import file in the second column. Use the preview in the right pane to find matching columns:
4. Specify import option.
Add and Modify - if the import file contains new and existing comments/reviews, new will be imported, existing ones will be updated.
Add only - if the import file contains new and existing comments/reviews, new will be imported, existing will be skipped.
Modify only - existing comments/reviews will be updated, new will be skipped.
Just add - all comments/reviews from the file will be added as new without checking for existing comments.
Next, expand Advanced options, go to the option Product identify by, and select the identifier used in your import file: Product Name, Products ID, or Product SKU.
After all options are specified, press [Import]:
The reviews have been imported and now are visible in the Comments section.