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
I just updated our Simple Pull Quote WordPress plugin to include an external style sheet that you can edit. The plugin is simple and completely customizable via CSS. It uses shortcode and custom fields that make it easy to control where the pull quotes will go.
Tonight, I will be teaching a class for folks who are interested in learning more about blogging. The class, titled PC Web Blogging for Beginners, is offered at Minneapolis’ Washburn High School via Minneapolis Community Education‘s Adult Enrichment program. Anyone can register for only $15. I am excited to be participating in this exciting venture! …
I discovered today that there is not a pull quote plugin for WordPress that does what I would like it to do. So, I have begun developing one myself. This is my first attempt at a plugin, and so far it has been a great learning experience (read: lots and lots of failures). haha! I…