Item codes

A primary or alternate code (SKU, GTIN or other) that identifies a catalog item.

Fields

The API name is what the API, MCP and the CLI use.

NameAPI nameTypeRequiredDescription
IDidRecord IDYes
ItemproductitemIdReferenceYes
SchemeschemeConstantYesCode family: GTIN, internal SKU, legacy, or other scheme.
CodevalueTextYesScanned or entered value. GTIN values normalize to 14 digits in normalized.
PrimaryisPrimaryBooleanYesPrimary sku and gtin on the item are projection-maintained; alternates are authored here.
DatadataData
Created bycreatedByUser
Created atcreatedAtDate and TimeYes
Updated byupdatedByUser
Updated atupdatedAtDate and TimeYes
Blocked byblockedByUser
Blocked atblockedAtDate and Time
Archived byarchivedByUser
Archived atarchivedAtDate and Time

Relations

Owned records (solid line) are deleted with their owner. Grouped records (dashed line) can exist alone.

FieldPoints toKind
Item productitemIdProduct itemsgrouped by

Actions

What you can do with a record. Every action also sends the webhook event productitemcodes.<action>. Reads (find, get, count) work on every table.

NameAPI nameDescriptionWhere
CreatecreateAdd a new item code.App · WebMCP · API · MCP · CLI
EditupdateSave changes to this item code.App · WebMCP · API · MCP · CLI
BlockblockStop edits and deletion of this item code. It stays visible and can still appear on existing documents. Unblock to edit again.App · API · CLI
UnblockunblockAllow edits and deletion of this item code again.App · API · CLI
ArchivearchiveRetire this item code from daily use. It leaves active lists and pickers, and most actions stop. Unarchive to restore it.App · WebMCP · API · MCP · CLI
RestoreunarchiveReturn this item code to active lists and actions.App · WebMCP · API · MCP · CLI
DeletedeleteDelete this item code and the data that belongs with it. This cannot be undone.App · WebMCP · API · MCP · CLI