Importing Membership Levels

Bulk assign membership levels and expiration dates via CSV import

Membership Levels assigns a membership level, with an expiration date, to members who already exist. Use it once your levels are set up in your program.

Find it in the admin under Reports & Imports › Imports, at app.fanmaker.com/admin/settings/imports. Pick Membership Levels from the What are you importing? picker, then click Download example CSV to start from a file with the right headers.


Import Format

The first column

The first column of your file is how we find the member each row belongs to, and it has to come first. 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.

Required columns

  • level_id — matches an ID on your Membership Levels dashboard

  • expiration_date — when the level runs out, written as MM/DD/YYYY


Example Entry

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


Worth knowing

info icon
Note: Every membership level assignment needs an expiration date. There's no "never expires" option here — pick a date far enough out if the level is meant to run indefinitely.
success icon
Tip: If you can't find your level id, email [email protected] and we'll point you at it.

Did this answer your question?
😞
😐
😁