Skip to content

Inventory

Track stock levels for parts and materials, get low-stock warnings, and import a spreadsheet of items.

For office staffLast reviewed
On this pageAdd an item

Inventory tracks stock on hand for parts and materials, separately from the equipment and vehicle registers. Everyone can see what's in stock; the owner, admins, dispatchers, office and site supervisors manage it.

Add an item

  1. Open Inventory and select New item. The form opens in a side panel, which is a bottom sheet on a phone.
  2. Enter the Item name and, if you use one, a SKU.
  3. Enter the Qty on hand and a Unit, such as "m" or "ea".
  4. Set a Reorder threshold. ONYX1 flags the item as low stock once quantity on hand falls to or below it.
  5. Select Add item.

Import a spreadsheet

  1. Open Inventory and select Import CSV.
  2. Select Choose a file and pick a CSV with a name column. The columns ONYX1 reads are listed below; order doesn't matter, and other columns are ignored.
  3. Check the preview, which shows how many items are ready and the first 20 of them, and says how many rows were skipped if any were. Read the Check before importing list under it, if there is one.
  4. Select Confirm import. When it finishes, ONYX1 says how many items it imported and, if it skipped any, how many.

Items already in your stock, matched by SKU or otherwise by name, are skipped rather than duplicated or overwritten.

Columns ONYX1 reads

Each column can have any of the names listed. Capitals, spaces, hyphens and underscores don't matter, so Unit Cost and unit_cost both work.

  • Name (required): Name, Item, Product, Description or ItemName
  • SKU: SKU, Code, ItemCode, PartNo or PartNumber
  • Quantity on hand: Qty, Quantity, Stock, OnHand, QtyOnHand or QuantityOnHand
  • Reorder threshold: Reorder, ReorderThreshold, ReorderPoint, ReorderLevel, Threshold, Min or Minimum
  • Unit: Unit, UOM or Units
  • Cost: Cost, UnitCost, CostPrice, BuyPrice or PurchasesUnitPrice
  • Price: Price, Sell, SellPrice, UnitPrice, SalePrice or SalesUnitPrice

Check before importing

Under the preview, a Check before importing list shows anything in the file that won't import cleanly, with the spreadsheet row numbers. It can say that:

  • some columns are not imported, and names them
  • some rows have no name and will be skipped
  • some rows repeat a SKU or name from earlier in the file and will be skipped
  • some rows match stock items you already have (same SKU, or same name when there is no SKU) and will be skipped
  • the file has more than 5,000 rows, and only the first 5,000 will be imported; split the file and import the rest after

If the file has no name column, ONYX1 shows no preview and says it found no stock.

Nothing is imported until you select Confirm import. The iPhone and iPad app shows the same list in its import preview from its next update.

Low stock

The Low stock tile at the top of the Inventory page shows how many items are at or below their reorder threshold, and each of those items carries a Low stock label. Select an item to open it, change its threshold or top up its quantity on hand, and select Save item.

If something goes wrong

  • No stock yet. Add your stock items so the team can log parts on jobs. You can add them one at a time or import a CSV file.