How to Set or Update All of Your WordPress User Email Accounts to a Test Email Address in mysql and phpMyAdmin (and WooCommerce!)

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?

How To Update All WooCommerce Order Email Addresses to test@test

The Mighty Mo! Design Co.

RSS From Toby’s Blog

More posts from themightymo.com

WordPress Support

The Ultimate Guide to WordPress Support: Why it’s Essential for Your Website’s Success

By The Mighty Mo! Design Co. | September 25, 2023

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.

sem rush log file analyzer

How to optimize your Google Crawl Budget using SEM Rush Log File Analyzer and Rank Math SEO

By The Mighty Mo! Design Co. | September 22, 2023

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…

google analytics definitive guide

Where is the Google Analytics Measurement ID?

By Toby Cryns | August 16, 2023

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…

RSS From Toby’s Blog