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
The Ultimate Guide to WordPress Support: Why it’s Essential for Your Website’s Success
Whether you’re situated in Minneapolis, St. Paul, Illinois, New York, or any other corner of the globe, ensuring reliable WordPress Support is paramount for the continued success of your website. In this comprehensive guide, we will delve into the crucial role that WordPress support plays in your website’s journey to success.
How to optimize your Google Crawl Budget using SEM Rush Log File Analyzer and Rank Math SEO
Today I ran the SEM Rush Log File Analyzer tool, and it showed some interesting things that are a complete waste of our Google Crawl Budget. Specifically, I learned that Google is wasting some of our crawl budget on the /wp-includes/ directory, certain plugin directories, and cache directories. I also noticed random files being crawled…
Where is the Google Analytics Measurement ID?
In the vast, evolving world of web development and analytics, keeping up with terminologies and tools can sometimes feel like trying to chase a mischievous cat in a maze. You think you’ve got a grip, only for it to slip right through your fingers! Enter the mysterious “Measurement ID” from Google Analytics 4 (GA4), a…