Import a Price List

Go to Price List > Import PL > Find File:

Click to Enlarge


Select the file you wish to import.
Choose the database type of your file in the lower left corner of the "Open File for Import" box by clicking on the arrow under "List Files of Type."

Select the file name in the upper left corner. Note that dBase files usually use an extension of *.DBF, but they may also use other extensions. If you can't find your file right away, try changing the "File Name" box from *.dbf to *.* (Type in *.* and press the ENTER key.) This enables you to see all the files in a directory, not just the ones that end in .dbf or .mdb

Click once on the name of the file. Click once on [OK].

You have now selected the database to import and are ready to choose the fields you want to import. The fields in your existing price list can be easily aligned with QwikQuote fields by clicking once on the down arrows next to the fields you want to include such as Part Number, Manufacturer, Description, etc. Lining up Manufacturer fields in Import

The names of the fields in your original price list will appear. Click on the appropriate names for each field: for instance, if you want to include your "Mfr" field in QwikQuote's "Manufacturer" field, click on "Mfr" in the list of fields in the drop-down menu.

If you do not have a field that matches a QwikQuote field, select the first option in the list: "None."

The only required import field is Part Number since QwikQuote uses the unique part number to identify every product.

If you do not have part numbers, you must return to the program in which you created your original list, and add a unique number to each product.

Click to Enlarge


When you have chosen the fields you want to align, click once on (Import Records.) A blue progress bar will appear and reach 100% when all of the records are imported and all appropriate indices are created. A Pentium-based computer will take about 10 minutes to import 20,000 records the first time.

When the records are imported, the Import Box will close automatically and return to the Price List window.
Click to Enlarge