Remove WooCommerce orders, subscriptions, non admin users

remove_wc_data.sql

# GET number of orders 
select count(*)from wp_posts where post_type = 'shop_order';

# DELETE ORDERS
delete from wp_postmeta where post_id in (
select ID from wp_posts where post_type = 'shop_order');
delete from wp_posts where post_type = 'shop_order';

# DELETE order refunds
delete from wp_postmeta where post_id in (
select ID from wp_posts where post_type = 'shop_order_refund');
delete from wp_posts where post_type = 'shop_order_refund';

# DELETE subscriptions
delete from wp_postmeta where post_id in (
select ID from wp_posts where post_type = 'shop_subscription');
delete from wp_posts where post_type = 'shop_subscription';

# DELETE scheduled actions
delete from wp_postmeta where post_id in (
select ID from wp_posts where post_type = 'scheduled-action');
delete from wp_posts where post_type = 'scheduled-action';

# DELETE users
delete from wp_users where ID not in (
select user_id
from wp_usermeta
where meta_value like '%administrator%'
);
delete from wp_usermeta where user_id not in (
select ID from wp_users
);