Author 诗语

How To Export WooCommerce Reviews to CSV or XML

To export reviews go to WP All Export › New Export and select WooCommerce Reviews. Next, drag and drop the elements on the right to configure your CSV or XML export file. Then, run the export and download your custom file.

Drag and Drop to Export WooCommerce Reviews

The WooCommerce review data to export is under Available Data. This data is organized into four sections: Review Data, Author Info, Parent, and Other.

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 author of the review is in Available Data › Author Info.

Author's NameAuthor's EmailAuthor's URLAuthor'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 done by a guest user, the name and URL is entered manually by the user when submitting the review.

Parent

More information related to the reviewed product is in 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 in Available Data › Other.

How to Export WooCommerce to CSV or XML

WP All Export exports WooCommerce data to CSV, Excel, or XML. You can export all your WooCommerce products or use filters to select a few. You can also export your WooCommerce orders, or get a list with all your customers.

You can export the existing reviews on your WooCommerce products or the WooCommerce coupons that exist on your site.

WP All Export can also create a Google Merchant Center Product Feed with all your WooCommerce products.

Export WooCommerce Products

Learn how to export WooCommerce products along with their specifications, images, custom fields, etc.

Export WooCommerce Orders

Create a WooCommerce orders report including the product and customer information.

Export WooCommerce Customers

Obtain a list of the customers that have purchased on your site.

Export WooCommerce Reviews

Export existing reviews made on your WooCommerce products.

Export WooCommerce Coupons

Export all data associated with the WooCommerce coupons existing on your site.

Export WooCommerce Products in a Google Merchant Center Product Feed

Export your WooCommerce Products in a friendly format for the Google Merchant Center.

How to Export WordPress Categories and Tags

WP All Export automatically detects all categories, tags, and taxonomies tied to the post type you are exporting. This includes WooCommerce product types, brands, real estate locations, and more.

You can choose to export them in one of two ways. First, you can export the taxonomies directly, and get a CSV or XML with category/tag in each row. Or, you can choose to export posts and include the taxonomies attached to them.

Direct Export of WordPress Taxonomies

Export WordPress categories and tags to a custom spreadsheet or XML feed. Here's an example of a simple direct export of WooCommerce product categories:

Category, Description
Winter, Clothing for cold weather.
Summer, Clothing for warm weather.
Mens, Men's clothing.
Womens, Women's clothing.

Export WordPress Posts with Taxonomies

Export any WordPress post type, along with their attached categories. Here's an example of a simple WooCommerce product export with their categories:

Product, Categories
Leather Jacket, Mens|Winter
Fur Coat, Womens|Winter
T-Shirt, Mens|Summer
Halter Top, Womens|Summer

How to Export WordPress to CSV, Excel, and XML

To export WordPress data to CSV, Excel, or XML, go to WP All Export › New Export and select the type of data you'd like to export. Next, drag and drop the post data to set up your export file. Then run the export to create your customized WordPress export.

Step 1: Select a WordPress Post Type to Export

First, choose the type of data that you would like to export. WordPress separates data into different post types like posts, pages, WooCommerce products, real estate properties, etc. You can export any custom post type or taxonomy by selecting it here.

Step 2: Customize Your WordPress CSV/XML Export

The fields available to export are listed on the right. Drag and drop individual fields, or click Add All to export everything. Move export fields around to reorder the spreadsheet columns. Click to rename individual elements, combine multiple fields, and more.

Everything is available for export, including media, images, categories and tags, custom fields, etc. Things like WooCommerce, real estate plugins, Yoast, and ACF, have custom data that can be exported.

Step 3: Confirm and Run Your Export

When you have finished selecting the data to export, click Continue to verify your export settings. Click Confirm & Run Export when you're ready to run your export.

Step 4: Download Your WordPress CSV/XML Export

After the export finishes, you'll be able to download the generated file. At this point you can choose to migrate this data to another WordPress install, edit it in Excel and import it back to this WordPress install, run this export on a schedule, or send the data to Dropbox, Google Drive, email, and over 1000+ other external apps via Zapier.

How to Export WordPress to CSV, Excel, or XML

WP All Export exports WordPress to CSV, Excel, and XML. Each file type can be easily configured to meet pretty much any format, schema, or structure.

Drag & drop to rearrange and rename columns in CSV and Excel exports. Columns can be combined, and data passed through PHP functions. You can even change the delimiter to create TSV files, or whatever is required.

When exporting to XML you can drag & drop to create a simple feed. For more complicated XML schemas, WP All Export uses a simple syntax that allows you to directly write out the format that you need in XML.

Export WordPress to CSV and Excel

Export WordPress to CSV, TSV, XLS, and XLSX.

Create a Simple WordPress XML Feed

Drag & drop to create a custom WordPress XML feed.

Create a WordPress XML Feed with Custom Schema

Code a custom XML feed with any complex structure.

Export WordPress Categories and Tags to CSV or XML

To export WordPress categories and tags go to WP All Export › New Export and select which type of taxonomies to export. Then, drag and drop your taxonomy data to set up your export file. WP All Export will automatically detect all custom taxonomies and term data.

Understanding WordPress Taxonomies

Taxonomies are used in WordPress to group posts, products, and other post types together based on relationships. By default, WordPress posts have two taxonomy types: Categories and Tags.

Plugins and themes can also add their own custom taxonomies. For example, a real estate plugin might create a custom taxonomy called Property Type, with terms like House and Apartment. An e-commerce plugin might create a custom taxonomy called Brand, with a separate term for each brand of product available.

Read more about WordPress taxonomies: https://wordpress.org/support/article/taxonomies/

Exporting Taxonomies Directly vs Exporting Posts with Their Taxonomy Data

WP All Export offers two ways to export taxonomy data: export the posts with just the term name, or export taxonomies directly with all of the term data but without the posts they are attached to.

This guide focuses on exporting taxonomies and term data directly.

Select Taxonomies to Export

Go to WP All Export › New Export, select Taxonomies, and then select which taxonomy to export from the drop-down list. Here you can see the custom taxonomies added by WooCommerce:

Export WordPress Term Meta

Taxonomies are divided into three sections in Available Data: Standard, Media, and Term Meta.

The Standard section contains the most commonly used term meta.

Term ID: The term ID, assigned by WordPressTerm Name: The term's name, which is displayed most commonly on the frontend and in the WordPress admin areaTerm Slug: The term's slug, a database-friendly version of the nameDescription: A description of the term, similar to a post's contentParent ID: The ID of the parent term that this term is a child ofParent Name: The name of the parent termParent Slug: The slug of the parent termCount: The number of posts that are attached to this term

Export WordPress Taxonomy Images

The Media section contains the images or thumbnails added to your taxonomy.

Taxonomies don't have images by default, but this functionality can be added by other plugins. For example, WooCommerce enables thumbnails for its product categories. Exporting WordPress taxonomy images works just export post images.

Read more about how to export images from WordPress: https://www.wpallimport.com/documentation/export-wordpress-images/

Export WordPress Term Meta

The Term Meta section contains any other custom metadata added to your taxonomies by your theme and plugins. Term meta is automatically detected.

A Complete WordPress Taxonomy Export

After dragging and dropping the term meta and organizing your export, click the Preview button to see how your file will look.

How to Let Clients Run WordPress Exports

Client Mode in WP All Export allows admins to provide access to a limited, secure interface for selected user roles. Users with access to Client Mode can run exports and download export files for the exports made available to them.

By default, exports are only available to admins and are only available to non-admins when specifically added to Client Mode by an admin.

Enable Client Mode for Specific Exports

Client Mode can be enabled in Manage Exports › Export Settings.

It can also be enabled in All Export › Manage Exports from the Bulk Actions pulldown.

Enable Access to Client Mode

Go to the WordPress admin panel, then select All Export › Settings.Scroll down to Client Mode and select role select roles with access.

Giving a role access to Client Mode affects all user accounts with that role. They will have access to a limited part of WP All Export and will be able to run and download all exports that have been added to Client Mode.

What Clients See

For testing purposes, you can create an account for yourself and grant access to it. When going into WP All Export as a non-admin, users see a list of exports that you have given them access to.

This is how the Manage Exports page looks using Client Mode.

Client Mode and Security

Client Mode was built with security in mind. Users cannot edit any settings related to exports. They can only access exports that admins specifically allow. With exports they have access to, they can run exports, download the data, and nothing else.

How to Schedule WordPress Exports

WP All Export allows you to re-run an export automatically on a schedule. You may need to re-run an export when you have new data (such as orders, users, or comments), when you need to sync product stock data, or when you need to sync two sites together, etc.

WP All Export uses cron jobs to automate exports. You can manually create these cron jobs, or you can also use our Automatic Scheduling, which is a paid and optional service.

WP All Export can also use Zapier to connect with different applications and process exported data more efficiently. This integration comes built-in.

Automatic Scheduling Service

Optional paid service that's integrated directly within WP All Export and allows to easily schedule exports.

Manual Scheduling

Learn how to manually create the cron jobs required for exports to run on a schedule.