TOPIC:

Hi thank you for this great plug in. We just upgraded our plug in order to do the Canada post Rate system (see attached). I got the first part working where it detects the province and charges a 12.60 rate based on first letter. But I cannot get conditional weight requirements to work: Above 3kg, each .5kg is is an additional 0.60

Province detection for first letter:
1. Name=Canada Shipping ; Canada_Area=="A"; Shipping=17.50

But now I need to express:

2. for each incremental .5kg above 3kg 0.60*Weight; Shipping= (

I cannot make the former and latter expressions work together. Is this possible to do? Can you help us in finding the right expression to create the Canada Post Rate System? I have been obsessing over this since we boaught it.

Thank in advance for your assistance.

If I understand you correctly, you want a rule like

name=Canada Shipping; Canada_Area=="A", Shipping=17.50 + ceil(2*max(weight-3,0))*0.6

What it does:
-) Calculate how much we are above 3kg (0 if below): max(weight-3,0)
-) Count how many (partial) 1/2 kg we are above 3kg: ceil(2*...)
-) each of them is 0.6$

Best regards,
Reinhold

Of course, if you want to make the rules simpler (get rid of the max), you can split it into two rules, one for less than 3kg and one for more:

name=Canada Shipping; Canada_Area=="A" && Weight<=3; Shipping=17.50
name=Canada Shipping; Canada_Area=="A"; Shipping=17.50+0.6*ceil(2*(weight-3))

Thank you so much, this works perfect!

Problem solved.