Production Auth Migration — March 10, 2026

Problem

Production Supabase (vxabwjsddplhnpqtnuef) only had 6 organic signups. The 77 Firebase auth users were never migrated to production — only to dev.

Migration Process

Step 1: Auth User Creation

Script: migration-data/migrate-auth-prod.py

• Reads auth_users.json (Firebase export)
• Creates each user in prod Supabase via Admin API (/auth/v1/admin/users)
• Outputs id-mapping-prod.json (firebase_uid → prod_supabase_uuid)
• Result: 77 auth users created

Step 2: Users Table + Assignments Sync

Script: migration-data/sync-users-to-prod.py

• Uses id-mapping.json (dev) and id-mapping-prod.json (prod) to build dev_uuid → prod_uuid mapping
• Fetches all users from dev, inserts into prod with mapped UUIDs
• Syncs assignments (user-restaurant mappings)
• Result: 77 user rows synced, 6 assignments created

Step 3: Manual Fixes

• Ariane’s account existed on prod before migration (organic signup), required manual role update to super_admin and 4 restaurant assignments added directly

Key Files

Admin Roles on Production