To export reviews, go to All Export › New Export and select WooCommerce Reviews. Filter the review data with our powerful filter tool. Configure your export columns using our Drag & Drop interface, then run the export and download your exported reviews.

Step 1: Create a New Export for WooCommerce Reviews

Navigate to All Export › New Export and select WooCommerce Reviews from the dropdown list. You will see the number of reviews to export. Near the bottom of this screen, you can Add Filtering Options to reduce this number.

Click Customize Export File to continue.

Step 2: Customize Your Reviews Export

The WooCommerce review data fields available for export are displayed in the Available Data panel on the right. This data is organized into four sections: Review Data, Author Info, Parent, and Other.

To include a field in the export, simply drag it from the Available Data panel and drop it into the column selection area.

The following is a detailed description of each Available Data section and the fields it contains.

Review Data

The fields under Available Data › Review Data contain the most important information about the review:

• ID: The review ID, a unique number assigned to all reviews by WordPress.
• Product ID: The post ID of the reviewed product.
• Content: The text of the review, written by the author.
• Rating: The number of stars awarded by the author, a numerical value between 1-5.
• Approved: Whether the review is approved or not, exports 1 for approved, 0 for unapproved.
• Verified: The review is verified if the review's author purchased the product, exports 1 for verified reviews, 0 for unverified.
• Date (Server Time or GMT): The date the review was published, in y-m-d format.

Author Info

Data associated with the review's author is under Available Data › Author Info.

• Author's Name
• Author's Email
• Author's URL
• Author's IP: The internet protocol address of the author.
• Agent: Information on which browser the author was using.
• User ID: The ID of the user account which created the review, exports 0 for guest reviews.

If the review was created by a registered user, all of the author info is pulled from its user account. If the review was written by a guest user, the name and URL are entered manually by the user when submitting the review.

Parent

More information related to the reviewed product is under Available Data › Parent.

Reviews are always attached to a product, which is referred to as the parent product. Reviews can also be the child of another review.

• Parent Product Slug: The slug of the reviewed product.
• Parent Product Title: The title of the reviewed product.
• Parent Product ID: The post ID of the reviewed product, it's the same as the Product ID under Review Data.
• Parent Review ID: If this review does not have a parent review, 0 is exported.
• Parent Review Date (Server Time or GMT): If this review does not have a parent review, nothing is exported.

Other

Other less used data, like Karma, is under Available Data › Other.

Once you've set up your export template, click Continue at the bottom.

Step 3: Configure the Review Export Settings

You now see the Export Settings screen:

In the Scheduling Options section of this screen, you can set up recurring exports by scheduling your export to run automatically every week or month.

Among other things, the Advanced Options section lets you:

• control which reviews to export in subsequent runs of the same export;
• change the batch processing size for the export to avoid overwhelming the server;
• split your export into multiple files if one file is too big;

For now, leave these options alone and simply click the Confirm & Run Export button.

Step 4: Download the Exported Reviews

When the export finishes, you'll see the Export Complete page:

To download the exported WooCommerce reviews, click the export file type under Click to Download. In this example, the export file type is CSV.

The Bundle option exports an import template in addition to the export data. This template instructs WP All Import how to automatically configure itself to import the review data, and is mainly used to migrate data from one WooCommerce or WordPress site to another.

Export WooCommerce Reviews – Advanced Topics

How to Get the Product Permalink

You can use the PHP function get_permalink to obtain the product's permalink by passing it through the product ID, which is available under Available Data › Parent › Parent Product ID. Here's how to do that:

If you're using a custom export field or a custom XML export, you can do this instead:

[get_permalink({Parent Product ID})]

Learn more about using PHP functions here: How to Pass Exported WordPress Data Through PHP Functions.

How to Run the Export Automatically

You can run an export automatically using either of our available scheduling options:

• Manual cron jobs: included at no extra cost. You must set these up at the server level via cPanel or Plesk. Learn more here: Schedule WordPress Exports Using Cron Jobs.
• Automatic Scheduling Service. This is an optional service, charged monthly, but it lets you set up your schedules directly through the interface. Learn more here: Run WordPress Export on a Schedule.

Send Reviews to A Third-Party App with Zapier

You can connect Zapier to WP All Export to send export data to third parties. For example, you can automatically save your exported reviews to Google Drive or send them to someone via email. Here's what you need to do to send your exported WooCommerce reviews via email using Zapier:

1. Connect Zapier and WP All Export.
2. Set up your export process as required.
3. Create a new trigger in Zapier with New Export File in WP All Export Pro.
4. Set up a new action to send that exported file via email.
5. Test the action and then turn on the zap.
6. After that, every time the export is re-run, the zap will trigger and perform the designed action.

Learn more about this process in Send Exported WordPress Data via Email using Zapier.

Frequently Asked Questions

Where Are WooCommerce Reviews Stored?

WooCommerce product reviews are stored with all other comments in the wp_comments table. WP All Export uses the WooCommerce Export Add-On to enable support for WooCommerce reviews. You need to follow the instructions explained in this guide to export the reviews.

How Do I Import Reviews into WooCommerce?

1. Go to All Import > New Import.
2. Choose your import file.
3. Select WooCommerce Reviews as your import type.
4. Map the incoming data elements to their WooCommerce review fields.
5. Run the import.

How Do I Migrate WooCommerce Reviews?

1. In the source site, create a new WooCommerce reviews export via All Export › New Export.
2. Click on Migrate Reviews and process the export.
3. Download the bundle file with the exported WooCommerce reviews.
4. In the target site, go to All Import › New Import and create a new import process with the bundle file.
5. Click Skip to Step 4 and process the full import.
6. Once completed, you should confirm that all reviews were correctly migrated.

Learn more about migrating data in How to Migrate WooCommerce and WordPress Data.

Related Docs

Export WooCommerce Products to CSV, Excel, or XML.

Export WooCommerce Customers to CSV, Excel, or XML.

Export WooCommerce Orders to CSV, Excel, or XML.

Export WooCommerce Coupons to CSV, Excel, or XML.

Schedule and automate your export using cron jobs.

Related Videos