Articles

Contains data on Articles (products). Articles are structured hierarchically as:

• Article Group
  • Article Sub Group
    • Article

Storage Location

{customer_id}-article.json

Fields

Field	Type	Required	Description
id	string	Yes	Unique ID. Is integer but stored as string.
name	string	Yes	Article name.
customer_id	integer	Yes	Relationship to Customer owning the Article.
article_num	string	Yes	External reference number, PLU or similar.
group_id	integer	Yes	Identifier for Article Group.
group_name	string	Yes	Name of Article Group (denormalized).
sub_group_id	integer	Yes	Identifier for Article Sub Group.
sub_group_name	string	Yes	Name of Article Sub Group (denormalized).
display_name	string	No	Optional display name used on receipts etc.

Article Hierarchy

Articles are organized in a two-level hierarchy:

Article Group (e.g., "Boller")
└── Article Sub Group (e.g., "Bakst", "Boller")
    └── Article (e.g., "Kanelsnurr", "Croissant")

This hierarchy enables reporting and analytics at different levels of aggregation.

Example

{
  "id": "584734",
  "customer_id": 10352,
  "group_id": 44664,
  "group_name": "Boller",
  "sub_group_id": 79131,
  "sub_group_name": "Boller",
  "article_num": "1103",
  "name": "Kanelsnurr s"
}

Example - Article with Display Name

{
  "id": "644572",
  "customer_id": 10352,
  "group_id": 44664,
  "group_name": "Boller",
  "sub_group_id": 79131,
  "sub_group_name": "Boller",
  "article_num": "34353",
  "name": "Fastelavensbolle med solbær",
  "display_name": "Fastelavensbolle med solbær"
}

Example - Multiple Articles

[
  {
    "id": "584732",
    "customer_id": 10352,
    "group_id": 44664,
    "group_name": "Boller",
    "sub_group_id": 79131,
    "sub_group_name": "Boller",
    "article_num": "1101",
    "name": "Bringebærsnurr"
  },
  {
    "id": "584733",
    "customer_id": 10352,
    "group_id": 44664,
    "group_name": "Boller",
    "sub_group_id": 79131,
    "sub_group_name": "Boller",
    "article_num": "1102",
    "name": "Croissant"
  },
  {
    "id": "584758",
    "customer_id": 10352,
    "group_id": 44665,
    "group_name": "Drikke",
    "sub_group_id": 79140,
    "sub_group_name": "Kaffe",
    "article_num": "4202",
    "name": "Latte"
  }
]

Related Entities

• Customers - Parent customer/tenant
• Lines - Order lines reference articles via article_id
• ArticleWaste - Waste records reference articles
• ArticleDynamicStatuses - Article availability status