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 canclled 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 |
Share this page
