使用数据库SQL删除woocommerce的全部订单

前缀要根据自己的修改，wp_是默认前缀

DELETE FROM wp_woocommerce_order_itemmeta;
DELETE FROM wp_woocommerce_order_items;
DELETE FROM wp_wc_customer_lookup;
DELETE FROM wp_wc_orders ;
DELETE FROM wp_wc_orders_meta;
DELETE FROM wp_wc_order_addresses;
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';