Shipping Charges By States

Hi everyone,

I am having problems trying to figuring out how to add/update shipping charges by states.

Currently, I have created about 500 suppliers and 500 Shipping methods.

- Each shipping method would have different rates for each state.

- Each supplier is linked to a different Shipping method.

- Each product is then linked to each Supplier.

This setup is working fine except it is very complicated and it is a nightmare when the suppliers decide to change their shipping charges.

Is there anyone who had the same problems and how did you get around it? It looks like an addon is required but it is good to know your ideas and suggestions. Attached is a sample of shipping charges.

shipping by state.JPG