The complication stems from the requirement: If the total of the order is over $500, we need to apply an additional discount, but only to _certain items_, not the whole order.

If a dealer orders more than $500 in merchandise, they get an additional 5% off of their "entire order", but because we don't want it to apply to limited discount items (which, if discounted further than X% we make no profit on), it's not really off of the entire order, it's off of the items in the order that aren't limited discount items.

My understanding is that price rules apply to ITEMS, whereas promotions apply to ORDERS. We need a mechanism that can do both. We either need a price rule that can be employed only when a certain value is reached in the cart, or a promotion that can be employed only on certain items in the cart.

David E. Jones wrote:

On Feb 18, 2007, at 5:22 AM, Walter Vaughan wrote:

What really monkeys this up (my apologies to any monkeys on the list) is that after I get this rule working, I have a exception for a category of products that are limited to 10% regardless of amount of order total.
What is that actual error you are getting?

Its not an error yet :) What I can't wrap my head around it how to handle the case where the customer is entitled to an additional discount based upon the value of items in the cart, yet they are not entitled to recieve that additional discount percentage for all the items in the cart.

           10% off         5% Promo
Part    Retail     PriceRule   Qty   over $500         Total
A $10 $9 10 0 $90 A $10 $9 70 35 $595
B    $10       $9        10    0        $90
B    $10       $9           70    0            $630

So if a customer had 70 of partA and 70 of partB which is exempt from any more discounting, their cart total should be $1225, not $1260

I guess I need to get a promo I created working, before I worry about the exception to the promo :)

I'm really lost here... maybe I'm missing something obvious.

One thing I'm not clear about it where you are using price rules, and where you are using promotions. The two are very different.

I think what you are describing here is easiest to do with promotions. You can specify a category (or multiple categories) that are excluded from a promotion condition or action or in general.

-David



--
David Shere
Information Technology Services
Steele Rubber Products
www.SteeleRubber.com

Reply via email to