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 *

 

Live chat: cookie consent required

Copyright © Hungersoft 2019

· Terms & Conditions · Privacy policy