How to apply discounts to products with attributes.

Quantity discounts are not being applied properly when order includes the same product (same product_ID) multiple times, but with different option values.

I sell socks by the case.

I have the product set up once, with seven different color options. These options are set up in the attributes controller to be listed in a pull-down menu.

In order for my customer to purchase cases of different colors, he/she must select a color, enter how many cases (quantity) to order and add to cart, then go back to the product page and order another color and add to cart, etc. When this is done, the cart is not applying the quantity discount to all cases, only those added after reaching the quantity level for that discount.

For example: a customer order is to include:

1 case of black, and
2 cases of red socks.

Price manager has been set to apply the price for under 3 cases at $216 and the price for 3 or more cases at $172.50 per case.

The customer adds 1 case of black socks to the cart, and the cart shows the price as $216.00. Then the customer adds 2 cases of red socks to the cart (same product id, different option value). The cart still displays the black socks at $216 and the red socks are shown at $172.50 per case. All three cases should be $172.50 at this point.

In admin-> configuration-> attribute settings I have "Enable Qty Price Discount" set to true.

What have I missed in setting up this product?

Zencart 1.3.7 - url: http://www.aspenshopsonline.com/index.php?main_page=product_info&cPath=68&products_id=193

Still need some help here.

Anybody?

On the edit product page, do you have Product Qty Min/Unit Mix set to Yes?

mamasylvia:

On the edit product page, do you have Product Qty Min/Unit Mix set to Yes?
Thank you for the reply mamasylvia.

Yes, Product Qty Min/Unit Mix is set to Yes.

Here are some other settings from that page:

Product Qty Minimum: 1
Product Qty Maximum: 0
Product Qty Units: 1
Product Qty Min/Unit Mix: yes
Product Priced by Attributes: No

Ron

1. Is it just the socks that aren't discounting correctly, or do all your products have the problem?

2. How about a link to one or two products that aren't working correctly, to save others time hunting through the site?

Baffled,

mamasylvia:

1. Is it just the socks that aren't discounting correctly, or do all your products have the problem?

2. How about a link to one or two products that aren't working correctly, to save others time hunting through the site?

Baffled,
Good idea!

The socks are the only items I carry that have an option name with multiple option values (option name: *color choice *option values: Royal Blue, Light Blue, Pink, Red, Burgundy and Black.) I sell socks by the case (first scenario below) and by the pair (second scenario below).

http://www.aspenshopsonline.com/index.php?main_page=product_info&cPath=68&products_id=193
Enter an order for 1 case of black and 2 cases of red. The total quantity of this product is 3 which qualifies for the quantity price of $172.50 per case. The shopping cart displays different prices for the two colors. The first case (black) is displayed with no discount applied. The second and third case (red) show the correct case price for a quantity of 3.

Clear the shopping cart and enter a different order:

**http://www.aspenshopsonline.com/index.php?main_page=product_info&products_id=232**This product has the same requirement. Enter an order for 4 pair of Royal Blue and 2 pair of red. The total quantity of this product is 6 pair which qualifies for the quantity price of $4.64 per pair. Although the shopping cart now displays one price for both line items, the quantity price was not applied to either item.

Now clear the shopping cart and enter an order for both of the products in the quantities listed above. If entered in the above order, the shopping cart displays a quantity price only for the last item (2 pairs at $4.64). All other items are shown at full price.

I have a similar problem with packs of 6 pair (** http://www.aspenshopsonline.com/index.php?main_page=product_info&products_id=186 **). Attributes are handled a little differently for this product, but the result is similar when an order qualifies for quantity discounted price.

Ron

Thanks for the explanation. Your problem is, sadly, WAY beyond my abilities -- I've gotten pretty good at settings but it sounds like your settings are correct and it may be a program bug. Hopefully one of the gurus will jump in.

RESOLVED - bugfix supplied by DrByte at
http://www.zen-cart.com/forum/showpost.php?p=484232&postcount=9