ISQuote

In addition to importing customers, contacts, pricing updates & changes you can import competitive items. To import competitive items follow the Import Basics in listed here. Your import sheet will need to contain the following information: Your manufacturer, part number, competitive manufacturer (note: the competitive manufacturer must be entered into the competitive manufacturer module before importing.) competitive part and description. See sample below:

To begin select > Imports from the main menu
You will now be directed to the Add Import screen. Select > New

Add Import

Fill in the appropriate information.

Import Description Enter a description for this import such as "Widget New Items"

Import Type Select from the dropdown box the Import Type. "New Items"

Import File Name Enter the .xls full file name that has been saved into the ISQuote/Import folder

Import Sheet Name Enter the .xls sheet name. Defaults to sheet1 (This information is located at the bottom of your .xls sheet. See image below:)

Note: Importing is a two step process. You will first "Import" the data, second you will "Process" the data.
Importing brings the data into ISQuote but does not update and files.
Once you are ready to process the information you will "Process or Update" the file into ISQuote.
This is helpful when you have a pricing update. You may have obtained the price increase ahead of schedule and have the data ready to go on a particular date. Then you can return to ISQuote and simply Process/Update the imported file.
All import status can be viewed in the Imports table. To view select Imports from the main menu.

When finished entering the import information select > Save. You will now be directed to the Import screen.
Select the Manufacturer, Item Category and Item Type from the dropdown boxes.
Verify the Import File Name and Import Sheet Name.
Select Import/Data from the top of the screen.

Wait for the Import Date/Time field refreshes before proceeding. Do not click any other button until the screen refreshes.
The import step can take several minutes depending on the size of the spreadsheet.

After the spreadsheet is imported, review the import statistics at the bottom of the page. The total records imported should match the number of rows in your spreadsheet. If you are doing a item import and the imported record count is zero, there is probably a mismatch between the Import Mfg and the Mfg in the spreadsheet or there is numeric data in the Part Number column. Review the Import Detail for specific errors and warnings. If you have an error in the spreadsheet, you can fix the spreadsheet and Import again. You will not be able to import again after the update.

Once the import has finished click on Process/Update button to add or update records. Wait until the Update Date/Time field refreshes in the Date Updated field before proceeding. Do not click any other button until the screen refreshes. The update step can take several minutes depending on the number of items added or updated.

Once the update is complete and the date has refreshed you have completed the import process.