categories
5 rows where master_category = "NoFunerals"
This data as json, CSV (advanced)
Suggested facets: sort_order, product_count, scraped_at (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3 | Kranser | occasion | NoFunerals | visible | 1 | Kranser | 1 | 1 | 0 | 30 | 2026-02-04 09:45:23 | |||||||
| 47 | Hjerter | occasion | NoFunerals | visible | 1 | Hjerter | 1 | 1 | 0 | 10 | 2026-02-04 09:44:57 | |||||||
| 80 | Kondolanse buketter | occasion | NoFunerals | visible | 0 | Kondolanse buketter | 1 | 1 | 0 | 9 | 2026-02-04 09:45:21 | |||||||
| 85 | Baarebukett | occasion | NoFunerals | visible | 4 | BÃ¥rebukett | 1 | 1 | 0 | 11 | 2026-02-04 09:43:39 | |||||||
| 89 | Kistedekorasjon | occasion | NoFunerals | visible | 1 | Kistedekorasjon | 1 | 1 | 0 | 11 | 2026-02-04 09:45:15 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);