Delete All Zero Order Customers WooCommerce

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


DELETE from ulj_users where ulj_users.ID not in (
	SELECT meta_value FROM ulj_postmeta WHERE meta_key = '_customer_user'
) AND ulj_users.ID not in (
	select distinct(post_author) from ulj_posts
)LIMIT 100;

delete from ulj_usermeta where ulj_usermeta.user_id not in (select ID from ulj_users)
LIMIT 100;

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article