Shipping Formula
Hi Folks,
I need to be able to sort a shipping calculation out based on the highest shipping rate placed in the cart.
Each item is set to add uniquely as this is what the customer wanted as he has colors etc attached to them.
The shipping is driven from a database table called ship and the column Shipping holds the price, whilst the column ShippingName holds the value with the product table so they can be joined (A,B,C,D,E,F)
So for example, if a customer places an item in shipping category A ($1 shipping) into the cart, then they would be charged $1.
If the customer then goes back shopping and chooses a different item, but it is still in category A for shipping, then they wont be charged anymore.
If the customer then goes back shopping and chooses an item that is in shipping category D ($3) then the whole cart shipping will change to $3. The highest shipping charge of the basket.
Hope this is explained in a way that is understandable. Basically, the shipping needs to default to the highest shipping category that is placed in the cart.
Can you help.
Cheers