[2026-03-16 04:43:55] [INFO] Found 11 orphaned checkout(s) to process
[2026-03-16 04:43:55] [INFO] Processing order: 031520261708036 (Invoice: PA-69b6e77353d19, PI: pi_3TBI91F4ltXXlPEk03FadB2y)
[2026-03-16 04:43:55] [INFO] Stripe status for order 031520261708036: requires_source
[2026-03-16 04:43:55] [INFO] Order 031520261708036 requires action but is < 12h old -- skipping
[2026-03-16 04:43:55] [INFO] Processing order: 031520261905312 (Invoice: PA-69b702fb0a33b, PI: pi_3TBJyhF4ltXXlPEk0MslnDRN)
[2026-03-16 04:43:55] [INFO] Stripe status for order 031520261905312: requires_source
[2026-03-16 04:43:55] [INFO] Order 031520261905312 requires action but is < 12h old -- skipping
[2026-03-16 04:43:55] [INFO] Processing order: 031520261939094 (Invoice: PA-69b70add52ab7, PI: pi_3TBKVFF4ltXXlPEk1kEMxiwg)
[2026-03-16 04:43:56] [INFO] Stripe status for order 031520261939094: requires_source
[2026-03-16 04:43:56] [INFO] Order 031520261939094 requires action but is < 12h old -- skipping
[2026-03-16 04:43:56] [INFO] Processing order: 031520262132383 (Invoice: PA-69b72576a62f8, PI: pi_3TBMH4F4ltXXlPEk0L2vUN4L)
[2026-03-16 04:43:56] [INFO] Stripe status for order 031520262132383: requires_source
[2026-03-16 04:43:56] [INFO] Order 031520262132383 requires action but is < 12h old -- skipping
[2026-03-16 04:43:56] [INFO] Processing order: 031620260119333 (Invoice: PA-69b75aa51c254, PI: pi_3TBPofF4ltXXlPEk14ogTj7k)
[2026-03-16 04:43:56] [INFO] Stripe status for order 031620260119333: succeeded
[2026-03-16 04:43:56] [INFO] Reusing Stripe customer from PaymentIntent: cus_U9jHVr7rglsRhg
[2026-03-16 04:43:56] [ERROR] Failed to process order 031620260119333: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'phone' at row 1
[2026-03-16 04:43:56] [INFO] Processing order: 031620260327478 (Invoice: PA-69b778b3aa114, PI: pi_3TBRolF4ltXXlPEk0kppTrfk)
[2026-03-16 04:43:56] [INFO] Stripe status for order 031620260327478: succeeded
[2026-03-16 04:43:56] [INFO] Reusing Stripe customer from PaymentIntent: cus_U9lReG53Zb7cw1
[2026-03-16 04:43:56] [INFO] Found existing donor ID: 1850 for akmemara@gmail.com
[2026-03-16 04:43:56] [INFO] Created transaction ID: 2381 for order 031620260327478
[2026-03-16 04:43:56] [ERROR] Failed to process order 031620260327478: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column `tsmtxvzpfj`.`wp_yoc_transaction_details`.`appeal_id` at row 1
[2026-03-16 04:43:56] [INFO] Processing order: 031620260629523 (Invoice: PA-69b7a360f2a64, PI: pi_3TBUezF4ltXXlPEk1LeebPXV)
[2026-03-16 04:43:56] [INFO] Stripe status for order 031620260629523: requires_source
[2026-03-16 04:43:56] [INFO] Order 031620260629523 requires action but is < 12h old -- skipping
[2026-03-16 04:43:56] [INFO] Processing order: 031620260830221 (Invoice: PA-69b7bf9e437e0, PI: pi_3TBWXaF4ltXXlPEk0C2xWmi4)
[2026-03-16 04:43:56] [INFO] Transaction already exists for order 031620260830221. Marking journey as confirmed.
[2026-03-16 04:43:56] [INFO] Processing order: 031620260834181 (Invoice: PA-69b7c08a516b4, PI: pi_3TBWbOF4ltXXlPEk08grOhbg)
[2026-03-16 04:43:56] [INFO] Transaction already exists for order 031620260834181. Marking journey as confirmed.
[2026-03-16 04:43:56] [INFO] Processing order: 0316202608375510 (Invoice: PA-69b7c16305ee7, PI: pi_3TBWetF4ltXXlPEk0UELgpxr)
[2026-03-16 04:43:56] [INFO] Transaction already exists for order 0316202608375510. Marking journey as confirmed.
[2026-03-16 04:43:56] [INFO] Processing order: 031620260838064 (Invoice: PA-69b7c16e481b4, PI: pi_3TBWf4F4ltXXlPEk1b2YZ6Hm)
[2026-03-16 04:43:56] [INFO] Transaction already exists for order 031620260838064. Marking journey as confirmed.
[2026-03-16 04:43:56] [INFO] ========================================
[2026-03-16 04:43:56] [INFO] Reconciliation complete. Total: 11
[2026-03-16 04:43:56] [INFO] Recovered: 0 | Already existed: 4 | Canceled: 0 | Abandoned: 0 | Processing: 0 | Skipped: 5 | No PI: 0 | Failed: 2
[2026-03-16 04:43:56] [INFO] ========================================