In Bookings it is possible to set up events so that people can cancel their bookings. It is also possible for event organisers to cancel an event and all of its existing bookings.
To assist in handling refunds, a report has been added to the Data Exporter that will export a list of any cancelled bookings within a time period. As the purpose of the export is to assist in processing refunds, free events are excluded.
Create the Export
Follow the usual steps in The Scheduler to create your export, with the following additions.
Data Source
In the data source section, pick "End Point" then find the
Schedule
As with normal exports, you can either configure a schedule for your export, which each time it runs will export bookings that have been cancelled since it last ran, or generate a one-off export for a given date range.
Result
The export includes the following information about each cancelled booking.
| Property | Description |
|---|---|
| Booking date | The date the booking was made |
| Booking time | The time the booking was made |
| Occurrence ref | The reference number (business key) of the event occurrence |
| Total price (£) | The price of the tickets booked |
| Event | The name of the event |
| Location | The location of the event |
| Name | The name of the booker |
| The email of the booker | |
| Booking ref | The reference number (business key) of the booking |
| Cancellation date | The date the booking was cancelled |
| Cancellation time | The time the booking was cancelled |
| Occurrence date | The date of the event occurrence |
| Occurrence time | The time of the event occurrence |
| Packages | The number and names of the ticket packages booked |
| PayID | Any payment reference numbers |
Event Specific Exports
This end point has been created as community content - it's not part of the core product. It can be used to export the cancelled bookings for specific events, rater than all events:
Event Specific Cancelled Booking Export (ZIP, 1KB)
To set it up:
- Download and extract the export file from the zip
- Import the end point
- Rename the end point to something meaningful (replace the word SAMPLE)
- In the script, enter one or more event article IDs into the
limitedEventIds array. For examplelimitedEventIds: [1234,9876] - Save and publish the end point
Now, when scheduling your export you'll see your new end point listed in the data source drop-down.
The end point can be copied and renamed as many times as needed.
