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
Alright, I’m going to show you how to whitelist a set of IPs on CloudFlare. In our case we use SEMrush and we want to make sure the SEMrush has full access to our sites.
Hey there! In this video, I’ll show you how to install a Cloudflare SSL certificate on your SiteGround website. I’ve noticed that Let’s Encrypt sometimes doesn’t renew properly due to conflicts with Cloudflare, so this is a great solution. We’ll use TCwebsecurity.com as the guinea pig. I’ll walk you through the process step-by-step. Once we…
Today I ran into an issue where a bunch of website files were deleted off the server, and I was called upon to restore the old files. After first pursuing other options (e.g. backups), I landed on Wayback Machine as the next best choice. Thankfully, there’s a handy command line tool for downloading any site…