Applies to Znode Storefront v4.4+

The Znode Storefront Store Locator uses reference data for the zip code, city, state, and area code. Since this data contains over 42,000 entries and changes fairly regularly it is best to purchase this information commercially.

You can purchase data that is compatible with the Znode Storefront from a company called ZIPCode Download at

http://www.zipcodedownload.com/Products/Product/Z5Premium/Standard/Schema/

Once you receive your download file do the following:

1. Unzip the download file to a convenient location on your server.
2. Edit the script below substituting the path to your download file.
3. Run the script in SQL Server Management Studio.
4. Go to the Store Locator link in the Admin and enter your store data.
5. Thats it! Customers can now search for store locations using the Store Locator.

-- Script to bulk load reference data into the store locator.
TRUNCATE TABLE ZNODEZIPCODE

BULK INSERT ZNODEZIPCODE FROM '<YOUR PATH TO ZIP CODE DATA FILE>\5-digit
Premiumdata.txt' WITH (FIELDTERMINATOR = ',')