Skip to content

Instantly share code, notes, and snippets.

@attilabacso

attilabacso/delete_all_woocommerce_orders.sql

Created September 30, 2022 07:12
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save attilabacso/02feb04774e280c983b3b38fa5280c79 to your computer and use it in GitHub Desktop.
Save attilabacso/02feb04774e280c983b3b38fa5280c79 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
delete_all_woocommerce_orders.sql
# Delete all WooCommerce orders, order_meta and order post_meta datas
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