Posted by
David Shere on
Feb 19, 2007; 2:01pm
URL: http://ofbiz.116.s1.nabble.com/Price-Rule-simple-question-tp144630p144634.html
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