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?

I see the coupon details, with the text and all the information is ok but it says that the coupon is good for all the categories and all the products.

If you want to try it, the adresse on this page on the store is http://fc4x4q.com/boutique/index.php...iscount_coupon and the coupon is AT00111. Just to warn you? The website is in french.

Unfortunately, the site is Down for Maintenance so I really cannot test anything ...

Ok, I put it back. Thanks for your energy on helping me on this.
The coupon AT00111 is suppose to be effective on all products in the "Cartes de membre" category.

Since it's not totaly ready I'll put it back on maintenance when you'll let me do it.

Is this a clean install of v1.5.1 or an upgrade?

The Discount Coupon should display each of the Product names if you have them set individually ...

For example, I have a Discount Coupon with ALLOW for all products in DVD ... Action ...

And then when I check the Discount Coupon in the Catalog, I see:

Quote:

---

Discount Coupon Restrictions

Category Restrictions:

This coupon has specific Product Restrictions.

Product Restrictions:

Die Hard With A Vengeance Linked (Valid for this product)
Fire Down Below Linked (Valid for this product)
Lethal Weapon Linked (Valid for this product)
Speed 2: Cruise Control (Valid for this product)
Speed Linked (Valid for this product)
The Matrix Linked (Valid for this product)
The Replacement Killers (Valid for this product)
Under Siege 2 - Dark Territory (Valid for this product)
Under Siege Linked (Valid for this product)

Discount Coupons may not be applied towards the purchase of Gift Certificates. Limit 1 coupon per order.

---

In my Admin I see:

It's a new installation but it's not me who installed it. I convinced the staff to have zencart installed on their server and they asked their I.T. guy to install it and he gave me access to the admin section and to the directory on the server. I had to work with that to modify the template avec to configure it.

So what did I miss? Why doesn't is shows the restriction in the coupon description?

On your Admin for the Discount Coupon restrictions, does it look similar to mine?

I think yes.
[IMG]http://img.photobucket.com/albums/v112/Bodeau/image_zps4514ac83.jpg[/IMG

Some of the products touched by this coupon and showed there are currently desactivated. Could it be the reason?

Are any of the Products active?

2 are active.

I tried on mine and active or inactive on the Products has no bearing on the display ...

Did you try switching to Classic Template for a minute to see if it makes a difference?

Oh, good idea. I'll try it right now.

No change unfortunately. :(

And just to humor me ...

If you compare your two configure.php files on the server in:
/includes/configure.php
/your_secret_admin/includes/configure.php

are you using the same database on both?

Yes, same data on both.

I cannot figure out why your Discount Coupons work this way ...

You are sure when you check your Restrictions that you are on the right Discount Coupon?

If you EDIT the Discount Coupon. what do you see in the URL for the cID= ...

If you look in phpMyAdmin, and search the table:
coupon_restrict

for the coupon_id that has the same value, what comes up?

Ok, I found where was the problem.

When I made this coupon it was te first one and was made as a test. So I deleted it, then tried to create it back, or should I say, to create another one with the same name, which off course didn't work. I saw the thread where you explained to rename, than copy and rename the copy. It worked like a charm and played a little with this to get familiar with he manipulation. It ended with 2 inactive coupons: AT00111R and... AT00111, which has the exact same name as the active coupon. It appears that ZenCart was having hard time to differentiate the active and the inactive one and was showing the description of the inactive one which has no restriction, but was running the restriction associated to the active coupon. So I renamed the inactive one to AT00111R2, et voilà! Weird huh...

But many many thanks for your help in this Ajeh! I really appreciated the time you gave me!! Best regards.

That is very weird ... thanks for hunting down the issue and for letting us know this is resolved ...

Now that I found how to fix this, is there a way to copy the restriction to over 100 coupons without having to edit them one by one? Could I do that directly in the DB?

Not easily ...

You could try to grab, via phpMyAdmin, the records for a valid Discount Coupon and then edit them with the next coupon_id and insert them ... but you are getting into some tricky edit/import and could make a real mess if you mess up ...

Something like:

Code:

---

SELECT restrict_id, coupon_id, product_id, category_id, coupon_restrict FROM coupon_restrict WHERE coupon_id = '7';

---

And you would get something like:

Code:

---

INSERT INTO coupon_restrict (coupon_id, product_id, category_id, coupon_restrict) VALUES
(7, 0, -1, 'Y'),
(7, 4, 0, 'N'),
(7, 6, 0, 'N'),
(7, 9, 0, 'N'),
(7, 10, 0, 'N'),
(7, 11, 0, 'N'),
(7, 12, 0, 'N'),
(7, 13, 0, 'N'),
(7, 17, 0, 'N'),
(7, 18, 0, 'N');

---

then, do a global replace of:
(7,

with the next Discount Coupon coupon_id that needs the same restrictions, for example, Discount Coupon coupon_id 12:
(12,

to get:

Code:

---

INSERT INTO coupon_restrict (coupon_id, product_id, category_id, coupon_restrict) VALUES
(12, 0, -1, 'Y'),
(12, 4, 0, 'N'),
(12, 6, 0, 'N'),
(12, 9, 0, 'N'),
(12, 10, 0, 'N'),
(12, 11, 0, 'N'),
(12, 12, 0, 'N'),
(12, 13, 0, 'N'),
(12, 17, 0, 'N'),
(12, 18, 0, 'N');

---

then import that ...

Before attempting it, be sure to backup your whole table:
coupon_restrict

If it possible to restrict coupon if certain product is in cart or other discount in cart.
Product restriction only work for that particular product but how can we restrict coupon to whole cart content if certain product is in cart or any other discount in cart.