Importing Order Users

Order Users is a join table that controls which users are assigned to orders.

To import order users, you must provide a CSV file containing the required information.

The available columns for this table are:

Column	Description
order_id	Optional. The database ID (UUID) of an existing order.
order_number	Optional. The order number of an existing order. Bridge Column.
user_id	Optional. The database ID (UUID) of an existing user.
user_email	Optional. The email address of an existing user. Bridge Column.

Order

An order is required for every order user assignment.

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.

User

A user is required for every order user assignment.

You can specify the user using either:

• user_id
• user_email

If both columns are provided, user_id takes precedence.

The user_email 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

order_id,order_number,user_id,user_email
550e8400-e29b-41d4-a716-446655440000,ORD001,660e8400-e29b-41d4-a716-446655440000,sales@example.com

Using database IDs

order_id,user_id
550e8400-e29b-41d4-a716-446655440000,660e8400-e29b-41d4-a716-446655440000

Using bridge columns

order_number,user_email
ORD001,sales@example.com