Delivery costs

I've built an eCart store for a client, but they have a very awkward delivery price structure that I am not sure how to implement.

Firstly they have a minimum charge for up to 10kg, then it is 28p/kg up to 100kg, then 40p/kg after that!!

The client also needs the ability to change these values regularly.

I'm assuming I need to create a delivery table (?) but I'm not sure how to make the calculations in eCart.

I think one of the biggest parts to this is going to be weather this base price will be included for orders greater than 10kg or if after 10kg it is only 28p/kg and so on.

Please explain this part as best as you can and use some examples for each of these three scenarios so that we can have a definite understanding of the scenario and requirements.

At the moment, anything up to 10kg is £14.50, then it is 28p/kg added to that (e.g. 11kg = £14.78; 12kg = £15.06 etc.)

Once it gets to 100kg (£54.50) it is 40p/kg extra (101kg = £54.90; 102kg= £55.30 etc.)

Ok, I think you can do this with a total of three rules. The first rule will just be a flat rate of 14.50.

The second charge rule will be setup like this:

based on a column subtotal, if totalweight is > 10

AND

based on multiple of column subtotal, if totalweight is <= 100

Then for the calculation you would do 'based on multiple of column subtotal' then choose totalweight times .28 minus 2.8. This will account for the first 10 kg.

For the third charge rule I'm not sure if the numbers you put here are correct, but if you know that they are then the rule should be crafted like this:

based on a column subtotal, if totalweight is > 100

Then for the calculation you would have 'Based on multiple of column subtotal' subtotal of column TotalWeight times .4 plus 0.

I did some testing of these charge rules and the results that I got for the weights equaled the values that you posted so it seems that the rules should be crafted like this. If you have any trouble with this please let us know and we will be glad to try and help you get it working.