Delete WooCommerce orders and customers

truncate_woocommerce_data.sql

DELETE FROM `wp_woocommerce_order_itemmeta`;
DELETE FROM `wp_woocommerce_order_items`;
DELETE FROM `wp_comments` WHERE `comment_type` = 'order_note';
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 FROM `wp_users` WHERE `wp_users`.`ID` NOT IN (SELECT `meta_value` FROM `wp_postmeta` WHERE `meta_key` = '_customer_user') AND `wp_users`.ID NOT IN (SELECT DISTINCT (`post_author`) FROM `wp_posts`);
DELETE FROM `wp_usermeta` WHERE `user_id` NOT IN (SELECT `ID` FROM `wp_users`);
TRUNCATE `wp_woocommerce_order_items`;
TRUNCATE `wp_woocommerce_order_itemmeta`;