categories

Product categories with master category hierarchy

5 rows where master_category = "NoSeasonal"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: scraped_at (date)

type 1

status 1

master_category 1

  • NoSeasonal · 5 ✖
id ▼ name type master_category status language sort_order title description seo_content breadcrumb_trail canonical heading menu_name date_limit next_day_only preorder product_count scraped_at
29 Sommer occasion NoSeasonal visible   0 Sommer             1 1 0 19 2026-02-04 09:46:23
46 Host occasion NoSeasonal visible   0 Host             1 1 0 31 2026-02-04 09:45:06
62 Sesongprodukt occasion NoSeasonal visible   0 Sesongprodukt             1 1 0 2 2026-02-04 09:46:17
72 Vinter occasion NoSeasonal visible   0 Vinter             1 1 0 28 2026-02-04 09:46:43
83 Var occasion NoSeasonal visible   0 VÃ¥r             1 1 0 29 2026-02-04 09:46:38

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE categories (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL UNIQUE,
    type TEXT,  -- 'flower', 'occasion', 'addon', 'color', etc.
    master_category TEXT,
    status TEXT DEFAULT 'active',
    language TEXT  -- 'no', 'en', or NULL if shared
, sort_order INTEGER DEFAULT 0, title TEXT, description TEXT, seo_content TEXT, breadcrumb_trail TEXT, canonical TEXT, heading TEXT, menu_name TEXT, date_limit INTEGER DEFAULT 0, next_day_only INTEGER DEFAULT 0, preorder INTEGER DEFAULT 0, product_count INTEGER DEFAULT 0, scraped_at TIMESTAMP);
CREATE INDEX idx_categories_name ON categories(name);