Seat reservation system

I am using Zencart 1.3.8
I added "Stock by Attributes" and "Product Attribute grid"
and it seems to be working OK except for one small point.
The URL is:
http://prairiedogcentralrailway.com/zencart/index.php?main_page=product_info&cPath=85&products_id=260

I am trying to sell seats on a train.
There are 20 trips, each a category.
On each trip, there are 300 seats, each a product.
Each seat can have one of 2 prices, Adult or Child.
When I enter the number of seats I want, adult and/or child, the stock is deducted from each attribute, and ALSO from the product.
The sales part is working fine, but I want to suppress the deduction of seats per attribute, because it is done for the product.

When all 300 seats are sold, I want to see the "Sold Out" indication.
The present system forces me to enter a quantity for each attribute, and the total becomes the product total

I want the product total to be 300, and ignore the attribute total for stock purposes. The attribute total is used for sales only.

Am I missing something here? Has anyone used Zencart for a reservation system?

Is there is simple fix?

Keith Bradley

It could be me who's missing something, but, assuming that there isn't a limit on either attribute (i.e. you don't mind a train with 300 adults and no kids), why not just dispense with stock by attributes? Then Zencart will track the total number of tickets and display Sold Out when appropriate.

I was just browsing through and caught a glimpse of your website and really liked your template...

I agree with stevesh. Use of the stock by attributes would seem to be getting in the way here with no obvious benefit.

You have a good point. If I dispense with stock by attributes, I will get a SOLD OUT display when all 300 seats are sold.
This is what I want.
However, each seat may be occupied by an adult or child, and there is a different price for adult and child.
How can I offer a choice of 2 different prices for the same seat? How can I do this without using attributes?
Can I use a discount for this?

Thanks for the help

Keith Bradley

No, we're not suggesting that you don't use attributes - just that you don't use stock by attributes.

You can add a positive or negative variation to to each attribute which is then applied to the products price.

So for example you could set your product price to be $10, and your child attribute to be -$5, which would discount your full price by $5 whenever the child attribute is selected.

Alternatively you could set your product price to be zero and give your child attribute a price of $5 and your adult attribute a price of $10.

This solution works fine, but if I want to buy 2 adults and 2 child seats, how does that work?
I removed the stock by attributes (GRID) and used Dropdown.
I can now select Adult and/or Child, with the correct price, but I have to enter the total quantity in "Add to Cart"
If I enter 4 in "Add to Cart", I get 4 seats at the child price. I want 2 adult and 2 child prices.
Is there a way to do this?
If I use a Radio button, I only get one or the other, not both.
If I buy adult and child seats separately, in 2 sessions, using Radio buttons, would that work?

I am very appreciative of your help, and the response time is amazing!
Thankyou

Keith Bradley

Using radio buttons, I can select Adult, add 2 to Add to Cart, and Continue shopping.
On the next screen, I select Child, and add 2 to Add to Cart.
This means I can buy 2 at the adult price and 2 at the child price.
This answers all my questions...
Thankyou.

I will send a donation

Keith Bradley :D

There is also this, which I believe will add quantity boxes to your attributes:

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=876

I haven't tried it, though.