The Best Way to Import Customers to WooCommerce

Last updated on September 10, 2021

The Best Way to Import Customers to WooCommerce

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 step-by-step

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. Then you have to keep the CSV file you are importing ready that has all the users and the user data.

You can either create one using any spreadsheet program such asMicrosoft Excel or Google Sheets or if the data is within an existing WordPress site you can export the users to get the CSV.

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 WebToffee > Import Export and click the Import submenu. Now you may follow the below steps to get import customers to WooCommerce.

Step 1: Choose the post type as ‘User/Customer’

Choose user as post type to import users to WordPress

Step 2: Select the import method and upload the file

You can choose from three options – quick, pre-saved template, and advanced.

If you are using the plugin for the first time and need all user fields to be imported, I recommend you to go with the advanced import method.

Upload CSV containing user data to import wordpress users
Upload CSV

Step 3 : Mapping

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.

If you have exported data using the

Mapping of CSV headers with WooCommerce user fields
Mapping

Step 4: Import

This is the final step to import. Here you have the options to merge the user details in the CSV file with the existing data by choosing update, retaining the existing user passwords, configuring import batch count (to avoid import failure due to server time-out), etc.

Once you have configured the options you click the import button to start the importing of user data.

update or import the WordPress users or customers
Update/import

Now all the users in the CSV file will be imported to your WooCommerce store.

User import completed
User import completed

The imported users will be reflected on the WordPress Users’ page.

Imported user on WordPress Users page
Imported users

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

Conclusion

Importing users could seem like a lot if there are hundreds and thousands of user data involved. The above-explained solution will help you simplify it multiple times thus saving you a ton of time.