Skip to content

Instantly share code, notes, and snippets.

@fgrweb

fgrweb/woocommerce-delete-order-from-db.txt

Last active June 6, 2022 07:44
Show Gist options
  • Save fgrweb/9f6e2fe5e96b75caa62073b86467f691 to your computer and use it in GitHub Desktop.
Save fgrweb/9f6e2fe5e96b75caa62073b86467f691 to your computer and use it in GitHub Desktop.
Download ZIP
Bulk delete WooCommerce orders
Raw
woocommerce-delete-order-from-db.txt
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';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment