categories

Product categories with master category hierarchy

3 rows where master_category = "NoRoses"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: scraped_at (date)

type 1

status 1

master_category 1

  • NoRoses · 3 ✖
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
50 Colombianske Roser flower NoRoses visible   0 Colombianske Roser             1 1 0 12 2026-02-04 09:44:20
54 Snittblomster flower NoRoses visible   0 Snittblomster             1 1 0 27 2026-02-04 09:46:21
102 Afrikanske Roser flower NoRoses visible   0 Afrikanske Roser             1 1 0 0 2026-02-04 09:43:31

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);