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

  • Fortify Your WordPress Site: Essential Security Steps
    Securing your WordPress site is a critical component of maintaining your online presence and safeguarding your data. Security is no longer a luxury, it has become a necessity in today’s digital world, where threats are lurking at every corner. This piece dives deep into WordPress security basics, giving you a comprehensive understanding of common vulnerabilities…
  • Master Your Site: Customizing WordPress Themes
    Just as a house is more than bricks and mortar, a WordPress site is much more than simple code. It’s a cohesive structure built with various layers such as PHP, HTML, CSS, and other key elements. Customizing WordPress themes involves gaining an in-depth understanding of this structure, learning to inspect and adjust design elements with…
  • Mastering WordPress Basics for Beginners within Hours
    Welcome to the world of WordPress, a widely used Content Management System (CMS) that powers millions of websites worldwide. Being immensely flexible and user-friendly, WordPress offers an endless scope to create, manage, and customize your website according to your needs and preferences. In this segment, we attempt to introduce you to the basics of WordPress,…

More posts from themightymo.com

How to merge multiple csv files via command line

How to merge multiple .csv files via command line

By The Mighty Mo! Design Co. | May 17, 2023

Today I downloaded 29 csv files with tax information. I could import those files 1 at a time into WooCommerce, but wouldn’t it be nice if I could merge them first and then only import a single file? The unix command is simple – just navigate to the folder with all the csv files and…

WordPress Security Services

15 Best WordPress Support and Maintenance Services for 2023: Ensuring Your Website Stays in Top Shape

By The Mighty Mo! Design Co. | April 27, 2023

Small business owners and non-profit leaders know that keeping your website secure, fast, and fully-functional is critical to success.  Here’s the unspoken truth: You can either learn how to do all that tech maintenance and development stuff yourself, or hire someone else to do it. But let’s face it, doing it yourself isn’t always the…

how to set up Cloudflare whitelist for ip

How to Whitelist SEM Rush IPs in Cloudflare

By The Mighty Mo! Design Co. | April 24, 2023

Alright, I’m going to show you how to whitelist a set of IPs on CloudFlare. In our case we use SEMrush and we want to make sure the SEMrush has full access to our sites.

RSS From Toby’s Blog

  • Fortify Your WordPress Site: Essential Security Steps
    Securing your WordPress site is a critical component of maintaining your online presence and safeguarding your data. Security is no longer a luxury, it has become a necessity in today’s digital world, where threats are lurking at every corner. This piece dives deep into WordPress security basics, giving you a comprehensive understanding of common vulnerabilities…
  • Master Your Site: Customizing WordPress Themes
    Just as a house is more than bricks and mortar, a WordPress site is much more than simple code. It’s a cohesive structure built with various layers such as PHP, HTML, CSS, and other key elements. Customizing WordPress themes involves gaining an in-depth understanding of this structure, learning to inspect and adjust design elements with…
  • Mastering WordPress Basics for Beginners within Hours
    Welcome to the world of WordPress, a widely used Content Management System (CMS) that powers millions of websites worldwide. Being immensely flexible and user-friendly, WordPress offers an endless scope to create, manage, and customize your website according to your needs and preferences. In this segment, we attempt to introduce you to the basics of WordPress,…