How to Export Customer List from a WooCommerce Shop

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!

Exporting customers in a WooCommerce shop is a very easy task when using the right export plugin. The best thing about making an online shop using WooCommerce is that you can find a lot of resources online. This makes creating an online website very easy with WooCommerce.

There are a lot of plugins that can make a WooCommerce website fully-functional. You can create or do just about anything with a WooCommerce store using plugins. They make it really easy to work with WooCommerce and create an e-commerce shop.

Likewise, you can find good plugins that can help you export the users from the WooCommerce shop. The best plugin that can help you export the users and the user metadata from the WooCommerce shop is WordPress Users and WooCmmerce Customers Import Export Plugin.

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.

From the plugin page, go to the User/Customer Export section.

The plugin page looks as shown below.

This is the first step in the export process. From this page, you can filter the users that you want to export to the CSV file. Following are the fields of the plugin to filter the data:

  1. User Roles: Select user roles for which you want to export details from the given list:
    User roles
    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.

After the filters have been applied, click on Step 2: Map and Transform button. This will take you to the mapping of the users to export to the CSV file.

User/customer export mapping
User/customer export mapping
  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: Enable this field to include guest users to be included in the exported CSV file.
  6. Click Export Users, the CSV file gets auto-downloaded to your computer. The sample users CSV file is as shown below:
    Exported CSV
    Exported CSV

Export User(s) from 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:

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

FTP Settings for Exporting Users

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.

Export/import users/customers via FTP
Export/import users/customers 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!

Leave a Reply

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