Community Forums 

Main Content

Shipping Calculation Query

    Jan 23 2009 08:43:34

    #1

    Darren

    Join date : 2008-11-05      Posts : 11

    Can anyone assist ...

    If order value is less than $70 ...
    Shipping = ( 15% of order value ) + $3

    If order value is over $70
    Shipping = flat $3



    Jan 23 2009 09:14:43

    #2

    just visiting

    Join date : 2008-09-18      Posts : 2950

    Using option 5 with the units=price box checked, you could define a flat fee of 3 and

    UNITS COST
    70 ___ 0.15 ______ 15% rises to 10.50 at 70
    0.01 _ -1050 ______ subtract 10.50 as soon as order exceeds 70

    You didn't say what happens at 70 exactly. If you wanted it to be 3 then

    UNITS COST
    69 ___ 0.15
    0.99 __ 0.15 ______ can't have 69.99 because max of four characters in UNITS column
    0.01 _ -1050

    Alan
    Some shipping help documents are available at www.stoner.org.uk/mals/




    Jan 23 2009 09:38:25

    #3

    Darren

    Join date : 2008-11-05      Posts : 11

    Thanks so much - really appreciate the time !