Discount question

I have the following discount rule for wines (PRODKATID = 7) in our shop:

10% discount if more than 95 bottles of wines are in the cart:

Number of items with PRODKATID of 7 >= 96

Now I need to exclude all wines with a special field value of 1. Means no discount on wines with Field "Primeur" = 1

I've already added another Column "Primeur" in the cart and add the field value from the recordset when adding to the cart.

Now how do I extend the rule to:

Number of items with PRODKATID of 7 AND Primeur of 0 >= 96

Thanks for any help.

in the discount, select to use a custom trigger, for the custom trigger use the following code:

$this->ConditionalTotal("Quantity", "PRODKATID", "7") - $this->ConditionalTotal("Quantity", "Primeur", "1") >= 96

this will return the total number of items where PRODKATID = 7 Minus the total number of items where Primeur = 1

The total discount is still wrong. Here is the rule:

//eCart Rule
function WAEC_eCart_Weinrabatt10() {
$totalDiscount = 0;
if (true && ((( $this->ConditionalTotal("Quantity", "PRODKATID", "7") - $this->ConditionalTotal("Quantity", "Primeur", "1") >= 96 )))) {
$totalDiscount += ($this->ConditionalTotal("TotalPrice", "PRODKATID", "7") * 0.1);//Result
}
return WA_eCart_FormatNumber($totalDiscount, $this->ForceDecimalsC, $this->DecimalPlacesC);
}
//eCart Rule

What happens is that if there are >= 96 bottles of non primeru wines in the cart, the total discount (10%) is counted on the non-primeur AND the primeur wines in the cart.



Furthermore I tried to extend the other discount(s) but received a parse error:

(Discount of 3% for 24 - 47 bottles of wines):

Current rule without primeur wines:

//eCart Rule
function WAEC_eCart_Weinrabatt3() {
$totalDiscount = 0;
if (true && (($this->ConditionalTotal("Quantity", "PRODKATID", "7") >= 24) && ($this->ConditionalTotal("Quantity", "PRODKATID", "7") <= 47))) {
$totalDiscount += ($this->ConditionalTotal("TotalPrice", "PRODKATID", "7") * 0.03);//Result
}
return WA_eCart_FormatNumber($totalDiscount, $this->ForceDecimalsC, $this->DecimalPlacesC);
}
//eCart Rule


New rule with primeur wines, causing parse error:

//eCart Rule
function WAEC_eCart_Weinrabatt3() {
$totalDiscount = 0;
if (true && ((( $this->ConditionalTotal("Quantity", "PRODKATID", "7") - $this->ConditionalTotal("Quantity", "Primeur", "1") >= 24 )) && (( $this->ConditionalTotal("Quantity", "PRODKATID", "7") - $this->ConditionalTotal("Quantity", "Primeur", "1") <= 47 )))) {
$totalDiscount += ($this->ConditionalTotal("TotalPrice", "PRODKATID", "7") * 0.03);//Result
}
return WA_eCart_FormatNumber($totalDiscount, $this->ForceDecimalsC, $this->DecimalPlacesC);
}
//eCart Rule

thanks for any additional help in advance :-)

May I push this thread up again? I do need some support in this issue. Thanks in advance :-)

instead of changing this in the code, you should do it in the discount portion of the eCart object

for the first rule, set the trigger to a custom condition:

$this->ConditionalTotal("Quantity", "PRODKATID", "7") - $this->ConditionalTotal("Quantity", "Primeur", "1") >= 96

then set the calculation to a flat rate and enter this code:

($this->ConditionalTotal("TotalPrice", "PRODKATID", "7") - $this->ConditionalTotal("TotalPrice", "Primeur", "1")) * 0.1

for the 3% off on 24 - 47, enter the following for the custom trigger:

($this->ConditionalTotal("Quantity", "PRODKATID", "7") - $this->ConditionalTotal("Quantity", "Primeur", "1") >= 24) && ($this->ConditionalTotal("Quantity", "PRODKATID", "7") - $this->ConditionalTotal("Quantity", "Primeur", "1") >= 47)

then set the calculation to a flat rate and enter this code:

($this->ConditionalTotal("TotalPrice", "PRODKATID", "7") - $this->ConditionalTotal("TotalPrice", "Primeur", "1")) * 0.03

Thanks a lot Jason, I'll give try on this and give you a feedback.

you're welcome.

Works like a charm :-)

glad to hear it is working.