Importing Quantity Discounts and Kits

Import Quantity Discounts

• Several types of data can be imported through the Import Data screen.
• Data can be imported from:

1. 1. A tab or comma-delimited text file.
   2. A table in a Microsoft Access database.
   3. Any other format (e.g., an Excel spreadsheet or FoxPro table) can link to an Access database. For information on linking data in external tables to Access, please see MS Access documentation.

• When importing data from a text file, if the data contains commas, the file should be saved as a tab-delimited file, not a CSV.
• Quotes should not be present in text files, regardless of whether it is a CSV or tab-delimited file, or you will encounter errors.
• To access this screen go to one of the following:

1. Main Menu
2. Manage My Inventory -> Import My Inventory – File
3. Click “Quantity Discounts” from top-bar

Options

• Create a new Quantity Discount -> Create an additional SKU to reference a product.
• Modify existing Quantity Discount ->

Required Fields

• Local SKU
• PriceLevel
• Starting Quantity
• Ending Quantity
• Price

Import Kits

1. Main Menu
2. Manage My Inventory -> Import My Inventory – File
3. Click “Kits” from top-bar

Options

• Create new Kits -> Create kits from items not previously set as a kit
• Modify existing Kits -> Add items to existing kits

Required Fields

• Kit SKU
• Part SKU
• Quantity