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
Make WordPress Work for You: How to turn your self-hosted WordPress blog into a totally rocking Content Management System (CMS)
WordPress Presentation What we might cover How many people have a website or blog? Brainstorm ideas for websites. What do you want your website to do? WordPress as a CMS Examples: GBSSA.org, TeamUpMn.org, Letronica.com (http://www.letronica.com/content/), cryns.com Switching WordPress from a Blog to a CMS Photo Gallery: http://www.cryns.com/category/photos/ Post by email iPhone Application Cool Plugins: Podpress…
I am liveblogging from Mark Gason’s presentation at FlashMN. These are my notes. Check out Mark’s page of resources. It contains links to tutorials as well as all sorts of other Papervision 3D-related stuff. http://gasolicious.com/flashstuff/PV3D_presentation.html Swift 3D is better than Papervision 3D in some ways: – You can model in Swift 3D, but AutoCAD also…