Delete All Zero Order Customers WooCommerce

Created by WP Fix It, Modified on Sun, 3 Aug at 6:10 AM by WP Fix It

SQL to run below (change table name to your prefix)

DELETE from wp_users where wp_users.ID not in (
	SELECT meta_value FROM wp_postmeta WHERE meta_key = '_customer_user'
) AND wp_users.ID not in (
	select distinct(post_author) from wp_posts
)LIMIT 1000;

delete from wp_usermeta where wp_usermeta.user_id not in (select ID from wp_users)
LIMIT 1000;

Delete All Zero Order Customers WooCommerce

Need Some Help?

Let us help you right now