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@example.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 firstname.lastname@example.org
Run the following SQL query on the database for recent versions of phpMyAdmin:
UPDATE `wp_users` SET `email@example.com'
Run the following SQL query on the database for earlier versions of phpMyAdmin:
UPDATE wp_users SET firstname.lastname@example.org'
This will set all WordPress users’ email addresses to “email@example.com”.
How To Update All WooCommerce Order Email Addresses to firstname.lastname@example.org
If you are using WooCommerce, do the above and THEN do this for newer versions of phpMyAdmin:
UPDATE `wp_usermeta` SET `meta_value` = 'email@example.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 = 'firstname.lastname@example.org' WHERE meta_key = 'billing_email'
Pretty nifty, eh?
More posts from themightymo.com
Mark Gason Papervision 3D Presentation at FlashMN
I am liveblogging from Mark Gason’s presentation at FlashMN. These are my notes. Check out Mark’s page of resources. It contains links to tutorials as well as all sorts of other Papervision 3D-related stuff. http://gasolicious.com/flashstuff/PV3D_presentation.html Swift 3D is better than Papervision 3D in some ways: – You can model in Swift 3D, but AutoCAD also…
Reorganize Your WordPress 2.7 Admin Panel with Fluency 2.0
Yesterday I discovered the new Fluency 2.0 plugin for WordPress 2.7. It does a fantastic job of cleaning up the admin interface and makes the back-end WordPress experience much better for users.
We Now Offer Search Engine Optimization!
We have just teamed up with one of the web’s finest search engine optimization gurus, Greg Cryns, and will now be offering his services to you, our customers! For you, our customer, this means that we now have added expertise in driving targeted traffic to your website. Greg has over a decade worth of search…