LitExtension Blog
  • Ecommerce Platforms
    • Shopify
    • WooCommerce
    • Magento (Adobe Commerce)
    • Wix
    • Other Platforms
  • eCommerce Migration
    • Shopify Migration
    • WooCommerce Migration
    • Magento Migration
    • Other Migrations
  • Store Growth
  • LitExtension
    • LitExtension Updates
    • Case Study
No Result
View All Result
VISIT LITEXTENSION
LitExtension Blog
  • Ecommerce Platforms
    • Shopify
    • WooCommerce
    • Magento (Adobe Commerce)
    • Wix
    • Other Platforms
  • eCommerce Migration
    • Shopify Migration
    • WooCommerce Migration
    • Magento Migration
    • Other Migrations
  • Store Growth
  • LitExtension
    • LitExtension Updates
    • Case Study
No Result
View All Result
VISIT LITEXTENSION
LitExtension Blog
No Result
View All Result

WooCommerce Import Customers & Export: 2026 How-to Guide

by Kristen Quach
Nov, 2026
in Ecommerce Platforms, WordPress

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.

Import Export Suite for WooCommerce
Import Export Suite for WooCommerce

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 2: Install the plugin
Step 2: Install the plugin.

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.

Step 3a: Select post type
Step 3a: Select post type

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.
Step 3b: Select quick or advanced import method
Step 3b: Select quick or advanced import method

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.

Step 4: Map import columns
Step 4: Map import columns

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.
Step 5a: Configure advanced options
Step 5a: Configure advanced options.

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.
Step 5b: Schedule the import
Step 5b: Schedule the import

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.

START FREE DEMO

LitExtension Automated Migration Tool Demo

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.

Step 1a: Open the Export tab
Step 1a: Open the Export page

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.

Method 1: Quick export WooCommerce customers
Method 1: Quick export WooCommerce customers

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 2: Pre-saved templates
Method 2: Pre-saved templates

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.

Method 3: Advanced export WooCommerce customers
Method 3: Advanced export WooCommerce customers

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.

Step 3: Filter export data
Step 3: Filter export data.

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.
Step 4: Map and reorder export columns
Step 4: Map and reorder export columns

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.
Step 5a: Export or schedule
Step 5a: Export or schedule

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.

Step 5b: Configure advanced options for export
Step 5b: Configure advanced options for export

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 Export WooCommerce Orders by 4 Methods

WooCommerce Import Orders: The Complete Guide


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:

WooCommerce migration by LitExtension
WooCommerce migration by LitExtension

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.

BOOK FREE CONSULTATION

All-in-One Migration Service

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.

Import Export Suite for WooCommerce
Import Export Suite for WooCommerce

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 2: Install the plugin
Step 2: Install the plugin.

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.

Step 3a: Select post type
Step 3a: Select post type

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.
Step 3b: Select quick or advanced import method
Step 3b: Select quick or advanced import method

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.

Step 4: Map import columns
Step 4: Map import columns

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.
Step 5a: Configure advanced options
Step 5a: Configure advanced options.

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.
Step 5b: Schedule the import
Step 5b: Schedule the import

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.

START FREE DEMO

LitExtension Automated Migration Tool Demo

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.

Step 1a: Open the Export tab
Step 1a: Open the Export page

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.

Method 1: Quick export WooCommerce customers
Method 1: Quick export WooCommerce customers

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 2: Pre-saved templates
Method 2: Pre-saved templates

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.

Method 3: Advanced export WooCommerce customers
Method 3: Advanced export WooCommerce customers

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.

Step 3: Filter export data
Step 3: Filter export data.

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.
Step 4: Map and reorder export columns
Step 4: Map and reorder export columns

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.
Step 5a: Export or schedule
Step 5a: Export or schedule

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.

Step 5b: Configure advanced options for export
Step 5b: Configure advanced options for export

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 Export WooCommerce Orders by 4 Methods

WooCommerce Import Orders: The Complete Guide


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:

WooCommerce migration by LitExtension
WooCommerce migration by LitExtension

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.

BOOK FREE CONSULTATION

All-in-One Migration Service

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.

Previous Post

How to Upload CSV to Salesforce by 10 Different Methods 2026

Next Post

Shopify Import Metafields & Export: The Best Methods in 2026

Kristen Quach

Kristen Quach

Meet Kristen, a passionate advocate for eCommerce success and Content Team Leader at LitExtension. Her expertise in the dynamic world of eCommerce, particularly in WooCommerce, allows her to provide valuable guidance and practical strategies that help businesses thrive in the digital age.

Table of Contents
  1. When Do You Need Import & Export WooCommerce Customers?
    1. 1. Migrate from another platform to WooCommerce
    2. 2. Sync with CRM or email marketing tools
    3. 3. Back up your customer database
    4. 4. Analyze and segment customer behavior
    5. 5. Merge or split stores
    6. 6. Support staging and development environments
  2. How to Import WooCommerce Customers With CSV File?
    1. Step 1: Map customers data
    2. Step 2: Install the plugin
    3. Step 3: Select the import method
    4. Step 4: Map import columns
    5. Step 5: Configure advanced options/scheduling
  3. How to Export WooCommerce Customers to CSV?
    1. Step 1: Decide the post type
    2. Step 2: Choose the export method
    3. Step 3: Apply filters to your data
    4. Step 4: Map and arrange your export fields
    5. Step 5: Configure advanced settings
  4. How to Perform WooCommerce Import Export Customers with Experts?
    1. Step 1: Consultation with LitExtension experts
    2. Step 2: Data mapping & setting by experts
    3. Step 3: Perform full WooCommerce import/export
  5. WooCommerce Import Customers: FAQs
  6. Final Words
  7. When Do You Need Import & Export WooCommerce Customers?
    1. 1. Migrate from another platform to WooCommerce
    2. 2. Sync with CRM or email marketing tools
    3. 3. Back up your customer database
    4. 4. Analyze and segment customer behavior
    5. 5. Merge or split stores
    6. 6. Support staging and development environments
  8. How to Import WooCommerce Customers With CSV File?
    1. Step 1: Map customers data
    2. Step 2: Install the plugin
    3. Step 3: Select the import method
    4. Step 4: Map import columns
    5. Step 5: Configure advanced options/scheduling
  9. How to Export WooCommerce Customers to CSV?
    1. Step 1: Decide the post type
    2. Step 2: Choose the export method
    3. Step 3: Apply filters to your data
    4. Step 4: Map and arrange your export fields
    5. Step 5: Configure advanced settings
  10. How to Perform WooCommerce Import Export Customers with Experts?
    1. Step 1: Consultation with LitExtension experts
    2. Step 2: Data mapping & setting by experts
    3. Step 3: Perform full WooCommerce import/export
  11. WooCommerce Import Customers: FAQs
  12. Final Words
woocommerce-migration-litextension

Popular eCommerce Migration

  1. Shopify Migration
  2. WooCommerce Migration
  3. Magento Migration
  4. BigCommerce Migration
  5. PrestaShop Migration

Best Ecommerce Platforms

  1. Shopify Review
  2. WooCommerce Review
  3. Wix Ecommerce Review
  4. BigCommerce Review
  5. Best Ecommerce Platforms

 

Popular Migration Pairs

  • Wix to Shopify
  • Magento to Shopify
  • BigCommerce to Shopify
  • WooCommerce to Shopify
  • Shopify to WooCommerce

Company

  • About LitExtension
  • Success Stories
  • Sitemap
  • Disclosures
  • Our Author
  • Contact Us

DMCA.com Protection Status

  • All the Basics to Build eCommerce Website
  • Disclosures
  • LitExtension Authors
  • LitExtension Blog – Shopping Cart Migration Expert & eCommerce News
  • LitExtension Blog Sitemap
  • LitExtension Methodology

© 2011 - 2024 LitExtension.com All Rights Reserved.

No Result
View All Result
  • Ecommerce Platforms
    • Shopify
    • WooCommerce
    • Magento (Adobe Commerce)
    • Wix
    • Other Platforms
  • eCommerce Migration
    • Shopify Migration
    • WooCommerce Migration
    • Magento Migration
    • Other Migrations
  • Store Growth
  • Ecommerce News
    • News & Events
    • Case Studies
VISIT LITEXTENSION

© 2011 - 2024 LitExtension.com All Rights Reserved.