Selling Ticket packages. Need multiple options.

Hello,

Our client is selling tickets to events. Each event has multiple packages (e.x. General admission, VIP, VIP Cabana, etc.) Each ticket package has it's own price. So basically one event will have different package options with different prices. Each event will NOT share the same packages and/or prices.

We have successfully created all of the data-assist admin pages to insert a single event with a single price into the products table. We are now having trouble trying to figure out how to add multiple ticket packages with each it's own price to one event.

What would be the easiest way create multiple ticket packages and prices for one single event? Is there a way to simple add to our products_insert.php file the necessary form elements to insert these records?

Thank you for your time,
Nenad

I was hoping anyone could help. We are pressed on time and any help would be greatly appreciated.

Thanks!

I think I would do something like this:

Assign an event code for each event

Create a table with:

EventCode
package
package_price

The master table has all of the information for the event and you would look up the available packages and prices from the secondary table.

You can use the order and orderdetail tables in the eCommerce database as a guide as a guide.
ecommerce-database/

Thank you for the prompt reply Office Guy-172461, however I do not believe I am fully following your post. Could you possibly elaborate a bit?

Thank you!

Hopefully I'm following what you want :)

Think of the price packages as options for the event (product).

Instead of :

Concert featuring all of your favorite groups $50

It would be:

Concert featuring all of your favorite groups (product - unique event code)

and then you lookup and display all of the packages available for that event code from the second database (options)

Which would look like this:

Concert featuring all of your favorite groups
General admission $50
VIP $150
VIP Cabana $500

All of these option share the same event code so they would only show up on the product page with the same event code.

Maybe this will help:

Designing a Database
161/

In the example, Customer Orders Products table would be the event options
order_id would be package_id
quantity would be packge_price
comments would be package_name

The Product table would be your Event table and contains all of the info about the event except prices.
product_id would link the two tables.

Thanks Office Guy. Unfortunately I wasn't able to figure it out.

We have resorted to an alternate, "not what I intended" solution.

Thanks anyway!