1. Bulk Delete All Orders
DELETE FROM wp_woocommerce_order_itemmeta;DELETE FROM wp_woocommerce_order_items;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'; |
2. Bulk Delete All Products
DELETE FROM wp_postmeta WHERE post_id IN ( SELECT ID FROM wp_posts WHERE post_type IN ( 'product', 'product_variation' ));DELETE FROM wp_posts WHERE post_type IN ( 'product', 'product_variation' ); |
3. Bulk Delete All Trashed Products
DELETE FROM wp_postmeta WHERE post_id IN ( SELECT ID FROM wp_posts WHERE post_type = 'product' AND post_status = 'trash' );DELETE FROM wp_posts WHERE post_type = 'product' AND post_status = 'trash'; |
4. Bulk Delete All Coupons
DELETE FROM wp_postmeta WHERE post_id IN ( SELECT ID FROM wp_posts WHERE post_type = 'shop_coupon' );DELETE FROM wp_posts WHERE post_type = 'shop_coupon'; |
5. Bulk Delete All Order Notes
DELETE FROM wp_commentmeta WHERE comment_id IN ( SELECT ID FROM wp_comments WHERE comment_type = 'order_note' );DELETE FROM wp_comments WHERE comment_type = 'order_note'; |