Importing Default Prices

To import default prices, you must provide a CSV file containing the required default price information.

The available columns for this table are:

Column	Description
price	Optional. Numeric. Must be greater than 0 and less than 10,000,000.
cost	Optional. Numeric. Must be greater than 0 and less than 10,000,000.
currency	Required. Must be a valid three-letter ISO 4217 currency code.
batch_number	Optional. Maximum 50 characters.
item_id	Optional. The database ID (UUID) of an existing item.
item_code	Optional. The code of an existing item. Bridge Column.

Price & Cost Validation Rules

At least one of the following values must be provided:

• price
• cost

If neither a price nor a cost is provided, the import will be rejected as invalid.

Item

An item is required for every default price.

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

price,cost,currency,batch_number,item_id,item_code
12.50,8.00,GBP,SUMMER2026,550e8400-e29b-41d4-a716-446655440000,ITEM001

Using required columns and item_id

price,currency,item_id
12.50,GBP,550e8400-e29b-41d4-a716-446655440000