How to set up Quantity Discounts??

I have read tons of posts on quantity discounts, but they are for specific issues or a mod and have not been able to assist me thus far.

I sell tumbled stones. I want to be able to offer quantity discounts on many of those items. For instance 1-5 pieces would be $1.00, 6-10 pieces would be $0.90, 11-15 pieces $0.75, 16 -20 pieces $0.50

So how do I go about setting this up? is it part of the attributes or no? I thought I had set it up before, but I must of been mistaken cause for the life of me I do not remember....:)

Could someone point me in a direction or give me starter steps please? Thank you!!

Zen Cart has a built in quantity discounting which is useful if you want to discount bulk purchases of a single item. It is documented here:
https://www.zen-cart.com/tutorials/index.php?article=59

There is a Quantity Discounts contribution which allow s you to group items by category (or by all items in the cart) and discount that way. It is documented here:
http://www.thatsoftwareguy.com/zencart_quantity_discounts.html

An overview of the differences between these two facilities is provided here:
http://www.thatsoftwareguy.com/zencart_quantity_discounts.html#diff

Good luck,
That Software Guy

I've tried activating the bulk discounts, it was easy enough. When i go to the item in the store, as a shopper, the discounts show up, no problem.. but when i add the item to my cart and go to check out, the discount doesn't show up in the cart. it shows the items at their original price. Why?

If you're using my Quantity Discounts contribution, the discount doesn't show up until page 2 of checkout. It's a discount off the order total; the price is not changed in the cart.

That's really asinine! It's awfully confusing when you see a price at the bottom of the page that says one thing, but it's a different thing when it adds to your cart. Then it's a different thing when you check out. Any way to just get the discounted price in the cart?

swan:

That's really asinine! It's awfully confusing when you see a price at the bottom of the page that says one thing, but it's a different thing when it adds to your cart. Then it's a different thing when you check out. Any way to just get the discounted price in the cart?
I was just about to start a new thread to ask the same question. We're using swguy's Quantity Discounts and Quantity Discount Preview modules to offer across-the-board percentage discounts for customers who buy in bulk. Unfortunately, our customers keep calling us because they don't see the discounts being applied. We explain to them that they have to look at the bottom of the screen, but it's embarrassing that we have to keep apologizing to our customers for their poor checkout experience. More than that, I'm sure that there are lots of customers who aren't calling us, and I know it's costing us business.

Is there any known fix, hack, or workaround? Is there a better module that we should be using?

We need to be able to apply a bulk discount across the board, and we need to show these discounts being applied per line item in the shopping cart. It seems like this ought to be simple, but we're willing to pay for something custom if need be.

Please advise.

Response by PM.

I am using the quantity discount mod and I am having one problem with it.

I have 6 categories and 5 of the categories I want to apply a discount that if they buy any 3 items or more from any of the 5 categories they get $3.00 off.

I set this up by doing

Discount Basis
Total Items in Cart

and applying my info in the discount level/amount

this works fine however in my 6th category I would like to have a different discount. 3 items or more get you $5.00 off.

I tried editing the apply_special_category_discount
but since I have total items in cart selected as my discount basis in order to make it aply properly to the other 5 categories this edit does not work.

Is there some other way of doing this.

You can't easily handle situations like this without writing a lot of additional logic. See PM.

swguy:

Zen Cart has a built in quantity discounting which is useful if you want to discount bulk purchases of a single item. It is documented here:
https://www.zen-cart.com/tutorials/index.php?article=59

There is a Quantity Discounts contribution which allow s you to group items by category (or by all items in the cart) and discount that way. It is documented here:
http://www.thatsoftwareguy.com/zencart_quantity_discounts.html

An overview of the differences between these two facilities is provided here:
http://www.thatsoftwareguy.com/zencart_quantity_discounts.html#diff

Good luck,
That Software Guy

Hello,

I installed your mod and I entered the categories to exclude as follows:

class ot_quantity_discount {
var $title, $output;
var $explanation;

// Add categories you wish to exclude to this list.
// Go to Admin->Catalog->Categories/Products and look 
// at the left hand side of the list to determine 
// category id.   Note that 99999 and 99998 are just given
// as examples.
function exclude_category($category) {
    switch($category) {
       case 65:
	   case 69:
	   case 71:
	   case 77:
	   case 70:
	   case 73:
	   case 83:
	   case 67:
            return true;
    }
    return false;
}

I tested products in the excluded categories above and they are showing in the discount on page 2 of checkout. Did I miss something?

The category is id the master_categories_id of your product. Be sure this field is set correctly in the products table. (If it's a linked product, it may not be what you think it is.)

http://www.thatsoftwareguy.com/zencart_category_issues.html

swguy:

The category is id the master_categories_id of your product. Be sure this field is set correctly in the products table. (If it's a linked product, it may not be what you think it is.)

http://www.thatsoftwareguy.com/zencart_category_issues.html

OK, I went to MySQL (gulp!) and I got this to display using browse:

Full Texts categories_id language_id categories_name categories_description
Edit Delete 65 1 CD Box
Edit Delete 66 1 Bracelets MIX N MATCH DISCOUNTING available for this categor...
Edit Delete 67 1 Zippo Lighters
Edit Delete 68 1 ClassyWraps MIX N MATCH DISCOUNTING available for this categor...
Edit Delete 69 1 CD Trays
Edit Delete 70 1 Digi Trays
Edit Delete 71 1 DVD Boxes
Edit Delete 73 1 Game Cases
Edit Delete 74 1 Incense MIX N MATCH DISCOUNTING available for this categor...
Edit Delete 75 1 Gift Wraps MIX N MATCH DISCOUNTING available for this categor...
Edit Delete 76 1 JiffyWraps MIX N MATCH DISCOUNTING available for this categor...
Edit Delete 77 1 Sleeves
Edit Delete 78 1 CD Sleeves
Edit Delete 79 1 LP Sleeves
Edit Delete 80 1 Comic Book Sleeves
Edit Delete 81 1 45 Sleeves
Edit Delete 82 1 DVD Sleeves
Edit Delete 83 1 Shrinkwrap
Edit Delete 87 1 CD Frames MIX N MATCH DISCOUNTING available for this categor...
Edit Delete 86 1 LP Album Frames MIX N MATCH DISCOUNTING available for this categor...

Obviously, the ones with the MIX N MATCH are the ones I want to use your discount on. The balance to be excluded. I did not use link product at all so I think these category ids are good. Any other ideas?

You're looking at the wrong table. Products table, master_categories_id. Follow the link I posted; it's explained there.

swguy:

You're looking at the wrong table. Products table, master_categories_id. Follow the link I posted; it's explained there.

Hi Scott,

I finally figured out what is going on. I imported my products from QB into the categories I had setup. I had an idea so I also tried to move products from one category to another and the same thing happens. No Product Master Category number gets generated. It displays "0" for that product. The Product Master Category number will generate only if I create a new product one by one in that category. Is there an easy fix for this?

Again, please take the time to follow the link I posted.

Look for the phrase "This is the most common root cause of category problems." It's in bold. You can't miss it.

swguy:

Again, please take the time to follow the link I posted.

Look for the phrase "This is the most common root cause of category problems." It's in bold. You can't miss it.

Sorry :blush: I guess I've been "working" on this a bit to long.

VGlide:

Sorry :blush: I guess I've been "working" on this a bit to long.

OK, categories are all fixed. I turned off your discounts before running the category fix. After the categories were fixed, I then turned your discounts back on. Discounts 1-5 work fine. I had added a Discount 6 but, it does not calculate now. It did before I turned off
because I had played with the percentages to make sure they were good for me. Is it something simple to edit?:unsure:

Version 1.3.9
I am going crazy with product discounts. i have product discounts and options for products. The options do not affect pricing as they are just colors and such. I have a page where if I add 10 of one product in black and a 1000 in red it works right for some of the products and not others on the page. 9they should be different prices)

Fred McCaughey
https://www.idsupply.co
[email protected]