Quantity Discounts for 1.3

[swguy]

Both of these questions are answered in the notes that follow the marketing text examples. See notes 3 and 7.

[lunabug]

Not quite there yet...

I updated the code as stated in note 3, nothing changed in the text, still no numbers.

So, now it must be the issue about excluding categories. I have all my products in 2 categories: one that is discounted, one that is not. Both these categories are the master categories for the products and are hidden/inactive, all the products are linked into their 'end user' categories.

I have excluded the master category ID in the user exit code:
function exclude_category($category) {
switch($category) {
case 16:
return true;
}
return false;
}

which brings me to note 4... how does it determine "$current_category_id"?

[OneWorldStudios]

I have the Checkout Without Account (Fast and Easy Checkout mod) installed, and when customer chooses to pay with Paypal IPN, he gets charged full price instead of the discounted price, even though the discounts do show up in cart and on order page.

Now I don't know yet whether the correct total is being passed to payment gateway (authorize.net emulator). We haven't had a qty discount authorize.net sale, but the store has only been live for one day.

Everything appears to be correct in ZenCart Admin, discount and correct total displays on the order, the only thing I can see that's wrong is Gross Amount: in the payment section of the order.

This is exactly the problem we have. It works fine if someone signs in, but doesn't work if they select PayPal as the payment option in COWOA. The gateway processes fine either way. Also the Paypal Express button works fine so it's definitely a COWOA issue, but we can't pinpoint it...

[swguy]

You probably want to post in the COWOA thread; someone else supports that.

[OneWorldStudios]

You probably want to post in the COWOA thread; someone else supports that.

The solution at the following link fixed the issue for us:
http://www.zen-cart.com/forum/showth...nt+code&page=2

[lunabug]

Not quite there yet...

I updated the code as stated in note 3, nothing changed in the text, still no numbers.

So, now it must be the issue about excluding categories. I have all my products in 2 categories: one that is discounted, one that is not. Both these categories are the master categories for the products and are hidden/inactive, all the products are linked into their 'end user' categories.

I have excluded the master category ID in the user exit code:
function exclude_category($category) {
switch($category) {
case 16:
return true;
}
return false;
}

which brings me to note 4... how does it determine "$current_category_id"?

I was able to fix this myself, seems there's a bug when you use linked categories. The code only uses the current_category_id, where I am excluding master categories.

I was also able to exclude my wholesale group from the quantity discount. I created a session variable for the discount_group and was able to excluded it.

[swguy]

I was able to fix this myself, seems there's a bug when you use linked categories. The code only uses the current_category_id, where I am excluding master categories.

This issue - and other category related behavior - is described in http://www.thatsoftwareguy.com/zenca...ry_issues.html
See "Marketing Text and Linked Items in Quantity Discounts" for my suggested workaround.

[mldnkslvc]

Seems easy enough, I modified the ot_quantity_discount.php page with the following in case it helps anybody in the future. (the add dealers portion)

for ($i=0, $n=sizeof($products); $i<$n; $i++) {
// Add categories you wish to exclude to exclude_category()
if ($this->exclude_category($products[$i]['category'])) {
continue;
}
// Add products you wish to exclude to exclude_product()
if ($this->exclude_product($products[$i]['id'])) {
continue;
}
// Add dealers

if ($_SESSION['customer_id']) {
$customers_id = $_SESSION['customer_id'];
$customer_check = $db->Execute("select * from " . TABLE_CUSTOMERS . " where customers_id = '$customers_id'");
if ($customer_check->fields['customers_whole'] != "0") {
$disc_amount = 0;
continue;
}
}

where exactly did jou put this code..? i am using quantity discount mod v 1.10.... i have some troubles putting that code in the script... where ever i put it and ther eload the page,the page is blank.... i need this badly...thank you in advance...

[olieve]

hello,

I installed quantity discounts module.
Zen-cart version 1.3.8a.
Admin-Modules-Order Total : Include Tax = False / Re-calculate Tax = Standard


Now I noted following problem.

I sell products with 2 differtent taxes (6% and 21% - belgium).

I apply quantity discount (% ) for only one category-id.

If customer only buys products from that category, calculation just works fine.
But if customer selects products form another category (where tax% also is different) order calculation is wrong.

I give an example.
Category = 69 ; if quantity is more than 3 than discount of 7% must be applied.

Customer selects 4 products in the category 69.
Price 12,50 euro each.
tax : 6%

So subtotal : 50,00
Quantity discount : -3,30 (= 50 x 7% / 1,06 tax excluded)
vat 6% : 2,63
total : 46,50 (that's correct)

Now customer add 1 item of another category, and subject another tax % (21%) , 41,94 tax included

Subtotal : 91,94
Quantity discount : -3,30
vat 6% : 2,63
vat 21% : 6,59 (not correct) 7,28
total : 87,75 (not correct) - must be : 88,44


Can anyone tell me how to solve this ?
Now I loose money because I have to pay the right Vat to the VAT Administration.

Thanks for your quick reply.
Olieve
http://www.olieve.be

[swguy]

This situation is not well handled by the current code. In 2.0 the checkout logic is changing to I might be able to do a better job of tax calculation.