Clean orders on your store

clean-store.sql

-- This SQLs remove orders, orders notes, customers, coupons on your store
-- SalesGen.io


-- NOTICE: Replace wp_ by your prefix table 


DELETE FROM wp_woocommerce_order_itemmeta;
DELETE FROM wp_woocommerce_order_items;
DELETE FROM wp_wc_order_stats;
DELETE FROM wp_wc_order_product_lookup;
DELETE FROM wp_wc_order_coupon_lookup;
DELETE FROM wp_wc_customer_lookup;
DELETE FROM wp_woocommerce_sessions;
DELETE FROM wp_comments WHERE comment_type = 'order_note';
DELETE FROM wp_posts WHERE post_type = 'shop_order';
DELETE FROM wp_posts WHERE post_type = 'shop_coupon';
DELETE FROM wp_posts WHERE post_type = 'shop_order_refund';