Community Forums 

Main Content

Re:Having trouble with shipping settings

    Aug 29 2017 17:47:57

    #1

    Alan

    Join date : 2008-09-18      Posts : 2951

    SIt down with an ice pack and consider the following.

    It sounds as though
    1. any jewellery on its own costs $2.50. If there is also an antique the jewellery can go in the box and be ignored.
    2. each small antique costs $8.50.
    3. each large antique costs $14.50.

    Jewellery - a UNITS value of 1. I've assumed not more than 9 items bought.
    Small antique - a UNITS value of 10. I've assumed not more than 5 bought.
    Large antique - a UNITS value of 100. I've assumed not more than 4 bought.

    With those assumptions you could use advanced shipping based on total units - needs a Premium account. The costs are cumulative.

    The first 9 units costs 2.50 the band - up to 9 jewellery items
    The next 10 costs 6 the band - 10-19 units would be a small antique and maybe some jewellery so one box for $8.50 (cumulative so 2.50+6)
    The next 10 costs 8.50 the band - 20-29 two small antiques and maybe some jewellery 2x8.50=$17 (cumulative so 2.50+6+8.50)
    The next 10 costs 8.50 the band - 30-39 three small antiques etc so 3x8.50=$25.50
    The next 10 costs 8.50 the band - 40-49 so 4x8.50=$34
    The next 50 costs 8.50 the band - 50-99 so 5x8.50 (assumed max 5 small) giving a total of 5x8.50=$42.50
    The next 10 costs -28 - 100-109 would be one large antique and maybe some jewellery in one large box so price drops to $14.50
    The next 10 costs 8.50 the band - 110-119 one large and one small antique so total is 14.50+8.50=$23
    The next 10 costs 8.50 the band - 120-129 one large and two small antique so total is 14.50+2x8.50=$31.50
    The next 10 costs 8.50 the band - 130-139 one large and three small antique so total is 14.50+3x8.50=$40
    The next 10 costs 8.50 the band - 140-149 one large and four small antique so total is 14.50+4x8.50=$48.50
    The next 50 costs 8.50 the band - 150-199 one large and five small antique so total is 14.50+5x8.50=$57
    The next 10 costs -28 the band - 200-209 two large and maybe some jewellery so total is 2x14.50=$29
    The next 10 costs 8.50 the band - 210-219 two large one small and maybe jewellery 2x14.50+8.50=$37.50
    The next 10 costs 8.50 the band - 220-229 two large two small 2x14.50+2x$8.50=$46
    The next 10 costs 8.50 the band - 230-239 two large three small 2x14.50+3x8.50=$54.50
    The next 10 costs 8.50 the band - 240-249 two large four small 2x14.50+4x$8.50=$63
    The next 50 costs 8.50 the band - 250-299 (assumed max 5 small) two large 5 small 2x14.50+5x$8.50=71.50
    The next 10 costs -28 the band- 300-309 three large 3x14.50 = 43.50 so price drops
    The next 10 costs 8.50 the band - 310-319 three large one small 3x14.50+8.50=$52
    The next 10 costs 8.50 the band - 320-329 three large two small 3x14.50+2x8.50=$60.50
    The next 10 costs 8.50 the band - 330-339 three large three small 3x14.50+3x8.50=$69
    The next 10 costs 8.50 the band - 340-349 three large four small 3x14.50+4x8.50=$77.50
    The next 50 costs 8.50 the band - 350-399 three large five small 3x14.50+5x8.50=$86
    The next 10 costs -28 the band - 400-409 four large and maybe some jewellery 4x14.50=$58

    I think that's 25 rows and you can have up to 26 in the table so that's about as far as we can go. The free stuff can have a units value of 0 and will be ignored.

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