Zip Code Data for the Store Locator

The Znode Storefront Store Locator and County Based Taxes (Enterprise Edition only) 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 it commercially.

Purchasing Data

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

http://www.zipcodedownload.com/Products/Product/Z5Commercial/Standard/Overview/

Once you receive your download file do the following:

1.	Backup your database.

2.	Unzip the download file to a convenient location on your server.

3.	Update the script below to have the full path to your unzipped data file and run the script.

4.	That's it! You can now set up store locations in the admin and start using the Store Locator.

Script to bulk-load store locator data into Znode Storefront

TRUNCATE TABLE ZNODEZIPCODE

BULK INSERT ZNODEZIPCODE FROM '<YOUR PATH TO ZIP CODE DATA FILE>\5-digit

Premiumdata.txt' WITH (FIELDTERMINATOR = ',')