| Name | Yes | Up to 120 characters | Stainless screw M6x20 |
| SKU | No | Up to 60 characters; must not match another item (case-insensitive). Used to find existing items; rows without a SKU are matched by name | HW-001 |
| Category | No | Up to 60 characters | Hardware |
| Unit | No | Up to 20 characters; defaults to piece when blank | box |
| Location | No | Up to 60 characters | A1-01 |
| Quantity | No | Whole number ≥ 0, blank means 0. Recorded as stock in for new items; for existing items only applied when “Also update stock” is ticked (recorded as a stocktake) | 50 |
| Minimum stock | No | Whole number ≥ 0; at or below this the item shows as low stock | 10 |
| Cost price | No | Number ≥ 0, ex GST, up to 4 decimals; $ and thousands separators allowed | 3.25 |
| Default sale price | No | Number ≥ 0, up to 2 decimals; $ and thousands separators allowed | 6.50 |
| GST-free | No | Y (or yes / 1) for GST-free items, otherwise blank | Y |
| Notes | No | Up to 500 characters | 100 per box |