Sale and discount coupon questions

IS there a way to set the coupons not to be applied to the sale price but to the original price, during a sale?

IS there a way to set the coupons not to be applied to the sale price but to the original price, during a sale?

No, there is not.

As a consumer I would really POed if I got through the checkout and didn't get the full additional discount your were offering.

Kim:

No, there is not.

As a consumer I would really POed if I got through the checkout and didn't get the full additional discount your were offering.

Yes well in that case, is there a setting to set where coupons do not work during the sale period, on the items that are for sale?

because we dont want to have a sale for 25% off and have the customer use a discount code and get an additional 15% off the sale price.

mrcoolboy15:

Yes well in that case, is there a setting to set where coupons do not work during the sale period, on the items that are for sale?

because we dont want to have a sale for 25% off and have the customer use a discount code and get an additional 15% off the sale price.

I agree. There are lots of reasons why stores might want this functionality. In my case, I have a class of customer that I have promised will always get a certain minimum discounted price, and it is currently managed via a coupon. There are times when I want to extend sales to other customers as well, but like the other writer, I don't want to "double down" on the discount to my priviledged customers. Since I am also doing free shipping as a part of my cart, this is especially precarious.

Perhaps there is a better way to accomplish this goal, rather than using coupon codes. If you have some tips I would appreciate hearing them.

I'm in the same boat...want to offer coupons to certain customer BUT don't want them to be able to use coupon on sale items! :frusty:

Same here, am surprised this issue does not have a workaround, if there is one and someone sees this thread, please point us in the right direction.

same here.. i have a sale going on and someone is buying and has a coupn code which was given prior (and still valid) i wish there was a way that you can only use a coupn code on non sale items

I am having That Software Guy set this up for me since I am not a programmer and I use his discount modules. Good luck with whatever way you go for a solution, at least you know it is do-able even if you do the programming yourself.

I tell my customers that the coupon is good for something off of the retail price. Then, when I have a sale, I adjust the coupon to give them the effective amount off of the retail price.

For example, a coupon for $100 off is given and is set up for a $100 discount. Then we have a $50 off sale. So I set the "Special" price and adjust the coupon so it's only a $50 off coupon. In the coupon text I make sure to say that it's a $100 discount off of the regular/retail price.

Chris

Well, one workaround would be to put your Specials items in a new category and then restrict coupon access to that category.

--2 cents.

My site is set for free shipping over $100.00. I want the free shipping to only apply if the customer has used their discount coupon and the price is still over $100.00. If the price falls below $100.00 I want the original ship price to show back up for under $100.00. I tested this and it will only continue to give free shipping on an order below $100.00. I don't see anything in the coupon mod that lets you choose not to use coupons with other discounts or to fix this to work the way I want it to. Is there someplace else in the mod that I have to change to do this?

Lyndia or another ZC guru can you look at something for me.

**also don't get mad at me for doing this... client wants it :) **
Coupons cannot be combined with other offers in this clients store so I am going to stop the use of coupons for Specials and Salemaker. I have Specials working but Salemaker is being difficult.

Can you look at my code and tell me if you see anything obvious? This is around line 800 if functions_general.php

	// vf deny if product is on sale  Working well
				 
	$specials = $db->Execute("select specials_new_products_price
           from " . TABLE_SPECIALS . " where products_id = '". (int)$product_id ."' and status = '1'");

	    if ($specials->RecordCount() > 0 ) {
                  return false;
            }		
	// vf end deny if on sale  ///////////////////////


	// vf add deny if salemaker  not working  well
	$productCatPath = zen_get_product_path($product_id);
	$catPathArray = array_reverse(explode('_', $productCatPath));	
	
	foreach ($catPathArray as $catPath) {			  
		$sql2 = $db->Execute("select sale_specials_condition from " . TABLE_SALEMAKER_SALES . " where sale_categories_all like '%," . (int)$catPath . ",%'");  
		
	 $salemaker = $db->execute($sql2);
            if ($salemaker->recordCount() > 0) {
             return false;
          } 

	} // vf end deny if salemaker  ///////////////////////

Thanks

Sorry gave you the wrong code here is what I really have

	// vf deny if product is on sale  Working well
				 
	$specials = $db->Execute("select specials_new_products_price
           from " . TABLE_SPECIALS . " where products_id = '". (int)$product_id ."' and status = '1'");

	    if ($specials->RecordCount() > 0 ) {
                  return false;
            }		
	// vf end deny if on sale  ///////////////////////


	// vf add deny if salemaker  not working  well
	$productCatPath = zen_get_product_path($product_id);
	$catPathArray = array_reverse(explode('_', $productCatPath));		


        foreach ($catPathArray as $catPath) {			  
		$salemaker = $db->Execute("select sale_id from " . TABLE_SALEMAKER_SALES . " where sale_categories_all like '%," . (int)$catPath . ",%'");
   
		 if ($salemaker->recordCount() > 0) {
			 return false;
    	         } 
	}

askjv:

I am having That Software Guy set this up for me since I am not a programmer and I use his discount modules. Good luck with whatever way you go for a solution, at least you know it is do-able even if you do the programming yourself.

Hi!
Is this really the only solution to this issue?

bump :sleep:

This is not, at this time, a feature of Zen Cart where Discount Coupons are not allowed on Products with Specials or Sales ...

You can, however, setup your Discount Coupons to exclude Categories (based on master_categories_id) or Products that might be on Sale or Special so that the Discount Coupon does not qualify for these Products ...

Hi Ajeh.
Thank you for anwering! :smile:

Yes I am aware of the option to exclude categories, but as I understand, a category has to show as its own categorie in the shop!?
Meaning I can't show an item with Quantity Discount together with other items with no discount? (Without ending up paying for the sale...:shocking:)

Or is It possible to "tag" an item to be "owned" by one category, and still show in another category?
If so I havent figured it out...
Doesent seem that impossible though!... :cool: (how did that commercial fix attack the problem?)

Linked Products are "owned" by one Category (the master_categories_id) and can still "show" in other Categories ...

A Discount Coupon uses the master_categories_id ...

Be sure, however, to apply the Known Bugfixes to your site as some do affect the Discount Coupons and master_categories_id ...

Hi. Sorry for falli'n out for a while...

Well, I apparently mistook the exclude option for hiding catagories/items... It obviously does not! :blush:
I then found the "Catagories Dressing" mod for hiding catagories in the sidebar. Have'nt tried it yet though.

So now I can let my ordinary customer buy with e.g. quantum discount, while the customer with discount code gets no discout at all with this item... :no:

Hmmm... There has to be a way to give "flat" discount that only affects ordinary prices before any other Specials or Sales!?
I know for shure I'm not the only one that gives a flat % discount!.. :P

Actually, to be fair, the system should calculate what discount benefits the customer the most! Either it is the "flat" discount (that I thought I had going with the "discount code") or other discounts that may appear, temporary or not!
With peronal service/billing this is obvious! Could someone please give me a hint how to adress this in the webshop!? :lookaroun

Thanks' alot! :cool: