Data Import Wizard Instructions

Note: This topic may refer to data types not applicable to your Point of Sale installation. For example, Point of Sale Free users cannot import customer, vendor, or item quantity/cost information and Basic users cannot import item pictures.

Following is the basic procedure for using the wizard to import data. Select Help on each page of the wizard for additional information about the choices on that page.

(Basic, Pro) If in network mode, the Data Import option can be accessed from the File Utilities menu on the Server Workstation only.

The Data Import Wizard is displayed. Read the overview material and select Next.

Read the information about how the tool works and then select Open Import Template.
Enter information on the data worksheets included in the template (Vendors, Customers, and Inventory) as appropriate.

Clear any information left in the template from a previous import. Otherwise, you may create duplicates in Point of Sale and/or get error messages.
View the general instructions on the Instructions worksheet, and follow the specific instructions on each data worksheet to complete it (click here for additional tips about entering data). You do not need to use all three worksheets and only the data you actually enter into the template is imported (some fields are required as specified on the worksheets).
Don't leave blank rows and ensure you have entered values in the required fields (bright green).
Do not enter formulas in the fields; they will not work during the import.
Do not change the format of the field. For example, if a numeric field is changed to a text format, the import will fail.
You can close the Data Import Wizard while you work on your spreadsheet and return to the same page when ready to continue.

When done entering information, Save the template and close it. Do not change the template name.
Return to the Data Import Wizard, and select Next.
Select the options for how you wish the wizard to identify duplicate records and how you want to handle them and then select Next. Learn more.

The Wizard analyzes the import file and displays the status, including any errors found. Learn more.

Review the information on this window and the notes below for help in resolving errors before continuing.

If errors were found, click the link to view them in the Import Log. If the errors are serious you will want to cancel the import and go back and fix them in the import file. If they are not serious, you can continue at your discretion and make minor edits later in Point of Sale.
If you did not back up your company data before beginning, it is strongly recommended that you select the check box to do so now.

If ready to continue, have other workstations exit Point of Sale, and then select Import. Learn more.
After the import is complete, select Utilities View Data Import Log from the File menu,if you want to review the import information, including errors and records not imported.

Browse to the file containing the data you wish to import and select it. If importing from a text file, the file must have a .csv extension.
Select which sheet contains the data to import (Excel format only) and which row on the sheet contains the first line of data to import (Excel or .csv format, do not include any heading rows.).
Choose a file mapping to use or select Add New and specify how the Data Import Wizard is to import your data. Learn more. When done defining mappings, select Next to continue.
Select the options for how you wish the wizard to identify duplicate records and how you want to handle them and then select Next. Learn more.

The Wizard analyzes the import file and displays the status, including any errors found. Learn more.

Review the information on this window and the notes below for help in resolving errors before continuing.

If errors were found, click the link to view them in the Import Log. If the errors are serious you will want to cancel the import and go back and fix them in the import file. If they are not serious, you can continue at your discretion and make minor edits later in Point of Sale.
If you did not back up your company data before beginning, it is strongly recommended that you select the check box to do so now.

If ready to continue, have other workstations exit Point of Sale, and then select Import. Learn more.
After the import is complete, select Utilities View Data Import Log from the File menu,if you want to review the import information, including errors and records not imported.