Coupon for Free Item if certain amount purchased

I want to give a free pair of earrings to any customer who purchases $500 or more. Is this possible? If its not possible to set it up directly, can someone think of a workaround?

Also, I know this is a stupid question, but where do I direct customers to see what coupons are available?

Lastly, when I try to check out and put in the coupon code i get this error message:

1065 Query was empty
in:
[]

Any ideas?

Jason

What version Zen Cart are you running? Your site in your signature looks rather old, the current release is v1.3.6 ...

On the Discount Coupon you can set the restriction to have a minimum order amount and be only for the specific product ...

I'm running 1.3.0.2. I know its old but I dont feel competent enough to upgrade. I'll have to hire it out and I'm not prepared to do that yet.

What do you make of that error message?

Thanks,

Jason

I don't have a v1.3.0.2 handy to know if that was a bug in that version or something in your template or what on this one ...

I'd have to hunt down the bug fixes etc. from that version until now ...

If you can find the time I would greatly appreciate it.

Jason

Ajeh:

On the Discount Coupon you can set the restriction to have a minimum order amount and be only for the specific product ...

I just posted a question about this, but I think I see why it doesn't work. When you set a minimum purchase, then you restrict the coupon to a particular product, the cart will only allow the minimum purchase to be made from those products.

So basically they would have to buy $500 worth of that earring set to get the free pair. Not the optimal setup, I can't think of a workaround but it's a good idea for a tweak.

Maybe I'm missing something??