How to Export Customer List From WooCommerce

The Best WordPress User/ WooCommerce Customer Import Export Plugin

10,000+ Active Installs as per WordPress Official Plugin Repository

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

WooCommerce is one of the best e-commerce websites that allows you to make the online presence of your business. It gives you a lot of control over the store, unlike many other platforms. Also, there are a ton of resources available for WooCommerce online and in case there are any issues, there is a huge community support.

You can export the list of customers from the database of the website, but that can be a nightmare situation if you are not a WordPress developer. The best way to do that is getting your hands on a plugin. WordPress Users & WooCommerce Customers Import Export Plugin is the plugin to go for if you want to export the list of the customers. The plugin helps you to export the list of the customers and its related data to a CSV file.

The plugin offers a lot that can help you achieve more from this plugin. Visit the product page of the plugin.

The following are the main features of the plugin to export the customer’s list.

  • Export all the users/customers and their metadata into a CSV file.
  • Filter users to export based on their user roles.
  • Export a partial list of users.
  • Export all the data of a single user from the Users page.
  • Export all the data of all or selected users in bulk from the Users page.
  • Schedule export to a remote server using FTP.

Exporting the Customer List

The first thing you need to do to export the customer list is to install and activate the plugin on your WordPress website. After the plugin activation, go to the dashboard and navigate to WooCommerce > Customer Import Export.

This will take you to the plugin page. To export the products, go to the User/Customer Export tab. The customer export can be completed in two steps. The screen for the first step looks as shown below.

User export step 1
User export step 1

From this page, you can filter the data that are to be exported to the CSV file using the plugin. Following are the fields on this stage:

  1. User Roles: Select user roles for which you want to export details from the given list:
    Filter by user roles
    Filter by user roles
  2. Offset: Enter the user row number at which you wish to start the export.
  3. Limit: Enter the maximum number of users that you wish to export.
  4. From Date: Select the date of registration from which you want to export the users by clicking on the calendar icon.
  5. To Date: Select the date of registration till which you want to export the users by clicking on the calendar icon.

Then click on Apply Filter button. This will show the resultant set of customers on the right-hand side of the page. The reset button will help you clear all the filters that have been applied and lets you start afresh. After the required filters have been applied, proceed to the next step by clicking on Step 2: Map and Transform button. It will take you to the mapping screen as shown below.

  1. Select a mapping file for export: Similar to import settings, you can select an existing mapping file for export. This option is enabled only when you create your first mapping file.
  2. Columns: Select the checkbox for required columns if you want to export specific columns. With the Column Name field, you can modify the column header in the CSV file. To do that, simply enter the required column name for the specific column.
  3. Save the export mapping: Enter a mapping filename for exporting.
  4. Delimiter: With this field, you can change the comma separated file to ‘|’ or ‘.” separated file according to your requirement.
  5. Export Guest Users: Check this field to include the guest users of the website to the exported CSV file.
  6. Click Export Users/customers, the CSV file gets auto-downloaded to your computer. The sample users/customers CSV file is as shown below:
    Exported user CSV
    Exported user CSV

Export Customer(s) from WordPress Users Page

Export customers from the Users page
Export customers from the Users page

You can directly download the export file with all the fields. To do that, navigate to Dashboard > WooCommerce > Users. The Users page appears as shown below:

  • To export Customers, select them. From Bulk Action drop-down list, select Download as CSV and click Apply. All the information about the selected customer(s) gets auto-downloaded to CSV file.

FTP Settings for Exporting Customers

The plugin allows you to schedule automatic import of the customers into the remote server via FTP. To do that, go to the Settings tab of the plugin.

User Import export via FTP
User import export via FTP

From this page, enable FTP and fill in the required fields. After all the required fields have been filled, this will export all the customer data in a CSV file via FTP on a regular interval.

You can try out the free version of the plugin before purchasing the premium version.

The Best WordPress User/ WooCommerce Customer Import Export Plugin

10,000+ Active Installs as per WordPress Official Plugin Repository

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

2 thoughts on “How to Export Customer List From WooCommerce

  1. Mark
    Mark says:

    Hi Jessica,

    Using this plugin you can Import-Export WordPress/Woocommerce customer data only. In order to Import/Export order data, you may please have a look at our Order Import Export plugin.

Leave a Reply

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