Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

iffy

Pioneers
  • Posts

    6
  • Joined

  • Last visited

Profile Information

iffy's Achievements

  1. Thanks for the great add-on. It's functionality is exactly what I needed without too many modifications. After testing the coupon codes, there are 2 problems I ran across, but not sure if there are more. 1) when you set a minimum order, it was calculating the minimum based on the order total, which included tax and shipping. I needed the minimum to be on the subtotal of all items purchased before shipping and tax. 2) the tax calculation is based on the subtotal before discount. I'd like the tax to be calculated after the discount. I've tried what others have posted before with no luck. The tax is still calculated incorrectly. I was able to solve #1 with a minor change, which I have posted below if anyone needs it. If anyone has solved the tax problem, please post a solution. Thanks. in ot_discount.php on line 40, change: $check_query = tep_db_query("select dc.products_id, dc.categories_id, dc.manufacturers_id, dc.excluded_products_id, dc.customers_id, dc.orders_total, dc.order_info, dc.discount_values, dc.number_of_products from " . TABLE_DISCOUNT_CODES . " dc where dc.discount_codes = '" . tep_db_input($sess_discount_code) . "' and if(dc.expires_date = '0000-00-00', date_format(date_add(now(), interval 1 day), '%Y-%m-%d'), dc.expires_date) >= date_format(now(), '%Y-%m-%d') and dc.minimum_order_amount <= " . $order->info['total'] . " and dc.status = '1' limit 1"); to: $check_query = tep_db_query("select dc.products_id, dc.categories_id, dc.manufacturers_id, dc.excluded_products_id, dc.customers_id, dc.orders_total, dc.order_info, dc.discount_values, dc.number_of_products from " . TABLE_DISCOUNT_CODES . " dc where dc.discount_codes = '" . tep_db_input($sess_discount_code) . "' and if(dc.expires_date = '0000-00-00', date_format(date_add(now(), interval 1 day), '%Y-%m-%d'), dc.expires_date) >= date_format(now(), '%Y-%m-%d') and dc.minimum_order_amount <= " . $order->info['subtotal'] . " and dc.status = '1' limit 1"); It's a simple one word change to check minimum order using order subtotal instead of order total. BTW- I am using Discount Code version 2.9 on oscommerce 2.2 (newer add on with older shopping cart) Best, Iffy www.cuddlebugfactory.com
  2. Hi, I am having trouble downloading your paypal express fix for discount coupon codes. Would you be able to repost or send it to me directly at [email protected]

    Thanks,

    Iffy

  3. Hi Ken, Thanks for all you help. It worked perfectly! If you would like to take a look, my site is at: www.cuddlebugfactory.com I'm very happy with the way it's turning out...thanks to you and all of the other contributors on this forum. Best regards, Iffy
  4. Hi Ken, Adding the manufacturers tag to the index.php page definitely helped. Sorry for this basic question, but I think I am misunderstanding you. Are you suggesting that the same code that was added to the index.php page should also be added to the product_info.php page? Thanks, Iffy
  5. Hi Ken, Thanks for an awesome contribution! It works great, but I have one hopefully minor problem. My Product_Info page doesn't display manufacturer, which I would really like to include. Not sure what the issue may be. I'm using the following title tag on my product_info.php: title><?php echo ((strlen($categories['categories_name']) > 1) || (strlen($manufacturers['manufacturers_name']) > 1)) ? $header_tags['products_name'] . ' - ' . $breadcrumb_tags->trail_tags(' ') . ' - ' . TITLE : TITLE; ?> </title> Thanks for your help. Best, Iffy
  6. Hi Jack, Excellent contribution! Thanks for all your support. It's been a great help for a newbie like me. I had the redirect to index.php problem that happens in some templates and followed instructions in a previous post: __________________________________________________________ Posted 10 October 2010 - 12:04 PM If clicking a product or Mfr takes you back to the index.php page, read this! I'd love to take credit for this fix, but I am not THAT good of a PHP developer (yet). However, if you look here http://addons.oscomm.../info/2823/v,22, Sunrise99 found a fix for your problem on February 6. I was having the same problem. The Ultimate SEO contribution (wonderful, by the way) automatically sets the new pages to .HTML pages. Your /includes/header.php file contains the following line ... if(strpos($path_parts['basename'], "php") == false) { print("<script type='text/javascript'>window.location='index.php';</script>"); } that basically says "If 'php' is not included in the basename URL, redirect to index.php! THAT'S WHAT'S CAUSING YOUR PROBLEM. I simply added "//" before print("... and it works GREAT! My code in header.php now looks like this... if(strpos($path_parts['basename'], "php") == false) { //print("<script type='text/javascript'>window.location='index.php';</script>"); } Sunrise99, you saved me a HELLUVA lot of troubleshooting! Thanks a million! Jim Evans unpaid help for Aunt Denise's Children's Used Clothing and More _________________________________________________________ After following this post, I lost my banner ads on my home page (which follows the above line I commented out). I see where the problem may be, but have no idea how to fix it. Any suggestions. Here's the relevant section of my header.php. __________________________________________________________ <?php $path_parts=getCurrPathName(); if(strpos($path_parts['basename'], "php") == false) { //print("<script type='text/javascript'>window.location='index.php';</script>"); } if(($path_parts['basename'] != "index.php") && ($path_parts['basename'] != "") && ($path_parts['basename'] != "index.php?language=en") && ($path_parts['basename'] != "index.php?language=de") && ($path_parts['basename'] != "index.php?language=es") && ($path_parts['basename'] != "index.php?currency=EUR") && ($path_parts['basename'] != "index.php?currency=USD") && ($path_parts['basename'] != "index.php?currency=USD&language=en") && ($path_parts['basename'] != "index.php?currency=USD&language=de") && ($path_parts['basename'] != "index.php?currency=USD&language=es") && ($path_parts['basename'] != "index.php?currency=EUR&language=en") && ($path_parts['basename'] != "index.php?currency=EUR&language=de") && ($path_parts['basename'] != "index.php?currency=EUR&language=es")) { ?> <?php }else{ ?> <tr><td class="banner"><a href="index.php?cPath=1"><img border=0 src="images/banners/banner_02.jpg"></a><a href="specials.php"><img border=0 src="images/banners/banner_04.jpg"></a></td></tr> <?php } ?> <tr><td class="row_3"> _______________________________________________ Any help or advice would be greatly appreciated. Best, Iffy
  7. Hi Ken, Love this contribution! It has really enhanced my website. Just one question: is there a way to get Manufacturer name on the title tag for products? Currently, it is Product name - Category name - Store name I'd like to to show Product name - manufacturer name - store name Thanks for your help. Best, Iffy
×
×
  • Create New...