Page 2 of 2 FirstFirst 12
Results 11 to 19 of 19
  1. #11
    Join Date
    Apr 2009
    Posts
    23
    Plugin Contributions
    0

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

  2. #12
    Join Date
    Mar 2006
    Posts
    283
    Plugin Contributions
    0

    Default 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

    Code:
    
    	// 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
    Last edited by makenoiz; 20 Nov 2009 at 12:27 AM.
    22 stores and counting! Ive been zenned.

  3. #13
    Join Date
    Mar 2006
    Posts
    283
    Plugin Contributions
    0

    Default Re: Sale and discount coupon questions

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

    Code:
    	// 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.

  4. #14
    Join Date
    Nov 2009
    Posts
    42
    Plugin Contributions
    0

    Default Re: Sale and discount coupon questions

    Quote Originally Posted by askjv View Post
    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?

  5. #15
    Join Date
    Nov 2009
    Posts
    42
    Plugin Contributions
    0

    Default Re: Sale and discount coupon questions

    bump

  6. #16
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default 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: v1.5.5]
    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!

  7. #17
    Join Date
    Nov 2009
    Posts
    42
    Plugin Contributions
    0

    Default Re: Sale and discount coupon questions

    Hi Ajeh.
    Thank you for anwering!

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

    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!... (how did that commercial fix attack the problem?)

  8. #18
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default 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: v1.5.5]
    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!

  9. #19
    Join Date
    Nov 2009
    Posts
    42
    Plugin Contributions
    0

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

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

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

    Thanks' alot!

 

 
Page 2 of 2 FirstFirst 12

Similar Threads

  1. Replies: 6
    Last Post: 19 Jun 2011, 07:06 AM
  2. Replies: 18
    Last Post: 12 Mar 2010, 06:37 PM
  3. Ideas/Suggestions for Discount Coupon - How to give a credit and a discount
    By vegascoug in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 0
    Last Post: 15 Nov 2007, 05:40 PM
  4. Bug with sale items and 100% discount coupon
    By bryanb in forum Bug Reports
    Replies: 0
    Last Post: 12 Nov 2006, 04:23 AM
  5. Coupon/ Discount Groups/ Specials/ Sale maker help needed
    By steveyork136 in forum General Questions
    Replies: 0
    Last Post: 19 Sep 2006, 11:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR