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?
Started by mrcoolboy15 on 21 Mar 2008, 6:47 PM · Views: 8,487
New Zenner
IS there a way to set the coupons not to be applied to the sale price but to the original price, during a sale?
Obaa-san
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.
New Zenner
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.
New Zenner
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.
Todd, a grateful New Zenner
my sites:
http://www.certifiedbattery.com
http://www.pccapital.ca
http://www.upstartbattery.com
New Zenner
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:
New Zenner
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.
New Zenner
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
New Zenner
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.
New Zenner
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
New Zenner
Well, one workaround would be to put your Specials items in a new category and then restrict coupon access to that category.
--2 cents.
New Zenner
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?
Zen Follower
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.
Zen Follower
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.
New Zenner
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?
New Zenner
bump :sleep:
Oba-san
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 ...
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!
New Zenner
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?)
Oba-san
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 ...
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!
New Zenner
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:
Tell staff why this post should be reviewed.