States

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.

If you wish to display states from certain countries, you can use the configuration below in the administration :

Xdisplaystates

This is a comma-delimited list of country abbreviations, displaying states available from these countries.

For example, if you set the value for “xdisplaystates” to “US,AU” then the state dropdown menus in the Customer Information section will only display the states from US and AU.