Shipping based on quantity

[Tony Green]

We are setting up a ShopSite store (Manager, version: 10 sp1 r1) to sell music CDs and are having trouble setting up shipping charges. We don't charge a fixed rate per CD, but rather use a proportional scale based on quantity. Here's an example:

1 $3.50
2 $4.00
3 $5.50
4 - 7 $6.50
8+ $1.75 each

I think we are looking for a lookup table based on quantity, but all the shipping choices seem based on having a fixed cost per unit (or weight). Any suggestions? Thanks for your help!

[Jim]

If you aren't going to be using the product weight field on all products you could set the weight of each product to 1. Then using the shipping by weight method setup the table so that the "weights" match the number of products you will ship at a certain price
0.00 1.00 3.50
1.01 2.00 4.00
2.01 3.00 5.5
3.01 7.00 6.50


Note that I used the 1.00 for the end weight range and the 1.01 for the begin range because computers don't always work with exact integer values so you need to carry it to 2 decimal places so some rounding can be done. But the above table will work for your shipping rates for 1 to 7 products.

This method breaks down at that point but you could continue the table out farther using your 1.75 as the multiplier for further groups say 8-10 for 10.50
11-15 22.50 etc and adjust the price slightly for larger groups.

You can have 20 different ranges by default and I think you can add up to 99 so you could even continue the table on an individual cd bases and setup fields for each individual cd over the 8 and just use the multiplier for the prices.

[Tony Green]

Jim,

That works perfectly, thanks!