close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Delivery costs

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

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.

Sign in to reply to this post

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.

Sign in to reply to this post

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

Sign in to reply to this post

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.

Sign in to reply to this post

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

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 Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

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

Uploading file...