Quick Order Entry

Importing products

Our import program uses a CSV file to import products into your shopping cart or saved shopping lists.

Please configure your spreadsheet (CSV import file) to contain *2 columns, where:

• Column #1 = Item Number (SKU) or Cross Reference Code
• Column #2 = Quantity to order (optional) (if quantity is not a number or left blank, a qty of 1 will be used)
• Column #3 = Location (optional/reference field)
• Column #4 = Minimum Quantity (optional/reference field)
• Column #5 = Maximum Quantity (optional/reference field)

* Extra columns or invalid lines will be ignored. Columns 3-5 are optional reference fields and may not be set to appear when viewing the cart.

Columns should be separated by commas, and (optionally) quoted by the " character.

What is a CSV file?

A CSV file is a way to collect the data from any table so that it can be conveyed as input to another table-oriented application such as a relational database application.

How to create a CSV file

Most spreadsheet programs, such as Microsoft Excel, can be used to save a worksheet as a CSV file, simply by choosing to save as type "CSV".

EXAMPLE: