Back to blog
6 min read Import Guides

How to Import WooCommerce Customers from CSV

You have a list of customers in a spreadsheet: exported from a CRM, an old shop, a mailing tool or typed in by hand. To see them in WooCommerce with their addresses, so checkout is filled in and orders can be assigned to them, each one needs a WordPress account with the customer role and WooCommerce billing and shipping fields. Below: importing customers from a CSV file, updating the ones that already exist, and avoiding the usual problems with country names, passwords and welcome emails.

We tested it with a 5-customer CSV using Import Export by RockStarLab 2.1.25 with the PRO add-on 2.1.5, WooCommerce 11.2 and WordPress 7.1. Importing WooCommerce customers is a PRO feature.

Short Answer

  1. Make a CSV with at least an Email column. Add names, phone, company and address columns if you have them.
  2. Back up the site.
  3. Go to Import Export → Import, choose WooCommerce Customers and upload the file.
  4. Click Auto Map and check the mapping.
  5. Keep Check for Existing Items by Field: Email and If Match Found: Update, then start the import.
  6. Send password reset links from Users when you are ready to tell customers about their accounts.

The CSV File

Our file came from a CRM. It has the usual columns, with country and state written out as names, and a “Customer Since” date:

customers.csv with 5 customers: First Name, Last Name, Email, Phone, Company, Address, Address 2, City, State, Postcode, Country, Newsletter, Customer Since; countries written as Germany, United States, France, United Kingdom, Canada
A customer list from a CRM, with country and state names instead of codes.

What the columns can contain:

  • Email is required. It identifies the customer, so a second import with the same email updates the account instead of creating a new one.
  • First Name, Last Name, Company, Phone go to the customer’s name and billing details.
  • Address, Address 2, City, State, Postcode, Country become the billing address. If your file has a separate delivery address, map those columns to the shipping fields.
  • Country can be a name (“Germany”, “United States”, “UK”) or a code (“DE”, “US”). State can be a name (“Texas”, “Ontario”) or a code (“TX”, “ON”). The import stores the codes WooCommerce uses.
  • Customer Since (or Registered, Date Registered) becomes the account’s registration date.
  • Username is optional. Without it, the part of the email before the @ is used, with a suffix if that name is taken.

Columns that WooCommerce has no field for, such as our “Newsletter” column, can stay in the file; leave them unmapped and they are ignored.

Step 1: Back Up the Site

The import creates and changes user accounts. Make a backup first: UpdraftPlus Backup Now, your host’s backup, or ask an AI agent to run rsl-ie/updraftplus-backup-start. See How to Create a WordPress Website Backup and Restore It.

Step 2: Upload and Map the Columns

Open Import Export → Import, choose WooCommerce Customers, upload the CSV and go to Field Mapping. Click Auto Map. In our file, 12 of 13 columns were matched: Email, names, Phone, Company, the address columns and Customer Since. Only Newsletter was left out:

Field Mapping after Auto Map: 12 of 13 fields mapped; Email to email, Phone to billing_phone, Company to billing_company, Address to billing_address_1, Address 2 to billing_address_2, City to billing_city, State to billing_state, Postcode to billing_postcode
Auto Map matches the usual customer columns to the WooCommerce billing fields.

Check two things before you go on: Email is mapped to email, and the address columns went to billing_* (or shipping_* if that is what your file holds). You can drag any column to another field by hand.

Step 3: Match by Email and Import

On Import Options, keep Email in Check for Existing Items by Field:

Import Options: Check for Existing Items by Field set to Email (required, matches existing customers), If Match Found Update, If No Match Found Create
Customers are matched by email.
  • If Match Found: Update changes the existing account: names, addresses and phone. Skip leaves existing customers as they are. WordPress allows only one account per email, so Create also updates.
  • If No Match Found: Create adds new customers. Choose Skip if the file should only update customers you already have.

Start the import. Four customers were created and one was updated: Ben Turner already had an account with the same email, so he got the new address and phone instead of a second account.

Import Completed Successfully: 5 successful, 1 updated, 4 created, 0 skipped, 0 failed
Four new customers and one existing customer updated.

Step 4: Check the Customers

In Users, filter by the Customer role. The new accounts have the role Customer:

WordPress Users list: ben.t, chloe.nguyen, daniel.okafor, laura.fischer and sophie.martin with the role Customer
The imported customers in Users.

Open a customer and scroll to Customer billing address. The file said “United States” and “Texas”; WooCommerce has US and TX, so the country and the state show in their drop-downs, and checkout, shipping zones and taxes recognize the address:

Customer billing address of Daniel Okafor: Okafor Design, 410 Congress Ave, Suite 300, Austin, 78701, Country United States (US), State Texas
"United States" and "Texas" from the file are stored as US and TX, so the drop-downs show them.

The other rows worked the same way: Germany became DE, France FR, United Kingdom GB, Canada CA and Ontario ON. A value WooCommerce does not know is saved as it is, so check customers from unusual countries or regions. The “Customer Since” dates became registration dates, for example 30 January 2024 for Daniel.

An existing user keeps their role. If an email in the file belongs to an administrator or a shop manager, that person is not turned into a customer.

Passwords and Welcome Emails

The import gives every new account a random password and sends no emails. That is on purpose: you decide when customers hear about their new accounts.

When the shop is ready, go to Users, filter by Customer, select the customers and choose Send password reset from Bulk actions. Each customer gets a link to set a password. Customers can also use Lost your password? on the My Account page at any time. Passwords from another system cannot be moved with a CSV, because they are stored encrypted.

Customers from Another Store

Common Mistakes

  • Rows without an email. They fail with “A valid customer email is required”. Add the email or create those customers by hand.
  • The same email twice in the file. The second row updates the account created by the first. Remove duplicates before importing if the rows differ.
  • Opening the CSV in Excel and saving it again. Postcodes with leading zeros (01234) and phone numbers starting with + can change. Format those columns as text or edit the file in a text editor. Accented names need the file saved as CSV UTF-8; see CSV Import Shows Broken Characters.
  • Billing columns mapped to shipping or the other way round. Check the mapping list; WooCommerce uses the billing address for invoices and taxes.
  • Sending a password reset to everyone on day one. Do it after the shop is live, or customers will log in to an empty store.

FAQ

Can I import order history with the customers?

Not with the customer import. Total spent and order count are calculated by WooCommerce from the orders that belong to the customer. Orders are a separate import; see How to Import WooCommerce Orders from CSV.

Does it work without WooCommerce billing fields, just names and emails?

Yes. Only Email is required. You can add addresses later with another import, matched by email.

Can I import into a different role, such as wholesale customer?

New accounts get the Customer role. Existing users keep their roles. To move customers to another role afterwards, use Users → Change role to.

Do I need PRO?

Yes, WooCommerce customers are imported with the PRO add-on.

Get the free plugin on WordPress.org.

Dmitriy
About author

Dmitriy

WordPress Developer with 15+ years of commercial experience. Elite Author on ThemeForest and creator of custom WordPress plugins. Passionate about clean code, performance optimization, and building useful tools for the WordPress community.

JOIN THE CONVERSATION

Comments 0

Have a question or a tip to share? Leave it below.

Leave a comment

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

We store your name, email and comment to show and moderate it; your email is never published. Spam protection is provided by Cloudflare Turnstile and profile pictures by Gravatar. See our Privacy Policy.


Try the plugin with no risks!

New users get 1 month with access to all premium features. Experience the most powerful WordPress data engine today.

Download Now
Get PRO for FREE