🔧 Comprehensive Fix and Test for Event 250474
Date: 2025-11-05 03:48:42

1️⃣ Fixing Event Features:
✅ Event features already exist

2️⃣ Testing Sales Query:
- Statuses ['wc-completed', 'wc-processing']: 0 orders
- Statuses ['wc-completed', 'wc-processing', 'completed', 'processing']: 0 orders
- Statuses ['completed', 'processing']: 0 orders
- Statuses ['wc-completed']: 0 orders
- Statuses ['completed']: 0 orders

3️⃣ Actual Order Statuses:

4️⃣ Testing Corrected Sales Calculation (HPOS):
Found 65 sales records
Free: £0 x1 = £0
Table: £100 x1 = £100 → 1 tables = 6 entries
Paid: £5.5 x3 = £16.5
Paid: £5.5 x2 = £11
Paid: £5.5 x1 = £5.5
Paid: £5.5 x1 = £5.5
Paid: £5.5 x1 = £5.5
Paid: £10 x1 = £10
Paid: £5.5 x1 = £5.5
Paid: £5.5 x1 = £5.5
Paid: £12.5 x2 = £25
Paid: £5.5 x1 = £5.5
Paid: £10 x1 = £10
Paid: £10 x1 = £10
Paid: £12.5 x1 = £12.5
Paid: £10 x1 = £10
Paid: £2.5 x3 = £7.5
Paid: £5.5 x1 = £5.5
Paid: £5.5 x2 = £11
Paid: £10 x1 = £10
Paid: £10 x1 = £10
Paid: £10 x6 = £60
Paid: £2.5 x2 = £5
Paid: £12.5 x3 = £37.5
Paid: £15 x2 = £30
Paid: £10 x1 = £10
Table: £100 x1 = £100 → 1 tables = 6 entries
Paid: £2.5 x3 = £7.5
Paid: £12.5 x3 = £37.5
Paid: £12.5 x2 = £25
Paid: £10 x1 = £10
Paid: £5.5 x1 = £5.5
Paid: £5.5 x1 = £5.5
Paid: £5.5 x1 = £5.5
Paid: £10 x1 = £10
Paid: £10 x1 = £10
Paid: £10 x1 = £10
Paid: £5.5 x2 = £11
Paid: £5.5 x1 = £5.5
Paid: £12.5 x1 = £12.5
Paid: £10 x1 = £10
Paid: £10 x1 = £10
Paid: £15 x2 = £30
Paid: £12.5 x5 = £62.5
Paid: £12.5 x2 = £25
Paid: £12.5 x1 = £12.5
Paid: £15 x1 = £15
Paid: £15 x1 = £15
Paid: £10 x2 = £20
Paid: £10 x2 = £20
Paid: £15 x2 = £30
Paid: £12.5 x4 = £50
Paid: £15 x2 = £30
Paid: £10 x2 = £20
Paid: £10 x2 = £20
Paid: £10 x2 = £20
Paid: £15 x1 = £15
Paid: £10 x2 = £20
Paid: £15 x4 = £60
Paid: £15 x3 = £45
Paid: £12.5 x1 = £12.5
Paid: £12.5 x1 = £12.5
Paid: £12.5 x1 = £12.5
Paid: £12.5 x1 = £12.5
Paid: £12.5 x2 = £25

Summary:
Paid tickets: 107
Free tickets: 1
Table entries: 12
Minimum forecast: 119

5️⃣ Testing Forecasting Engine:
Generated forecast:
- Ticket sales p50: 41
- Attendance p50: 115
- Confidence: high
- Cohort count: 20

Rule Check:
Ticket sales p50: 41 (can be lower than current sales)
Attendance p50: 115 (should be >= paid + tables)
Paid tickets + table entries: 119
❌ FAILED: Attendance forecast (115) < paid tickets + table entries (119)

✅ Comprehensive test complete.