WA_eCart : TotalPrice - TruePrice

After changing the calculation of categorie 31, the calculations of categories 1-30 (when ordering more than 1 product) aren't correct anymore (see attached image).
In attach :
* OK.txt : before changing calculation 31 - calculations 1-30 OK
* not_OK : after changing calculation 31 - calculations 1-30 not_OK


I think it must be someting with the brackets in the code, but I searched and tried in vain.

It looks like you are missing the fourth ")" from the end of that line.

When I add a fourth ")", the error says :

End of the instruction is expected
/stickers/WA_eCart/stickersBE_VB.asp, line 194

........ Quantity > 19 AND itmObj.ProductCatID <> 57))*0.04) - ((abs(itmObj.Quantity > 50 AND itmObj.ProductCatID <> 57))*0.05)))'c
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------^

It looks like you are also missing an open "(" before: ((itmObj.Size-15)

it should be:
(((itmObj.Size-15)

Now there's no error, but the calculations for categorie 1-30 are still not correct when ordering more than one of the same product.
In the TotalPrice, only the discount price for one product is shown. The calculation doesn't multiply the price. See previously attached image.

Maybe there's another calculation rule for :

(Abs(itmObj.ProductCatID = 31) * (itmObj.Price+(abs(itmObj.Size < 110) * ( ((itmObj.Size-15)/5)) + (abs(itmObj.Size = 110) * (+18)) + (abs(itmObj.Size = 120) * (+19)) + (abs(itmObj.Size = 130) * (+20)) + (abs(itmObj.Size = 140) * (+21)) + (abs(itmObj.Size = 150) * (+22))) )+

The price for products > 110 (size cm) must be increased by 1 (euro) each 10 (size cm).



This calculation worked fine :
(Abs(itmObj.ProductCatID = 31) * (itmObj.Price+(abs(itmObj.Size <= 65) * ((itmObj.Size-15)/5)) + (abs(itmObj.Size > 65) * (((itmObj.Size-65)/10) + 10))))+

The price for products > 65 (size cm) are increased by 0,5 (euro) each 5 (size cm).
But here the max size was 100. Now the max size is 150, so the calculation should be edited.

Try this one:
(Abs(itmObj.ProductCatID = 31)*(itmObj.Price + (abs(itmObj.Size < 110) * ((itmObj.Size-15)/5)) + (abs(itmObj.Size = 110) * (+18)) + (abs(itmObj.Size = 120) * (+19)) + (abs(itmObj.Size = 130) * (+20)) + (abs(itmObj.Size = 140) * (+21)) + (abs(itmObj.Size = 150) * (+22))))+

I used your new line, but get the same error :
End of the instruction is expected
/stickers/WA_eCart/stickersBE_VB.asp, line 194

........ Quantity > 19 AND itmObj.ProductCatID <> 57))*0.04) - ((abs(itmObj.Quantity > 50 AND itmObj.ProductCatID <> 57))*0.05)))'c
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------^


I deleted one bracket on the end of line 194, 196 and 197.
Now it's working fine !


Thanks a lot Ray ! :-)