Search WooCommerce orders for line items with qty > 1, and multiple 'pa_color' assignments.

report.php

<?php

echo "START\n";

// Setup arguments for WP_Query
// set post type to WooCommerce orders
// set post status to published
// set fields to return just the post IDs
// set posts per page to -1 so all records are returned
$args = array(
	'post_type'     => 'shop_order',
	'post_status'   => 'publish',
	'fields' => 'ids',
	'posts_per_page'=> '-1',
);
// do the query
$query = new WP_Query( $args );

// get an array of Order post IDs
$orders = $query->posts;
$count = 0;
$total = 0;
$qty   = 0;

foreach ( $orders as $order_id ) {

	// load a WC_Order object from the ID
	$order = wc_get_order( $order_id );

	// Get line items for this order
	$items = $order->get_items();

	if ( count( $items ) > 2 ) {
		//echo "ID: " . $order_id . "\n";
		//print_r( $items );
		foreach ( $items as $item ) {

			if ( $item['qty'] > 1 && $item['name'] == 'Coolest Cooler' ) {

				// check for more than one pa_color
				if ( 1 < count( $item['item_meta']['pa_color'] )) {
					print_r( $item['item_meta']['pa_color'] );
					echo "ID (" . $order_id . ") Color: " . $item['pa_color'] . "\n";
					$qty ++;
				}
			}

			$count ++;
		}
	}
	$total++;
}

echo "Orders: " . $total . "\n";
echo "Orders with more than one line item: " . $count . "\n";
echo "Orders with multiple coolers: " . $qty. "\n";
echo "END\n";