Weight based shipping problem

Hello...

I'm trying to set up a shop with three different shipping costs.

Very small items cost £2.75 to deliver
medium items cost £7.50 to deliver
large items cost £17.50 to deliver

I've set up weight based shipping thus:

1:2.75,100:7.50,10000:17.50

...and the weights of each product are either 1, 100 or 10000.

but buying 2 products with a weight of '100' is charging the shipping at £17.50 and not £7.50.
Same if i buy 2 products weighing '1', it charges me £7.50 and not £2.75

I would have expected the shipping cost to increase from £7.50 to £17.50 only when 100 items weighing '100' have been ordered.

am i having a blonde moment?

ps... the actual weight of each product is irrelevant,

Any advice would be greatly appreciated.


edit... i think I'm getting there by doing th following...

1:2.75,2:2.75,3:2.75,4:2.75 [all the way up to] 98:2.75,99:2.75, [then] 100:7.50,101:7.50,102:7.50, [all the way up to] 9997:7.50,9998:7.50,9999:7.50,10000:17.50

...which is working better... but it's one hell of a long list! (although quick to compile)

is this the only way or have i gone down the long winded route?

The first part of the bracket (the weight) means "up to". Based on your description of what you need, you should just be able to do this instead:

99:2.75, 9999:7.50, 9999999:17.50

That means 100 of the "very small" items can be in the cart before it will charge the next bracket. See the difference?

You sir... are a genius!!!

Thank you

No problem It's a common misunderstanding of how the extension works. It's why I've tried to move away from that format in my own extensions.