Delete WooCommerce orders FORM

delete all orders

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_posts WHERE post_type = 'shop_subscription';


// Woo Core
DELETE FROM `wp_postmeta` WHERE meta_key LIKE '%_billing%';
DELETE FROM `wp_postmeta` WHERE meta_key LIKE '%_shipping%';
DELETE FROM `wp_postmeta` WHERE meta_key LIKE '%_order%';
DELETE FROM `wp_postmeta` WHERE meta_key LIKE '%_wc%';
DELETE FROM `wp_postmeta` WHERE meta_key LIKE '%_customer%';
DELETE FROM `wp_postmeta` WHERE meta_key LIKE '%_cart%';
DELETE FROM `wp_postmeta` WHERE meta_key LIKE '%_prices%';
DELETE FROM `wp_postmeta` WHERE meta_key LIKE '%_created_via%';
DELETE FROM `wp_postmeta` WHERE meta_key LIKE '%_payment%';
DELETE FROM `wp_postmeta` WHERE meta_key LIKE '%_download_permissions%';
DELETE FROM `wp_postmeta` WHERE meta_key LIKE '%shipping_phone%';
DELETE FROM `wp_postmeta` WHERE meta_key LIKE '%_recorded%';

// Other
DELETE FROM `wp_postmeta` WHERE meta_key LIKE '%_cw%';
DELETE FROM `wp_postmeta` WHERE meta_key LIKE '%_ga%';
DELETE FROM `wp_postmeta` WHERE meta_key LIKE '%pickup_time%';
DELETE FROM `wp_postmeta` WHERE meta_key LIKE '%invoice_select%';