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
ID the database ID of an existing parts database record. Leave this field blank to create new parts records. This field is only used to update existing records and may be ommitted from the source spreadsheet when creating new records.
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
Vendor the name of the vendor where the part may be purchased
URL a URL that shows more information about the part (usually on a vendor 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, EUR, 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 vendor field and are accepted only during the creation of parts
Phone a phone number for the vendor specified by the vendor field
Street a street address associated with the vendor
City address associated with the vendor
State address associated with the vendor
Zip address associated with the vendor
Poc point of contact associated with the vendor
Vendor Part Number the vendor's specific part number
SKU custom stocking unit number
UOM Unit of measure, e.g. gal, ft
require_serial Enable the require serial number setting

Viewing the Import Results

After submitting the import job, the Import Results screen will become active.

See Import Results for more details.

Updating Existing Parts Records

The database ID field controls whether the import action will update an existing database record, or create a new one. Use the Export function to download a spreadsheet of existing parts data that contains the database ID field. The database ID may also be obtained by observing the URL of an inventory item for example: reveals a database ID of 10.

When updating, you may remove other columns that are not changing and include the ID and the column to update. This process is commonly used to update parts list prices as shown:

This content is public.

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