Skip to content

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:

ColumnDescription
item_idOptional. The database ID (UUID) of an existing item.
item_codeOptional. The code of an existing item. Bridge Column.
tag_idOptional. The database ID (UUID) of an existing tag.
tag_nameOptional. 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_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.

Tag

A tag is required for every item tag assignment.

You can specify the tag using either:

  • tag_id
  • tag_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,Frozen

Using ID Columns

csv
item_id,tag_id
550e8400-e29b-41d4-a716-446655440000,660e8400-e29b-41d4-a716-446655440000

Using Bridge Columns

csv
item_code,tag_name
ITEM001,Frozen