Knowledgebase
When the checkout loads the first state is selected by default. How can I force a customer to select a state.
Posted by - NA - on 04 January 2011 03:45 PM
To display an option that says "Select...", and require the customer to change this to a valid state before submitting the form use the the following SQL statement. This can be entered in your X-Cart admin -> Patch/Upgrade -> SQL Query(ies) section:

INSERT INTO xcart_states (stateid, state, code, country_code) VALUES ('', ' Select...', '', 'US');


This query will need to be executed for each country you ship to. Change 'US' to enter a different country. For example, UK:

INSERT INTO xcart_states (stateid, state, code, country_code) VALUES ('', ' Select...', '', 'UK');

Related Articles

* I'm receiving this error on the checkout page: "There was an error loading the shipping options, please try again. (You may need to refresh your browser.)"
* How do I find files that may have extra line breaks or whitespace after the ?> in a PHP file?
* The On Sale module discounts aren't applied when using Google Checkout or Gift certificates.
* How do I add the On Sale discounts to the Related or Upselling products on my main product display page?


Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: