[DONE v1.3.9] Coupon Exclusions - I Don't Understand Anymore

Hello all,

right i create vouchers for single products by:

Top - Deny
Product 5 - Allow

this works fine.

now im trying to exclude 2 categories

My logic

Top - Allow
Cat 1 - Deny
Cat 2 - Deny

This doesn't seem to work for any category even the valid ones.

I tried denying it by products:

Top - Allow

Prod_id 5 - Deny
Prod_id 6 - Deny
Prod_id 7 - Deny
Prod_id 8 - Deny
Prod_id 9 - Deny
Prod_id 10 - Deny

still didn't work, what am i doing wrong?

regards

Andy.

I am moving this to the Bug Report ...

This is a bug in the function file:
/includes/functions/functions_general.php

Replace the function validate_for_category around lines 856 - 879 with this new code:

  function validate_for_category($product_id, $coupon_id) {
    global $db;
    $retVal = 'none';
    $productCatPath = zen_get_product_path($product_id);
    $catPathArray = array_reverse(explode('_', $productCatPath));
    $sql = "SELECT count(*) AS total
            FROM " . TABLE_COUPON_RESTRICT . "
            WHERE category_id = -1
            AND coupon_restrict = [B]'Y'
            AND coupon_id = " . (int)$coupon_id . " LIMIT 1"[/B];
    $checkQuery = $db->execute($sql);
    foreach ($catPathArray as $catPath) {
      $sql = "SELECT * FROM " . TABLE_COUPON_RESTRICT . "
              WHERE category_id = " . (int)$catPath . "
              AND coupon_id = " . (int)$coupon_id;
      $result = $db->execute($sql);
      if ($result->recordCount() > 0 && $result->fields['coupon_restrict'] == 'N') return true;
      if ($result->recordCount() > 0 && $result->fields['coupon_restrict'] == 'Y') return false;
    }
    if ($checkQuery->fields['total'] > 0) {
      return false;
    } else {
      return 'none';
    }
  }

Then, you can configure the coupon with the restrictions of:
Top - Allow
Cat 1 - Deny
Cat 2 - Deny

Or as:
Cat 1 - Deny
Cat 2 - Deny

See if that works better for you ...

thanks

ajeh

yep works fine now...

regards

Andy.