How to export WooCommerce orders with customers’ email and purchase history

How to export WooCommerce orders with customers’ email and purchase history

Are you looking to export WooCommerce orders with the customer’s email IDs and purchasing history? If that’s the case, you’re in the right place.

This article explains how to export WooCommerce orders with customers’ email IDs and purchase history.

We will be using the Order Import and Order Export plugin by WebToffee for this article. The plugin is available for free in the WordPress plugin library. It is one of the best free plugins available for order export and import in WordPress.

Before we begin let’s see why people want to export customers’ email addresses and purchase history with the order data.

Reasons to export customers’ email addresses and purchase history

Marketing purpose: By exporting the customer email and purchase history we can list out our most valuable customers and reward them with exclusive coupons.

Accounting purpose: You can use the purchase history for accounting and auditing purposes.

Customer segment analysis: By using the customer details and purchase history you can analyze your customer segments and create and manage marketing campaigns.

Having said that, let’s dive in.

Export WooCommerce orders with customers’ email IDs and purchase history

Step 1: Install and Activate the plugin

Go to Plugins > Add New from your WordPress dashboard.

Search for the ‘Order Import and Order Export’ plugin by WebToffee.

Order Export and Order Import for WooCommerce plugin

Install and activate the plugin.

Step 2: Select orders as the post type to export

Navigate to WebToffee Import Export (Basic) > Export.

Select Order as the post type to export.

Select orders as the post type to export

Proceed to the next step.

Step 3: Select an export method

There are two options here, Quick export and Advanced export.

We need to ensure certain fields are in the export file, so let’s go with the Advanced export.

Step 3: Select an export method

Proceed to the next step for filtering options.

Step 4: Filter orders to export

Below are the filtering options available to export WooCommerce Subscription orders. You can skip this step if you wish to export all orders without applying any filters.

Filter orders to export

Step 5: Map and reorder columns

Here are the order fields available to export. All fields are checked by default. If you want to remove any fields before exporting, uncheck the corresponding checkbox.

You can use the drag and drop functionality to reorder columns before export.

The export file will include customers’ email addresses, order fields, and purchase history related fields like order total, payment method, etc.

Reorder export order fields

Proceed to the next step for advanced export options.

Step 6: Advanced export options

Here are the advanced options available for exporting WooCommerce orders.

Enable the Exclude already exported checkbox if you want to exclude the previously exported orders.

Let’s leave the rest as default and proceed to export.

Advanced export options

Click Export to complete the export setup.

Once the export is finished, you can see the Export file processing completed popup with a download file button.

Download the export file

Click on the Download file button to save the order export file in your local storage.

Step 7: Save as Template

You can save these options as templates, it will simplify the setup process for future exports.

To save these options as templates, click on Save template.

Add a template name and click Save.

Closing thoughts

The plugin we discussed in this article will help you export WooCommerce orders to CSV. If you want to export orders to an XML sheet you can use the premium version which comes with some advanced features.

The same plugin can also be used to import WooCommerce orders as well. You may also be interested in reading our article about exporting WooCommerce orders without a plugin.

Hopefully, this article helped you export WooCommerce orders with customers’ email addresses and purchase histories. If you agree with us, drop your thoughts in the comments.