If you’re managing a WordPress or WooCommerce site, there are times when you might need to transfer user data, whether it’s for a site migration, setting up a staging environment, or just keeping backups. Doing this by hand can be quite a hassle and take up a lot of your time.
That’s where the Import Export WordPress Users and WooCommerce Customers plugin comes into play. It allows you to easily import and export users in bulk, making the entire process smooth and stress-free. You won’t have to worry about losing data or making mistakes; everything stays organized and easy to handle.
In this article, we’re going to show you how to easily import and export WordPress users with the free Import Export WordPress Users and WooCommerce Customers plugin. The process is simple, efficient, and makes managing your user data effortless.
Exporting WordPress Users
To export WordPress users, the process involves two simple steps: first, export the users from the source site into a CSV file, and then import them into the destination site using that file. Before you begin, make sure you’ve installed the free WordPress User Import Export plugin by WebToffee.
Step 1: Install the WebToffee Import Export WordPress Users Plugin
- Go to your WordPress dashboard and navigate to Plugins > Add New.
- Search for “Import Export WordPress Users” by WebToffee.
- Click Install, then Activate the plugin.
Step 2: Select User as the Post Type for Export
- After installing the plugin, go to WebToffee Import/Export (Basic) > Export.
- From the options, choose User/Customer as the post type.
Step 3: Choose an Export Method
Here, you need to choose an export method. The plugin offers two methods to suit different needs:
- Quick Export – Exports user data using the default settings.
- Advanced Export – Lets you apply filters, select specific columns, and customize advanced options to generate a CSV file tailored to your needs.
Step 4: Filter WordPress User Data
Here, you can easily customize what gets exported by applying filters. You can limit the number of users, exclude specific ones, or set criteria to export only the data you need.
Step 5: Map and Reorder User Export Columns
In this step, you’ll see the plugin’s column names on the left and their matching CSV column names on the right. By default, they’re identical, but you can easily edit the CSV column names or rearrange the order to suit your needs.
You also have the freedom to reorder the columns as you like. This can be helpful if you want to align the export file with a specific structure required by another system or for easier readability in spreadsheets.
Proceed to the next step.
Step 6: Configure Advanced Options / Batch Export
In this step, you can fine-tune your export settings before generating the final CSV file.
- Include guest users: Tick the checkbox if you want guest customers in the export file.
- Batch size: Choose how many records should be processed at a time.
- File name: Enter a name for the exported CSV file.
- Delimiter: Set a delimiter to separate columns (default is a comma).
- Save template (optional): Save your current settings to reuse later.
Click Export to generate and download the CSV file with your users/customers.
Once the export is complete, a pop-up will appear confirming that the file has been processed. Simply click Download file to save the CSV to your local storage.
Importing WordPress Users
You’ve got your users exported. Now it’s time to bring them into your new site. Using the same plugin, you can import them in just a few clicks and keep all your data intact.
Let’s see how it’s done.
Step 1: Select User/Customer as Post Type for Import
- Navigate to WebToffee Import/Export (Basic) from your WordPress dashboard.
- Click on the Import option.
- From the available post types, choose Users/Customers.
- Click the Select import method button to proceed.
Step 2: Select an Import Method
- Choose your preferred import method. The options are similar to export methods, such as Quick or Advanced import. For this guide, proceed with the Advanced Import option.
- Choose File for Import: Drag and drop the CSV file or click anywhere inside the box to browse and upload the file from your local storage.
- Set Delimiter: Specify the character used to separate columns in the CSV file (e.g., comma, semicolon, tab).
Then proceed to the next step.
Step 3: Map Import Columns
- Review the column mappings provided by the plugin. If your CSV file uses the default column names, the plugin will automatically match them to the required fields.
- If any columns are not mapped automatically, manually select and match the column names from your CSV file to the corresponding fields in the plugin.
Proceed to the next step.
Step 4: Configure Advanced Import Options
Before finalizing the import, you can fine-tune a few advanced settings. These options let you control how existing users are handled, whether to retain passwords, and how the import is processed.
- If User exists: Choose what to do if the user already exists on the site. You can skip that user from the import or update to overwrite the existing user details with the data from the CSV file.
- Skip Guest User: Sometimes, your CSV file may contain guest user records that you don’t want to import as registered customers. To handle this, you can choose to skip guest users during the import process, ensuring only registered customers are imported.
- Import in batches of: Set the number of records to be imported in each batch for smoother processing and to prevent timeout issues.
Before finishing, you can either save your settings for future use or proceed directly with the import.
- Click the Save Template button to save your current user import configuration as a reusable template.
- Click Import to begin importing users based on the configured options.
Once the import is complete, a pop-up will appear confirming that the process has finished. The message will display a Finished status. It will also show the number of failed imports (if any), so you can review and address them as needed.
That’s it. You’ve successfully imported users/customers into your site with the WebToffee User Import Export plugin.
Wrapping Up
With this plugin, managing user data via CSV becomes a quick and reliable process. All it takes is a few clicks. For those who require greater flexibility, the premium version of WordPress Users Import Export offers advanced customization, support for multiple file types, automated scheduling, regular updates, and priority support from our expert team.
In addition to user management, WebToffee also provides powerful solutions, such as the Order Import Export and Product Import Export plugins, designed to simplify and streamline your WooCommerce data handling.
We hope you found this article helpful! Feel free to share your questions or feedback in the comments below. Thanks for reading!
