Troubleshooting - Ultimate Cart Recovery (EN)

"No tracking rows are being created"

Symptoms: bin/magento ucr:detect returns 0 every time even when carts clearly look abandoned.

  1. visicrea_ucr/general/enabled = 1?
  2. Magento cron actually running? bin/magento cron:status or check cron_schedule table.
  3. The candidate quotes must have:
  4. is_active = 1
  5. items_count > 0
  6. updated_at <= NOW() - abandon_delay_minutes
  7. a non-empty customer_email
  8. Are quotes already tracked? Re-detection is suppressed for any quote that already has an active (new / contacted_step_*) tracking row.

"Emails never go out"

  1. dry_run = 1 will look like success in the logs but skip the actual send - check that first.
  2. License status: bin/magento ucr:debug:license. If the status is expired or invalid, sends are disabled (but dashboard + grids still work).
  3. Mailgun reports a bounce → the recipient is silently added to the unsubscribe list and future steps short-circuit as fallback_skipped.

"SMS work in dev but fail in prod"

"License banner shows up"

Online check failed for > 7 days (grace period). The banner stays for the configured banner_period_days (default 30), after which message dispatch is disabled. Reading + dashboards keep working.

Re-run bin/magento ucr:debug:license while you investigate connectivity.

RGPD requests

bin/magento ucr:export:gdpr customer@example.com > export.json
bin/magento ucr:delete:gdpr customer@example.com

The unsubscribe table keeps the email (legal hold) but the source is marked gdpr_deletion.

Resetting a stuck tracking

UPDATE visicrea_ucr_tracking
SET status = 'excluded'
WHERE entity_id = ?;

Re-detection will create a fresh tracking on the next cron tick - the old one is now in a terminal state so the join filter ignores it.