I'm building a simple order form that allows people to order varying quantities of different products. I need to allow for three different shipping prices, one for 0-3 products, another for 4-11 and a third price for 12+. The Shipping field doesn't seem to support any logic at all as far as I can see - it's merely a flat price per product (seemingly without regard to the quantity).
I could simply tie a Shiping price to each product but 1) since Shipping seems to ignore quantity that would leave me with the same shipping price whether a customer ordered 1 or 10 of that product and 2) it doesn't actually solve the case I'm working on where shipping goes to free at 12+.
Any thoughts on how this might be done? I'm kind of surprised the Shipping field is so lacking in options.