Skip to main content

​
Overview

The Part Inventory importer creates new inventory or updates existing inventory from a single CSV. The distinction is row-by-row:
  • Rows without an id value create new inventory. part_number is required.
  • Rows with an id value update the matching inventory record. part_number and revision are ignored on update.
Creates run through the same path used by the UI, so aBOM creation, serial autogeneration, and tracking-type validation all apply. Updates run through the matching update path, so cascade behavior (location propagation, quantity validation, etc.) is preserved.

​
Columns

ColumnRequiredDescription
idNoInventory ID. Provide to update an existing record; omit (or leave blank for the row) to create new inventory. Lookup column — an empty cell is treated as “not provided,” not 0.
part_numberYes (for create)Part number for new inventory. Ignored on update.
revisionNoPart revision. Combined with part_number to look up the part; if omitted, the latest revision is used.
serial_numberNoSerial number.
lot_numberNoLot number.
quantityNoQuantity. Must be non-negative. Empty cells become 0.
quantity_scrappedNoScrapped quantity. Must be non-negative. Empty cells become 0.
locationNoLocation name. Must match an existing location in ION.
supplierNoSupplier name. Must match an existing supplier in ION.
unit_of_measureNoUnit of measure name. Must match an existing unit in ION.
intent_optionNoIntent option value. Must match a configured intent option.
autogenerate_serialNoWhen true on a create row, ION generates a serial number. Cannot be set on update rows. Boolean field (see accepted values).
autogenerate_lotNoWhen true on a create row, ION generates a lot number. Cannot be set on update rows. Boolean field (see accepted values).
Name-valued fields (location, supplier, unit_of_measure, intent_option) are resolved case-insensitively against existing records. An unrecognized name produces a row-level error.
autogenerate_serial and autogenerate_lot only apply on create rows. Setting either to true on a row that includes an id is rejected. Remove the id or the flag to fix the row.

​
Custom attributes

Any column not listed above is treated as a custom attribute on the part inventory. Custom attribute columns must match a configured attribute key for your organization; unknown columns cause a validation error. For general import behavior, empty cell handling, and error reporting, see Importers.