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 “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:

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

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?

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

The Mighty Mo! Design Co.

RSS From Toby’s Blog

  • How Digital Ocean Cost Us Thousands of Dollars in a Single Day
    Here’s the rub for me: My belief is that bad stuff happens, and you need to own it. Digital Ocean definitely did not own it in this case. I wonder how the original founders of Digital Ocean would have reacted had they been in charge… For example, wouldn’t it be nice if an actual human… […]
  • Where uncertainty exists, don’t order specific.
    4 Idiot Case Studies with 2 simple age-old business lessons. The post Where uncertainty exists, don’t order specific. appeared first on Toby Cryns, WordPress Trainer in Minneapolis, MN.
  • “Now THAT was a good meeting!”
    A single effective meeting can change the course of history for a company. Imagine if you could lead effective meetings EVERY DAY! You can, but it takes curiosity & practice. This article is a good place to start your journey to a more effective you. The post “Now THAT was a good meeting!” appeared first […]

More posts from themightymo.com

How to style FacetWP checkbox hierarchy results using jQuery

By The Mighty Mo! Design Co. | February 21, 2023

I recently invested many hours trying to target and style a FacetWP taxonomy facet that uses hierarchy for display. It should be noted that you can use straight up CSS for some styling (and should use css wherever possible), but sometimes you need javascript to target parent elements and such. I thought I’d document the…

ballooning disk space

How to fix SpinupWP ballooning disk space issue

By The Mighty Mo! Design Co. | February 1, 2023

A site we host on Digital Ocean recently went down. It took me a lot of troubleshooting and digging before realizing that the issue was that our disk space was maxed out on Digital Ocean. The site in question needs ~20gb of space, so our 50gb server should be plenty. But alas, there it was…

google business reviews disappeared 1

Google Removed Our Business Listing – How we restored our biz to the Map and got our reviews back.

By The Mighty Mo! Design Co. | January 31, 2023

I was about to send an email to a potential customer pointing them to our 5-star Google Reviews via our Google Business profile (e.g. the Google Map), hoping this added information about our customers’ past experiences might help me close a deal. But when I checked the Google Reviews link, it was down. And after…

RSS From Toby’s Blog

  • How Digital Ocean Cost Us Thousands of Dollars in a Single Day
    Here’s the rub for me: My belief is that bad stuff happens, and you need to own it. Digital Ocean definitely did not own it in this case. I wonder how the original founders of Digital Ocean would have reacted had they been in charge… For example, wouldn’t it be nice if an actual human… […]
  • Where uncertainty exists, don’t order specific.
    4 Idiot Case Studies with 2 simple age-old business lessons. The post Where uncertainty exists, don’t order specific. appeared first on Toby Cryns, WordPress Trainer in Minneapolis, MN.
  • “Now THAT was a good meeting!”
    A single effective meeting can change the course of history for a company. Imagine if you could lead effective meetings EVERY DAY! You can, but it takes curiosity & practice. This article is a good place to start your journey to a more effective you. The post “Now THAT was a good meeting!” appeared first […]