👥 User Management

Combine duplicate player records and re-aggregate stats

🔒 Admin Tool
← Back to Admin 📊 Aggregator
-
Total Records
-
Auth Users 🔐
-
Linked (users coll)
-
Legacy Profiles
-
Migrated
-
⚠️ Issues
ℹ️ How to Combine Player Records (e.g., Joe/Joseph)
  1. Search for player name variants (e.g., "Joe Smith" and "Joseph Smith")
  2. Select the records to merge as Source (data moves FROM these)
  3. Select ONE record as the Target (data moves TO this)
  4. Preview shows actual playerStats and pitchingStats data
  5. Execute merge moves all season/game docs and deletes source docs
  6. Run the Aggregator afterward to rebuild career totals!
⚠️ This tool merges at the source level:
  • playerStats/{source}/seasons/* → playerStats/{target}/seasons/*
  • playerStats/{source}/games/* → playerStats/{target}/games/*
  • pitchingStats subcollections are also moved
  • Source documents are deleted after copying
  • aggregatedPlayerStats/{source} is marked as migrated
🔍 Find Player Records
🔎 Direct playerStats Lookup (for records not in aggregatedPlayerStats)

⚡ Merge Preview

📥 Source Records (will be merged)

→

📤 Target Record (receives all stats)

📊 Combined Career Stats Preview
📅 Seasons to Merge
Season Team G AB H R AVG Source
📊 Profile Setup Status

Track which authenticated users have completed the profile setup guide.

-
Total Auth Users
-
Setup Complete
-
Partial Setup
-
Not Started
-
Has FCM Token
-
In Directory
-
Active (30 days)
-
Stale (60+ days)
User ↕ 1️⃣ 2️⃣ 3️⃣ Role Joined ↓ Last Visit ↕
Loading user data...

🔧 Repair Orphaned Stats (Auth UID → Legacy ID)
⚠️ What this does: Finds playerStats documents stored under a Firebase auth UID (caused by a merge bug now fixed). Moves seasons/games to the correct legacy snake_case path, then deletes the orphaned UID doc. Run the Aggregator afterward.
📧 Bulk Email Update

Upload a CSV or Excel file to update the email field in users/{id} for any player — auth or non-auth. Matched by player name against the loaded player list.

📋 Expected format: Any CSV or Excel with at least a name column and an email column. You'll map the columns after upload.
Writes only the email field to users/{documentId} — no other fields touched.
📧

Click to upload or drag & drop

CSV, XLSX, or XLS

📋 Operation Log
Ready. Search for players to begin...