Importing a Parts List

///Importing a Parts List
Importing a Parts List 2020-06-09T00:03:23+00:00

Info and Concepts

To facilitate the creation of parts in Aerotrack it is possible to import an existing parts list directly into the database from a spreadsheet. This feature requires that the user has access to the System Administration – Pricing Systems section. This process will upload an existing parts catalog and a secondary process can then import pricing data to be appended to the part number. The pricing upload can then be done multiple times as new price lists are released by the supplier.

 

Where

The parts upload can be access from the System > Company Details menu, under the Pricing tab.

Click on the Import Pricing Data button to access the uploading functions.Screen Shot 2016-02-22 at 12.25.23 PMScreen Shot 2016-05-11 at 9.15.31 AM

Walkthrough

  1. Before starting the import process you will need to have a spreadsheet of the parts formatted and ready to be loaded.
  2. The format requires twelve columns with the correct spelling and in the correct order. Even if there is no data to be loaded into the field the column heading must exist.
  3. The example below shows the format required for the parts upload.
  4. Click on the “Import Parts List” button to begin the process.
  5. The dialog will explain the process, click OK to continue.
  6. Navigate to the location of your saved spreadsheet, located the file and click “Select”.
  7. The table will display a list of the parts that where in the spreadsheet.
  8. Click “Create New Parts” to add all the new parts to the catalog.