Table Shipping Rates by Zones

Hi all.

I was wondering if it is possible to configure custom shipping rates by zones and tables like in the screenshot below. Or is there a module to do this. In my case I just need UPS Ground and UPS 2 Day.

Any help welcome. Thanks!

You could use the built-in UPS extension with just Ground and 2-Day selected, if you sign up for a UPS account. Otherwise, you can use geo zones (created in System > Localisation > Geo Zones) and Weight Based Shipping if you want to set the weight of each bottle to 1. Or, if you'd rather charge on a per-item basis, you could use Item-Based Shipping.

Thanks Jonathan, but how will this work?

My client uses a fulfillment service and the table you see above are their prices. He sells a single bottle or 12 in one case, the price should reflect the price in the table by zone.

So for example if someone orders a bottle of wine in New York he:
Is in Zone 3 with a price of $15.42 for Ground or $23.92 for 2 day service.

How would that work with the Geo Zone and per item? (Weight is out of the option because they are fix prices by the fulfillment company)

Thanks for your help.

If the prices aren't actual UPS prices, then you would need to either use Weight Based Shipping with bottle weights of 1, or Item-Based Shipping. For instance, using the latter you would then set up a geo zone for each "Zone" in the table, and create rates like this:

RATE #1
Title: UPS Ground
Geo Zones: Zone 2
From: 0 To: 1, Charge: 15.42
From: 1, To: 2, Charge: 15.39
From: 2, To: 3, Charge: 17.41
etc.

RATE #2
Title: UPS 3-Day
Geo Zones: Zone 2
From: 0 To: 1, Charge: 24.74
From: 1, To: 2, Charge: 24.71
From: 2, To: 3, Charge: 25.65
etc.

Feel free to contact me at www.getclearthinking.com/contact if you have further questions about how to use that extension.