حذف تمام سفارشات ووکامرس به صورت یکجا از دیتابیس

DELETE FROM wp_posts WHERE post_type = 'shop_order';

SELECT * FROM wp_poststmeta pm
JOIN wp_posts p ON pm.post_id = p.ID
WHERE p.post_type = 'shop_order';

DELETE FROM wp_woocommerce_order_items WHERE order_id IN (SELECT ID FROM wp_posts WHERE post_type = 'shop_order');

DELETE FROM wp_woocommerce_order_itemmeta WHERE order_item_id IN (SELECT order_item_id FROM wp_woocommerce_order_items WHERE order_id IN (SELECT ID FROM wp_posts WHERE post_type = 'shop_order'));

DELETE FROM wp_woocommerce_order_itemmeta WHERE order_item_id IN (SELECT order_item_id FROM wp_woocommerce_order_items WHERE order_id IN (SELECT ID FROM wp_posts WHERE post_type = 'shop_order'));

SELECT * FROM wp_posts WHERE post_type = 'shop_order';