dvdmierden/woocommerce-clear-customers.sql

Created June 22, 2020 20:04

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/dvdmierden/27a4642b05db449bb2425cc3ef1cd3ae.js"></script>
Save dvdmierden/27a4642b05db449bb2425cc3ef1cd3ae to your computer and use it in GitHub Desktop.

Download ZIP

Woocommerce clear all customers

Raw

woocommerce-clear-customers.sql

	DELETE u,um
	FROM wp_users u
	JOIN wp_usermeta um ON um.user_id = u.id
	WHERE um.meta_key = 'wp_user_level' AND um.meta_value = 0

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment