In this section, we will explain how to setup premium tablerates csv for specific state/region.
Configure different rates for states
We will begin with a simple example on how to setup different shipping rates based on region. In this example, Standard shipping method will be provided to all customers from the US. However, rates will differ based on the state / region selected by the customer. To know more about the region/state column in the csv, please check our section on CSV Import / Export.
The below CSV defines Standard shipping method at $10 for 48 Contiguous States and Standard shipping method with $15 for Alaska (AK) and $20 Hawaii (HI).
| Country | Region/State | City | Zip From | Zip To | Weight >= | Weight < | Price >= | Price < | Qty >= | Qty < | Shipping Price | Algorithm | Shipping Method | Sort Order |
| USA | AK | * | * | * | * | * | * | * | * | * | 15 | * | Standard | * |
| USA | HI | * | * | * | * | * | * | * | * | * | 20 | * | Standard | * |
| USA | * | * | * | * | * | * | * | * | * | * | 10 | * | Standard | * |
Disable shipping for certain states
To disable shipping rates from showing for certain state / region, the shipping price should be set to -1 for those particular regions. In this example, shipping rates will be available only for 48 Contiguous States and, Alaska and Hawaii will not display any shipping rates.
| Country | Region/State | City | Zip From | Zip To | Weight >= | Weight < | Price >= | Price < | Qty >= | Qty < | Shipping Price | Algorithm | Shipping Method | Sort Order |
| USA | AK, HI | * | * | * | * | * | * | * | * | * | -1 | * | Ground | * |
| USA | * | * | * | * | * | * | * | * | * | * | 15 | * | Ground | * |
Exclude certain shipping methods for certain states
The previous example explained how to disable shipping method to a certain state entirely. This example, explains how to exclude some shipping methods for certain states.
In this example, US continental will receive all shipping methods namely: Express Critical, Next Day and Ground whereas Alaska (AK), Hawaii (HI), Guam (GU) and Puerto Rico (PR) will receive only Standard shipping method.
| Country | Region/State | City | Zip From | Zip To | Weight >= | Weight < | Price >= | Price < | Qty >= | Qty < | Shipping Price | Algorithm | Shipping Method | Sort Order |
| USA | * | * | * | * | * | * | * | * | * | * | 50 | * | Express Critical | * |
| USA | * | * | * | * | * | * | * | * | * | * | 25 | * | Next Day | * |
| USA | AK,HI,GU,PR,* | * | * | * | * | * | * | * | * | * | 10 | * | Standard |
Additional shipping methods for certain states
In certain cases, you might want to allow additional shipping methods for certain regions and disallow them for the rest of the regions. For example, it might be possible for you to provide faster shipping options intra-state / state of origin (whence the orders will be shipped). Specifying shippping rates for each state is not ideal. In such cases, you can specify the shipping rates allowed for all the states and define additional shipping method for a specific state as shown below.
In this example, all US states will have a Standard shipping method available, whereas, Alaska will have a Express Critical delivery option available.
| Country | Region/State | City | Zip From | Zip To | Weight >= | Weight < | Price >= | Price < | Qty >= | Qty < | Shipping Price | Algorithm | Shipping Method | Sort Order |
| USA | AK | * | * | * | * | * | * | * | * | * | 25 | * | Express Critical | * |
| USA | AK,* | * | * | * | * | * | * | * | * | * | 10 | * | Ground | * |