categories

Product categories with master category hierarchy

2 rows where status = "active"

✎ View and edit SQL

This data as json, CSV (advanced)

status 1

  • active · 2 ✖

type 0

master_category 0

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
34 Other Decoration     active   0               0 0 0 0  
49 Nasjonaldagen 17 mai     active   0               0 0 0 0  

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