Skip to content

Instantly share code, notes, and snippets.

@ValeriiVasyliev

ValeriiVasyliev/woocommerce-delete-all-orders-by-mysql.md

Created February 7, 2022 15:21
Show Gist options
  • Save ValeriiVasyliev/55a92f6bd09223ee3c0f368d4ffc5d64 to your computer and use it in GitHub Desktop.
Save ValeriiVasyliev/55a92f6bd09223ee3c0f368d4ffc5d64 to your computer and use it in GitHub Desktop.
Download ZIP
Woocommerce : delete all orders by mysql
Raw
woocommerce-delete-all-orders-by-mysql.md 
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