Travel tour booking system
I'm building an event booking system for a travel tour company. It's pretty straightforward: several tour types, a calendar, shopping cart integration, a display how many seats are available per date, and close that tour date when sold out etc.
After navigating various incompatibility hurdles between various versions of contributed modules (I'm on my 7th fresh install at this point) I'm inching closer to gauge if Drupal Commerce in its current state is a viable option for this project.
Currently I see the following show stoppers.
1. I added a date field to the event product type, but cannot reference it in Calendar due to the Rules issue where it can't find referenced nested fields. Is there another way to display a date attribute of a product type in Calendar?
2. I saw the SKU discussion thread, and from the perspective of this project it's not a good solution. In its current state, I would have to create the same product again and again for each event date. I looked into the bulk product creation module in the hopes of being able to batch create products based on product type id and date, but this module seems to be not working at all.
3. Is there a solution available to manage stock, in this case the number of seats available per tour?
Advice would be much appreciated.