How to Export WooCommerce Order Emails? (Using a Free Plugin)

Exporting order emails is essential for many reasons, whether you want to share special offers with your customers, send out review-seeking emails, or build strong customer relationships. In this article, we will discuss how to effortlessly export the emails associated with orders from your WooCommerce store.

Orders placed by your customers in your WooCommerce store can be easily exported. WordPress has a built-in tool that lets you export orders from your WooCommerce store. However, the built-in tool has some limitations, and it won’t allow you to selectively export the required data from the whole.

The Order Import & Order Export for WooCommerce plugin from WebToffee will help you export the emails associated with completed orders in your WooCommerce store. The free plugin offers several export methods, filters, and more to filter the required data selectively.

Keep reading to learn how to export the email addresses in the completed orders as a CSV file.

Exporting order emails in WooCommerce can be valuable for several reasons:

• Marketing – You can use customer emails to keep in contact with your customers through marketing emails, newsletters, and more. Besides, analyzing the content in order emails can help you identify customer segments by examining their purchasing behavior, preferences, and demographics.

• Sales Trends – Examining order email data can reveal sales trends, identify peak seasons, track customer lifetime value, and assess product popularity and performance.

• Discounts & Offers – You can also use these emails to generate user-specific discounts to show your appreciation for purchasing from your store. This will help you build a good customer relationship and improve returning traffic to the store.

• Customer Support – Keeping a record of order emails allows customer support agents to easily refer to previous interactions, resolve issues more effectively, and offer consistent help, leading to higher customer satisfaction.

• Legal & Compliance – Order emails can act as proof of purchase in legal situations, including warranty claims or product liability cases. Keeping a record of these order emails can help your store meet different legal and regulatory obligations.

You can export your WooCommerce orders and other order-related data using the ‘Order Import Export’ plugin. Order emails (billing and/or shipping) can also be exported individually using this plugin.

To export the completed order emails with the free ‘Order Import Export’ plugin for WooCommerce,

Step 1: Install & Activate Order Import Export for WooCommerce Plugin

To install a plugin in your WordPress admin console,

1. Go to Plugins > Add New.
2. Search for the plugin ‘Order Import Export’.
3. Install and Activate the plugin.

Step 2: Choose Order as Post Type for Export

• On the dashboard, navigate to WordPress Import Export (Basic) > Export.
• Select the post type as Order.

This lets you specify that you only require the data about the purchase orders in the export CSV file as this plugin also lets you export coupon data.

Step 3: Select Advanced Export Method

By default, the plugin facilitates order export via two methods. Quick export and Advanced export.

• Choose Advanced export.

The advanced order export method provides several customization and configuration options, such as filters, export file column selection, etc. These options can filter out the completed orders and required columns.

Step 4: Filter Order Export Data

• Go to the Order status field and choose Completed from the list.

This will remove orders with any other statuses from the export list.

Step 5: Map & Reorder Order Export Columns

You can select which order data you want to export from here.

You can check the email address fields once you have unchecked all other fields.

• Since we must export the email addresses from the completed orders, select Customer email and Billing email from the list.

If you like, you can edit the Column name field to change the corresponding column names in the export file.

Step 6: Export Order Emails

Here, you can configure a couple of options for the final export.

• Mark the Exclude already exported checkbox to exclude previously exported orders.
• You can also select whether to exclude Line items or not.
• Next, change the configurations of your export file, such as the number of orders to be exported in a single batch or the delimiter of the CSV file.
• Once you have selected the configurations, click Export.

This will initiate a CSV file download.

The downloaded file will have two columns, billing and customer email addresses, in addition to the order items. If you do not require the order items field, you can delete it by editing the CSV file.

Here is a sample CSV file with emails of a few completed orders.

Now, let’s consider the scenario in which you must export your orders, their email addresses, and their purchase history.

Sometimes, you may need to export WooCommerce Orders with customers’ email addresses and purchase histories for various reasons, such as marketing or accounting. Let’s see how to do this.

Here, you will follow the same steps as above, such as choosing orders as post type, selecting the export method, and filtering the export orders.

The step for mapping and reordering columns is where you will select the email and purchase history for export, so we will jump right into it.

Map & Reorder Columns for Order Export

Here are the WooCommerce order fields that are available to export. All fields are checked by default. To remove any fields before exporting, uncheck the corresponding checkbox.

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

You can simply toggle the checkboxes for all the fields, including customers’ email addresses, order fields, and purchase history-related fields like order total, payment method, etc., to be exported.

Proceed to the next step for advanced export options.

Let’s leave the rest as default and proceed to export. This will then export all your orders, along with the customers’ email addresses and purchase histories.

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

The premium version of the WooCommerce order import export plugin has all the features of the free version in addition to several advanced configurations. For instance, using this version, you can get the email addresses of the product vendors whose products are being sold through your website. You can use this information to analyze the most profitable vendors, strike new deals, and more.

You can even include custom and third-party plugin fields in your WooCommerce store to the export file with this plugin. For example, if you are asking for additional email addresses from customers using a custom plugin, you can add this field to your export file using this plugin.

Other notable features include:

• Import and export WooCommerce coupons and subscriptions
• Schedule automatic exports with Server Cron
• Keep track of debug logs
• Export orders to XML, XLS, and XLSX files in addition to CSV
• Advanced filter options like payment methods, shipping addresses, etc.

Unlike the complete order export with the default WordPress tool, you require custom-built export plugins to help you selectively export the required amount of data regarding your orders.

The order import export plugin we mentioned in this article offers several filters and configurations. You can filter out the billing and customer email addresses, as well as the purchase history associated with the completed orders in your store.

Was this article of interest to you? Do let us know what you think in the comments below.