Appearance
Importing Item Tags
Item Tags is a join table that controls which tags are assigned to items. To import item tags, you must provide a CSV file containing the required information.
The available columns for this table are:
| Column | Description |
|---|---|
item_id | Optional. The database ID (UUID) of an existing item. |
item_code | Optional. The code of an existing item. Bridge Column. |
tag_id | Optional. The database ID (UUID) of an existing tag. |
tag_name | Optional. The name of an existing tag. Bridge Column. |
Item
An item is required for every item tag assignment.
You can specify the item using either:
item_iditem_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.
Tag
A tag is required for every item tag assignment.
You can specify the tag using either:
tag_idtag_name
If both columns are provided, tag_id takes precedence.
The tag_name 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
csv
item_id,item_code,tag_id,tag_name
550e8400-e29b-41d4-a716-446655440000,ITEM001,660e8400-e29b-41d4-a716-446655440000,FrozenUsing ID Columns
csv
item_id,tag_id
550e8400-e29b-41d4-a716-446655440000,660e8400-e29b-41d4-a716-446655440000Using Bridge Columns
csv
item_code,tag_name
ITEM001,Frozen