Main Content

## Re:Having trouble with shipping settings

Aug 29 2017 17:47:57

#1

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.

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/