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 as Microsoft 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’
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.
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
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.
Now all the users in the CSV file will be imported to your WooCommerce store.
The imported users will be reflected on the WordPress Users’ page.
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.
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.