Prism Administration Console Guide
Node Preferences > System - General
In Node Preferences > System > General, you can enable the lookup of customers (and vendors) by ZIP Code. When enabled, if an associate enters the ZIP Code on an address, the city and state will be filled in automatically. For example, when adding a new customer, if the associate enters the ZIP Code of 94630, then when the Associate moves the focus away from the ZIP field, the Address 3 field is automatically set to "Folsom, CA". You can map the City and State to the same field (in this case, Address 3) or to different fields.
To use ZIP Code look-up on customer and vendor records, two configuration steps are necessary:
- Enable the feature in preferences and specify which Address fields will be populated with the "City" and "State" data.
- Populate tables in the database with ZIP Code data using Technician's Toolkit.
Sample System - General preferences:

Populate the database with ZIP Code data
Populating the database with ZIP Code data takes one to two hours. Plan accordingly.
Before you can run the Data Utilities tool to populate the database with ZIP Code data, you need a database connection (not a REST connection). Add a new connection or edit an existing connection so that the Type field is set to "Database."
1. Log in to the Tech Toolkit.
2. Select Data Utilities > ZIP Code Injection. ZIP Code Injection will take between 1 and 2 hours depending on several factors. Once completed there is a message dialog indicating the data has been injected.
Postal Code Lookup at POS
Start a new customer (or vendor) record or edit an existing record. Customers and vendors can have multiple addresses. Add a new address or edit an existing address.
In the Postal Code field, enter a complete five-digit ZIP Code for the U.S. or seven-digit code for Canada. Navigate out of the Postal Code field. The City and State information is automatically entered in the field(s) specified in preferences. During address creation/edit, if the entered ZIP Code matches a specific City and State and then the user edits the City/State values to differ from the automatically populated values, the manually entered values take precedent. In some cases, a single postal code will match multiple locales. If that happens, a list of the matching results is displayed so the user can select the desired locale to use to populate the City and State info.
Overwriting ZIP Code Lookup with Manual Entry
During address creation/edit, if the entered ZIP Code matches a specific City and State and then the user edits the City/State values to differ from the automatically populated values, the manually entered values take precedent.