Do you want to import and export WordPress users from one website to another?
This could be really helpful if you are merging multiple sites and want to quickly move all your users to the new site. It’s also an easy way to add customer information to a new tool or mailing list.
In this article, we will show you how to easily import and export users in WordPress. If you run an online store, then we will also show you how to import and export WooCommerce customers.
Why Import and Export WordPress Users?
There are many reasons why you may want to import and export WordPress users. You might want to merge the user base from two websites, such as a new WordPress website you just bought.
If you run a membership website or WooCommerce store, then you may want to encourage users to check out your new website. In this case, you can import their information into the new website and offer a seamless login experience.
With that being said, let’s see how you can easily import and export WordPress users and move WooCommerce customers from one store to another.
How to Export Users in WordPress
The best way to import and export WordPress users is with the Import and Export Users and Customers plugin.
The first thing you need to do is install and activate the Import and Export Users and Customers plugin. For more details, see our step-by-step guide on how to install a WordPress plugin.
Upon activation, you need to go to Tools » Import and export users and customers in the WordPress admin area and switch to the ‘Export’ tab.
From here, you can choose which users you want to export. For example, you can open the ‘Role’ dropdown and select the user role you want to export, such as customers from your membership plugin, subscribers, commenters, or any other user role.
To filter users by date, simply type into the ‘User created’ fields.
When you are ready to export users from your WordPress website, go ahead and click on ‘Download.’ The WordPress plugin will now create and download a CSV file containing all the user information.
You can open this file in any spreadsheet software like Google Spreadsheets or Microsoft Excel, and also import it into WordPress.
How to Import WordPress Users and WooCommerce Customers
Once you have created a CSV file, you can import these users into any WordPress website.
To start, make sure you’ve installed the Import and Export plugin on the new website. After that, simply go to Tools » Import and export users and customers in the new website and select the ‘Import’ tab.
Here, click on the ‘Choose file’ button and select the CSV file you downloaded earlier.
Once the import is complete, you may want to send your users an email with a login link and their credentials. To do this, simply check the box next to ‘Send Email’. This can improve the user experience and encourage them to log in to their new account.
The plugin has a default email template, but we will show you how to customize it in the next step.
You may also want to force users to reset their password the first time they log into their new account. This can help keep your website safe and is particularly important if your user accounts contain sensitive information, such as the customer’s credit card details.
To add this security feature, check the box next to ‘Force users to reset their password’.
There are some more settings you may want to configure, but this is all you need to import users into a new WordPress blog or website.
When you are happy with how the import is set up, simply click on the ‘Start importing’ button.
The plugin will now perform the import and display a list of all the new users.
Sending Emails to Imported Users and Customers
When moving users to a new website or online marketplace, you may want to send them an email about the change.
If you enabled the ‘Send email’ setting in the previous step, then you can customize the message by going to Tools » Import and export users and customers. Here, select the ‘Mail options’ tab.
By default, the message includes the user’s login details and a link to the site’s login page. To change this message, simply type into the text editor.
You can also use all the standard text formatting options. For example, you can add links, use bold and italic formatting, create lists, and more.
After creating these emails, you will want to make sure they arrive safely in the user’s inbox and not in the spam folder. The best way to do this is by using an SMTP service provider to improve email deliverability.
For more details, see our guide on how to fix the WordPress not sending email issue.
We hope this article helped you easily import and export WordPress users and WooCommerce customers. You may also want to see our guide on how to create an email newsletter or see our expert picks for the best live chat software.