CiviCRM Community Forums (archive)

Hi everyone,

I work in a Cambodian NGO and we are using CiviCRM on Drupal (version 7.19). We are organizing a program of rotating performances in Phnom Penh which are Monday to Saturday at 7pm (Monday & Thursday is show #1, Tuesday & Friday show #2 and Wednesday & Saturday show #3). That's every week like this until March.

We have an online booking on our website and booking & contact information get sent to CiviCRM whenever somebody buys a ticket. Right now this is how it works, once the person has completed the purchase:
- if the contact record doesn't exist in the CRM yet, it gets created with all relevant information and it gets added to a group to keep track of all contacts who purchased tickets (if the contact record exists already it just gets updated)
- a contribution record is created for this contact (amount, type = "purchase", status = "completed")
- the relevant activity record is created for this contact (type = "contribution", subject = amount, status = "completed")
- a note record is created for this contact, with all booking information from the booking form on our website (amount, what show, what tickets, date of performance)

We would like to be able to pull out reports of these online bookings and keep better records of these activities. I would love your opinion on how to organize this.

Especially:
1) I guess using CiviEvent for this would be sensible but these are recurrent events, so should we create one event for each show each day (which makes 94 events! do we do manually?!) OR should we create one event for show #1, one event for show #2 and one event for show #3, but then how do we know who came on what date?
2) what's the best way to keep track of booking information (especially what ticket types - adult, child, etc.)? Should we create a new field somewhere?

Thank you so much for your help, and thanks for the Civi community for having created such a great tool!
Marion