Skip to content

Instantly share code, notes, and snippets.

@dvdmierden

dvdmierden/woocommerce-clear-customers.sql

Created June 22, 2020 20:04
Show Gist options
  • Save dvdmierden/27a4642b05db449bb2425cc3ef1cd3ae to your computer and use it in GitHub Desktop.
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