🔍 Debugging Sales Query for Event 250474
Date: 2025-11-05 03:49:06

1️⃣ All Orders (HPOS - No Status Filter):
Found 10 orders
- Order 264226: Status=wc-completed, Price=£0, Qty=1, Total=£0.00
- Order 264924: Status=wc-completed, Price=£100, Qty=1, Total=£100.00
- Order 265324: Status=wc-completed, Price=£5.5, Qty=3, Total=£16.50
- Order 265410: Status=wc-completed, Price=£5.5, Qty=2, Total=£11.00
- Order 265573: Status=wc-completed, Price=£5.5, Qty=1, Total=£5.50
- Order 265575: Status=wc-completed, Price=£5.5, Qty=1, Total=£5.50
- Order 265577: Status=wc-completed, Price=£5.5, Qty=1, Total=£5.50
- Order 265606: Status=wc-completed, Price=£10, Qty=1, Total=£10.00
- Order 265649: Status=wc-completed, Price=£5.5, Qty=1, Total=£5.50
- Order 265664: Status=wc-completed, Price=£5.5, Qty=1, Total=£5.50

2️⃣ Orders by Status:
- Status 'wc-completed': 0 orders
- Status 'wc-processing': 0 orders
- Status 'completed': 0 orders
- Status 'processing': 0 orders

3️⃣ Actual Order Statuses:

4️⃣ Using get_historical_sales_data Function: