=== Abandoned Cart Email System Test ===

1. Testing database connection... ✓ Connected (Found 519 abandoned carts)

2. Checking for abandoned carts ready for emails...

   Cart #3358:
   - Email: nbrigman21@gmail.com
   - Status: LINK_GENERATED
   - Reminders sent: 1/3
   - Minutes since abandoned: 647
   - Amount: $59.99
   → Not yet ready for next email

   Cart #2814:
   - Email: racquelrimle@gmail.com
   - Status: LINK_GENERATED
   - Reminders sent: 3/3
   - Minutes since abandoned: 35573
   - Amount: $59.99
   → Not yet ready for next email

   Cart #2803:
   - Email: cyclonuspam@gmail.com
   - Status: LINK_GENERATED
   - Reminders sent: 3/3
   - Minutes since abandoned: 45850
   - Amount: $59.99
   → Not yet ready for next email

   Cart #2792:
   - Email: dcox@tmindustrialsales.com
   - Status: LINK_GENERATED
   - Reminders sent: 3/3
   - Minutes since abandoned: 45941
   - Amount: $839.93
   → Not yet ready for next email

   Cart #2744:
   - Email: kegg97@aol.com
   - Status: LINK_GENERATED
   - Reminders sent: 3/3
   - Minutes since abandoned: 48843
   - Amount: $59.99
   → Not yet ready for next email

   Cart #2742:
   - Email: angelshy2002@charter.net
   - Status: LINK_GENERATED
   - Reminders sent: 3/3
   - Minutes since abandoned: 50157
   - Amount: $119.99
   → Not yet ready for next email

   Cart #2736:
   - Email: shoey758@att.net
   - Status: LINK_GENERATED
   - Reminders sent: 3/3
   - Minutes since abandoned: 51164
   - Amount: $59.99
   → Not yet ready for next email

   Cart #221:
   - Email: Sheikhazeem.pk@gmail.com
   - Status: LINK_GENERATED
   - Reminders sent: 3/3
   - Minutes since abandoned: 296316
   - Amount: $119.98
   → Not yet ready for next email

3. Running email sender...
   Emails sent: 0
   Errors: 0

4. Recent email activity:

   nbrigman21@gmail.com:
   - Reminders: 1
   - Last sent: 2026-04-28 01:20:03
   - Status: LINK_GENERATED

   dmarquez1288@gmail.com:
   - Reminders: 3
   - Last sent: 2026-04-27 20:30:02
   - Status: cancelled

   nopeekipani@gmail.com:
   - Reminders: 3
   - Last sent: 2026-04-27 12:50:02
   - Status: cancelled

   skylaralexis927@gnail.com:
   - Reminders: 3
   - Last sent: 2026-04-27 12:10:02
   - Status: cancelled

   mdl888@live.com:
   - Reminders: 3
   - Last sent: 2026-04-26 23:40:02
   - Status: cancelled

=== Test Complete ===

Next Steps:
1. Set up cron job: */10 * * * * php send_abandoned_cart_emails.php
2. Monitor results in database
3. Check email delivery with test orders