WooCommerce import customers and export tasks have become increasingly common as stores adopt more marketing tools, CRM systems, and multichannel setups. A reliable process ensures your data moves safely from one system to another without breaking customer accounts or losing important information.
In this guide, we will walk you through the following key points:
- When to import/export WooCommerce customers;
- Easy steps to import WooCommerce customers;
- Detailed guide to export WooCommerce users.
Let’s get started!
When Do You Need Import & Export WooCommerce Customers?
Your customer data won’t stay still as your store grows, and you’ll need to move it from time to time. Importing or exporting WooCommerce customers helps you handle those changes smoothly. Here are the main situations where a WooCommerce import customers task becomes necessary.
1. Migrate from another platform to WooCommerce
If you’re moving to WooCommerce from Shopify, Magento, BigCommerce, or any other platform, importing customers means their accounts are already waiting in the new store, so they don’t have to register again. This helps you retain loyalty and avoid friction during migration.
2. Sync with CRM or email marketing tools
Many businesses export customer data to connect with tools like HubSpot, Mailchimp, Klaviyo, or Salesforce. Having clean customer exports makes it easier to segment audiences, automate campaigns, and run targeted marketing.
3. Back up your customer database
Regular exports allow you to keep safe, offline copies of customer information. This protects your store in case of site crashes, hosting failures, or plugin conflicts.
4. Analyze and segment customer behavior
Exporting customers gives you flexible datasets for deeper analysis. You can build reports, segment buyers, and better understand purchasing trends without relying solely on WooCommerce’s built-in tools.
5. Merge or split stores
If you own multiple stores or are restructuring your business, import–export tools help you combine customer lists or duplicate them across stores while preserving all key data and account details.
6. Support staging and development environments
Developers often export customers from a live site and import them into a staging environment for testing. This keeps test environments realistic without exposing sensitive data manually.
How to Import WooCommerce Customers With CSV File?
WooCommerce doesn’t come with a built-in customer importer (its native CSV importer only handles products). So, to complete a WooCommerce import customers task, you’ll need to install a third-party plugin.
In this article, we’ll work with the Import Export Suite for WooCommerce by WebToffee plugin for demonstration. We chose this plugin because it’s actively maintained with regular updates, and it offers clear CSV mapping options that make the import process easier for beginners.
Beyond WooCommerce import customers jobs, the suite also handles products, orders, coupons, subscriptions, and reviews. It works with CSV, XML, TSV, XLS, and XLSX files, which you can upload from your computer, a URL, FTP/SFTP, or Google Sheets. The plugin costs $129 per year for a single site ($209 for up to 5 sites and $299 for up to 25 sites), and comes with a 30-day money-back guarantee.
Of course, depending on your workflow, other extensions may work as well, so always check your plugin’s documentation for specifics.

Here’s how to perform WooCommerce import customers using the WebToffee Import Export plugin.
Step 1: Map customers data
First, you’ll need to prepare your CSV file so that each column matches the corresponding WooCommerce customer field. This step ensures that the plugin understands what each piece of data represents – such as login details, customer IDs, email addresses, and profile information.
If your CSV headings don’t match WooCommerce’s default format, this mapping step keeps your WooCommerce import customers file aligned so the data imports correctly without errors.
The only mandatory column for a customer import is user_email. If you want the new accounts to be WooCommerce customers, also add a roles column with the value customer. Below is an overview of the main customer fields you’ll encounter and the formats they accept.
|
Column name |
Explanation |
Accepted format |
|
ID |
WordPress user ID of the customer. The plugin can use it to match existing users. |
Numerical Example: 1317, 26515 |
|
customer_id |
Identification number of the customer. |
Numerical Example: 1317, 26515 |
|
user_login |
Username the customer logs in with. |
Letters, numbers, and the characters _ . – @ Example: johndoe or [email protected] |
|
user_pass |
Login password of the customer. It can be plain text or an existing WordPress password hash, which is kept when Retain user passwords is turned on. |
Text or password hash Example: $wp$2y$10$… (a WordPress 6.8+ hash) |
|
user_nicename |
Slug of a nicer-looking name stored only in the database. This value is not displayed in the user’s details page. |
Alpha-numeric characters. Example: customer-nice-name |
|
user_email |
Email address of the customer. This is the only mandatory column. |
Alpha-numeric characters. Example: [email protected] |
|
user_url |
URL of the customer’s own website. |
URL Example: https://johndoe.com |
|
user_registered |
Registration date of the customer. |
Date (YYYY-MM-DD or YYYY-MM-DD HH:MM:SS) Example: 2026-05-26 10:30:00 |
|
display_name |
Display name of the customer. |
Alpha-numeric characters. Example: John Doe |
|
first_name |
First name of the customer. |
Alpha-numeric characters. Example: John |
|
last_name |
Last name of the customer. |
Alpha-numeric characters. Example: Doe |
|
roles |
User role. Set it to customer to create WooCommerce customer accounts. |
Text Example: customer |
|
nickname |
Nickname of the customer. |
Alpha-numeric characters. Example: johndoe101 |
|
description |
Description or short bio of the customer. |
Alpha-numeric characters. |
|
locale |
Language the customer prefers in the dashboard. |
WordPress locale code Example: en_US, es_ES |
|
billing_* fields |
Billing details, such as billing_first_name, billing_email, billing_phone, billing_address_1, billing_city, billing_postcode, billing_state, and billing_country. |
Same formats as the matching shipping fields Example: billing_phone: +1 239 555 0100 |
|
shipping_first_name |
First name in the shipping address. |
Text Example: John |
|
shipping_last_name |
Last name in the shipping address. |
Text Example: Doe |
|
shipping_company |
Company name in the customer’s shipping address. |
Text Example: Acme Inc. |
|
shipping_address_1 |
First line of the street address in the shipping address. |
Alpha-numeric characters. Example: 123 Sample Street |
|
shipping_postcode |
Postal or ZIP code in the shipping address. |
Text (keep any leading zeros) Example: 33901 |
|
shipping_city |
City in the shipping address. |
Text Example: Fort Myers |
|
shipping_state |
State in the shipping address. |
State code Example: FL |
|
shipping_country |
Country in the shipping address. |
2-letter country code Example: US |
Step 2: Install the plugin
To start your WooCommerce import customers task, you’ll need to install the Import Export Suite for WooCommerce by WebToffee plugin.
Since this is a premium plugin, you won’t find it by searching the WordPress plugin directory. Purchase it, download the .zip file, then go to Plugins > Add Plugin > Upload Plugin in your WordPress dashboard to install and activate it. Once activated, the plugin adds a dedicated WebToffee Import/Export (Pro) menu to your dashboard sidebar.

Step 3: Select the import method
From your WordPress dashboard, go to WebToffee Import/Export (Pro) > Import. Select Users/Customers as the post type, then click Step 2: Select import method.

At this stage, you’ll need to choose how you want to run your WooCommerce import customers job. The plugin offers three methods:
- Quick import: Choose this if your CSV was generated using the same plugin. This option skips several steps because the file format already matches the plugin’s requirements.
- From pre-saved template: Reuse the mapping and settings you saved during a previous Advanced import.
- Advanced import: Choose this if your CSV comes from another platform or tool, so you can review and map your fields before bringing the data into WooCommerce.

After selecting your method, upload your file from your computer (drag it into the upload box), a URL, or an FTP location. With Quick import, you can click Import right away. If you’re using the Advanced method, click Step 3: Map import columns to move forward.
Step 4: Map import columns
Mapping is the step where most WooCommerce import customers errors happen, so take your time here. When you reach the mapping screen, the plugin will divide your WooCommerce customer fields into three groups. Review each group and match your CSV columns accordingly:
- Default fields: username, email, first name, last name, and billing/shipping details.
- Meta (custom fields): membership levels, CRM IDs, loyalty points, or any extra profile fields your store uses.
- Hidden meta: These fields store internal or system-level data. They usually don’t need to be mapped unless you’re restoring a full site or migrating highly specific backend information.
If you need to adjust a value during the import, the mapping screen also lets you use an evaluation field, which calculates or combines values from your CSV columns with simple operators.

After completing the mapping, click Step 4: Advanced Options/Batch Import/Scheduling to continue.
Step 5: Configure advanced options/scheduling
When you reach this step, the plugin will display several advanced settings that control how your customer data is handled during the WooCommerce import customers process. You can also save these settings as a template for future imports if needed:
- Update Only: Choose Yes to update data only for customers who already exist in your store. Choose No if you want the plugin to process all rows in your CSV, creating new users when needed.
- Match users by their: Select whether the plugin should identify users based on ID, Email, or Username.
- If the user exists in the store: Decide whether to Skip or Update a user when the system finds a match.
- Retain user passwords: Keep the original password hashes from your file, so customers can log in with their existing passwords instead of resetting them.
- Email new users: Turn this on if you want newly created accounts to receive a registration email. It’s off by default.
- Advanced timeout options: In the expanded Advanced Options panel, you can set how many records are processed per iteration. If your server times out during import, reduce this number and try again.

At the bottom of the page, you can choose to Import your customers right away or Schedule the job.
To schedule the import
Select Schedule, and you’ll be taken to the cron scheduling window. The plugin offers two scheduling methods:
- WordPress Cron: Runs when there is traffic on your site. It checks timestamps and triggers your scheduled import when the set time arrives.
- Server Cron: Generates a unique URL that you can add to your server’s cron jobs. This is more reliable and ideal for large data imports since it doesn’t depend on site visitors.

You can schedule the import to run daily, weekly, monthly, or on a custom schedule, and you can specify the exact time it should run. When ready, confirm the schedule to save the job.
To import immediately
Choose Import to run the process right away. After your WooCommerce import customers job completes, a pop-up will show how many customers were imported successfully and how many failed (if any).
Moving Your Customers to WooCommerce from Another Platform?
LitExtension Automated Migration Tool transfers your customers, products, and orders to WooCommerce, with no CSV formatting or column mapping on your side.

How to Export WooCommerce Customers to CSV?
Now that you know how to import customer data, let’s look at the opposite process – export WooCommerce customers to a CSV file. This is useful when you need to back up your data, migrate to another platform, or prepare information for email marketing and CRM tools.
If you only need a quick customer list, WooCommerce has a built-in option: go to WooCommerce > Customers and click Download to export the current view as a CSV file. For larger lists, WooCommerce prepares the file in the background and emails you a download link. This list covers details like name, email, registration date, orders, total spend, and location, but not custom fields or passwords.
For full customer profiles with meta fields, filters, and scheduling, we’ll walk through the process step by step using the same WebToffee Import Export Suite plugin.
Step 1: Decide the post type
To export WooCommerce customers list, go to WebToffee Import/Export (Pro) > Export.

From here, select Users/Customers as your post type. This tells the plugin exactly which data set you want to export before moving on to the next steps.
Step 2: Choose the export method
After opening the WooCommerce users export screen, you’ll be asked to choose how you want to generate your customer CSV file. The plugin offers three different export methods, each designed for a specific level of control and customization.
Method 1: Quick export
Quick export from DB provides the fastest way to download customer data using the plugin’s standard fields. If you need more than the basic fields, you can enable extra groups like Meta (custom fields) or Hidden meta by selecting their checkboxes.

You can export right away or continue to Step 3 to apply filters.
Method 2: Pre-saved template
A pre-saved template lets you reuse settings you saved during a previous Advanced Export. This option loads all your earlier filters, column selections, and mappings, so you don’t have to rebuild your configuration. You can choose a template from the drop-down and either export right away or move to Step 3 for additional adjustments.

Method 3: Advanced export
Last but not least, this method gives you full control over the export process. You can apply detailed filters, choose specific fields, reorder columns, and configure advanced settings. It’s also where you can save your setup as a template to reuse later.

Step 3: Apply filters to your data
When you move to Step 3, the plugin shows several options that let you control exactly which customers you want to export. These help you narrow down large datasets and extract only the information that matters.
First, you can set how many records to include and in what order:
- Limit: This sets how many users you want to include in the export. For example, entering 500 with an offset of 10 will export users from the 11th to the 510th record.
- Offset: This lets you skip a specific number of users at the beginning of the list. For example, entering 10 skips the first ten users in the export.
- Sort by and order by: These options let you sort the exported data by a specific column, in ascending or descending order.
Then, click Add new filter to build your own conditions. Each filter has an Element (the field to filter on), a Condition, and a Value. For example, you can export only users with the customer role, users with a specific email, or customers who registered within a certain date range. You can add as many filters as you need and remove any of them with the delete icon.

After adjusting your filters, click Step 4 to continue.
Step 4: Map and arrange your export fields
At this stage, you can map and rearrange the columns that will appear in your export file. The fields are grouped into three sections:
- Default fields: Core WooCommerce customer fields that you can rename or reorder.
- Meta (custom fields): Extra fields added by plugins or custom setups that you can include if needed.
- Hidden meta: System-level fields that you may export for more technical or detailed data needs.

After organizing your columns, click Step 5 to proceed.
Step 5: Configure advanced settings
When you reach Step 5, the plugin displays several final settings that let you control how your export file is generated. You can adjust the following options before completing the export:
- Export guest users: Include data from guest checkouts if you want these records in your file.
- Export file name: Set a custom filename, or leave it blank to let the system generate one automatically.
- Export file format: Choose CSV or XML depending on your needs (Excel formats are also supported on the latest versions).
- Delimiter: Select the character used to separate columns in your CSV file (the default is a comma).
- Enable FTP export: Upload the exported file directly to an FTP location by selecting a profile and path.

If you expand Advanced options, you can also control how many records the server processes per iteration. Lowering this number can help if your export times out on larger datasets.

You can save these settings as a template if you want to reuse the same configuration in future exports. Once everything looks right, click Export to generate your file or choose to schedule the export if you want it to run automatically.
Related posts:
WooCommerce Export Subscriptions Orders & Import
How to Create Advanced Order Export for WooCommerce
How to Perform WooCommerce Import Export Customers with Experts?
Handling a WooCommerce import customers project with a plugin is convenient, but it’s not always smooth. Large CSV files can break, field mapping can get confusing, and complex stores often run into timeout errors or missing data.
Instead of struggling through the process alone, you can rely on LitExtension to handle your migration from start to finish. Backed by 15+ years of experience and 300,000+ completed migrations, our team manages every detail – ensuring a seamless WooCommerce transition while your current store keeps running, and complete peace of mind.
With our All-in-One Migration Service, starting from $129 as a one-time payment, the process works in three steps:

Step 1: Consultation with LitExtension experts
The first step in a WooCommerce import customers and export project with LitExtension is a one-on-one consultation with our team of experts.
During this step, we explain the process, answer your questions, and recommend the best approach to ensure an accurate, trouble-free transfer. We then agree on the scope in a service level agreement (SLA), and a dedicated personal assistant keeps you updated on progress throughout the project.
Step 2: Data mapping & setting by experts
In this step, our team carefully maps every customer field from your old platform to the correct WooCommerce structure. We handle core details like names, emails, billing and shipping addresses, and order history, along with any custom fields unique to your business.
Where your source platform supports it, we can also migrate customer passwords, so shoppers log in with their existing credentials. If the password format isn’t compatible, customers simply set a new password after the migration.
Additionally, we also take the time to review your data structure to ensure that everything is aligned properly. Our team sets up and validates your WooCommerce store for the migration, and adjusts the settings to accommodate your specific requirements, whether it’s handling complex customer data or ensuring seamless integration with your WooCommerce store.
With this level of attention, we make sure no information is misplaced or overlooked. Your customer data is prepared accurately and configured correctly for WooCommerce, creating a stable foundation for a smooth and uninterrupted migration.
Step 3: Perform full WooCommerce import/export
Once the data mapping is complete, our team runs the full WooCommerce import customers process to transfer all records into your WooCommerce store. This includes core details like contact information, purchase history, and any custom fields.
We use advanced automation to handle large data volumes efficiently while minimizing errors or data loss. Throughout the process, we run multiple rounds of checks with our in-house automated testing system to make sure every field is correctly formatted and working properly in WooCommerce.
After the migration, you get 2 free re-migrations and up to 60 days of support, so your customers can access their accounts without interruption.
Let Our Experts Handle Your WooCommerce Migration!
With the All-in-One Migration Service, our experts map, transfer, and test your WooCommerce customer data, so every account is ready before you launch.

WooCommerce Import Customers: FAQs
How to import customers in WooCommerce?
WooCommerce does not include a built-in customer importer, so for WooCommerce import customers tasks, you’ll need a plugin like Import Export Suite for WooCommerce (WebToffee). After installing the plugin, go to WebToffee Import/Export (Pro) > Import, choose Users/Customers, upload your CSV file, map your fields, and run the import. Turn on Retain user passwords if you want customers to keep their existing passwords. The plugin will create or update customer accounts based on your settings.
How to migrate WooCommerce customers?
To migrate customers from another platform to WooCommerce, you can export your customer data as a CSV file, then import it into WooCommerce using a plugin. For large or complex WooCommerce import customers projects, most merchants choose a professional migration service like LitExtension. We handle data mapping, customer passwords (where the source platform supports it), and order history linking, then run the full migration while your current store keeps running.
How do I add customers to WooCommerce?
You can add customers manually by going to Users > Add User in your WordPress dashboard, creating an account, and setting its role to Customer. For bulk additions, use a CSV import plugin to upload multiple customer profiles at once. This is the fastest option when setting up a new store or migrating from another platform.
How to export WooCommerce customers to CSV?
For a basic list, go to WooCommerce > Customers and click Download to get a CSV file. For full profiles with custom fields, use the Import Export Suite plugin: go to WebToffee Import/Export (Pro) > Export, choose Users/Customers, select your export method (Quick, Template, or Advanced), apply filters if needed, and download the CSV file. The export will include all selected customer fields and metadata.
Final Words
In short, the WooCommerce import customers process is essential for businesses looking to maintain their customer base during platform changes or updates. Whether you’re migrating from another platform or simply need to import customer data into your WooCommerce store, using the right tools and methods ensures accuracy and efficiency.
If you like this article and want to learn more about WooCommerce tutorial, don’t forget to check out other WooCommerce blogs on our website.
WooCommerce import customers and export tasks have become increasingly common as stores adopt more marketing tools, CRM systems, and multichannel setups. A reliable process ensures your data moves safely from one system to another without breaking customer accounts or losing important information.
In this guide, we will walk you through the following key points:
- When to import/export WooCommerce customers;
- Easy steps to import WooCommerce customers;
- Detailed guide to export WooCommerce users.
Let’s get started!
When Do You Need Import & Export WooCommerce Customers?
Your customer data won’t stay still as your store grows, and you’ll need to move it from time to time. Importing or exporting WooCommerce customers helps you handle those changes smoothly. Here are the main situations where a WooCommerce import customers task becomes necessary.
1. Migrate from another platform to WooCommerce
If you’re moving to WooCommerce from Shopify, Magento, BigCommerce, or any other platform, importing customers means their accounts are already waiting in the new store, so they don’t have to register again. This helps you retain loyalty and avoid friction during migration.
2. Sync with CRM or email marketing tools
Many businesses export customer data to connect with tools like HubSpot, Mailchimp, Klaviyo, or Salesforce. Having clean customer exports makes it easier to segment audiences, automate campaigns, and run targeted marketing.
3. Back up your customer database
Regular exports allow you to keep safe, offline copies of customer information. This protects your store in case of site crashes, hosting failures, or plugin conflicts.
4. Analyze and segment customer behavior
Exporting customers gives you flexible datasets for deeper analysis. You can build reports, segment buyers, and better understand purchasing trends without relying solely on WooCommerce’s built-in tools.
5. Merge or split stores
If you own multiple stores or are restructuring your business, import–export tools help you combine customer lists or duplicate them across stores while preserving all key data and account details.
6. Support staging and development environments
Developers often export customers from a live site and import them into a staging environment for testing. This keeps test environments realistic without exposing sensitive data manually.
How to Import WooCommerce Customers With CSV File?
WooCommerce doesn’t come with a built-in customer importer (its native CSV importer only handles products). So, to complete a WooCommerce import customers task, you’ll need to install a third-party plugin.
In this article, we’ll work with the Import Export Suite for WooCommerce by WebToffee plugin for demonstration. We chose this plugin because it’s actively maintained with regular updates, and it offers clear CSV mapping options that make the import process easier for beginners.
Beyond WooCommerce import customers jobs, the suite also handles products, orders, coupons, subscriptions, and reviews. It works with CSV, XML, TSV, XLS, and XLSX files, which you can upload from your computer, a URL, FTP/SFTP, or Google Sheets. The plugin costs $129 per year for a single site ($209 for up to 5 sites and $299 for up to 25 sites), and comes with a 30-day money-back guarantee.
Of course, depending on your workflow, other extensions may work as well, so always check your plugin’s documentation for specifics.

Here’s how to perform WooCommerce import customers using the WebToffee Import Export plugin.
Step 1: Map customers data
First, you’ll need to prepare your CSV file so that each column matches the corresponding WooCommerce customer field. This step ensures that the plugin understands what each piece of data represents – such as login details, customer IDs, email addresses, and profile information.
If your CSV headings don’t match WooCommerce’s default format, this mapping step keeps your WooCommerce import customers file aligned so the data imports correctly without errors.
The only mandatory column for a customer import is user_email. If you want the new accounts to be WooCommerce customers, also add a roles column with the value customer. Below is an overview of the main customer fields you’ll encounter and the formats they accept.
|
Column name |
Explanation |
Accepted format |
|
ID |
WordPress user ID of the customer. The plugin can use it to match existing users. |
Numerical Example: 1317, 26515 |
|
customer_id |
Identification number of the customer. |
Numerical Example: 1317, 26515 |
|
user_login |
Username the customer logs in with. |
Letters, numbers, and the characters _ . – @ Example: johndoe or [email protected] |
|
user_pass |
Login password of the customer. It can be plain text or an existing WordPress password hash, which is kept when Retain user passwords is turned on. |
Text or password hash Example: $wp$2y$10$… (a WordPress 6.8+ hash) |
|
user_nicename |
Slug of a nicer-looking name stored only in the database. This value is not displayed in the user’s details page. |
Alpha-numeric characters. Example: customer-nice-name |
|
user_email |
Email address of the customer. This is the only mandatory column. |
Alpha-numeric characters. Example: [email protected] |
|
user_url |
URL of the customer’s own website. |
URL Example: https://johndoe.com |
|
user_registered |
Registration date of the customer. |
Date (YYYY-MM-DD or YYYY-MM-DD HH:MM:SS) Example: 2026-05-26 10:30:00 |
|
display_name |
Display name of the customer. |
Alpha-numeric characters. Example: John Doe |
|
first_name |
First name of the customer. |
Alpha-numeric characters. Example: John |
|
last_name |
Last name of the customer. |
Alpha-numeric characters. Example: Doe |
|
roles |
User role. Set it to customer to create WooCommerce customer accounts. |
Text Example: customer |
|
nickname |
Nickname of the customer. |
Alpha-numeric characters. Example: johndoe101 |
|
description |
Description or short bio of the customer. |
Alpha-numeric characters. |
|
locale |
Language the customer prefers in the dashboard. |
WordPress locale code Example: en_US, es_ES |
|
billing_* fields |
Billing details, such as billing_first_name, billing_email, billing_phone, billing_address_1, billing_city, billing_postcode, billing_state, and billing_country. |
Same formats as the matching shipping fields Example: billing_phone: +1 239 555 0100 |
|
shipping_first_name |
First name in the shipping address. |
Text Example: John |
|
shipping_last_name |
Last name in the shipping address. |
Text Example: Doe |
|
shipping_company |
Company name in the customer’s shipping address. |
Text Example: Acme Inc. |
|
shipping_address_1 |
First line of the street address in the shipping address. |
Alpha-numeric characters. Example: 123 Sample Street |
|
shipping_postcode |
Postal or ZIP code in the shipping address. |
Text (keep any leading zeros) Example: 33901 |
|
shipping_city |
City in the shipping address. |
Text Example: Fort Myers |
|
shipping_state |
State in the shipping address. |
State code Example: FL |
|
shipping_country |
Country in the shipping address. |
2-letter country code Example: US |
Step 2: Install the plugin
To start your WooCommerce import customers task, you’ll need to install the Import Export Suite for WooCommerce by WebToffee plugin.
Since this is a premium plugin, you won’t find it by searching the WordPress plugin directory. Purchase it, download the .zip file, then go to Plugins > Add Plugin > Upload Plugin in your WordPress dashboard to install and activate it. Once activated, the plugin adds a dedicated WebToffee Import/Export (Pro) menu to your dashboard sidebar.

Step 3: Select the import method
From your WordPress dashboard, go to WebToffee Import/Export (Pro) > Import. Select Users/Customers as the post type, then click Step 2: Select import method.

At this stage, you’ll need to choose how you want to run your WooCommerce import customers job. The plugin offers three methods:
- Quick import: Choose this if your CSV was generated using the same plugin. This option skips several steps because the file format already matches the plugin’s requirements.
- From pre-saved template: Reuse the mapping and settings you saved during a previous Advanced import.
- Advanced import: Choose this if your CSV comes from another platform or tool, so you can review and map your fields before bringing the data into WooCommerce.

After selecting your method, upload your file from your computer (drag it into the upload box), a URL, or an FTP location. With Quick import, you can click Import right away. If you’re using the Advanced method, click Step 3: Map import columns to move forward.
Step 4: Map import columns
Mapping is the step where most WooCommerce import customers errors happen, so take your time here. When you reach the mapping screen, the plugin will divide your WooCommerce customer fields into three groups. Review each group and match your CSV columns accordingly:
- Default fields: username, email, first name, last name, and billing/shipping details.
- Meta (custom fields): membership levels, CRM IDs, loyalty points, or any extra profile fields your store uses.
- Hidden meta: These fields store internal or system-level data. They usually don’t need to be mapped unless you’re restoring a full site or migrating highly specific backend information.
If you need to adjust a value during the import, the mapping screen also lets you use an evaluation field, which calculates or combines values from your CSV columns with simple operators.

After completing the mapping, click Step 4: Advanced Options/Batch Import/Scheduling to continue.
Step 5: Configure advanced options/scheduling
When you reach this step, the plugin will display several advanced settings that control how your customer data is handled during the WooCommerce import customers process. You can also save these settings as a template for future imports if needed:
- Update Only: Choose Yes to update data only for customers who already exist in your store. Choose No if you want the plugin to process all rows in your CSV, creating new users when needed.
- Match users by their: Select whether the plugin should identify users based on ID, Email, or Username.
- If the user exists in the store: Decide whether to Skip or Update a user when the system finds a match.
- Retain user passwords: Keep the original password hashes from your file, so customers can log in with their existing passwords instead of resetting them.
- Email new users: Turn this on if you want newly created accounts to receive a registration email. It’s off by default.
- Advanced timeout options: In the expanded Advanced Options panel, you can set how many records are processed per iteration. If your server times out during import, reduce this number and try again.

At the bottom of the page, you can choose to Import your customers right away or Schedule the job.
To schedule the import
Select Schedule, and you’ll be taken to the cron scheduling window. The plugin offers two scheduling methods:
- WordPress Cron: Runs when there is traffic on your site. It checks timestamps and triggers your scheduled import when the set time arrives.
- Server Cron: Generates a unique URL that you can add to your server’s cron jobs. This is more reliable and ideal for large data imports since it doesn’t depend on site visitors.

You can schedule the import to run daily, weekly, monthly, or on a custom schedule, and you can specify the exact time it should run. When ready, confirm the schedule to save the job.
To import immediately
Choose Import to run the process right away. After your WooCommerce import customers job completes, a pop-up will show how many customers were imported successfully and how many failed (if any).
Moving Your Customers to WooCommerce from Another Platform?
LitExtension Automated Migration Tool transfers your customers, products, and orders to WooCommerce, with no CSV formatting or column mapping on your side.

How to Export WooCommerce Customers to CSV?
Now that you know how to import customer data, let’s look at the opposite process – export WooCommerce customers to a CSV file. This is useful when you need to back up your data, migrate to another platform, or prepare information for email marketing and CRM tools.
If you only need a quick customer list, WooCommerce has a built-in option: go to WooCommerce > Customers and click Download to export the current view as a CSV file. For larger lists, WooCommerce prepares the file in the background and emails you a download link. This list covers details like name, email, registration date, orders, total spend, and location, but not custom fields or passwords.
For full customer profiles with meta fields, filters, and scheduling, we’ll walk through the process step by step using the same WebToffee Import Export Suite plugin.
Step 1: Decide the post type
To export WooCommerce customers list, go to WebToffee Import/Export (Pro) > Export.

From here, select Users/Customers as your post type. This tells the plugin exactly which data set you want to export before moving on to the next steps.
Step 2: Choose the export method
After opening the WooCommerce users export screen, you’ll be asked to choose how you want to generate your customer CSV file. The plugin offers three different export methods, each designed for a specific level of control and customization.
Method 1: Quick export
Quick export from DB provides the fastest way to download customer data using the plugin’s standard fields. If you need more than the basic fields, you can enable extra groups like Meta (custom fields) or Hidden meta by selecting their checkboxes.

You can export right away or continue to Step 3 to apply filters.
Method 2: Pre-saved template
A pre-saved template lets you reuse settings you saved during a previous Advanced Export. This option loads all your earlier filters, column selections, and mappings, so you don’t have to rebuild your configuration. You can choose a template from the drop-down and either export right away or move to Step 3 for additional adjustments.

Method 3: Advanced export
Last but not least, this method gives you full control over the export process. You can apply detailed filters, choose specific fields, reorder columns, and configure advanced settings. It’s also where you can save your setup as a template to reuse later.

Step 3: Apply filters to your data
When you move to Step 3, the plugin shows several options that let you control exactly which customers you want to export. These help you narrow down large datasets and extract only the information that matters.
First, you can set how many records to include and in what order:
- Limit: This sets how many users you want to include in the export. For example, entering 500 with an offset of 10 will export users from the 11th to the 510th record.
- Offset: This lets you skip a specific number of users at the beginning of the list. For example, entering 10 skips the first ten users in the export.
- Sort by and order by: These options let you sort the exported data by a specific column, in ascending or descending order.
Then, click Add new filter to build your own conditions. Each filter has an Element (the field to filter on), a Condition, and a Value. For example, you can export only users with the customer role, users with a specific email, or customers who registered within a certain date range. You can add as many filters as you need and remove any of them with the delete icon.

After adjusting your filters, click Step 4 to continue.
Step 4: Map and arrange your export fields
At this stage, you can map and rearrange the columns that will appear in your export file. The fields are grouped into three sections:
- Default fields: Core WooCommerce customer fields that you can rename or reorder.
- Meta (custom fields): Extra fields added by plugins or custom setups that you can include if needed.
- Hidden meta: System-level fields that you may export for more technical or detailed data needs.

After organizing your columns, click Step 5 to proceed.
Step 5: Configure advanced settings
When you reach Step 5, the plugin displays several final settings that let you control how your export file is generated. You can adjust the following options before completing the export:
- Export guest users: Include data from guest checkouts if you want these records in your file.
- Export file name: Set a custom filename, or leave it blank to let the system generate one automatically.
- Export file format: Choose CSV or XML depending on your needs (Excel formats are also supported on the latest versions).
- Delimiter: Select the character used to separate columns in your CSV file (the default is a comma).
- Enable FTP export: Upload the exported file directly to an FTP location by selecting a profile and path.

If you expand Advanced options, you can also control how many records the server processes per iteration. Lowering this number can help if your export times out on larger datasets.

You can save these settings as a template if you want to reuse the same configuration in future exports. Once everything looks right, click Export to generate your file or choose to schedule the export if you want it to run automatically.
Related posts:
WooCommerce Export Subscriptions Orders & Import
How to Create Advanced Order Export for WooCommerce
How to Perform WooCommerce Import Export Customers with Experts?
Handling a WooCommerce import customers project with a plugin is convenient, but it’s not always smooth. Large CSV files can break, field mapping can get confusing, and complex stores often run into timeout errors or missing data.
Instead of struggling through the process alone, you can rely on LitExtension to handle your migration from start to finish. Backed by 15+ years of experience and 300,000+ completed migrations, our team manages every detail – ensuring a seamless WooCommerce transition while your current store keeps running, and complete peace of mind.
With our All-in-One Migration Service, starting from $129 as a one-time payment, the process works in three steps:

Step 1: Consultation with LitExtension experts
The first step in a WooCommerce import customers and export project with LitExtension is a one-on-one consultation with our team of experts.
During this step, we explain the process, answer your questions, and recommend the best approach to ensure an accurate, trouble-free transfer. We then agree on the scope in a service level agreement (SLA), and a dedicated personal assistant keeps you updated on progress throughout the project.
Step 2: Data mapping & setting by experts
In this step, our team carefully maps every customer field from your old platform to the correct WooCommerce structure. We handle core details like names, emails, billing and shipping addresses, and order history, along with any custom fields unique to your business.
Where your source platform supports it, we can also migrate customer passwords, so shoppers log in with their existing credentials. If the password format isn’t compatible, customers simply set a new password after the migration.
Additionally, we also take the time to review your data structure to ensure that everything is aligned properly. Our team sets up and validates your WooCommerce store for the migration, and adjusts the settings to accommodate your specific requirements, whether it’s handling complex customer data or ensuring seamless integration with your WooCommerce store.
With this level of attention, we make sure no information is misplaced or overlooked. Your customer data is prepared accurately and configured correctly for WooCommerce, creating a stable foundation for a smooth and uninterrupted migration.
Step 3: Perform full WooCommerce import/export
Once the data mapping is complete, our team runs the full WooCommerce import customers process to transfer all records into your WooCommerce store. This includes core details like contact information, purchase history, and any custom fields.
We use advanced automation to handle large data volumes efficiently while minimizing errors or data loss. Throughout the process, we run multiple rounds of checks with our in-house automated testing system to make sure every field is correctly formatted and working properly in WooCommerce.
After the migration, you get 2 free re-migrations and up to 60 days of support, so your customers can access their accounts without interruption.
Let Our Experts Handle Your WooCommerce Migration!
With the All-in-One Migration Service, our experts map, transfer, and test your WooCommerce customer data, so every account is ready before you launch.

WooCommerce Import Customers: FAQs
How to import customers in WooCommerce?
WooCommerce does not include a built-in customer importer, so for WooCommerce import customers tasks, you’ll need a plugin like Import Export Suite for WooCommerce (WebToffee). After installing the plugin, go to WebToffee Import/Export (Pro) > Import, choose Users/Customers, upload your CSV file, map your fields, and run the import. Turn on Retain user passwords if you want customers to keep their existing passwords. The plugin will create or update customer accounts based on your settings.
How to migrate WooCommerce customers?
To migrate customers from another platform to WooCommerce, you can export your customer data as a CSV file, then import it into WooCommerce using a plugin. For large or complex WooCommerce import customers projects, most merchants choose a professional migration service like LitExtension. We handle data mapping, customer passwords (where the source platform supports it), and order history linking, then run the full migration while your current store keeps running.
How do I add customers to WooCommerce?
You can add customers manually by going to Users > Add User in your WordPress dashboard, creating an account, and setting its role to Customer. For bulk additions, use a CSV import plugin to upload multiple customer profiles at once. This is the fastest option when setting up a new store or migrating from another platform.
How to export WooCommerce customers to CSV?
For a basic list, go to WooCommerce > Customers and click Download to get a CSV file. For full profiles with custom fields, use the Import Export Suite plugin: go to WebToffee Import/Export (Pro) > Export, choose Users/Customers, select your export method (Quick, Template, or Advanced), apply filters if needed, and download the CSV file. The export will include all selected customer fields and metadata.
Final Words
In short, the WooCommerce import customers process is essential for businesses looking to maintain their customer base during platform changes or updates. Whether you’re migrating from another platform or simply need to import customer data into your WooCommerce store, using the right tools and methods ensures accuracy and efficiency.
If you like this article and want to learn more about WooCommerce tutorial, don’t forget to check out other WooCommerce blogs on our website.
