How to Export WooCommerce Customers and Orders?

Customers and Orders are the heart and soul of a WooCommerce store. You need to regularly manage, maintain, and update the user data and order data on your store site. This can be a hectic task when you have thousands of customers and related orders on your WooCommerce store.

In this article, we will show you how to export WooCommerce customer data order data using plugins. The Customer Import Export plugin and the Order Import Export Plugin for WooCommerce are the best plugins that allow store owners to generate a CSV file for both customers and customer orders. These plugins will save you a lot of time and effort.

Having said that, let’s get started.

How to Export WooCommerce Customers? Step-by-Step Guide

The WordPress Users and WooCommerce Customers Import Export Plugin by WebToffee can make the exporting of the customers with just a click of a button. This plugin not only allows you to export WooCommerce customers but also gives you the option to select which users and their related data should be exported.

Prerequisites:

Install and activate the free plugin: Import Export WordPress Users and WooCommerce Customers

  • From your WordPress dashboard, go to Plugins > Add New
  • Search for the WordPress User Import plugin by WebToffee.
  • Once you have found the plugin, click Install Now and then Activate the plugin.

Now, follow the below steps to export WooCommerce Customers from your store site.

  1. Select the post type to export

    Navigate to WebToffee Import Export (Basic) > Import. 
    Select User/Customer as the post type to export.
    Select User as the post type to export

  2. Select an export method

    Here you have two options, Quick Export and Advanced Export. Selecting the Quick export will export your WooCommerce customers quickly without any data filtering options. If you want advanced data filtering options, you may select the Advanced Export option.
    Let’s go with Quick Export.
    Select Quick Export for User Export
    We will then proceed to Step 3 to look at some available options. You can go with the Export option too.

  3. Advanced export options

    Here, you have some advanced options for exporting WooCommerce Customers.
    • Choose whether to export guest users. 
    • Select a batch count to export. This option will allow you to export in batches to reduce the server load when you have a large number of user data to export. 
    • Then click on the Export button to proceed to export.
    Advanced User export options

    Once the export is completed, you can see a success message with the option to download the user data file.

    Export User data Download

This WordPress user import plugin has a premium version with advanced features like export WordPress users to an Excel file, additional filters, scheduling import export actions using FTP profiles, etc.

Read this article to learn more about the plugin: Best WordPress Plugin for Import Export of User Data

How to Export WooCommerce Orders? Step-by-Step Guide

To export WooCommerce orders from a website, you don’t have to go far away to search for a plugin that can do that effortlessly. WooCommerce Order Import Export Plugin by WebToffee can help you export all the orders from the WooCommerce store into a CSV file.

Prerequisites:

Install and activate the free plugin: Order Export & Order Import for WooCommerce

  • From your WordPress dashboard, go to Plugins > Add New
  • Search for the Order Import Export plugin by WebToffee.
  • Once you have found the plugin, click on Install Now and then Activate the plugin.

Now, follow the below steps to export WooCommerce orders from your store site.

Step 1: Select a post type

Here, select Order as the post type to export. Then proceed to the next step.

Select Post Type as Order to export

Step 2: Select an Export Method

Like the User import plugin, you also have two options, Quick Import, and Advanced Import. If you have used this plugin earlier and saved a template for the export option, you can see a third import method Pre-saved template.

Selecting Advanced Export for Order Export

Let’s select Advanced Export and proceed to the next step.

Step 3: Filter Data for Order Export

Here, you have some filtering options available to custom export orders from your store site.

You can choose the number of orders you want to export, skip the first n number of orders, and select order IDs to specifically export order data. Also, export order data based on order status, products, users, coupons, and date range.

Advanced filters for exporting WooCommerce Orders

After choosing the necessary filters, proceed to the next step.

Step 4: Map and Reorder Export Columns

Here you can edit, reorder and rearrange the columns in the export file. Use the drag-and-drop handle to rearrange the columns.

Map and reorder columns

Step 5: Advanced Export Options

You have some advanced options for exporting orders. Choose whether to exclude already exported orders.

Advanced Order Export Options

Click on the Export button to export the orders.

Download Order export CSV

Once the export process is finished, you will see a dialog box with the option to download the export file. Click on the Download file button to download the CSV file containing the order data.

This WooCommerce Order Import Export plugin also has a premium version with advanced features like support for the import export of subscription orders.

Conclusion

Exporting WooCommerce order and customer data can be daunting, especially with bulk orders on your store site. But with the plugins mentioned in this article, it can be done effortlessly.

This article was intended to help you with the export of WooCommerce orders and customers from your store site. If you want a solution for the import and export of WooCommerce products, take a look at our plugin:

Article by

Safwana is a technical content writer for WebToffee. She loves working in WordPress and writing about it.

Got any query? Please leave a comment or reach out to our support

Your email address will not be published. Required fields are marked *