[2026-07-16 18:55:44] [INFO] Found 5 orphaned checkout(s) to process
[2026-07-16 18:55:44] [INFO] Processing order: 031620260928565 (Invoice: PA-69b7cd5890b5b, PI: pi_3TBXSGF4ltXXlPEk0r74Uj8g)
[2026-07-16 18:55:45] [INFO] Stripe status for order 031620260928565: succeeded
[2026-07-16 18:55:45] [WARNING] cart_items invalid for order 031620260928565 — Stripe PI pi_3TBXSGF4ltXXlPEk0r74Uj8g metadata keys: item1_amount, item1_amount_id, item1_fund_id, item1_id, item1_quantity | parsed item_* count: 0
[2026-07-16 18:55:45] [ERROR] Cart items unresolvable for order 031620260928565 (PI: pi_3TBXSGF4ltXXlPEk0r74Uj8g) — Stripe metadata has no item_* keys and stored cart has empty appeal_id. Manual fix required.
[2026-07-16 18:55:45] [INFO] Processing order: 042320262210214 (Invoice: PA-69ea98cd64db0, PI: pi_3TPVRxF4ltXXlPEk0neYQgvS)
[2026-07-16 18:55:45] [INFO] Stripe status for order 042320262210214: succeeded
[2026-07-16 18:55:45] [WARNING] cart_items invalid for order 042320262210214 — Stripe PI pi_3TPVRxF4ltXXlPEk0neYQgvS metadata keys: item1_amount, item1_amount_id, item1_fund_id, item1_id, item1_quantity | parsed item_* count: 0
[2026-07-16 18:55:45] [ERROR] Cart items unresolvable for order 042320262210214 (PI: pi_3TPVRxF4ltXXlPEk0neYQgvS) — Stripe metadata has no item_* keys and stored cart has empty appeal_id. Manual fix required.
[2026-07-16 18:55:45] [INFO] Processing order: 043020260434496 (Invoice: PA-69f2dbe98f431, PI: pi_3TRmJJF4ltXXlPEk0cwWAxlj)
[2026-07-16 18:55:45] [INFO] Stripe status for order 043020260434496: succeeded
[2026-07-16 18:55:45] [WARNING] cart_items invalid for order 043020260434496 — Stripe PI pi_3TRmJJF4ltXXlPEk0cwWAxlj metadata keys: invoiceid, item_1, order_no | parsed item_* count: 1
[2026-07-16 18:55:45] [ERROR] Failed to save Stripe enrichment for journey id=3471: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'isrecurring' in 'SET'
[2026-07-16 18:55:45] [ERROR] Cart items unresolvable for order 043020260434496 (PI: pi_3TRmJJF4ltXXlPEk0cwWAxlj) — Stripe metadata has no item_* keys and stored cart has empty appeal_id. Manual fix required.
[2026-07-16 18:55:45] [INFO] Processing order: 0525202603165510 (Invoice: PA-6a13bf279ea08, PI: pi_3Tap0dF4ltXXlPEk1GvPymKN)
[2026-07-16 18:55:45] [INFO] Stripe status for order 0525202603165510: succeeded
[2026-07-16 18:55:45] [WARNING] cart_items invalid for order 0525202603165510 — Stripe PI pi_3Tap0dF4ltXXlPEk1GvPymKN metadata keys: invoiceid, item_1, item_2, order_no, visit_id | parsed item_* count: 2
[2026-07-16 18:55:45] [ERROR] Failed to save Stripe enrichment for journey id=4525: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'isrecurring' in 'SET'
[2026-07-16 18:55:45] [ERROR] Cart items unresolvable for order 0525202603165510 (PI: pi_3Tap0dF4ltXXlPEk1GvPymKN) — Stripe metadata has no item_* keys and stored cart has empty appeal_id. Manual fix required.
[2026-07-16 18:55:45] [INFO] Processing order: 052620260648420 (Invoice: PA-6a15424a8e910, PI: pi_3TbEn8F4ltXXlPEk1BPOl6fW)
[2026-07-16 18:55:46] [INFO] Stripe status for order 052620260648420: succeeded
[2026-07-16 18:55:46] [WARNING] cart_items invalid for order 052620260648420 — Stripe PI pi_3TbEn8F4ltXXlPEk1BPOl6fW metadata keys: invoiceid, item_1, item_2, item_3, item_4, order_no, visit_id | parsed item_* count: 4
[2026-07-16 18:55:46] [ERROR] Failed to save Stripe enrichment for journey id=4673: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'isrecurring' in 'SET'
[2026-07-16 18:55:46] [ERROR] Cart items unresolvable for order 052620260648420 (PI: pi_3TbEn8F4ltXXlPEk1BPOl6fW) — Stripe metadata has no item_* keys and stored cart has empty appeal_id. Manual fix required.
[2026-07-16 18:55:46] [INFO] ========================================
[2026-07-16 18:55:46] [INFO] Reconciliation complete. Total: 5
[2026-07-16 18:55:46] [INFO] Recovered: 0 | Already existed: 0 | Canceled: 0 | Abandoned: 0 | Processing: 0 | Skipped: 0 | No PI: 0 | Failed: 5
[2026-07-16 18:55:46] [INFO] ========================================