Event Product: Seats or Tables or Little of Both...

[scubes13]

I am currently setting up ZenCart for a non-profit so that they may use the system to register visitors for a conference.

Here is my situation:

Tables at the event can seat 10 people.

A person may purchase either individual seats, individual tables (10 seats), or a combination of seats and tables.

Also, note that a table might be 10% cheaper to purchase than 10 individual seats (based on discount).

I would like to be able to set the system up so that I have an initial quantity of 1500 individual seats (or 150 tables).

The user should then be able to click on the event listing and I would like them to be able to see the following:

Indiv. Seat: __
Table: __
[Add To Cart]

It would also be nice to see in the admin section (backend) exactly how many "Tables" were purchased versus "Individual Seats". This would greatly assist in assigning seats and issuing tickets, etc.

Could someone please walk me through the process of setting up such a product?

I do not even really know where my limitations are/are not.

Any and all help is greatly appreciated!!!

Thanks,
Kevin L.

[scubes13]

Just for further clarification...

A Table of Ten Seats would cost $300.00
Individual Seats would cost $35.00

Individual Seats Purchased for students would cost $30.00 each

I would love to be able to do this as one individual product. I have noted that there is some way of making copies of the product and tying them together in some way.

I am really unsure of how to approach the situation. Any help and advice would be greatly appreciated!

TIA,
Kevin L.

[scubes13]

TTT...

Anybody?

Kevin L.