Wait!

Lifetime licenses are only available for a short time, don't miss out!
People Love WP All Import 
"This plugin is a game changer for my situation. I’m stunned at how fast and effortless the import process is."
@glitzformals
"I have never experienced such a quick and helpful support experience with any plugin, and by the way, the knowledge of the support colleagues is professional!"
@adatfalo
"Even if you just use this plugin once, it will save you time. If you work on several sites its invaluable. Constantly developed, and continuously supported. Great job."
@jessedw44
The Powerful Features You Need

Any File Type, Any File Structure

No need to reorganize your data, just upload your file to WP All Import and it'll sort it out.

Complete Customization

Granular control over every single piece of data. Think your import is too complicated? Think again.

Import Huge Amounts of Data

It doesn't matter how big your site is or how much data you need to import, WP All Import can handle it. 

Multilingual Imports with WPML

Importing data to multilingual sites has never been easier, with support from the WPML team.

Scheduled WordPress Imports

Run imports automatically on a schedule. Subscribe to our point and click scheduling service, or set up cron jobs.

Developer Friendly

Write and test PHP right inside WP All Import when setting up your import, with tons of snippets to get you started.
90-Day Money Back Guarantee
Not 100% happy? Let us know and we’ll promptly send you a refund.
Free Updates For Life
Pay once for unlimited installs, even client sites. No renewal fees.
Fast, World Class Support
Over 9 years experience with WordPress imports and exports.
Now is your last chance to buy a lifetime license before we switch to annual pricing. Existing licenses will be unaffected.
Read More

How To Export WooCommerce Customers to CSV, Excel, or XML

To export your WooCommerce customers, go to WP All Export › New Export in the main WordPress menu and select WooCommerce Customers. Configure your export using our Drag & Drop interface, then run the export and download your data.

This documentation covers how to export WooCommerce customers using WP All Export. For a broader look at exporting WooCommerce customers, check out:

WordPress Users vs WooCommerce Customers

A WooCommerce customer is a specific type of WordPress user.

When someone visits your WooCommerce site and creates a purchase, WooCommerce creates a user account for them. This user account is assigned the role customer with a set of WooCommerce-specific data attached to their account.

Step 1: Create a New Export for WooCommerce Customers

Navigate to All Export › New Export:

New Customer Export
  1. Select Specific Post Type.
  2. Choose WooCommerce Customers.
  3. Click the blue Customize Export File button at the bottom. This will call up the Drag & Drop interface.

Step 2: Configure Your WooCommerce Customer Export Columns

When exporting WooCommerce customers, most users only need a subset of the available data fields. You can select this subset in the Drag & Drop interface.

All the available data tables and fields are accessible in the Available Data panel on the right.

To export a data field, simply drag it from Available Data to the column selection area as shown below:

Export WooCommerce Customers Drag and Drop

To delete an export column, simply drag it from the column selection area to another part of the interface.

WooCommerce Customer Tables and Fields

There are four default data tables in the Available Data panel for WooCommerce customer exports: Standard, Address, Custom Fields, and Other. The address fields are actually custom fields but WP All Export creates a special listing to make them more accessible.

Standard Fields

All basic export fields tied to your WooCommerce customers are in Available Data › Standard. These fields come from the WordPress Users table but are limited users who have been assigned a customer role:

  • ID: Customer ID, which is actually the user ID assigned by WordPress
  • Username: The username the user chose when creating their account
  • User Email: Email address associated with the customer account
  • First Name: Customer's first name
  • Last Name: Customer's last name
  • User Registered: Date when the customer registered
  • User Nicename: Sanitized version of the username
  • User URL: Website associated with the customer account
  • Display Name: The name to be displayed publicly, which is selected in WordPress as either the username, first/last, or nickname
  • Nickname: A name chosen by the user to be displayed on the frontend
  • Description: A description of the user, also labeled as Biographical Info in WordPress
Export WooCommerce Customers Standard Fields

WooCommerce Customer Address Fields

Address fields tied to your WooCommerce customers are found in Available Data › Address. WooCommerce adds these address fields and stores them in WordPress as custom user metadata.

Every customer in WooCommerce has a billing address and a shipping address. WooCommerce organizes both sets of addresses the same way:

  • First Name
  • Last Name
  • Company
  • Address 1
  • Address 2
  • City
  • Postcode
  • Country
  • State
  • Email
  • Phone
Export WooCommerce Customers Address Fields

Custom Fields

Custom fields added to your WooCommerce Customers are in Available Data › Custom Fields. These contain extra information (or metadata) added by your plugins or themes. WP All Export automatically detects these.

For example, WooCommerce adds an "_order_count" custom field which keeps track of how many orders a customer has made.

Export WooCommerce Customers Custom Fields

Other Fields

Other, less-used export fields tied to your WooCommerce customers are in Available Data › Other.

Export WooCommerce Customers Other Fields

Exporting WooCommerce Customer Passwords

To include a WooCommerce customer password in the export, add the User Pass field.

This field does not include the actual customer password but instead a hash code of that password, which is basically a scrambled/coded version of the original text that cannot be interpreted by humans. The hashing process cannot be reversed. But when you import a hashed password back into WordPress, the associated customer will still be able to use their old password.

Step 3: Download Your WooCommerce Customer Export

Once you've finished setting up your export, click Continue and verify the export settings. Then click Confirm & Run Export to run the export.

Once the export is complete, click CSV to download your exported customers:

Confirm and Run Interface

You can also click Bundle, which downloads a zip file containing an import template along with the export file. You can use this template to migrate customers from one WooCommerce store to another, as it contains everything that WP All Export needs to know to import the exported customers.

Export WooCommerce Customers Advanced Topics

Exporting Customers to Excel or XML

In addition to CSV exports, WP All Export can also export users to Excel or XML.

To use Excel, open the Drag & Drop interface and...

Export Customers to Excel
  1. Expand the Export Type section.
  2. Select Spreadsheet.
  3. Choose Excel File XLS or Excel File XLSX.

Exporting to XML is just as simple:

Export Customers to XML
  1. Expand Export Type.
  2. Select Feed.
  3. Choose Simple XML Feed or Custom XML Feed.

For more information on custom XML exports, see https://www.wpallimport.com/documentation/export-wordpress-data-to-custom-xml-feed/.

Export WooCommerce Customers Advanced Options

For CSV or XML exports, an Advanced Options section will appear just above the Export Type section. Here are the options for CSV files:

Export Customers Advanced Options CSV

The Separator field defines the character that will be used to separate columns. This is a comma (,) by default, but you can change it to any character that you want. Just be careful that you don't use a separator that is present inside the export data itself.

The Include header row and column titles in export option determines whether the first row contains just regular data or a header row consisting of the column names.

For more information on XML options, see exporting WordPress data to XML.

How to Filter WooCommerce Customer Exports

Sometimes, you only need to export a subset of all your customers.

To do this, expand the Add Filtering Options section in the lower half of the New Export screen. Every filter rule requires three components: an Element, a Rule, and a Value:

Adding Customer Export Filter Rules

This particular filter rule is designed to export only customers with a billing address in the city of Memphis.

Once you click the Add Rule button, you will see that only three customers will be exported:

Single Filter Rule

You can also combine filter rules. For example, if we add a rule to also include customers from the city of Phoenix, the number of customers to be exported rises to six:

Combination Filter Rule

Note the importance of selecting the "OR" join option for this combination filter. If we had left the default "AND" option in place, our combination filter wouldn't have returned any WooCommece customers because no customer lives in both Memphis and Phoenix.

Frequently Asked Questions About Exporting Customers

How to Import WooCommerce Customers?

  1. Go to All Import -> New Import.
  2. Choose the method for importing your customers (i.e., upload file, use a URL, etc.).
  3. Select the file you want to import and the import target (i.e., WooCommerce Customers).
  4. Drag and drop the incoming data elements to their target WooCommerce customer fields.
  5. Complete the import.

For more information, see Import WooCommerce Customers.

How to Migrate WooCommerce Customers to Another Website?

  1. Export the customers that you wish to migrate.
  2. When you download your export file, choose the Bundle option. This option will export an import template along with your export data file.
  3. Using WP All Import, import the bundle file on the target site.
  4. Simply accept the default settings, as the bundle file contains everything that WP All Import needs to know to complete the import.
  5. Review the imported customers.

To learn more, see Migrate WooCommerce Customers.

How to Schedule WooCommerce Customer Exports?

You can schedule your WooCommerce customer export using either cron jobs manually via your server, or by using our automatic scheduling service to set your customer export schedule directly from our interface.

For additional details, please see How to Schedule WordPress Exports.

How to Export All Customers From WooCommerce?

  1. Go to All Export > New Export.
  2. Select to export WooCommerce Customers. Do not set any filters.
  3. Set up the export by customizing the export file.
  4. Configure and run the export.
  5. Download the exported Woocommerce customers.

See Exporting WooCommerce Customers for more information.

How to Export WooCommerce Subscribers?

Subscribers are also customers (see question above). The subscriber “subtype” is added by third-party plugins or via code. If the metadata allows it, you can filter subscribers from customers. However, in some cases, custom code is needed to export the subscriber data correctly.

See Export WooCommerce Customers to learn more.

How to Import WordPress Users?

  1. Navigate to All Import > New Import and select the import file (upload, use URL/FTP, or select existing).
  2. Choose to import Users from the dropdown list.
  3. Proceed to set up the import template and map all user fields.
  4. Configure and run the WordPress users import.
  5. Verify that all users were imported as expected.

For more information, see Importing WordPress Users.

How to Export WordPress Users?

  1. Go to All Export > New Export.
  2. Select to export Users from the dropdown list.
  3. Customize the export file and include all user fields.
  4. Configure and run the export.
  5. Download the exported WordPress users.

See Exporting WordPress Users for additional details.

Export WordPress users in different file formats using WP All Export.

Use WP All Export to export WooCommerce orders to CSV, Excel, or XML.

Export WooCommerce products to CSV, Excel, XML, or the Google Merchant Center.

Export WooCommerce reviews using WP All Export.

Lifetime support. Lifetime updates. Pay once.

Packages
Standalone
Import
Pro Package
$249
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Pro Package
$299
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
WooCommerce Import Package
$149
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import Standalone
$99
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Standalone
$169
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Export Standalone
$99
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
cross