clear all orders, subscriptions and customers

query.sql

delete
p,pm
from wp_posts p
join wp_postmeta pm on pm.post_id = p.id
where p.post_type = 'shop_order';
delete
p,pm
from wp_posts p
join wp_postmeta pm on pm.post_id = p.id
where p.post_type = 'shop_subscription';
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;