In an effort to work around the 150lb weight limitation of the live-rate system, my client moved to a flat-rate based on weight scenario, basing his rates on shipping Xlbs to Los Angeles, all the way across the country from Brooklyn, NY where he's located. Using these rates and applying them to each product in the cart, the shipping costs have become prohibitive as well as unrealistic. They are often in the 40-50% of the total cart cost range.
When speaking with the supplier (who will be doing the drop-shipping) I was informed that local (East coast) deliveries tend towards 20% of the cart total, central states 25% and western states about 30%. These would reflect a much more reasonable charge in the cart.
I know that I can implement the shipping categories for these flat rates based on cart total, but how can I apply them on the fly based on delivery address? I thought I'd read a question about this here in the forums, but I'm not finding anything. Would like to essentially create a zone1, zone2, etc., and apply those categories on the fly at checkout.