Import Postal Codes

Your Postal Code List

If you have a list of postal codes that you need to load into STX, you can import any comma-separated file (CSV) that contains suitable information. STX will add all of the postal codes that it can read. You may import postal codes even if you already have existing postal codes and they will not be duplicated.

 

Your file must have a header row that has an appropriate title (case sensitive) for each column. At a minimum, your file must contain the following 3 columns: postalCode, city and state. If your file has additional columns, title them as skip and they will be ignored

 

An Example of a Properly Formatted CSV File

Please note that this file contains the 3 required columns, has data in the postalCode, city and state columns. All column headers are spelled correctly, are case sensitive and include no spaces.

The postal code list you have to import may be in another format such as tab delimited text or Excel. You will need to reformat the data and save as a comma-separated text file (CSV) before attempting to import. Excel is the best application to add and/or edit column headers and perform any necessary cleaning up of your postal code data.

 

Importing Postal Codes into STX

1. In STX, go to Setup: General:  Postal Codes and click Import.
   
2. Navigate to and select the csv file you wish to import.
   
3. If the postal codes are processed without error, click Import. When this process is complete, your additional postal codes will appear in STX.
   

​If you require further assistance, please contact the STX Support team at 800.766.4778, or by emailing support@stxsoftware.com.

• Related Articles

• Import Clients

  Your Client List If you have a list of clients that you need to load into STX, you can import any comma-separated file (CSV) that contains suitable information. STX will add all of the clients that it can read. You may import clients even if you ...

• Import Products

  STX allows you to import products into the system. Once you have set up your Manufacturers, Product Lines and Product Groups, you can optionally set up your Suppliers as well. Supplier set up is only required if the products you intend to import ...

• Import/Export Data for Non-OLS Users

  The process of exporting and importing data is useful for updating the database to a newer version, which can improve performance and repair minor inconsistencies in the database. It is also used in preparation for changing server computers from a ...

• DESKTOP Export Client Email Addresses

  STX has the ability to export email addresses from the Client file. Once those addresses are exported, STX has nothing else to do with getting the addresses into the actual email you wish to send. Because there are so many different variables to ...

• General Setup

  Company Info Company Logo This logo will appear at the top of the first page of all reports. If you wish to use your own log, it must be an image of type bmp, gif, jpeg, png, ico, or tiff and should be approximately .67 inch x .67 inch square. You ...