原创作者：
Fengjiajun
发布日期：2021年4月27日
WooCommerce常用批量删除SQL语句
1、批量删除所有订单
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、批量删除所有产品
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、批量删除所有回收站产品
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、批量删除所有优惠券
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';
