Disable coupons and group discounts when quantity discount applied?

We offer quantity discounts when you buy a case of products. We don't want to allow coupons or group discounts on cases. Would anyone be able to help me modify the code so that if a product has a quantity discount applied, coupons and group discounts would not apply?

I have the solution on the Discount Coupons that can work for you ...

Customize the file:
/includes/modules/order_total/ot_coupon.php

and add the code in RED:

  function get_order_total($couponCode)
  {
    global $order;
    $orderTaxGroups = $order->info['tax_groups'];
    $orderTotalTax = $order->info['tax'];
    $orderTotal = $order->info['total'];
    $products = $_SESSION['cart']->get_products();
    for ($i=0; $i<sizeof($products); $i++) {
[B]// bof: no discount on Products with Product Discount quantities products_discount_quantity
      global $db;
      $no_discount = false;
      $sql = "SELECT products_id from " . TABLE_PRODUCTS_DISCOUNT_QUANTITY . " WHERE products_id = '" . (int)$products[$i]['id'] . "'";
      $chk_discount = $db->Execute($sql);
      if ($chk_discount->RecordCount() > 0) $no_discount = true;
//echo 'ot_coupon products_id: ' . (int)$products[$i]['id'] . ' RecordCount(): ' . $chk_discount->RecordCount() . ' Discounted: ' . ($no_discount ? 'YES' : 'NO') . '<br><br>';
[/B]      if ([B]$no_discount ||[/B] !is_product_valid($products[$i]['id'], $couponCode)) {
[B]// eof: no discount on Products with Product Discount quantities products_discount_quantity
[/B]        $products_tax = zen_get_tax_rate($products[$i]['tax_class_id']);
        $productsTaxAmount = (zen_calculate_tax($products[$i]['final_price'], $products_tax))   * $products[$i]['quantity'];
        $orderTotal -= $products[$i]['final_price'] * $products[$i]['quantity'];
        if ($this->include_tax == 'true') {

For the Group discounts, this is going to be more complicated and if I get time, I will try to workout some kind of solution for that ...

Ajeh:

I have the solution on the Discount Coupons that can work for you ...

Customize the file:
/includes/modules/order_total/ot_coupon.php

and add the code in RED:

function get_order_total($couponCode)
{
global $order;
$orderTaxGroups = $order->info['tax_groups'];
$orderTotalTax = $order->info['tax'];
$orderTotal = $order->info['total'];
$products = $_SESSION['cart']->get_products();
for ($i=0; $i<sizeof($products); $i++) {
[B]// bof: no discount on Products with Product Discount quantities products_discount_quantity
global $db;
$no_discount = false;
$sql = "SELECT products_id from " . TABLE_PRODUCTS_DISCOUNT_QUANTITY . " WHERE products_id = '" . (int)$products[$i]['id'] . "'";
$chk_discount = $db->Execute($sql);
if ($chk_discount->RecordCount() > 0) $no_discount = true;
//echo 'ot_coupon products_id: ' . (int)$products[$i]['id'] . ' RecordCount(): ' . $chk_discount->RecordCount() . ' Discounted: ' . ($no_discount ? 'YES' : 'NO') . '<br><br>';
[/B] if ([B]$no_discount ||[/B] !is_product_valid($products[$i]['id'], $couponCode)) {
[B]// eof: no discount on Products with Product Discount quantities products_discount_quantity
[/B] $products_tax = zen_get_tax_rate($products[$i]['tax_class_id']);
$productsTaxAmount = (zen_calculate_tax($products[$i]['final_price'], $products_tax)) * $products[$i]['quantity'];
$orderTotal -= $products[$i]['final_price'] * $products[$i]['quantity'];
if ($this->include_tax == 'true') {

> 
> For the Group discounts, this is going to be more complicated and if I get time, I will try to workout some kind of solution for that ...

will this also apply to Swguy quantity discount module?

I am afraid that you'd have to ask swguy on that one ... :lookaroun

I have asked him few times but did not get answer yet. I will post here if find solution.

The answer is no.

BTW, asking me a question, getting an answer, and then asking a completely different question and waiting less than 24 hours actually doesn't constitute "asking him a few times and not getting an answer."

swguy:

The answer is no.

BTW, asking me a question, getting an answer, and then asking a completely different question and waiting less than 24 hours actually doesn't constitute "asking him a few times and not getting an answer."

I have included same question in PM, email and other forum post as I am still looking to restrict customers to use / get only 1 discount of your module not all. I have replied to your PM explaining question again.

So your question is really "can the discounts know about each other so they can know not to apply to the same item?" The answer is no; they don't know about each other. Most have specific item exclusion user exits that you can add products to by hand, but each discount is individual and is not aware of the operation of other discounts.