TicketSpice allows you to import memberships in bulk, making it easy to add existing memberships to your account or update multiple memberships at once. Importing memberships helps you migrate member data, keep membership records up to date, and manage your membership program more efficiently.
Jump To...
Import Memberships into TicketSpice
Note: When you import new members, TicketSpice does not create system contacts for them. To save an imported member as a contact, you must use the Import Contacts feature to import them as a contact or have them complete an order in TicketSpice.
From the top menu bar, hover over the Extras tab
Select Memberships from the dropdown
Select the Members tab on the left-hand side
Click Import Members
Click Download Template. You can also click here to download the template
Click View Columns and make note of the Numerical Member Level ID for each membership level. This value identifies each membership level in your account and is used to match your imported members to the correct level. If you want to upload members to a level that does not appear in the list, create the new membership level in TicketSpice first. Click here to learn how to add a new membership level
Warning: When importing members, follow the template exactly and avoid moving or deleting any columns to ensure a successful import into TicketSpice. We recommend entering your information directly into the provided template file, as even small changes to the template can cause the import to fail.
Find the template on your computer, and open the file
Add the Membership information to the template
Member Number: A unique number for your member(s). Make sure that you enter a unique member number for each member
First Name: the first name of the member
Last Name: the last name of the member
Email: the email address of the member
Numerical Member Level ID: The specific identifier of the membership levels you have on TicketSpice. If you do not know the numerical member level ID for your memberships, go to the Import Members screen in TicketSpice, and expand the View Columns dropdown. From there, scroll to the Numerical Member Level ID field, and find the IDs associated with each membership level on your account
Fee: The price for the membership
Status: The status of the membership
Expiration Date: The date the membership expires
Save the file
Pro Tip: Before importing your data into TicketSpice, we recommend reviewing the file, and ensuring that there are no duplicates and that all of the information is accurate.
Note: When importing memberships, be sure to use only the numerical Member Level IDs that match your existing membership levels.
Using any other values, including other numbers, letters, or symbols, can prevent memberships from importing correctly and may cause data issues.
When you are ready, go back to the TicketSpice Import Members screen
Click Upload CSV File
Select the appropriate file
Click Open
Enter the Email you'd like to receive a summary of successful members, along with a CSV file detailing the reasons for any unsuccessful imports
Select whether you want to Create New Members Only or Create New Members and Update Existing Members Based on Your Member ID or Webconnex Member ID
Click Import
Pro Tip: When selecting the Create New Members Only option, our system will only add new members. If a member ID already exists in your TicketSpice account, that membership will be skipped. The summary email will indicate how many members were skipped due to existing records in TicketSpice.
If you choose the Create New Members and Update Existing Members option, our system will update any members in your account that share the same member ID as those in your CSV file. With this option, the system will update the name, email, numerical member level ID, fee, status, and expiration date for the member(s) if these fields are different on the CSV file. If you choose this option, we recommend confirming that your member IDs match your previous upload to ensure the correct information is updated.
FAQs
Will members receive an email when I import memberships into TicketSpice?
Will members receive an email when I import memberships into TicketSpice?
No. Members do not receive an email when they are imported into TicketSpice. Membership info emails are only sent when a membership is purchased or renewed on the live page, or when an admin manually resends the membership information email.