When you want to move users and user data from one WordPress site to another, you would want to export and import the users. And using a plugin will easily accomplish the transfer of the data in a matter of minutes.
When you are exporting the data using a plugin, the additional metadata associated with the plugin will also be exported with it. WordPress Users & WooCommerce Customers Import Export Plugin is one of the best plugins that can help you export and import user data from one site to another.
The user and data associated with the users are stored in the table wp_user and all the additional metadata are stored in the table wp_usermeta. All the data from these two tables will be exported and imported using this plugin. To know more how the user data are stored in the database read this article.
For importing and exporting the user data from a WordPress website, you must install and activate the WordPress Users & WooCommerce Customers on the website.
Exporting the Users and User Metadata
To export the users from the website into a CSV file, go to WooCommerce > Customer Import Export. From the plugin page, go to the User/Customer Export tab. The screen looks as below:
From this section, You can filter the users for export with the User Roles and download a partial list of users using the Offset and Limit fields. Also, you can download the users based on the registration dates of the users using the From Date and To Date fields.
After the required filters have been applied, the Map and Transform button takes you to the next step of the user export. Step 2 of the export looks as below:
In the columns field, all the data that will be exported to the CSV are listed. When exporting, you can choose which data you want to export by choosing the columns from the columns field. Select the columns of the user data and the user metadata that you want to export to the CSV file.
After you have filled in the required fields, click on Export Users. This will export the users and in a CSV file and the file will be downloaded locally on your computer. The exported CSV will contain all the users and its related metadata.
Importing the Users and User Metadata
The following are the methods by which you can import the users from the CSV file into the WordPress website.
You can import all the required users by using Import Users. Click Import Users, the window appears as shown below:
- Method 1: Select a file from your computer. Click Choose File to browse a required CSV file from your computer.
- Method 2: Provide FTP Details. If your CSV file is on a server, provide the FTP details to connect to the server and download the CSV file.
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?
After you have chosen a method to import and then filled in the required fields, click on Upload file and import. Next step is mapping the file to match the WordPress user data fields.
While importing, all the data in the CSV file will be imported. To select which all data you want to import, you can either make changes in the CSV, or you can specify which columns you want to import the CSV during the mapping of the headers of the CSV file. Choose Do not import for the columns that you do not want to import into the store.
After the mapping click Submit to import the users and the user metadata.
To know more about importing and exporting users/customers from one WordPress site to another, read the plugin documentation.