Show Country on Web

Interprise Suite Community

Home

Members

Calendar

Who's On

Welcome Guest ( Login | Register )

Show Country on Web

Rate Topic

Display Mode

Topic Options

Message

Posted 7/10/2009 12:16:10 AM

Post #198

Matthew White

As we turn Countries on to the web, we notice that the State field in the address is a drop down field and is trying to pull data from the Postal Code table. Has anyone had experience with adding States for Countries so the State field can work properly?

Matthew J. White
President
TechXor
Your Prescription For Success
11310 S. Orange Blossom Trail #207
Orlando, FL 32837
800-604-8027
matthew@techxor.com
www.TechXor.com

Posted 8/3/2009 9:08:13 PM

Post #233

valentim

We had a big issue with international orders related to states. E-commerce would force the selection of a state if any state for the selected country existed. Since (by default) not all states are populated for countries, we had customers who couldn't enter their correct address (they had to choose from one of the existing states). We went the opposite route and removed all international states from the postal code table. This allowed customers to bypass the state field altogether when entering international addresses.

Matthew Valenti
Aydus Consulting
www.aydus.com

Posted 8/3/2009 9:54:23 PM

Post #234

Matthew White

It seems there are only a handfull of countries that use states. So, for those countries, we added an entry into the Postal Code table for each state so they would show up in the drop down. Like you said, the countries with no states don't pose a problem.

I understand there is a Canada postal code setup dll in QA testing that will load all the Canada zip codes into the table.

Matthew J. White
President
TechXor
Your Prescription For Success
11310 S. Orange Blossom Trail #207
Orlando, FL 32837
800-604-8027
matthew@techxor.com
www.TechXor.com