How to Import WooCommerce Customers from CSV (Step-by-Step)

Importing customers into WooCommerce usually starts with a specific need. You may be migrating from another platform, setting up a new WooCommerce store, bulk updating existing customer records, or syncing customer data from a CRM or external system.

In each of these cases, adding customers manually can quickly become time-consuming and error-prone, especially when you’re working with hundreds or thousands of records. A structured import process helps you move customer details such as names, email addresses, billing and shipping information, roles, and user metadata more accurately.

Unlike products, WooCommerce does not include a built-in customer importer. So, to import users or customers in bulk, you’ll need a dedicated customer import plugin. In this guide, we’ll show you how to import customers into WooCommerce from a CSV file using the free Import Export WooCommerce Customers plugin by WebToffee.

We’ll use WebToffee’s free WooCommerce Customers Import Export plugin for this tutorial. Before starting, make sure you have the customer data you want to import saved as a CSV file.

Step 1: Prepare Your WooCommerce Customer CSV File

Your CSV file should contain one customer per row, with each type of customer information stored in a separate column.

At a minimum, include the information required to identify and create each customer account.

Customer field	What it contains	Example
Username	Customer login name	johnsmith
Email	Customer email address	[email protected]
First name	Customer’s first name	John
Last name	Customer’s last name	Smith
Role	WordPress/WooCommerce user role	customer
Billing details	Billing name, address, city, postcode, etc.	25 Main Street
Shipping details	Customer shipping information	25 Main Street
Password	Existing password data, when applicable	Password value

The username and email address are the primary fields needed for a customer import. Billing information, shipping details, passwords, and other account data can be included depending on what you want to migrate.

If you’re migrating customers from another WordPress or WooCommerce store, you can export the existing users first and use the resulting CSV for the import

Step 2: Install WebToffee WooCommerce Customer Import Export Plugin

From your WordPress dashboard,

• Go to Plugins > Add New Plugin.
• Search ‘WordPress users and WooCommerce customers import export’ plugin by WebToffee.
• Install and Activate the plugin.

Step 3: Select User/Customer as Post Type to Import

• Go to WebToffee Import Export (Basic) and select the Import submenu.
• Choose the post type as ‘User/Customer‘.

Step 4: Select Advanced Import Method

You can choose from two options: Quick and Advanced import.

If you are using the plugin for the first time and need all user fields imported, I recommend the Advanced import method.

Next, upload the CSV file for importing.

Step 5: Map & Reorder Columns for Import 

To ensure that the right data is imported into the right user fields, you must map the column headers of the CSV to match the WooCommerce user data fields. This is especially useful when migrating from a different platform like Magento, Shopify, etc.

Step 6: Import Customers

This is the final step in the import process. Here, you have the options to merge the user details in the CSV file with the existing data by choosing update, retaining the existing user passwords, configuring the import batch count, etc.

Once you have configured the options, click the Import button to start importing user data.

Now, all the users in the CSV file will be imported to your WooCommerce store and reflected on the WordPress Users’ page.

If you want more features out of the plugin, such as automated scheduled import, XML file type support (in addition to CSV), custom fields (metadata) import, etc., you can get the plugin’s premium version.

WooCommerce customers are stored as WordPress users.

WooCommerce then adds ecommerce-specific information to those user accounts, including billing addresses, shipping addresses, and other customer-related metadata.

This is why a newly imported customer will appear under:

WordPress → Users → All Users

A customer’s WooCommerce-specific details are stored alongside the underlying WordPress user account.

This also explains why importing WooCommerce customers can involve more than simply importing names and email addresses. A complete customer migration may need to preserve account credentials, roles, billing information, shipping details, and other metadata.

Customer passwords can be retained during supported WooCommerce customer migrations. This can be especially important when moving customers from one WordPress or WooCommerce store to another because forcing every customer to reset their password after migration can create unnecessary friction.

To retain existing passwords, make sure the relevant password information is included in the import file and configure the password option during import.

How passwords should be handled can depend on where the customer data originated. If you’re moving customer accounts between WooCommerce sites, preserving the existing WordPress password data can allow customers to continue using their existing credentials.

Always test customer login behavior before completing a major store migration.

Customer imports are generally straightforward when the source file is properly structured, but there are several issues worth checking if the import doesn’t produce the expected results.

1. Customers Were Imported but Don’t Appear Where Expected

Remember that WooCommerce customers are stored as WordPress users. Start by checking:

WordPress → Users → All Users

Then verify the user’s assigned role and imported WooCommerce account data.

2. Existing Customers Are Being Duplicated or Overwritten

Review the existing-user configuration before importing.

If you’re synchronizing customer data, configure the import to update existing users appropriately. If you only want to create new customer accounts, use the option that prevents existing records from being changed.

3. Billing or Shipping Details Are Missing

Return to the field mapping step and check whether the corresponding CSV columns were mapped to the correct WooCommerce billing and shipping fields.

A successful import does not necessarily mean every field was mapped correctly.

4. Customer Data Appears in the Wrong Fields

This usually points to incorrect column mapping.

Check the CSV headers and confirm that each source column is mapped to the intended WooCommerce customer field.

5. Special Characters Are Incorrect

Check whether the CSV file is saved using UTF-8 encoding.

Incorrect file encoding can cause customer names, addresses, or other data containing special characters to display incorrectly.

6. Large Customer Imports Time Out

Try reducing the import batch count.

Processing fewer customer records at a time can help when your hosting environment has limited server resources.

7. Customer Passwords Don’t Work After Migration

Check how the password data was exported from the original system and how it was configured during import.

Password migration should always be tested with a small number of customer accounts before a full migration is completed.

There are several plugins available for importing WooCommerce customers, but they differ in supported formats, ease of use, pricing, and migration features. Here is a quick comparison of three popular options:

Plugin	Supported Formats	Bulk Import Capability	Free vs Paid	Key Limitations
WebToffee Import Export WooCommerce Customers	CSV in free version; CSV, XML, TSV, XLS, and XLSX in premium	Yes	Free version available; premium upgrade available	Free version is mainly CSV-based. Advanced formats, custom metadata, scheduled import/export, and FTP/SFTP automation require premium.
WP All Import	CSV and XML	Yes	Paid add-ons may be required for user/customer import workflows	Powerful and flexible, but more complex for beginners. Customer/user import often requires add-ons, and export workflows may require a separate WP All Export setup.
Import Export WordPress Users and WooCommerce Customers	CSV	Yes	Free plugin on WordPress.org	Useful for basic CSV import/export, but advanced formats, deeper metadata handling, and automation are limited compared with premium tools.

For most WooCommerce stores, WebToffee’s Import Export WooCommerce Customers plugin is the recommended choice because it is built specifically for WordPress users and WooCommerce customers. It supports customer imports, exports, password retention, field mapping, batch processing, and update/skip options for existing users.

The free version is a strong choice for CSV-based imports and exports. If you need advanced migration features such as XML support, Excel files, custom user metadata, guest customer export, or scheduled FTP/SFTP workflows, the premium version gives you more control.

The premium version of the WooCommerce Customers Import Export plugin is designed to make customer data migration easier with a range of advanced features, such as:

• Support for More File Formats: Support for exporting and importing data in XML, TSV, and Excel formats. Enhances compatibility with various platforms and tools.
• Advanced Filtering Capabilities: Fine-tune your exports by applying advanced filters to extract specific subsets of customer data based on custom criteria.
• Bulk Edit Functionality During Import: Make mass updates or changes to customer records directly while importing, saving time and reducing manual effort.
• Customer Metadata Export: Export detailed customer metadata, including custom fields and additional user information for deeper insights and reporting.
• Automated FTP/SFTP Export Scheduling: Set up scheduled exports to FTP/SFTP servers, automating data delivery at regular intervals for seamless integration with other systems.
• Support for Guest Customer Data: Export options include data for guest customers, ensuring a complete view of all store interactions, even from non-registered users.

Whether handling large imports, automating exports, or focusing on specific customer data, this plugin is one of the best solutions for quickly and efficiently importing customers into your WooCommerce store.

WooCommerce doesn’t include a built-in tool for bulk-importing customers, but a customer import plugin makes the process straightforward.

With WebToffee’s free WooCommerce Customers Import Export plugin, you can prepare a CSV file, upload it to your store, map the customer fields, configure how existing users should be handled, and import customer accounts in bulk.

The most important part of the process is preparing the source data correctly and verifying the imported accounts afterward. This is especially important when you’re migrating customer passwords, billing and shipping details, or updating users who already exist in the destination store.

For simple CSV imports, the free plugin provides the essential tools you need. For more advanced migrations involving additional file formats, custom metadata, guest customer data, or automated workflows, you can use the premium version.

Hope this article provided you with a clear understanding of how to import customers using this plugin. If you have any questions or feedback, feel free to leave a comment below and we will be happy to assist!