Community Add-Ons

Maintainers: rkelley
Add file to this package
Top » Zones

Default State Changed to "Please Select a State"
for osCommerce Online Merchant v2.2

We noticed a problem when customers mistyped their state name while filling our shipping or billing address information. If selects United States as the country and types in the name of the state incorrectly, OsCommerce checks the name against the names in the database and returns the customer to a prefilled form with a state name drop down menu replacing the previous text box. The default state is Alabama. If the customer fails to read the error message at the top of the screen and simply clicks "continue" without verifying their information, Alabama is instantly set as the chosen state. Had the customer actually read the error message they would have changed the state and been all set.

I wanted to change the default value in the state field to "Please Select a State" but I couldn't find any mods or add-ons that addressed only this issue in a simple fashion. So I made my own fix. This fix only modifies the "zones" table of the database and requires no modification of the OsCommerce code. It is working without a hitch in my store and my store has been modified so many times that I don't remember all of the mods I have in it.

The attached text file describes the process of modifying your "zones" table and includes a copy of my "zones" table with the modifications already made.

Legend:  Download   Report

Expand All / Collapse All

Code Correction monkster 3 Mar 2010  

You only need to run a single SQL query:

INSERT INTO `zones` VALUES (0,223, ' ', ' Please Select a State');

in order to solve this problem.

See package for details. Download original package for accurate description of problem.

Default State Changed to "Please Select a State" rkelley 9 Dec 2009