Community Forums 

Main Content

Units - Shipping option up to then free

    Feb 11 2013 14:51:52

    #1

    Sandro

    Join date : 2013-02-11      Posts : 15

    My shopping cart is set up this way:

    I offer each product (coffee) in both 12 oz bags and 5 lb. bulk bags. We want to set it up (assuming units is the best method?) so that shipping is based on pounds/ units.

    First unit is $8.50, next unit $2.50, then $1.00 for EACH additional unit up to 25 (pounds/units) which would be a max of $23, then over the 25 units/pounds shipping is free. Idea being max shipping charged up to 25 pounds would be $35 ($8.50 + $2.50 + $23) See below:

    First= $8.50
    Next= $2.50
    Next= $1.00
    Next= $1.00
    Rest= $1.00.

    Problem is no matter how many pounds are order the max shipping calc comes out to $15.
    I have units field in form as follows:

    1 pound bags as so: <input type="hidden" name="price1" value="10.95" units="1" />
    5 pound bags as so: <input type="hidden" name="price1" value="47.50" units="5" />

    My cart is set up and works fine (just not live yet), except for this shipping calc issue I need help on.

    Do I need a Pro account for this feature? In any event how do I set this up. Which option 4, 5, 6, 7,???

    Cheers



    Feb 11 2013 15:01:35

    #2

    GT

    Join date : 2008-09-18      Posts : 3256

    Have you tried option 4?

    The first 1 = 8.50
    The next 1 = 2.50
    The next 12 = 1.00
    The next 1 = -23.00

    Having trouble with a form or need one building?
    Fast turnaround, but I do charge :)

    Mal's Forms / Scripts and the syntax are here.




    Feb 11 2013 17:11:01

    #3

    Alan

    Join date : 2008-09-18      Posts : 2987

    Your numbers don't tie up. 8.50+2.50+23=34 not 35. And with the numbers you quote the cart should be giving 14 as a maximum not 15.

    Assuming a pound is a unit and you wish to charge $8.50 for a 12oz bag, you would require option 7 but would run out of rows in the table, and the solution needs a Premium account..

    If you are happy to charge 0.75*8.50 for a 12oz bag, you could use option 5 where the COST column has multipliers

    UNITS COST
    1 ____ 8.50
    2 ____ 2.50
    23 ___ 1 ______ 25 units=pounds costs 34
    0.1 __ -340 ___ subtract 34 if over 25 pounds

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




    Feb 12 2013 14:10:37

    #4

    Sandro

    Join date : 2013-02-11      Posts : 15

    I will repost this issue now that I have a premium account with some of my code and maybe better explanation. I believe it may be a syntax issue as I am not a form expert, but have used Mals with success past 7 years or so on a more limited scale.

    Pleas see my new post on this topic



    Feb 12 2013 17:24:24

    #5

    Alan

    Join date : 2008-09-18      Posts : 2987

    Can't find the new post.

    The format for advanced shipping would be

    The first 1 unit is charged 8.50 the band
    The next 1 unit is charged 2.50 the band
    The next 23 units is charged 1 each
    The next 1 unit is charged -34 the band

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