WooCommerce 刪除所有訂單

2個方法

一、用wp cli

wp post delete $(wp post list --post_type='shop_order' --format=ids --allow-root) --force --allow-root

二、用sql指令

DELETE FROM wp_posts WHERE post_type = 'shop_order';
DELETE FROM wp_postmeta WHERE post_id NOT IN (SELECT ID FROM wp_posts);

DELETE FROM wp_wc_order_stats WHERE order_id NOT IN (SELECT ID FROM wp_posts);

wp cli會逐筆刪，效率沒那麼理想，建議進phpmyadmin用sql指令；執行前務必備份資料庫