Forums / Setting Up Specials and SaleMaker / Sale and discount coupon questions

Sale and discount coupon questions

Locked

Started by mrcoolboy15 on 21 Mar 2008, 6:47 PM · Views: 8,487

Results 1 to 19 of 19
This thread is locked. New replies are disabled.
21 Mar 2008, 6:47 PM
#1
mrcoolboy15 avatar

mrcoolboy15

New Zenner

Join Date:
Feb 2008
Posts:
61
Plugin Contributions:
0

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?

21 Mar 2008, 8:03 PM
#2
Kim avatar

Kim

Obaa-san

Join Date:
Jun 2003
Location:
West Coast, North America
Posts:
26,741
Plugin Contributions:
0

Re: 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?

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.

Please do not PM for support issues: a private solution doesn't benefit the community.

Be careful with unsolicited advice via email or PM - Make sure the person you are talking to is a reliable source.

21 Mar 2008, 11:02 PM
#3
mrcoolboy15 avatar

mrcoolboy15

New Zenner

Join Date:
Feb 2008
Posts:
61
Plugin Contributions:
0

Re: Sale and discount coupon questions

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.

8 May 2008, 7:59 PM
#4
bifficus avatar

bifficus

New Zenner

Join Date:
Sep 2007
Location:
Vancouver, CA
Posts:
87
Plugin Contributions:
0

Re: Sale and discount coupon questions

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.

17 Oct 2008, 3:38 PM
#5
chrissiemags avatar

chrissiemags

New Zenner

Join Date:
Sep 2008
Posts:
40
Plugin Contributions:
0

Re: Sale and discount coupon questions

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:

20 Jan 2009, 11:00 PM
#6
askjv avatar

askjv

New Zenner

Join Date:
Dec 2006
Posts:
21
Plugin Contributions:
0

Re: Sale and discount coupon questions

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.

29 Jan 2009, 8:11 PM
#7
chachab avatar

chachab

New Zenner

Join Date:
Apr 2008
Posts:
73
Plugin Contributions:
0

Re: Sale and discount coupon questions

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

Classy, Upscale, Sophisticated, Discreet
www.ClassyDesires.com

29 Jan 2009, 8:32 PM
#8
askjv avatar

askjv

New Zenner

Join Date:
Dec 2006
Posts:
21
Plugin Contributions:
0

Re: Sale and discount coupon questions

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.

9 Mar 2009, 4:37 PM
#9
ctopher avatar

ctopher

New Zenner

Join Date:
Nov 2006
Posts:
24
Plugin Contributions:
0

Re: Sale and discount coupon questions

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

28 Apr 2009, 5:17 PM
#10
batterygenie avatar

batterygenie

New Zenner

Join Date:
May 2008
Location:
Thousand Oaks, CA
Posts:
30
Plugin Contributions:
0

Re: Sale and discount coupon questions

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

--2 cents.

15 May 2009, 6:56 PM
#11
scrappycat avatar

scrappycat

New Zenner

Join Date:
Apr 2009
Posts:
23
Plugin Contributions:
0

Re: Sale and discount coupon questions

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?

19 Nov 2009, 11:21 PM
#12
makenoiz avatar

makenoiz

Zen Follower

Join Date:
Mar 2006
Posts:
284
Plugin Contributions:
0

Re: Sale and discount coupon questions

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

22 stores and counting! Ive been zenned.

19 Nov 2009, 11:44 PM
#13
makenoiz avatar

makenoiz

Zen Follower

Join Date:
Mar 2006
Posts:
284
Plugin Contributions:
0

Re: Sale and discount coupon questions

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;
    	         } 
	}

22 stores and counting! Ive been zenned.

23 Nov 2009, 3:40 PM
#14
troll avatar

troll

New Zenner

Join Date:
Nov 2009
Posts:
42
Plugin Contributions:
0

Re: Sale and discount coupon questions

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?

26 Nov 2009, 12:55 AM
#15
troll avatar

troll

New Zenner

Join Date:
Nov 2009
Posts:
42
Plugin Contributions:
0

Re: Sale and discount coupon questions

bump :sleep:

27 Nov 2009, 1:40 AM
#16
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Sale and discount coupon questions

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 ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

27 Nov 2009, 10:07 AM
#17
troll avatar

troll

New Zenner

Join Date:
Nov 2009
Posts:
42
Plugin Contributions:
0

Re: Sale and discount coupon questions

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?)

27 Nov 2009, 3:23 PM
#18
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Sale and discount coupon questions

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 ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

15 Dec 2009, 11:50 AM
#19
troll avatar

troll

New Zenner

Join Date:
Nov 2009
Posts:
42
Plugin Contributions:
0

Re: Sale and discount coupon questions

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: