You can import several types of data using the Import Data from Other Sources dialog box:
You can import data from:
A tab- or comma-delimited text file
A table in a Microsoft Access database
Any other format (e.g. an Excel spreadsheet or FoxPro table) that can link to an Access database. For information on linking data in external tables to Access, please see your Access documentation.
Note: Depending on the type of data you are importing, you see different fields on the Import Data from Other Sources dialog box. Read the information after the Import Data section for help with the various options.
Go to the Main Menu>Maintenance Menu>Import/Export tab>Import Suppliers, Customers, Inventory or Costs & Prices button.
The Import Data from Other Sources dialog box opens:
Click the radio button for the type of data you wish to import.
Click in the Backup Data Before Importing checkbox to configure the program to make a backup copy of the table into which you are importing the data. If you encounter a problem while importing data, you can restore the backup copy of the table by clicking the Restore from Backup button.
Enter the path and file name of the MS Access database or text file from which you wish to import data or click the Browse button to select a file. The file must be a tab- or comma-delimited text file (.txt or .csv) or a Microsoft Access database (.mdb).
If you enter an Access database, the Database table to import from drop down list appears below the File to import from field. Select the table in the database that contains the data you wish to import from the drop down list.
If you enter a text file, you are prompted for more information about the file. Indicate whether or not the first row of data in the text file contains field names by clicking in the checkbox. If there are any tab characters in the text file, the program will pre-select the Tab option; if not, it will pre-select Comma. If your text file uses a different delimiter between fields, click on the drop-down list in the Other field to select it.
After you enter the path and file name of the file from which you wish to import data, a sample of the data in the file opens at the bottom of the screen.
The field names listed on the tabs (i.e. Standard Product Fields, Custom Text & Integer Fields, etc.) are the field names used in the table into which you are importing the data. Match those fields with the corresponding fields in the external file by clicking on the drop down lists.
Click Test Data to have the program look at your incoming data and tell you if it detects any obvious problems.
Click Begin Import to import your data.
The Import Suppliers function can add new suppliers, modify existing suppliers, or both. Click in the appropriate checkbox(es) to configure the program accordingly. The field names listed on the Standard Supplier Fields tab are the field names used in the Supplier table in the Order Manager, the table into which you are importing data. Match these fields with the corresponding fields in the external file by clicking on the drop down lists.
The Import Customers function only adds new customer records; it does not modify existing customer records.
Note: The Email field is required since email addresses must be unique. Phone, Web ID and [Last Name + Zip] are optional, however, these five fields are used to match customer information imported with new orders to existing customer records in your data file. Therefore, we suggest you map these fields to avoid the possibility of creating duplicate customer records in the future. You do not have to import data into any of the other fields if you do not wish to. Check all of the tabs (i.e. Standard Customer Fields, Custom Text & Integer Fields, etc.) for any other fields you may need to import.
If you are importing product data, select one of the following options if appropriate:
Start by deleting all existing Products - If checked, the Inventory table in your data file is emptied before your new data is imported. If not checked, products that do not already exist in your data file are appended to the Inventory table as new product records.
Create new products - If checked, products that do not already exist in your data file are added based on SKU. If not checked, existing product records are modified, but no new product records are added.
Modify existing products - If checked, the program replaces data in existing product records with data from the imported file for items with identical SKUs. If not checked, new product records may be added, but existing products are NOT modified.
Default Supplier - If you select a default supplier from the drop down list, new product records that do not contain a Supplier ID or Supplier Name are assigned to the default supplier you select.
Note: You must match fields for Local SKU and Item Name. You do not have to import data into any of the other fields if you do not wish to. Check all of the tabs (i.e. Standard Product Fields, Custom Text & Integer Fields, etc.) for any other fields you may need to import.
If you are importing cost, price, weight and/or supplier SKU data, select one of the following options if appropriate:
Select a default supplier from the drop down list to configure the program to assign new product records that do not contain a Supplier ID or Supplier Name to the default supplier you select.
Match Items On (select one): - Local SKU is the best choice because SKUs must be unique whereas you may have products that share the same name.
Match Suppliers On (select either or both, or use Default Supplier, above): - The Supplier IDs in the external file must be numeric and they must be the same Supplier IDs you use in the Order Manager.
Fields to Update - The field names listed under Fields to Update are the field names used in the table into which you are importing the data. Match these fields with the corresponding fields in the external file by clicking on the drop down lists.
See Also