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

Toby Cryns

Toby Cryns is a freelance CTO, expert WordPress consultant, and teacher.

He offers free advice to improve your freelance biz.

He also publishes small droppings every now and then to twitter.com/tobycryns and twitter.com/themightymo

Follow Toby's contributions on Github and WP.org.