Importing Customer Prices

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

The available columns for this table are:

Column	Description
price	Required. Numeric. Must be greater than 0 and less than 10,000,000.
batch_number	Optional. Maximum 50 characters.
customer_id	Optional. The database ID (UUID) of an existing customer.
customer_code	Optional. The code of an existing customer. Bridge Column.
item_id	Optional. The database ID (UUID) of an existing item.
item_code	Optional. The code of an existing item. Bridge Column.

Customer

A customer is required for every customer price.

You can specify the customer using either:

• customer_id
• customer_code

If both columns are provided, customer_id takes precedence.

The customer_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.

Item

An item is required for every customer 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,batch_number,customer_id,customer_code,item_id,item_code
12.50,SUMMER2026,550e8400-e29b-41d4-a716-446655440000,CUST001,660e8400-e29b-41d4-a716-446655440000,ITEM001

Required columns and using database IDs

price,batch_number,customer_id,item_id
12.50,SUMMER2026,550e8400-e29b-41d4-a716-446655440000,660e8400-e29b-41d4-a716-446655440000

---

Required columns and bridge columns

price,batch_number,customer_code,item_code
12.50,SUMMER2026,CUST001,ITEM001