Do not waste any more time looking for an easy way to import the customers into your WooCommerce store. WooCommerce helps you do almost any task easily with the help of extension plugins. The best and easy way to import customers to WooCommerce is by using a WooCommerce customer import extension that can help you do just that like the WordPress Users & WooCommerce Customers Import Export Plugin.
The plugin is full of features that can help you import customers into your WooCommerce store in the easiest possible way. With this plugin, you don’t have to go anywhere near the website database to export or import the data. The plugin does all the heavy lifting for you. All you need to do is configure the settings of the plugin so that it does what you want it to do.
Importing Customers to WooCommerce
Let’s go through the process of importing using this plugin. First of all, you have to install and activate the plugin on the website that you are importing the data to. Then you have to keep the CSV file you are importing ready that has all the users and the user data.
Note: The CSV Import file must be in UTF-8 format. For more information about UTF-8 encoding, read How to save CSV / Excel File as UTF-8 Encoded?
Next, from the WooCommerce website admin dashboard, go to WooCommerce > User Import Export. From the plugin page, go to the User/Customer Import tab and then Import Files in a CSV Format section and click Import Users.
This will take you to the Import page of the plugin.
Now, there are two methods depending on the location of your CSV by which you can import the users.
Method 1: Select a file from your computer
In this method, you can select a file from your local computer. Click Choose File to browse a required CSV file from your computer.
Method 2: Provide FTP Details
In this method, you can select a CSV file that is located on a remote server by providing the FTP details.
First, you have to check the box to enable FTP and then give the FTP details. You also have the option to use FTPS.
After choosing any of the two methods, enter the delimiter that is used in the CSV file and select whether you want to send an email to new users or not. Then, click on Upload file and import.
Now, we are halfway there in importing all the users. Next, the important half is the mapping fields.
To make sure that the right data is imported into the right user fields, you have to map the column headers of the CSV to match the WooCommerce user data fields. This is especially useful when you are migrating from a different platform like Magento, Shopify, etc.
Then in the final step, click Import. Now all the users in the CSV file will be imported to the WooCommerce store.
The imported users will be reflected on the WordPress Users page.
To know more about the WordPress Users and WooCommerce Customers Import Export plugin, visit the plugin product page.
You can read the detailed instruction on how to get started with the plugin and everything about importing and exporting using the plugin from the plugin documentation.
The Best WordPress User/ WooCommerce Customer Import Export Plugin
40,000+ Active Installs as per WordPress Official Plugin Repository
#1 in Customer Satisfaction With Most 5 Star Reviews
WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The ProductBuy Now!