categories

Product categories with master category hierarchy

3 rows where master_category = "NoWeddings"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: scraped_at (date)

type 1

status 1

master_category 1

  • NoWeddings · 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
20 Knappehulsblomster occasion NoWeddings visible   1 Knappehulsblomster             1 1 0 8 2026-02-04 09:45:17
41 Brudepikene occasion NoWeddings visible   1 Brudepikene             1 1 0 36 2026-02-04 09:44:03
87 Brudebuketter occasion NoWeddings visible   1 Brudebuketter             1 1 0 45 2026-02-04 09:44:01

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