states

[jay9898]

Anyone know how to make the state selection visible instead of hiddenby default for all countries?

[justinl]

The easiest way might be through executing some SQL in your database. This should do the trick:

 

UPDATE ps_country SET contains_states = '1' WHERE active = '1'

 

Other than that, you'll have to go into each country in the Back Office individually and turn "contains states" to on. However, if you don't have any state information for a country and a customer tries to checkout, you might get an error because a state is required for that country but there is nothing to select.

 

Cheers,

Justin

[jay9898]

unfortunately ps_country SET contains_states = '1' WHERE active = '1' does not work, turning on "contains states" does nothing, I have modified my theme to much and ajax is broken