In this section, we will explain how to setup premium tablerates csv for specific city within the state/region of a country.
Configure different rates for cities
In this example, we will explain how to apply different shipping rates for different cities in a particular state/region of a country. To know more about the city column in the csv, please check our section on CSV Import / Export.
We will configure rates for different cities in the state of California in the United States. Shipping method Ground will be available for everyone in the state of California. However, the rates will vary for few cities and a global rate for all the other cities within the state.
The below CSV defines Ground shipping method with a rate of $10 for every city in the state of California (CA). However, the rates of Los Angeles and San Francisco $14 and $12 respectively. The shipping rates will match regardless of letter case. For example: Customer will receive $14 as the shipping price regardless of whether the customer enters the city name as LOS ANGELES, Los Angeles, los angeles, etc.
| Country | Region/State | City | Zip From | Zip To | Weight >= | Weight < | Price >= | Price < | Qty >= | Qty < | Shipping Price | Algorithm | Shipping Method | Sort Order |
| USA | CA | Los Angeles | * | * | * | * | * | * | * | * | 14 | * | Ground | * |
| USA | CA | San Francisco | * | * | * | * | * | * | * | * | 12 | * | Ground | * |
| USA | CA | * | * | * | * | * | * | * | * | * | 10 | * | Ground | * |
Disable shipping for certain cities
In this example, we will explain how to disable shipping for specific cities.
To disable shipping to Sacramento, CA, USA, set -1 as the shipping price in the CSV row for the city of Sacramento. The below CSV configures Next Day delivery to every city in the country except Sacramento.
| Country | Region/State | City | Zip From | Zip To | Weight >= | Weight < | Price >= | Price < | Qty >= | Qty < | Shipping Price | Algorithm | Shipping Method | Sort Order |
| USA | CA | Sacramento | * | * | * | * | * | * | * | * | -1 | * | Next Day | * |
| USA | * | * | * | * | * | * | * | * | * | * | 15 | * | Next Day | * |
Additional shipping methods for specific cities
This example will show you how to provide additional shipping methods for specific cities.
In this example, Next Day delivery will be provided to every city in the state of California. However, Same Day shipping will be available only for customers from LA.
| Country | Region/State | City | Zip From | Zip To | Weight >= | Weight < | Price >= | Price < | Qty >= | Qty < | Shipping Price | Algorithm | Shipping Method | Sort Order |
| USA | CA | Los Angeles | * | * | * | * | * | * | * | * | 30 | * | Same Day | * |
| USA | CA | Los Angeles | * | * | * | * | * | * | * | * | 15 | * | Next Day | * |
| USA | CA | * | * | * | * | * | * | * | * | * | 15 | * | Next Day | * |