Calling gifted problem solvers!

A number of my products are via dropship. I update products via API. Potentially have 75,000 products that in theory might each have a different shipping rate to different parts of the country.

My supplier charges different shipping rates by product and location.

Any suggestions about how to deal with this.

  • Currently I am setting the product shipping charge based on the highest shipping rate, but the difference between the cheapest and most expensive shipping rate for a product can vary by $100 + (sometimes more than doubling the total price).
  • Thinking maybe creating 100 different shipping rates and combining with some dummy vendors (e.g. location A rate A, = vendor 1, location A rate B = vendor 2, then assigning product to a vendor based on the shipping charge)

… but hoping something simpler? Any ideas?