Parts information may be imported in bulk from a spreadsheet file.

Parts should be imported before attempting to import the associated inventory.

  1. Browse to the Parts listing by clicking Parts from the left side menu.
  2. Click Import Parts
  3. Follow the instructions on the Import Parts screen.

import parts

Sourcing information may be included in the bulk import, which will allow you to set a default price for the imported parts.

Data Fields

The following fields may appear in the spreadsheet in any order.

field description
Part Number the part number (required), e.g. CH48103-1
Title the part title (required), e.g. Oil Filter
Description a paragraph description of the part
Manufacturer the part manufacturer
Store the name of the vendor where the part may be purchased
URL a URL that shows more information about the part (usually on a store web site)
Weight the part weight (lbs)
List Price the part's default purchase price
List Price Currency the currency denomination for the list price, e.g. USD, CAD, AUD, GBP
Alternates alternate part numbers
BOM not used
Categories category tag for the part, usually aircraft system based e.g. airframe, engine, etc.
Events event tag for the part, usually maintenance event based e.g. 100hr, annual, oil change, etc.
Notes custom notes for the part
the following fields are related to the store (vendor) field and are accepted only during the creation of parts
Phone a phone number for the store specified by the store field
Street a street address associated with the store
City address associated with the store
State address associated with the store
Zip address associated with the store
Poc point of contact associated with the store
Vendor Part Number the store/vendor's specific part number

Viewing the Import Results

When an import job is active, browsing to the Import/Export page will automatically redirect to the Import Results view. Review the import results line by line to quality check the import.
import results

The import results remain in storage until they are manually cleared.

Resetting the Import Results

No further data may be imported until the import results are cleared, enabling a new import. If you are not already viewing the Import Results screen, browse to the Import Results page by clicking Inventory, Import/Export

Click the option Clear Results and Enable Another Import link to reset the import results and enable another import or export of the data.

clear results inventory import link

CAUTION: Using the Delete Imported Data and Enable Another Import option will delete the data objects that were imported during the import job. This is a handy feature when you need to retry a failed import. Do not select this option if you would like to retain the imported data but clear the import results history from the database.

This content is public.

More detailed content is available for registered users. Registration is FREE at FLY Online Tools.