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 contain a Supplier name.

To prepare STX for the product import, go to Setup: Products.

Make sure all appropriate product Groups are entered.

Make sure all appropriate Manufacturers and associated Product Lines are entered.

Make sure all appropriate Suppliers are entered.

The file you intend to import can be in either Comma-Separated-Values (CSV) or Tab-Delimited (TAB) formats.

​The first row of your file must contain Column Names of the values you intend to import. They can be in any order and must all appear, even if the fields underneath are left blank. The Column Names are as follows:

Again, all column names must appear on your file, however not all fields underneath the column names are required. There are 5 required column names where the fields must be filled in. The required column name fields are as follows:

• ManufacturerName
• ProductLine
• GroupName
• ProductName
• StockNumber (May contain a mix of alpha-numeric characters)

You may not leave any of the fields underneath these column names empty. 

IMPORTANT: Your file must not contain apostrophes, non-letter, or non-numerical characters. For example, L’Oreal must be entered as LOreal. Any field containing characters other than letters, spaces, or numbers will cause the import to fail.

To import your product file, go to Setup: Products, and click the Products tab.

Click the Import Products button.

Find your product file, and click Open.

If all of the column names and information were entered correctly on your product file, the import will proceed without error.

Once the products are imported, you can preview them in the Products list and make sure they appear as expected. 

If you wish to re-import the same list, close the Product Setup window without saving any changes and try again. Alternatively, you can make adjustments to the imported products and save.

• 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 Postal Codes

  Your Postal Code ListIf 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 ...

• 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 ...

• Employee Security (For Owners)

  As a business owner, setting up employee security can be a daunting task with so many options available. This document is intended to define each of the available security options so that you will know you’re assigning appropriate permissions to each ...

• Troubleshooting

  Additional Resources This Troubleshooting Guide is designed to help you solve many of the most common challenges encountered when using the STX desktop software.  STX uses ‘server’ files when accessing the database. If you have only a single ...