🔍 Debugging Event 250474 Issues
Date: 2025-11-05 03:48:57

1️⃣ Event Existence Check:
✅ Event exists: Cite - Afrobeats Saturdays at Cococure Cite (publish)

2️⃣ Event Features Check:
✅ Event features found:
  event_id: 250474
  venue_id: 3788
  start_ts: 2025-10-25 22:30:00
  weekday: Saturday
  start_bucket: late_night
  capacity: 250
  tags_json: []
  holiday_flag: 0
  created_at: 2025-10-23 17:46:25
  updated_at: 2025-10-23 18:17:34

3️⃣ Snapshot Data Check:
Found 5 snapshots:
- 2025-10-26 23:59:59: D-1.00, 108 tix, 2 tables, £1285.00
- 2025-10-25 23:59:59: D-0.04, 108 tix, 2 tables, £1285.00
- 2025-10-25 22:30:00: D0.00, 22 tix, 1 tables, £245.50
- 2025-10-24 22:30:00: D1.00, 22 tix, 1 tables, £245.50
- 2025-10-23 22:30:00: D2.00, 17 tix, 1 tables, £215.50

4️⃣ Live Sales Data Check:
WooCommerce orders found: 0

5️⃣ Event Products Check:
Products linked to event: 15
- Product 250475: Ladies Before 11pm
- Product 250476: Gents Before 11pm
- Product 250477: Ladies Before Midnight
- Product 250478: Gents Before Midnight
- Product 250479: Ladies Before 1am
- Product 250480: Gents Before 1am
- Product 250481: Ladies Before 2am
- Product 250482: Gents Before 2am
- Product 250483: Table C - £200 minimum spend
- Product 250484: Table B - £300 Minimum Spend
- Product 250485: Table A - £400 Minimum Spend
- Product 250486: VIP Booth D (Table for 6) £500 Minimum Spend
- Product 250487: VIP Booth E (Table for 6) £600 Minimum Spend
- Product 250488: Section for upto 12 - £700 Minimum Spend
- Product 264225: £350 - SILVER PACKAGE

6️⃣ Order Status Check:

7️⃣ Event Features Population:

✅ Debug complete.