PDA

View Full Version : Handling Fee



micah1
11-21-2005, 11:30 AM
Is there a way to offer free shipping but add a handling fee for heavier items? I have tried but had no luck. Thanks for any help.

kenlyle
11-22-2005, 09:38 AM
I use a spreadsheet to generate your shipping price scheme.

It produces output like this:

0 0 0:0,
1 10 1:10,
2 11 2:11,
3 12 3:12,

The formula in the third column is: =A3&":"&B3&","

If you take the third column of calculated numbers into an editor, replace the returns with nothing, you will have your shipping string.

In your case, the spreadsheet might just have rows for 99:0, 100:25, 101:26, whatever, which is to say 99# or less, charge nothing, then 100 pounds is $25, etc.

Ken