Coupon codes not working

[KTNaturals]

All of the sudden a lot of my coupon codes stopped working. I get a message "This coupon code is not valid for any product currently in your cart."

I did some tests, and I discovered that if I add a product restriction WITH a category restriction, the code does not work no matter what. I even added "allow all" at the end of the category restriction.

If the restriction is only on a product or only for a category, then it works fine.

I normally deny Gift Certificate category on all my coupons and deny a specific product, so majority of them aren't working...

Everything was fine up until 8/22 - that's when someone used a coupon code last with category and product restrictions. Since then, the changes I made are:

Authorized.net fix
http://www.zen-cart.com/forum/showthread.php?t=105924

SQL Injection patch
http://www.zen-cart.com/forum/showthread.php?t=106701

Any advice? TIA!

[Ajeh]

What are the exact settings you have on the restrictions?

Do you use Linked Products?

[KTNaturals]

Restriction for my test coupon code that doesn't work:

Deny Category "Gift Certificates"
Deny Product "6-Piece Mineral Makeup Starter Sample Kit"

That's it. Here's the coupon setting:

Coupon Name :: test
Coupon Amount :: 10.0000%
Start Date :: 09/04/2008
End Date :: 09/04/2009
Uses per Coupon :: Unlimited
Uses per Customer :: Unlimited
Valid Product List :: Restrictions Apply
Valid Categories List :: Restrictions Apply
Date Created :: 09/04/2008
Date Modified :: 09/04/2008
Coupon Zone Restriction: :: 0

I do have linked products, but they're not part of the coupon restriction. Plus they have been there for a very long time...

[KTNaturals]

The plot thickens... If I add more than 1 category to be denied to the category restriction, the code doesn't work. I even added "allow all" again...

Oh, BTW, I'm on 1.3.8a with all recent patches applied.

[Ajeh]

Could you set 1 more restriction on:
Category Top Deny

Does this get things working again for you?

[Ajeh]

NOTE: Gift Certificates, when setup correctly, are automatically excluded from Discount Coupons ...

[KTNaturals]

Could you set 1 more restriction on:
Category Top Deny

Does this get things working again for you?

Nope.

Thanks for the tip about GCs and coupons. That one tested fine.

I still have issues with other coupons with multiple categories and cat/product combo though.

What is the file that handles this logic? I'm going to compare mine against the default to see if something got accidentally changed...

[Ajeh]

There is an existing problem with Discount Coupons on Linked Products when the Allowed Category has a higher categories_id than one of the other categories_id for the Categories that the Product is Linked to ...

I do not have a simple solution to this, other than to define the Products separately ...

We are working on a fix for this ...

[KTNaturals]

I deleted the linked product because it was disabled anyway, but it's still not working. Any other ideas?

[Ajeh]

What are the settings set to now on the Discount Coupon?

What are your restrictions set to now on the Discount Coupon?

Make sure you do NOT have both:
Free Shipping
Amount/Percentage

set on the Discount Coupon ... you cannot do both ...