Find and trash specific orders

Locate and trash all orders matching a specific status and name or email address in batches of 500. Very useful after a credit card guessing attack has left unauthorized/uncharged orders behind. Then manually empty the trash and if times out, return and repeat until clean. Most servers can empty around 500 orders at a time before timeouts are reached, but this varies by site.

Consider our free Woo Prune Orders plugin for trashing orders by status and date limit.

add_action( 'admin_notices', function() {

	// Selection Criteria
	$args = [
		'billing_first_name' => 'John',
		'billing_email' => '[email protected]',
		'billing_last_name' => 'Smith',
		'limit' => 500,
		'status' => [ 'wc-failed', 'wc-cancelled' ],

	// Query Orders
	$orders = wc_get_orders( $args );

	// Print Size Or Bail
	if( is_countable( $orders ) ) {
		printf( '<p>Batch size %d orders:</p>', sizeof( $orders ) );
	} else {
		echo wpautop( 'No orders found' );

	// Loop Them
	foreach( $orders as $order ) {

		// Print Order Numbers
		echo $order->get_id() . ' ';

		// Trash Them


} );

Instructions for Find and trash specific orders

  1. Log into a staging or locally hosted clone of your site.
  2. Install and activate Code Snippets plugin.
  3. WP Admin > Snippets > Add New
  4. Copy and paste the code from the section above.
  5. Check to ensure formatting came over properly.
  6. Customize the code as desired.
  7. Add a meaningful title.
  8. Select whether to run on front-end or back-end (or both).
  9. Click “Save and Activate”.
  10. Test your site to ensure it works.
  11. Disable if any problems, or recover.
  12. Repeat for live environment.

Need help modifying Find and trash specific orders?

Contact me. I can help with fitting projects or refer to my partner.


All code snippets are licensed GPLv2 (or later) matching WordPress licensing.

Except when otherwise stated in writing the copyright holders and/or other parties provide the program as-is without warranty of any kind, either expressed or implied, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose.

Disclaimer of warranty

Note: I may receive compensation for referrals.

WP Engine - A smarter way to WordPress
The best email marketing tool, responsive templates, automations, Worldwide support, tracking and reports, Benchmark Email, free plan available
Sell everywhere. Use Shopify to sell in-store and online.
Klaviyo partner badge
Okendo Partner, certified
WooCommerce, the most customizable eCommerce platform for building your online business. Click to get started.
Jetpack, a stronger, customizable site without sacrificing safety. Click to get started.