This identifies batchable low-SKU orders—a great starting point for a smart batching run SELECT order_id, COUNT(DISTINCT sku) AS sku_count, COUNT(*) AS total_lines FROM order_items WHERE order_date = CURRENT_DATE GROUP BY order_id HAVING sku_count <= 2;