Map Auto-Generated Data from Accelevents to HubSpot
With the Accelevents to HubSpot integration, you can include order information in the data transfer aside from the attendee's basic information.
In this article, you'll learn how to export auto-generated data from Accelevents, such as the order number, ticket name, ticket number, ticket status, attendee QR code, discount codes and access codes, paid amount, and the tracking link used to purchase the ticket by mapping these fields in the HubSpot Integration.
Auto-Generated Accelevents Data
In the Configure HubSpot Mapping menu in Settings > Integrations > HubSpot Configure, you can search for the auto-generated data fields from the Accelevents dropdown.
Accelevents Field Name | Data |
Order ID | This is the order number in Accelevents.
This should be mapped to a number field in HubSpot. |
Ticket ID | This field will show the ticket number.
This should be mapped to a number field in HubSpot. |
Ticket Type | This is the Ticket Name in Accelevents.
This should be mapped to a single-line text field in HubSpot. |
Barcode ID | This is the Attendee QR Code. It will appear as an alpha-numeric code.
This should be mapped to a single-line text field in HubSpot. |
Tracking Link | This is the tracking link name. This field will populate if a tracking was used to purchase the ticket.
This should be mapped to a single-line text field in HubSpot. |
Ticket Status | This is the ticket status. This field will populate, indicating the status of the order.
This should be mapped to a single-line text field in HubSpot. |
Coupon Code | This is the discount code. This field will populate if a discount code was used to purchase the ticket.
This should be mapped to a single-line text field in HubSpot. |
Access Code | This is the access code. This field will populate if an access code is used to unhide the purchased ticket.
This should be mapped to a single-line text field in HubSpot. |
Paid Amount | This is the paid amount. This field will populate the amount paid at the time of ticket purchase.
This should be mapped to a single-line text or number field in HubSpot. |
Step 1: Create HubSpot Properties (fields)
You'll need to create matching contact properties in HubSpot so that the data will land on the designated field.
Log in to HubSpot
Go to Settings
Select Properties under Data Management
Click Create Property
Step 2: Map the fields
After you create the property fields in HubSpot, you can refresh your admin console to see the properties from the dropdown. Select the matching fields, then click Save.
Test the Auto-Generated Mapping
Sign up for the event using the tracking link, access, and discount code. Check the contact in HubSpot to see if the data auto-populated for the fields you added.
Note: The QR image will not show in HubSpot. Instead, the QR code will be converted to a Barcode ID.
Status When a Ticket is Purchased
When a ticket is purchased, the ticket or payment status will depend on the selected payment method upon purchase.
Status | Payment Type |
PAID | Cash, Check, or Credit Card |
COMPLIMENTARY | Complimentary |
UNPAID | Unpaid or Invoice |
Status When Payment is Applied
When a partial or full payment is applied to an unpaid transaction, the status in Accelevents will automatically change to Partial or Paid. However, the status will not automatically update in HubSpot.
Note: The Apply/Adjust Payment option is only available for invoice transactions
To push the status in HubSpot, you'll need to do at least one of these actions:
Check in the attendee
Open the ticket holder information and click update
If it's a full payment, the status in HubSpot will be PAID.
If it's a partial payment, the status in HubSpot will be PARTIALLY PAID.
Status When Refund is Applied
When a partial or full refund is applied to any type of transaction, the status in HubSpot will automatically update to PARTIALLY REFUNDED or REFUNDED.
Ticket Name Update
If a ticket exchange is done, the ticket name in HubSpot will only update if a "push" is done. To push the new ticket name in HubSpot, you'll need to do at least one of these actions:
Check in the attendee
Open the ticket holder information and click update