Overview

Your Alpine database can be configured to automatically integrate with your ACME Ticketing account, syncing over ticket admissions, donations, and membership payments on a regular basis. Never miss a beat again and see comprehensive data in one place, your Alpine database, without worrying about manually needing to do exports and imports.


source: https://kbhelp.humanitru.com/knowledge/acme-ticketing-integration


TABLE OF CONTENTS


What is pushed to ACME Ticketing

Since the goal of this integration is to pull information from ACME Ticketing, your Humanitru Alpine database will not push any information into your ACME Ticketing account—it will only pull information. This is to prevent data overrides—if you update a Member information in ACME (name, address, etc.), you will need to manually update the corresponding Constituent in Alpine as well. Likewise, if you update a Constituent in Alpine, that information will not automatically update in ACME Ticketing.


What is pulled from ACME to Alpine

On a nightly basis, Alpine will pull all Transactions from ACME Ticketing from the last time it synced—meaning that Alpine will be at most only 24 hours behind the latest data within ACME Ticketing.


Every ACME Transaction can encompass several different Alpine Actions: one ACME Transaction may involve a Ticket to an Event, as well as an additional Donation, and a Membership Purchase. This means that each ACME Transaction will correspond to several Alpine Actions, grouped by the following criteria:


Event Name

For each line item in the Transaction that shares the same Event Name, they will be grouped together as one Alpine Action of Type RSVP. This includes any Add Ons as well.


ACME Ticketing Transaction Field

Humanitru Alpine Action Field

Transaction Date

Date (Happened At / Action Date)

Transaction ID

Notes

Transaction Notes

Notes

Order ID

Notes

Discounted Amount

Summed into the Amount field

Quantity

Summed into Ticket Quantity field, excluding Add On Quantities

Ticket Type

Combined in the Notes field

Add On

Combined in the Notes field

Event Name

Campaign


Donation Add On

For each line item in the Transaction of AddOnType of “fixedDonation” that shares the same Add On name, they will be grouped together as one Alpine Action of Type Donation.


ACME Ticketing Transaction Field

Humanitru Alpine Action Field

Transaction Date

Date (Happened At / Action Date)

Transaction ID

Notes

Transaction Notes

Notes

Order ID

Notes

Discounted Amount

Summed into the Amount field

Add On

Campaign


Membership Purchase

For each line item in the Transaction of OrderItemType of “MembershipPurchase” that shares the same Membership Level and Membership Offering Name, they will be grouped together as one Alpine Action of Type Membership Payment.


ACME Ticketing Transaction Field

Humanitru Alpine Action Field

Transaction Date

Date (Happened At / Action Date)

Transaction ID

Notes

Transaction Notes

Notes

Order ID

Notes

Discounted Amount

Summed into the Amount field

Membership Number

Notes field (see below, also synced into the Constituent profile as a Custom Field)

Membership Level + Membership Offering Name

Campaign, with Membership Level and Membership Offering Name combined with a colon and space in-between

Membership Duration / Length

See below (automatically synced every night)

Constituent Profile

All Alpine Actions will be associated with one Constituent, that is matched / de-duplicated by the email address given in the ACME Ticketing Transaction. This means that any ACME Ticketing Transactions without an email address will be skipped, and not synced into Alpine.


ACME Ticketing Transaction Field

Humanitru Alpine Constituent Field

Email

Email

Contact First Name + Contact Last Name

Name

Contact First Name

Email Salutation

Phone Number

Phone

Address1 + Address2 + City + State + ZipCode

Combined into the Address field


Nightly Membership Record Reconciliation

Key membership information such as Membership Number and Membership Expiration Date managed in ACME Ticketing will also be reconciled within Alpine on a regular basis. Every night, all Memberships within ACME Ticketing will be reconciled with their corresponding Alpine Actions of type Membership Payment, with the most current Membership Expiration Date from ACME Ticketing updating the Membership Length attribute of the corresponding Alpine Action. Furthermore, any ACME Ticketing Card Holders associated with that ACME Ticketing Membership, with valid email addresses within ACME Ticketing, will be reconciled with any matching Alpine Constituents via email address, and will have the Alpine Membership Payment Action “linked” or “soft-credited” to their profile, as well as having the Custom Field of “[ACME] Membership Number” updated as well.


Any Memberships within ACME Ticketing will be appropriately reflected not only to the primary Constituent associated with the Alpine Membership Payment Action, but also any additional cardholders listed within ACME Ticketing will also be reflected on additional Constituent profiles within Alpine. Finally, any changes to Membership Expiration Dates within ACME Ticketing will also be reflected within Humanitru Alpine within twenty-four hours.


Sync Details

Timing: Nightly

This integration syncs on a nightly basis every 24 hours.


Constituent Matching: Email only

When looking up a pre-existing constituent to match within Humanitru Alpine, the “Email” field will be prioritized, then any Custom Fields of type “Email” to return the first matching constituent. If no match is found, then a new Constituent will be created.


Action Matching: Yes

Transactions from ACME Ticketing are de-duplicated by Transaction ID if they already exist within Humanitru Alpine; however, once created/initially synced into Alpine, any further updates will not be propagated into Alpine from ACME. This means that if changes are made to ACME Orders after they are created, they will need to be manually updated within Alpine.


Technical Caveats

  • Item Purchases that are not associated with fixedDonations or an Event will not be synced
  • Membership Status filters and reporting within Alpine are based on the primary Constituent (hard-credited), and will not accurately reflect the Membership Status of additional cardholders that are “soft-credited” or linked.
  • Within Alpine, Memberships are considered started from the moment of purchase, meaning that if within ACME Ticketing a Membership Level is configured such that purchasing a Membership somehow results in the Membership not activating until a certain in the future, Membership reporting within Alpine may not be accurate
  • Due to timezone issues, calculated Membership expirations within Alpine may be up to a day off in rare cases where the time zone of the ACME Ticketing platform does not match the time zone of the configured Humanitru Alpine deployment