How to Delete Users and WooCommerce Orders in WordPress Database

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.

2. Select your database and then click on SQL

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)
		
		

Return to Category