Import Inventory

1
Download a CSV template.
2
Upload your CSV file.
3
Identify CSV columns and add custom parameters.
4
Create Part Types, Manufacturers, and Units (as required).
5
Create parts.

Download CSV Template

Edit the template to include your part imports or adjust your own spreadsheet to match this template. Click to download

Things to Pay Attention to:

  • Part Number or both Manufacturer and Manufacturer P/N are required. If part number is provided, it takes precedence in all cases, even if a MPN match could be made.
  • Units must be an exact match for the unit name.
  • Location and Sublocation must be an exact match for the full name of the location / sublocation.
  • Vendor (if present) must be an exact match for the full name of the vendor.
  • Generate Asset ID should be true to generate the ID. All other values are treated as false.