612-293-8629 HELLO@THEMIGHTYMO.COM

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 “test@test.com”

After all, you don’t want to accidentally send a test email to all those users!

How to Change All WordPress User Emails to test@test.com

Run the following SQL query on the database for recent versions of phpMyAdmin:

<span class="cm-keyword">UPDATE</span> <span class="cm-variable-2">`wp_users`</span> <span class="cm-keyword">SET</span> <span class="cm-variable-2">`user_email`</span>=<span class="cm-string">'test@test.com'</span>

Run the following SQL query on the database for earlier versions of phpMyAdmin:

UPDATE wp_users SET user_email='test@test.com'

This will set all WordPress users’ email addresses to “test@test.com”.

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

If you are using WooCommerce, do the above and THEN do this for newer versions of phpMyAdmin:

UPDATE `wp_usermeta` SET `meta_value` = 'test@test.com' 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 = 'test@mailinator.com' WHERE meta_key = 'billing_email'

Pretty nifty, eh?

PHONE, EMAIL, TEXT

We love to communicate: phone, email, text, Facebook, Twitter, LinkedIn, you name it.

LOCATIONS

PAYMENTS ACCEPTED

Call Now

Enroll in Our Free Beginner WordPress Class by Email

Never feel powerless in WordPress again!  Become a WordPress superstar for free in only minutes a day!

Our Beginner WordPress Email Class is delivered to your inbox!

Learn More 

You Have Successfully Enrolled! Prepare For Amazing!