The WooCommerce import customers tool is a valuable tool for businesses aiming to transfer customer data from other platforms or systems into their WooCommerce store. This process simplifies customer management, enabling a seamless transition when businesses migrate or upgrade their eCommerce platform. By importing customer information, you maintain relationships, keep historical data, and allow customers to continue shopping with ease.
If you are learning how to import Woocommerce customers, you are in the right place! Keep reading to find out more about:
- How to import WooCommerce customers using a plugin
- Perform WooCommerce import customers with LitExtension
Let's get right into it.
Import WooCommerce Customers Using A Plugin
Unfortunately, WooCommerce does not support WooCommerce import customers as a built-in feature. Instead, you'll need to install a third-party plugin to import data to WooCommerce.
In this article, we'll work with the “WebToffee Import Export” plugin for demonstration. Keep in mind that different extensions have different ways to import data, so please refer to your plugin's documentation for further guidance.
Here's how to perform WooCommerce import customers using the WebToffee Import Export plugin.
Step 1. Install the plugin
- From your admin dashboard, go to “Plugins” > “Add New”.
- Then, search for the plugin in the search bar, and click “Install” > “Activate”.
Step 2. Select the import method
- Navigate to the “WebToffee Import Export” bar, and click “Import”
- Then, select the “User/Customer” tab, and click the “Step 2: Select import method” button.
- Here, you need to choose your import option
- Quick import: Choose this option if you exported the input file using the same plugin.
- Advanced import: Choose this option if your CSV file is exported from another platform. In this case, you'll need to filter and map your data before performing the WooCommerce import customers.
- Then, drag your CSV file into the corresponding blank, and click “Import”. In case you choose the Advanced import option, select “Step 3: Advanced options/Batch import” to proceed.
Step 3. Map import columns
- Now, you'll need to map the import columns in your CSV files under the 3 fields:
- Default
- Meta (or custom fields)
- Hidden meta
- After that, click “Step 4: Advanced Options/Batch Import/Scheduling” to continue.
Step 4. Advanced Options / Scheduling
- Here, you'll be navigated to a new window for advanced options such as:
- Update only: Select “Yes” if you want to import only match/existing records from your database. Otherwise, select “No” if you want to import everything from your input file.
- Match users by their: Choose either “ID”, “Email”, or “Username” to determine if the users will be looked up based on the corresponding field.
- Existing user: Select “Skip” if you want to ignore the matching user between your database and import file or “Update” if you want to update them.
- Email new users: Select “Yes” if you want to send an email notification to all new users upon successful import. Otherwise, click “No”.
- Click on “Import/Schedule” option to finish.
How to Perform WooCommerce Import Customers with LitExtension
As you may see, the manual import process might take up lots of time cleansing and mapping data to make sure your CSV file is in the right format.
In these cases, LitExtension – #1 eCommerce Migration Service can be your trusted companion in WooCommerce import customers. With over 10 years of experience, we can simplify the process, ensuring data accuracy and minimal downtime during migration. Our experts will handle everything for you, from customizing your data to match WooCommerce's requirements to performing post-migration service. This means you can fully focus on growing your business, and rest assured your WooCommerce migration is in good hands.
Step 1. Consultant by LitExtension experts
The first step in performing a WooCommerce import customers migration with LitExtension is consulting with our team of experts. This phase is critical for ensuring a smooth and successful transfer of customer data. During the consultation, we assess your specific migration needs, including the size of your customer database, the platform you’re migrating from, and any custom data fields that need to be preserved.
Our experts guide you through the process, addressing any concerns and answering your questions. We provide insights into the best approach for your migration and recommend the most suitable tools or services to ensure an accurate and efficient transfer. This step lays the groundwork for the entire migration process, helping you avoid potential challenges and ensuring that all customer data is handled with care and precision.
Step 2. Data mapping & setting by experts
In the WooCommerce import customers process, data mapping is a crucial step, and at LitExtension, we handle it with precision. Our experts carefully map customer data from your old platform to WooCommerce, ensuring all information is correctly transferred. This includes key details such as customer names, email addresses, order history, and any custom fields specific to your business.
We take the time to review your data structure to ensure that everything is aligned properly. Our team adjusts the settings to accommodate your specific requirements, whether it's handling complex customer data or ensuring seamless integration with your WooCommerce store. This level of customization ensures that no data is misplaced or left behind.
With our experts managing the data mapping and settings, you can trust that your customer information will be transferred accurately, allowing your store to continue operating without disruption. This step is essential for a smooth migration experience.
Step 3. Perform full WooCommerce import customers
Once the data mapping and settings are finalized, we move on to performing the full WooCommerce import customers migration. This step involves transferring all customer data from your old platform into your WooCommerce store. Our system ensures that each customer’s information, including contact details, purchase history, and custom fields, is migrated accurately and securely.
We use advanced technology to automate this process, minimizing the risk of errors or data loss. During the full import, our system handles large volumes of data efficiently, ensuring a smooth and uninterrupted transfer. We also run checks throughout the process to ensure that all data is properly formatted and functions correctly within your WooCommerce store.
With our experience and specialized tools, we ensure that the full import is completed quickly, reducing any potential downtime for your store. This means your customers can continue to access their accounts without any disruption, maintaining their shopping experience seamlessly.
Seamlessly perform WooCommerce import customers
LitExtension can transfer your customer to WooCommerce with no technical required.
Data Mapping for WooCommerce Import Customers
Column name | Explanation | Accepted format |
ID | Identification number | Numerical Example: 1317, 26515 |
customer_id | Identification number of the customer. | Numerical Example: 1317, 26515 |
user_login | Can include: email, id, name. | Alpha-numeric characters Example: [email protected] |
user_pass | Login password of the customer. | Alpha-numeric characters Example: password1 |
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. | Alpha-numeric characters. Example: [email protected] |
user_url | URL of the user’s/customer's website. | Alpha-numeric characters. Example: yourstore.com/customer/name |
user_registered | Registration date of the customer. | Numerical. Example: 2016-05-26 |
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 |
user_status | Customer's status. | 0 - Inactive 1 - Active |
nickname | Nickname of the customer. | Alpha-numeric characters. Example: johndoe101 |
description | Description or short bio of the customer. | Alpha-numeric characters. |
locale | Local language which the user prefers. | Text Example: English, Espanol |
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 | Name of the shipping company. | Text Example: DHL |
shipping_address_1 | First address of the shipping company. | Alpha-numeric characters. Example: 123 Sample Street |
shipping_postcode | Customer's postal code. | Numerical Example: 123456 |
shipping_city | City of the shipping company. | Text Example: Fort Myers |
shipping_state | State of the shipping company. | Text Example: Florida |
shipping_country | Country of the shipping company. | Text Example: United State |
Bonus reading for you:
WooCommerce Import Customers – FAQs
How to import customers in WooCommerce?
If you want to import customers to WooCommerce using a plugin (for example, WebToffee Import Export), please follow these steps below:
- Step 1. Install plugin
- Step 2. Select import method
- Step 3. Map import columns
- Step 4. Perform Advanced Options / Scheduling
How to migrate WooCommerce customers?
If you want to import customers to WooCommerce, please follow these steps below to transfer your data seamlessly with LitExtension.
- Step 1. Consult with LitExtension experts
- Step 2. Have your data mapped and set up by LitExtension experts
- Step 3. Perform full migration
How do I add customers to WooCommerce?
Here are 4 simple steps to add customers to WooCommerce:
- Step 1. From your admin dashboard, navigate "WooCommerce" > "Users" > "Add New"
- Step 2. Input your customers' name, email, and set a password
- Step 3. Click "Save"
How to export WooCommerce customers to CSV?
To export WooCommerce customer CSV, please follow these steps below:
- Step 1. From your admin dashboard, go to "WooCommerce" > "Users" > "Export"
- Step 2.
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.
