Importing Line Items

To import line items, you must provide a CSV file containing the required line item information.

The available columns for this table are:

Column	Description
quantity	Required. Numeric. Greater than 0 and less than 10,000,000.
price	Required. Numeric. Greater than 0 and less than 10,000,000.
cost	Required. Numeric. Greater than 0 and less than 10,000,000.
batch_number	Optional. Maximum 50 characters.
order_id	Optional. The database ID (UUID) of an existing order.
order_number	Optional. The order number of an existing order. Bridge Column.
item_id	Optional. The database ID (UUID) of an existing item.
item_code	Optional. The code of an existing item. Bridge Column.

Order

An order is required for every line item.

You can specify the order using either:

• order_id
• order_number

If both columns are provided, order_id takes precedence.

The order_number column acts as a bridge column, allowing you to import data without needing to know the database IDs generated by Quick Docket in advance.

Item

An item is required for every line item.

You can specify the item using either:

• item_id
• item_code

If both columns are provided, item_id takes precedence.

The item_code column acts as a bridge column, allowing you to import data without needing to know the database IDs generated by Quick Docket in advance.

Example CSV

All columns

quantity,price,cost,batch_number,order_id,order_number,item_id,item_code
10,12.50,8.00,SUMMER2026,550e8400-e29b-41d4-a716-446655440000,ORD001,660e8400-e29b-41d4-a716-446655440000,ITEM001

Required columns and bridge columns

quantity,price,cost,batch_number,order_number,item_code
10,12.50,8.00,SUMMER2026,ORD001,ITEM001