How to Delete All Orders in HPOS wordpress

by

Run these queries in phpMyAdmin (SQL tab):

TRUNCATE TABLE wp_wc_orders;
TRUNCATE TABLE wp_wc_order_addresses;
TRUNCATE TABLE wp_wc_order_operational_data;
TRUNCATE TABLE wp_wc_order_stats;
TRUNCATE TABLE wp_wc_order_product_lookup;
TRUNCATE TABLE wp_wc_order_tax_lookup;
TRUNCATE TABLE wp_wc_order_coupon_lookup;
TRUNCATE TABLE wp_woocommerce_order_items;
TRUNCATE TABLE wp_woocommerce_order_itemmeta;
TRUNCATE TABLE wp_wc_customer_lookup;
TRUNCATE TABLE wp_wc_download_log;