Solabran — Customer Re-link Tool

1 Scan for broken customer links

Fetches all live customers, then scans estimates, invoices, jobs and payments for records whose customer_id doesn't match any live customer UUID.

Load Export JSON (optional — improves auto-match)

2 Review & fix broken records

Auto-matched (0)

Need manual fix (0)

Already correct (0)

These records were automatically matched using name/number lookup. Click Apply All Auto-matches to patch them on the live portal.

These records could not be auto-matched. Use the dropdown to select the correct customer, then click Apply Manual Fixes.

These records already have a valid customer_id — no changes needed.

3 Alternative: console script (if direct patching failed)

If the direct patches above didn't work, use this console script instead. It contains the exact UUID mappings determined by the scan — no guessing needed.