16oz 200 205 admin bag bags becomes calculate cart-discounts charge coffee costs discount discounts elements field flat handling help min note order orders packaging percentage price product rate remove settings setup shipping table weight zipcode

I have one product setup. I want to charge a flat shipping rate of $5 per 16oz bag of coffee, $4 for the second bag, and $2 for each bag after the first and second. I have yet to figure out how to do this. Please help. Thanks.

So basically, your shipping table looks like:

1 bag - $5
2 bags - $9
3 bags - $11
4 bags - $13
.
.
100 bags - $205

Say, if your bag costs $2, then the shipping table becomes

For a $2 order, shipping is $5
For a $4 order, shipping is $9
For a $6 order, shipping is $11
.
.
For a $200 order, shipping is $205

Now, in Admin > Shipping Settings, set weight and price of all packaging elements to 0, remove your zipcode and in the handling field enter $205.

This will basically set a flat shipping of $205 for all your orders. Since we don't want that, you should go to Admin > Cart Discounts.

Add the following discounts:

For a min. $2 order, add a 97.56% shipping discount.
note: to calculate the percentage -> (($205-$5)/$205)*100

For a min. $4 order, add a 95.60% shipping discount
note: to calculate the percentage -> (($205-$9)/$205)*100

For a min. $6 order, add a 94.63% shipping discount
.
.
For a min. $200 order, add a 0% shipping discount.

Hope this makes sense :)