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 ORDER DATA FROM POSTMETA TABLE
delete from wp_postmeta where post_id in (select ID from wp_posts where post_type = 'shop_order');

# DELETE ORDER DATA FROM POSTS TABLE
delete from wp_posts where post_type = 'shop_order';

# DELETE ORDER REFUNDS FROM POSTMETA TABLE
delete from wp_postmeta where post_id in (select ID from wp_posts where post_type = 'shop_order_refund');

# DELETE ORDER REFUNDS FROM POSTS TABLE
delete from wp_posts where post_type = 'shop_order_refund';

# DELETE SUBSCRIPTIONS FROM POSTMETA TABLE
delete from wp_postmeta where post_id in (select ID from wp_posts where post_type = 'shop_subscription');

# DELETE SUBSCRIPTIONS FROM POST TABLE
delete from wp_posts where post_type = 'shop_subscription';

# DELETE scheduled actions
# Note: As of WooCommerce 4.0 Scheduled actions are in custom tables
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 except for administrators
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
);

payment_retry