📑 Pronto Replacement Cards Migration & Audit Report
Feature: Pronto Card Replacement & Member UUID Backfill
Date: September 2026
Status: :white_check_mark: VERIFIED ON STAGING
1. Migration Overview
To resolve split member identities resulting from lost or reissued physical loyalty cards across retail locations, this migration deployed:
1. Member UUID Backfill: Generated immutable UUIDs for all historical partners.
2. Pronto Replacement Cross-Referencing: Ingested the Pronto card replacement mapping matrix (Cards_in_Pronto_replacement.csv).
3. De-duplication & Deactivation: Re-anchored new card numbers to the primary member profile while deactivating previous card records.
2. Test & Verification Matrix
| Verification Step | Target Output | Status |
|---|---|---|
| UUID Backfill Script | Every active loyalty member has a non-null rrp_member_uuid. |
:white_check_mark: PASSED |
| Card Ingestion | Pronto cards mapped to correct partner records without dropping points balances. | :white_check_mark: PASSED |
| Search Override | Searching for previous card number redirects to the current active member profile. | :white_check_mark: PASSED |
| Replacement Audit Log | Every swapped card has a corresponding entry in real.rewards.card.replacement.log. |
:white_check_mark: PASSED |
3. Migration Statistics
- Total Member Records Audited: 120,000+
- Pronto Replacements Ingested: Complete
- Zero Points Discrepancies: Verified through automated ledger reconciliation scripts.