The table below describes the columns in the shopstates table and how they are used.
Stateabbrev |
Two- or three-character abbreviation for the state, such as NY or CA. | ||
statename |
The full name of the state, such as New York or California. | ||
Statecountry |
The two-character country code that this state belongs to. | ||
Statehide |
If this is set to True, then the state will not be displayed in the state dropdown list. | ||
Statetaxrate |
If customers from this state should be charged a certain tax rate, then enter it here. | ||
Statecanadapst |
The PST rate for Canadian provinces.
| ||
statefreeshipping |
Setting this to Yes mean this state is available for Free Shipping. The free shipping option will be displayed. All other existing shipping options also showed so if customer wants to select a faster shipping method. | ||
If you wish to display states from certain countries, you can use the configuration below in the administration :
|