Whether you run a WordPress community with 1,000 members or a WooCommerce store with 100,000 orders, sometimes for testing you want to change all the account emails to something like “[email protected]”
After all, you don’t want to accidentally send a test email to all those users!
How to Change All WordPress User Emails to [email protected]
Run the following SQL query on the database for recent versions of phpMyAdmin:
UPDATE `wp_users` SET `user_email`='[email protected]'
Run the following SQL query on the database for earlier versions of phpMyAdmin:
UPDATE wp_users SET user_email='[email protected]'
This will set all WordPress users’ email addresses to “[email protected]”.
How To Update All WooCommerce Order Email Addresses to [email protected]
If you are using WooCommerce, do the above and THEN do this for newer versions of phpMyAdmin:
UPDATE `wp_usermeta` SET `meta_value` = '[email protected]' WHERE `meta_key` = 'billing_email'
If you are using WooCommerce, do the above and THEN do this for older versions of phpMyAdmin:
UPDATE wp_usermeta SET meta_value = '[email protected]' WHERE meta_key = 'billing_email'
Pretty nifty, eh?
More posts from themightymo.com
Yesterday I discovered the new Fluency 2.0 plugin for WordPress 2.7. It does a fantastic job of cleaning up the admin interface and makes the back-end WordPress experience much better for users.
We have just teamed up with one of the web’s finest search engine optimization gurus, Greg Cryns, and will now be offering his services to you, our customers! For you, our customer, this means that we now have added expertise in driving targeted traffic to your website. Greg has over a decade worth of search…
Below are my notes from tonight’s FlashMN meeting starring Dustin Tauer. The presentation focused on the new features of Adobe Creative Suite 4. Illustrator CS4 Can create multiple art boards. So, if I wanted to use artwork for the front and back of t-shirt, I would create 2 art boards (up to 100). There are…