Skip to content

Instantly share code, notes, and snippets.

@tallesairan

tallesairan/deleteallOrders.sql

Created May 18, 2018 17:18
Show Gist options
  • Save tallesairan/2a1c4078cbce8e6dfdcd61d001769644 to your computer and use it in GitHub Desktop.
Save tallesairan/2a1c4078cbce8e6dfdcd61d001769644 to your computer and use it in GitHub Desktop.
Download ZIP
Delete all orders from WooCommerce
Raw
deleteallOrders.sql
DELETE FROM wpcs_woocommerce_order_itemmeta;
DELETE FROM wpcs_woocommerce_order_items;
DELETE FROM wpcs_comments WHERE comment_type = 'order_note';
DELETE FROM wpcs_postmeta WHERE post_id IN ( SELECT ID FROM wpcs_posts WHERE post_type = 'shop_order' );
DELETE FROM wpcs_posts WHERE post_type = 'shop_order';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment