company logo

Help center

Go to FanmakerLogin
All collectionsSettingsImportImport Member Info

Import Member Info

Update existing users by importing profile details

Member Info fills in profile details on members who already exist — names, addresses, phone numbers, your own ids for them.

Find it in the admin under Reports & Imports › Imports, at app.fanmaker.com/admin/settings/imports. Pick Member Info from the What are you importing? picker, then click Download example CSV — it comes with every column already in the header row, so you only have to delete what you don't need.


Import Rules

The first column

The first column of your file is how we find the member each row belongs to. It has to come first — having an email column further along isn't enough.

Use whichever one of these you already have:

  • email — their email address

  • username — their username

  • user_id — Fanmaker's own id for the member

  • member_id — your membership number for them

  • student_id — student number, for education programs

  • ticketmaster_id — their Ticketmaster account id

  • cust_id — external customer ID

  • pid — external customer ID

  • oktaid — their Okta id, for sites using Okta SSO

  • phone_number — their mobile number. We match on the last 10 digits, so 19522177561 and (952) 217-7561 both work.

Optional columns

Everything this import updates is optional — send the ones you have:

  • first_name — given name

  • last_name — family name

  • member_id — your membership number for them

  • student_id — student number, for education programs

  • ticketmaster_id — Ticketmaster account id

  • paciolan_id — Paciolan account id

  • address — street address

  • address_2 — apartment, suite, unit

  • city — city

  • state — state or province

  • zip — postal code

  • country — normalized on the way in, so "USA" and "United States" both land

  • phone_number — 11 digits, including country code. For example: 19522177561

  • priority_points — priority points balance

  • relationship_status — your own relationship or status label


Example Entry

A file with the headers email and member_id, and one row reading:

  • email — [email protected]

  • member_id — 1234

This updates the member [email protected] and sets their member id to 1234.


Worth knowing

warning icon
Note: This overwrites the values already on the account, and it cannot be reverted. Leave a column out entirely if you don't want to touch it.
info icon
Note: This import will not create anyone. It only updates members who already exist — use the Create Members import first if you need new accounts.
info icon
Note: A Ticketmaster id can take several hours to resolve before the Ticketmaster data attached to it appears.

Did this answer your question?
😞
😐
😁