Sometimes, users provide their billing company information only, and that makes it difficult to find the details on where we need to send the products they order. Something we can do to solve that problem is copying the information from the billing company section to the shipping company section. However, when we have thousands of user-profiles to edit, it can be something really tedious.
That’s why in this tutorial, we want to show you how to copy billing company to shipping company in thousands of user-profiles in less than five minutes. You just need to follow these simple steps.
1- Install the “WordPress Users Spreadsheet” plugin
This plugin has been designed to assist you in your WordPress user’s management. We want you to save a lot of time and clicks and apply massive changes in seconds. For that, we’ve created a great spreadsheet where you can freely edit and fields you want in your user profiles.
Once installed and activated, open the spreadsheet by going to Sheet Editor > Edit Users.
2- Open the “Bulk Edit” tool
The Bulk Edit tool allows you to apply changes on thousands of user-profiles in seconds. You don’t need to use any kinds of snippets. You will just need to use some simple fields and your changes will be applied in seconds.
Open the tool by clicking on Bulk Edit on the plugin’s toolbar.
3- Filter the user profiles you’ll edit
Probably, you won’t need to edit all your users, so you can select the users missing shipping company only. For that, you just need to select the I want to search rows to update option in the Select the rows that you want to update dropdown.
You’ll see that you can select your users by role and combine it with the fact that they don’t have a shipping company. Of course, this is optional.
To find all users without shipping company, you need to tick the Enable advanced filters checkbox and select these values.
- Field key: Shipping company
- Operator: =
- Value: Leave this field empty.
Click on Run search to filter all your user profiles missing shipping company.
4- Copy billing company to shipping company in all selected users
After filtering your users missing shipping company, you need to select these values in the bulk edit fields in order to copy billing company to shipping company.
- Select the rows that you want to update: I want to search rows to update
- What field do you want to edit: Shipping Company
- Select the type of edit: Copy from other companies
- Replace existing value with this value: $billing_company$ (Billing company)
- Click on Execute now
That was all. As you can see, filtering and editing thousands of user-profiles is really simple with the WordPress Users Spreadsheet plugin. You just need to use some simple fields and the plugin does it all.