How to Import WooCommerce Customers

To import customers into WooCommerce, navigate to WP All Import › New Import, upload your import file, and select WooCommerce Customers from the dropdown list. Then, use our drag and drop interface to import your customers.

Step 1: Import WooCommerce Customers – New Import

On your WordPress site, navigate to All Import › New Import, choose your import file, and select to import WooCommerce Customers.

Import WooCommerce Customers Create New Import

To move to the following step, click on Continue to Step 2.

Step 2: Review Import File with WooCommerce Customers

In Step 2, the Review Import File screen will appear.

Import WooCommerce Customers Review Import File

Here, you'll be able to change the default delimiter if you're importing from a CSV file (as in this example). If you import from an XML or Excel file, you can select the parent node for the import.

You can also Add Filtering Options if you want to define which specific customers to import.

Everything looks in place, so click Continue to Step 3 to continue.

Step 3: Map Incoming Fields to Import WooCommerce Customers

Now the Drag & Drop screen appears. Here, you can map the customer data to their required fields. Just drag and drop the data elements from the panel on the right to the appropriate field on the left. The first panel is Customer Account Info, which will contain the customer's main data:

Import WooCommerce Customers Customer Account Info

Below this panel, you'll find other panels to map the remaining customer information. First, the Billing & Shipping Info, then Other Customer Info.

Import WooCommerce Customers Billing and Other Customer Info

Once you've mapped all required fields, click on the Continue to Step 4 button.

Step 4: Configure the WooCommerce Customers Import Settings

The Import Settings screen will appear. Here you can define the import options and other settings:

Import WooCommerce Customers Import Settings

First, click on the Auto-detect button to automatically define your unique identifier. You can also manually define this identifier by dragging and dropping elements to this field from the panel on the right.

You can modify how the import behaves with the options under When WP All Import finds new or changed data... However, these settings can often be left alone with their default selections.

Below, there's a panel named Email Notifications For Imported Customers. Keep the Block email notifications during import option enabled if you want to avoid sending WordPress email notifications to the imported users. Otherwise, you can disable this option.

You can also define Scheduling Options and Configure Advanced Settings.

Click on the blue Continue button at the bottom of the screen to move to the following step.

Step 5: Run the Import and Check Imported WooCommerce Customers

The Confirm & Run screen appears next. Here, you can review the Import Summary section to confirm that everything is in place before running the import.

Import WooCommerce Customers Import Summary

Since all looks correct, click on Confirm & Run Import to continue and execute the import.

Once the import finishes, you will see this screen:

Import WooCommerce Customers Import Complete

That's it! All WooCommerce customers have been imported. To confirm that everything worked correctly, you can review the imported customers in Users › All Users.

It is best to check all users because, for a customer to appear in WooCommerce › Customers, they need to make a purchase on this WordPress site first.

Import WooCommerce Customers – Advanced Topics

Difference Between WooCommerce Customers and WordPress Users

All WooCommerce customers are also WordPress users. This is because when someone makes a purchase on your website via WooCommerce, it creates a new user account with the role customer.

WooCommerce also adds billing address and shipping address custom fields to every customer. Those custom fields aren't available for regular WordPress users.

Keep the same Customer ID After the Import

Out of the box, every imported WooCommerce customer is treated as a new record, which will generate a new ID for it.

That said, you may have exported these WooCommerce customers from another WordPress site and want to retain the same customer IDs instead of generating new ones. To do so, you need to use custom code and our API.

However, this is only an attempt to use the existing IDs. If an existing ID is not available, then a new ID will be automatically created upon import and assigned to the imported customer.

We have a working example snippet available at Keep Old IDs When Migrating Users or Customers.

What to Expect with WooCommerce Customer Passwords

If your customer import file was obtained via WP All Export, you'll be able to simply map the hashed value of the password while importing.

However, if you import file only contains plaintext passwords, that can also be handled by WP All Import. All you need to do is disable the option This is a hashed password from another WordPress site and map your plaintext password there:

Import WooCommerce Customers Hashed Passwords

Frequently Asked Questions

How do I Bulk Edit WooCommerce Customers?

While this guide focuses on importing WooCommerce customers, you may also need to modify information for the customers that exist on your site. To do so, you can apply a bulk edit process, which will let you modify all WooCommerce customers in bulk.

Here's what you need to do:

  1. Use WP All Export to export the WooCommerce customers to change.
  2. Open the exported file in spreadsheet software (such as Microsoft or Google Sheets), which allows you to make bulk changes using copy and paste, search and replace, etc.
  3. Once you complete your changes, use the Import with WP All Import option to re-import everything into WordPress.

To learn more about the bulk edit process, please see our Quickstart Bulk Edit guide.

How Do I Schedule My WooCommerce Customer Import?

Let's assume that you're importing your WooCommerce customers from an URL or an FTP source. The import works as expected but now you want to schedule it to happen regularly. No worries, you can do this using WP All Import! Here are the available options:

  • Manual cron jobs. Configure these via your web host in cPanel. See Manual Scheduling.
  • Automatically Scheduling Service. This is an optional monthly subscription that allows to schedule imports directly from WP All Import's interface. See Automatic Scheduling.

Can I Import From Any File Format?

You can import your WooCommerce customers from different file formats. The supported import file types are XML, CSV, ZIP, GZIP, GZ, JSON, SQL, TXT, DAT, and PSV.

Can I Import From Multiple Feeds?

Each import can only have one (1) feed as the source. However, you can create multiple imports if you have multiple import files, or you can merge your import files to import from a single feed.

Related Docs

Use WP All Export to export and obtain your WooCommerce customers in a CSV, XML, or Excel file.

Learn how to migrate WordPress users (including WooCommerce customers).

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

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