How to export completed order emails in WooCommerce using a free plugin?

How to export completed order emails in WooCommerce using a free plugin?

The orders placed by your customers in your WooCommerce store can be easily exported. WordPress even has a built-in tool that lets you export orders from your WooCommerce store. However, you will need a third-party export tool (such as a plugin) to help you selectively export only the required data from the whole.

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

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

Why do you need to export order emails?

You can use the customer emails used for placing orders from your store for several marketing purposes. These emails can be used to keep in contact with your customers through marketing emails, newsletters, and more.

This is a great tool to communicate discounts, new deals, special offers, and new products. You can also send emails to gather customer feedback, educate them about your brand, and more.

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 also will improve the returning traffic to the store.

How to export the emails from completed orders in WooCommerce?

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

Export the completed order emails using a free plugin

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

Step 1: Install and activate the 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.
Order Import Export plugin

Step 2: Choose the post type

Select the post type as Order. This lets you specify that you only require the data pertaining to the purchase orders in the export CSV file as this plugin also lets you export coupon data,

post type for WooCommerce completed order email export

Step 3: Choose an export method

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

Choose Advanced export. This advanced order export method provides several customization and configuration options such as filters, export file column selection, etc. You can use these options to filter out the completed orders and required columns.

the export method for order email export

Step 4: Filter out the required 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.

Set the filter as completed orders

Step 5: Select the export columns

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

Note that all the fields on this page will be selected by default, you can unselect all these fields by checking and unchecking the column heading checkbox. You can then check the email address fields once you have unchecked all other fields. Since we have to export the email addresses from the completed orders, select customer email and billing email from the list.

You can change the corresponding column names in the export file by editing the Column name field if you like.

select the columns to be exported

Step 6: Export the file

You can simply export the file by clicking on Export.

You can also 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 from the same window. Once you have selected the configurations, export the file. This will initiate a CSV file download.

export the woocommerce orders

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

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

sample csv of the orders with WooCommerce email addresses

Export with Order Import Export for WooCommerce (Pro)

order import export plugin premium version

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, you can get the email addresses of the product vendors whose products are being sold through your website using this version. You can use this information to analyze the most profitable vendors, strike new deals, and more.

With this plugin, you can even include custom fields and third-party plugin fields in your WooCommerce store to the export file. 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.

The plugin also includes other features like importing and exporting coupons and subscriptions, scheduling automatic exports, keeping track of debug logs, and more. You can also export orders to XML, XLS, and XLSX files in addition to CSV with the pro version of the plugin.

The pro version offers several additional filter options like payment methods, shipping addresses, etc., which will help you further customize your export files.

Conclusion

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 and order export plugin offers several filters and configurations with which you can filter out the billing and customer email addresses associated with the completed orders in your store.

Check out this article on exporting WooCommerce orders with customers’ email and purchase histories if you are interested.

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