Discount coupon product restriction

I have created a coupon discount and want to assign it to a single product. However, when I click on restrictions, it says that I have no products (Displaying 0 to 0 (of 0 products)). Why is this happening. I have many product offerings that are fully functional and that have been purchased by many clients. Could you help?

When you make the Discount Coupon then go to the Restrictions ... what happens when you select from the Product Section the Category that the Product is in that you want to set on this Discount Coupon? :unsure:

Similar problem here: I've got products assigned to mulitple categories and coupons with product category restrictions.

It seems that the coupon will not work unless the **first category **assigned (as listed in tables products_to_categories) is allowed in the coupon. If the product category allowed by the coupon is listed 2nd or later, then the coupon will not apply.

I think the first one is considered the 'master category.' Any ideas?

Thank you.

The master_categories_id is actually assigned to the Product itself ...

You can see this on the Product page in your Admin ...

If you need to include a Product not using the master_categories_id that matches a Category ... you can add the individual Product to the Discount Coupon ...

Setup the Discount Coupon as:
Category Top DENY

Then add your Categories and/or Products to the coupon ...

Thanks Linda.

This is too many products to do individually. The coupon that my customer wants applies to the entire category of items. Several hundred items.

I did the Category Top DENY, then added Category B allow. A product that is assigned to both Category A and Category B should be but will not be discounted by the coupon. A product assigned to both Category B and Category C will be discounted (as it should be).

Does this seem right? Is that the way the coupon category restrictions are intended to work?

Is there a way to make it look at all the categories of the item and not just the first one in the list?

Have you tried to use the setting in the Restrictions for Products where you pick the Category ... then pick the setting for:
Add All Category Products

This will pick all Products that are part of the Category via master_categories_id or just Linked to it ...

Okay, I see that option now. Thanks.

That does work. It's not the first choice, since each time we add products to the site (monthly), we'll have to re-run this process, whereas if the multiple-categories option was available, any new part within the ALLOWed category would be automatically subject to the discount, which is desired in this case.

But, a solution is a solution and I thank you, Linda, for quick, effective guidance.

This always reminds me that its time to buy the team more coffee and donuts. :smile:

Matt

You are most welcome ... thanks for the update that this worked for you and thanks for the support ... :smile:

Hi,
I am using this thread because it seems adeguate to me.
My problem is that if a product allowed for a coupon is in the cart, then any product put in the cart will get the same discount assigned to the coupon.
I have set the coupon to be denied for each category in the upper part of the form (red-green) and in the lower part only the two products allowed are listed as allow (green-red). When I say "each category" I mean that all the categories are listed. I used the top category as deny but did not work, so I listed all the categories but same result.
I do not know if this is normal but it seems it should not work in this way.
If a non allowed product, or many non allowed are in the cart then the coupon is not usable which is correct obviously.
Please let me know if I am right saying that there is somethign wrong, and what should I do to fix it.
Ciao from Italy
Thanks
Enzo

You should just need to mark the restrictions as Top DENY and the two Products that you are allowing as ALLOW ...

What are your settings on the Discount Coupon itself?

Hi Linda,
the coupon itself has not minimum order set while there is a number of total usage set and a limit to one usage per customer set. No free shipping. No zone limitation, beginning ans endig date set.
I placed all the categories to deny to see if that could solve the problem, but it did not.
If one not allowed is in the cart with a allowed then both gets the discount.
Thanks for you support. I hope we will find a solution cause I want to use this tool.
ciao from Italy
enzo

Could you check in phpMyAdmin, your database table for:
products

and sort on master_categories_id ...

Do all of your Products have a master_categories_id that is not 0?

What version of Zen Cart are you running?

Is this a Clean install or an Upgrade?

Hi Linda,
none of the products has 0 as master_categories_id. Each product has a number as master category.
The install is a n upgrade but actually is a fresh install because I had to reinstall 1.5.0 from scratch incluing db
I then uploaded the data form the db table to table in order to have alla my customers and orders on line. I probably uploaded ( I do not remember exaclty now) also the db regarding the coupons.......
Following the db-check suggestion, I cleaned up all the old coupons and all the other data in the coupon tables and now the discount is applied to the products allowed only.
I think that old coupon's examples data were there creating the problem.
As always you revealed to be precious to us users.
Thanks a lot.
Really.
ciao from Italy
enzo

Thanks for the update that this is working now ... :smile:

I will need a little help here. I made the coupon with the restriction that applies on a specific category and it works. It gives me 10% calculated on a product from that category on the cart even if other products from other categories are there. So that's ok.

But what's weird is that it doesn't show the restriction on the coupon details... It says that it can be use on all product and all category, which is not true.

What version Zen Cart are you using?

Hi Ajeh! Version 1.5.1.

So far, I cannot reproduce the problem ...

What are your exact settings in the Coupon Restrictions that you are using?

Well, I used many different way to make it work, any makes the restriction to show in the description. The current is the following:

In the coupon...
Coupon Amount: 10%;
Coupon Minimum Order: 30$;
Free Shipping: unchecked
Coupon Code: (not important)
Uses per Coupon: 1
Uses per Customer: 1

Coupon Zone Restriction: none

In the restriction...
Category restriction: Top - Deny. It's showing the green dot under the Deny column for All category.

Product Restrictions: I selected the category, then all the product in this category, then Allow. They are all showing with a green dot at "Allow" .

What do you see when you go to:
/index.php?main_page=discount_coupon

and enter the Discount Coupon code there?