Delivery costs

Thread began 11/16/2009 10:40 am by Heckie | Last modified 11/17/2009 9:18 pm by Eric Mittman | 924 views | 3 replies |

11/16/2009 10:40 am  |  #1 Heckie

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.

11/16/2009 6:37 pm  |  #2 Eric Mittman

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.

11/17/2009 5:24 am  |  #3 Heckie

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.)

11/17/2009 9:18 pm  |  #4 Eric Mittman

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.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Everything else!

Close Window

Account or customer service questions?

Need technical support?

Content

Layout

Ease of use

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Window

We were unable to retrieve the attached file

Close Window

Attach and remove files

• Text Formatting
• Insert Element
• Block Formatting
• Cancel
Close Window

Close Window

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --