My supplier will be in many cases shipping directly to my customers for items beyond the very limited selection I'll actually stock on hand. To calculate shipping they use the "official UPS rate chart" based on weight in lbs and zones (based on first 3 digit zip code ranges). They publish it in a table form in their annual catalog.
Ive set up realtime shipping with the UPS module but the quotes are not accurate, perhaps realtime tables have changed or it's due to my quotes not having package data beyond weight.
Ultimately I need to have things based on this total order lbs applied to the UPS zone table my supplier is using. I don't mind typing it in manually once per year when the catalog changes if I need to, but I'm not sure how I'd go about organizing or setting this up, if it is possible
thanks for any nudges in the right direction!