Moving users from one website to another is just as crucial as transferring products and orders – you don’t want to lose your customer base! After all, a business relies on its customers to succeed. In this article, we’ll look at how to bulk update WordPress users effectively using a plugin.
While WooCommerce provides basic user import functionality, utilizing a third-party plugin can significantly enhance your import capabilities. The “Import Export for WooCommerce Users and WordPress Customers” plugin is an excellent choice for import users.
In this guide, we will show you how to use the free version of the WordPress User & WooCommerce Customers Import Export plugin to update user field values during the import process.
Key Takeaways:
- Transferring users is a key aspect of running an eCommerce store and should be done efficiently and accurately.
- Using third-party plugins can simplify user data import and export, making the whole process easily manageable.
- WebToffee’s WordPress User Import Export plugin simplifies user import and export, making bulk updates easy whenever needed.
Updating WordPress users in bulk is super easy with a plugin like the WordPress Users Import Export plugin. You won’t have to deal with the hassle of doing it manually, and you can get it done quickly with little to no disruption.
Now, let’s go through the simple steps to bulk update your WordPress users.
Note – Before importing your users to another website, ensure you have exported a CSV file containing all the necessary user details to ease the importing process.
Step 1: Install & Activate the WordPress User Import Export Plugin
If you have already installed the plugin to export CSV files, skip to Step 2.
- From the WordPress dashboard, go to Plugins > Add New Plugin.
- Search for “Import Export WordPress Users and WooCommerce Customers” plugin.
- Install and Activate the plugin.
Step 2: Select Users as Post Type to Import
- Navigate to WebToffee Import Export (Basic) > Import.
- Select the post type as User/Customer from the drop-down list.
Step 3: Select Advanced Import Method
- Select the import method as Advanced Import to filter the mapping columns, mapping selections, and other advanced options in detail.
- Upload the CSV file of the user list.
Step 4: Map User Columns for Import
Here, we’ll map the columns to import and use the transform option to change/edit any columns.
Note: If a header name in the input file matches the default fields in your store, the columns are automatically mapped.
- Click the pencil-shaped icon ✏️ next to the file column. A pop-up will appear, allowing you to bulk edit (linearly change) the field values of every entry in that particular column.
- Expression: The field value can be changed using any operators +, *, /, -, (), &, @, or string constants. Ex: changing the billing name to a constant value.
- Input file columns: From the dropdown, select the column that needs to be mapped with the default product field values.
- Output/ Preview: A sample value will be generated based on the first record in the input file. Ex: the output of billing name as John.
Below are some options for changing the field values using the Transform option, along with examples:
Assign a Constant Value to a Field
You can change the shipping company of the user while importing as shown below:
Combine Two Columns
There may be situations during import where you want to combine two or more columns into one. The transform option makes it simple to integrate them.
Example: To merge 2 columns, first name, and last name, you can use the following expression: {billing_first_name} {billing_last_name}.
The WordPress User Import Export Plugin we mentioned in this article also has a premium version with advanced options. Let’s explore the premium version features of this plugin.
The WordPress Users and WooCommerce Customers Import and Export plugin is a reliable and accessible tool developed by WebToffee for easily importing and exporting users on WordPress.
This plugin simplifies importing and exporting WordPress users from your site. Whether you’re moving users between stores or updating their information, it guarantees a smooth and error-free experience.
Key Features:
- Easily import and export WordPress users
- Multiple methods for migrating user data
- Supports various file formats – CSV, XML, TSV and Excel
- Bulk update user data during imports
- Map and transform fields during user data import
- Retain user passwords while importing WordPress user data
- Schedule user data import export using FTP/SFTP
Although the variety of user data in the import process might look complicated initially, a reliable user import plugin simplifies everything, making it more manageable than it seems. With an appropriate plugin like the WordPress Users Import Export plugin, you can swiftly and effectively import WordPress users in bulk, which saves time and minimizes the risk of mistakes.
We trust this article has given you the understanding and assurance to handle your user imports easily. If you have any additional questions or require support, don’t hesitate to leave a comment below – we’re here to assist!
