Imagine you receive an email from one of your WordPress users saying that he’s forgotten his password. Or maybe some of your users’ accounts have been stolen. Or you want to reset all your passwords because new persons will use the accounts. Whatever problem you want to solve with your passwords, we’re sure you want to do it quickly.
That’s important for security’s sake. However, it can be difficult to do that if you have thousands of users. That’s why we want to show you how easy and fast it is to reset all your users’ password using the WP Sheet Editor Users Spreadsheet plugin.
Here you’ll learn how to…
- Change passwords to users individually in the spreadsheet
- Import passwords from Excel or Google Sheets
- Reset passwords in all customers using the Bulk Edit tool
We’re almost sure most people don’t want to reset all their users’ passwords. That’s why in this section we show you how to filter users so that you reset passwords only for the users you want.
For this we’ll use the Search tool, so you can click it on the plugin’s toolbar.
a) Filter users by email or name
Maybe you want to filter your users by email or name. In this case, use the Search in user login, email, name to filter your users. Simple, right?
b) Filter users by role
Maybe you want to reset passwords to all customers or all subscribers. Whatever the case, once you’ve opened the Search tool, you need to use the Role dropdown.
You’ll find the following options:
- Shop vendor
- Shop worker
- Shop accountant
- SEO editor
- SEO manager
- Shop manager
Therefore, you just need to select a role and then hit the Run search button.
That’s a piece of cake!
Passwords in Excel or Google Sheets
This is a great way to reset your users’ passwords. For example, you can create an Excel or Google Sheets document with a Emails and a New password column and you can edit it. For example, you can have a data base of all your users’ emails and then just assign a new password.
Use the import tool
Once you have your Excel or Google Sheets document, you can easily import it using WP Sheet Editor. Just click on the Import button on the top toolbar.
That will open the Import tool. You can either select the CSV document from your computer or you can import it from a URL. The Source dropdown will show you all the options you have.
So just select the file you’ll upload and then hit Next.
After that, click on Import all the columns.
As we’re updating the passwords, you need to select the Update existing items, ignore new items option in the Do you want to update or create items? dropdown.
Then you need to match the fields so the plugin finds items with the same value in the CSV Field and the WP Field. In this case, you’ll match the Emails so that the corresponding passwords be assigned to them.
- Field 1: CSV Field: Email
- Field 1: WordPress Field: Email
Finally, you’ll see how the columns will look after importing. Therefore, you just need to accept if the preview is fine.
For this, click on The preview is fine, start import.
a) Open the Bulk Edit tool
This tool will help you apply changes to thousands of products quickly, so you just have to click it on the toolbar.
b) Reset all your users’ passwords
Contrary to WordPress, which asks you to follow some steps to reset your users’ passwords individually. You can reset all of them quickly just by setting these values in the Bulk Edit tool:
- What field do you want to edit: New password
- Select type of edit: Set value
- Replace existing value with this value: $random_letters$
- Click on Execute now.
After that, all your users’ passwords will be reset. As you can see, you don’t have to use any codes nor follow the same steps several times. It only takes some seconds. It’s really simple, isn’t it?