Bulk import for coaches

You can now bulk-import coaches from a CSV — the fourth importer to go live, after athletes, facilities, and volunteers.

Who can use it: club admins. Where to find it: top nav → Import → Coaches.

What it does

• Upload a CSV with one row per coach. Required columns: first_name , last_name , email . Optional: phone .
• For each row, the importer creates a user account if one doesn’t exist with that email, then grants the coach role on your club via user_club_access . If a user with that email already exists, the existing account is reused (we don’t overwrite their name or phone) and just the coach role is added.
• Auto-created user accounts have login disabled until the coach claims the account via the existing signup or password reset flow with their email. Safe to bulk-upload without worrying about premature access.
• Re-running the same CSV is idempotent. The (user, club, role) triple has a unique constraint, so duplicate rows are silently skipped.

Team assignment is separate

This importer does not assign coaches to specific teams. Coaches imported here become club-level coaches who can be picked from existing team management screens after the import. We made this choice because:

• A coach often coaches multiple teams across seasons, and forcing a team in the CSV would be awkward.
• Team assignments need extra metadata (primary vs assistant, season, jersey, position) that’s better filled in from the existing per-team UI.
• It keeps this CSV simple — three required columns, four total.

If you need to assign a freshly-imported coach to a team, head to the team’s roster screen and add them as a head coach or assistant. They’ll show up in the coach picker since the import gave them the club-level coach role.

Example

 first_name,last_name,email,phone
Pat,Henderson,pat.henderson@example.com,5552001000
Riley,Nakamura,riley.nakamura@example.com,5552001001
Jordan,Goldberg,jordan.goldberg@example.com, 

Three rows → three users + three user_club_access rows with role coach on your club. Re-uploading the same file is a no-op.

What’s coming next

• Teams import — the final piece. Will reference coaches and facilities, so it makes sense as the last to ship.
• Invite emails for auto-created coach accounts (so they know they’ve been added and can claim their login). Same enhancement applies to volunteers.