Different Flat Rate shipping for each item, then discount.
I have studied, and even tried several of the shipping steps found here within the forum. But I am stumped.
My client ships at a flat rate, but each item has a different rate?
Shipping rates are stored in a database table. Oh, and this is for a PayPal Standard shopping cart.
The client wants to discount the flat rate by 50% for each item after the first one. AND not start over on a different unique item.
So for example.
Widget 1 = $10 shipping for the first one.
Then the second, third, fourth would be $5 shipping each
Widget 2= $3 shipping
Then the second, third, fourth would be $1.50 shipping each.
So if they order 2 of Widget 1, shipping would be $15 total.
But, if they order 1 each of Widget 1 Widget 2, then the higher shipping of $10 should be applied first, and a discounted shipping of $1.50 would be added for widget 2.
I'm confused about where I bring this shipping into the calculation and what the rules would be.
Should I use a hidden input and populate it with the shipping amount in the recordset to start with? If so, then what?