need to add a charge after each set of 10 items

I'm opening this new thread because I got an answer from page 1 dated way back. You didn't go to page 2 where I had added a question. I figured this would happen so I should've just opened this thread. Anyways, my original posted question yesterday (5-23) was:

I'm adding a snapshot of what I have for shipping, which is working fine. However, I need to add an extra charge of about $2.00 after each set of 10. I'm not sure what the formulas should be. Please help.

Thank you.

create a new shipping rule. set the trigger to number of unique items > 0

for the calculation, use a flat rate charge an enter the following code:

floor($this->TotalColumn("Quantity") / 10) *2

thanks. I'll try that.

I played around it for some time but it doesn't work the way I want. The question is where exactly am I supposed to put the code: floor($this->TotalColumn("Quantity") / 10) *2

Thank you.

as the flat rate charge in your shipping calculation.

Ok, it works and I understand it. I've never been good in Math so I don't know why I'm trying to program sometimes. So it works except that it charges right away once there's 10 items in the basket, because 10 / 10 = 1 x 2 = $2. It's always going to add a charge for the first set of 10, which I don't want. Likewise if you add 30 items to the basket it will charge $6 when it should charge $4. It's not supposed to charge on the first 10 period. I'm trying to figure it out but maybe you've already got the answer.

Thanks Jason.

it was not clear in the initial question that the first 10 should not be included.


Set the trigger to:
"Subtotal For Any Column"
if the subtotal of the column "Quantity" is ">=" "20"


and use the following for the flat rate charge:
floor(($this->TotalColumn("Quantity") - 10) / 10) *2