Shipping tables stored in database, multiple options

[ATeschner]

Forgive me for being precise, but here is what I need to do:

 

I have a table for each shipping option. fields=zones, rows=weight.

 

I want OSC to take the shipping address, determine the zone by the zip code and display all the shipping prices on shipping.php for comparison.

 

The problem is USPS, FedEx and UPS use different zip code tables to determine their zones, so one particular zip code would be in zone 4 for fedex and zone 5 for UPS. So I could have a table called zips with a field for each company and a row for each range of zips to designate the zone by carrier. (Not a problem - I could do this programmatically in access.)

 

I want to use my own tables because I am using a dropshipper and they have a minimum shipping charge, plus a handling fee - So pulling from UPS XML or USPS.com is out. Table module is out because of the 255 character limit, and zone module goes by state, which is not quite as precise as I would like to be. I don't want to lose money on shipping, but I really don't want to gouge my customers either becuase I already have a minimum charge, and the dropship handling fee is something like another $2 per package.

 

I can't seem to find a contribution that satisfies this. Is there one or will I need to write my own? (I don't really want to because I need to go live ASAP and make some $$$)

 

I tried searching the forum, but the search feature here is horrendous because i cannot search specifically by phrase. :blink:

[ATeschner]

I want OSC to take the shipping address, determine the zone by the zip code and display all the shipping prices on shipping.php for comparison.

 

Oops! I meant checkout_shipping.php of course... :blush:

[ATeschner]

I am working with the Toll Rates with SQL contrib to see if I can squeeze some more flexibility out of it.

 

I will still appreciate any input I may receive on this...