Import ZIP Code Table

To use the Zip code lookup feature in the program, a system administrator must first import Zip code table entries in .csv format. The spreadsheet must contain the following header information in this order: ZIP code, city, state, country. In the State column, use the abbreviated form of the state’s name, for example, “SC” for “South Carolina”. For entries in the Country column, use the country’s name, not the abbreviation. For example, enter “United States” rather than “US”. Once you import Zip codes for a country, when you select the country on screens that contain address information, you can search for the code that matches the city and state entered.

1. From Administration, select Import Zip code table under Configuration. The Import Zip code table screen appears.

2. In the File field, select the folder to browse to the directory where you store the .csv file.

3. Select Save. You return to Administration. You can now use the Zip code lookup feature.