Inventory Import Field Reference
This reference lists every field available when importing inventory items, along with its requirements, accepted values, and the column header names that auto-map to each field.
Field List
| Field | Required | Type | Description |
|---|---|---|---|
| Item Name | Yes | Text | The name of the product or service. Must be non-empty. |
| SKU | No | Text | Stock keeping unit or product code. Used as the match key for updates. |
| Barcode | No | Text | UPC, EAN, ISBN, or other barcode value. |
| Category | Yes | Lookup | Must match an existing category name in AccuArk. Case-insensitive. |
| Class | No | Lookup | Must match an existing class name. Case-insensitive. |
| Price | No | Number | Selling price. Defaults to 0 if not provided. |
| Cost | No | Number | Purchase cost. Defaults to 0 if not provided. |
| Stock Quantity | No | Number | Starting stock at the selected location. Defaults to 0. |
| Description | No | Text | Detailed description of the item. |
| Model | No | Text | Model number or identifier. |
| Unit | No | Text | Unit of measure (e.g., "ea", "lb", "box", "kg"). Defaults to "ea". |
| Weight | No | Number | Item weight for shipping or reference. |
| Tax Type | No | Text | Tax type code: "l" for local tax, "n" for non-taxable. Defaults to "l". |
| Track Stock | No | Yes/No | Whether to track stock levels. Use "true" or "false". Defaults to "true". |
| Notes | No | Text | Internal notes about the item. |
Auto-Mapping Keywords
AccuArk recognizes the following column header names and automatically maps them:
| Field | Recognized Headers |
|---|---|
| Item Name | name, item name, product name, item, product |
| SKU | sku, item number, item code, product code |
| Barcode | barcode, upc, ean, isbn |
| Category | category, department, dept, group |
| Class | class, type, classification |
| Price | price, sell price, selling price, retail price, unit price |
| Cost | cost, unit cost, purchase price, buy price |
| Stock Quantity | stock, quantity, qty, on hand, stock quantity |
| Description | description, desc, details |
| Model | model, model number |
| Unit | unit, uom, unit of measure |
| Weight | weight, wt |
| Tax Type | tax, tax type, taxable |
| Track Stock | track stock, track inventory, tracked |
| Notes | notes, memo, comments |
Validation Rules
- Item Name must not be empty
- Category must match an existing category in AccuArk (case-insensitive)
- Class (if provided) must match an existing class (case-insensitive)
- Price and Cost must be valid numbers if provided
- Stock Quantity must be a valid number if provided (can be zero)
Match Key for Updates
The primary match key is SKU. If an item with the same SKU exists, the row updates that item. If no SKU is provided or no SKU match is found, AccuArk checks by Item Name. If no match is found by either field, a new item is created.
Example CSV
A minimal inventory CSV file looks like this:
name,sku,category,price,cost,stock
Widget Pro,WP-001,Electronics,29.99,15.00,50
Bolt Standard,BS-002,Hardware,4.99,2.50,200
Premium Service,PS-003,Services,99.00,0,0A more complete file might include all fields:
name,sku,barcode,category,class,price,cost,stock,description,model,unit,weight,tax_type,track_stock,notes
Widget Pro,WP-001,123456789012,Electronics,Premium,29.99,15.00,50,Professional widget,WP-2026,ea,0.5,l,true,Best seller