This article shows you how to delete your WooCommerce Orders and Users when you create a Staging or Test site for your WordPress website.
When you create a staging or test site, which is a replica of your live WordPress website, you may want to delete any existing orders and users, especially when giving login details to 3rd parties or just to prevent accidental actions being executed on live users.
1. Go to phpMyAdmin for your test database.
3. Delete Orders from WooCommerce:
DELETE FROM wp_woocommerce_order_itemmeta
DELETE FROM wp_woocommerce_order_items
DELETE FROM wp_postmeta WHERE post_id IN
(
SELECT ID FROM wp_posts WHERE post_type = 'shop_order'
)
DELETE FROM wp_posts WHERE post_type = 'shop_order'
DELETE FROM wp_comments WHERE comment_type = 'order_note'
4. Delete Users. You can do by type or by Id (or any other field). Here are the 2 examples:
DELETE FROM wp_users
WHERE wp_users.ID IN
(
SELECT user_id FROM wp_usermeta
WHERE meta_key = 'wp_capabilities' AND meta_value LIKE '%subscriber%'
)
DELETE FROM wp_usermeta
WHERE meta_key = 'wp_capabilities' AND meta_value LIKE '%subscriber%'
DELETE FROM wp_users
WHERE wp_users.ID IN (2,3,1812)
DELETE FROM wp_usermeta
WHERE user_id IN (2,3,1812)
2025 © Nutty About Hosting. All Rights Reserved. Privacy Policy | Terms and Conditions | GDPR | Partners | Green Hosting
Follow us on Twitter to receive updates regarding network issues, discounts and more. All prices exclude VAT.