categories

Product categories with master category hierarchy

10 rows where master_category = "NoSidebar"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: sort_order, description, seo_content, breadcrumb_trail, product_count, scraped_at (date)

type 2

status 1

master_category 1

  • NoSidebar · 10 ✖
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
24 Morsdag occasion NoSidebar visible   1 Morsdag             1 1 0 36 2026-07-06 10:55:51
37 Valentines occasion NoSidebar visible   1 Valentines             1 1 0 34 2026-07-06 10:57:07
40 Romanse occasion NoSidebar visible   1 Kjærlighet             1 1 0 23 2026-07-06 10:56:34
52 Bedrift occasion NoSidebar visible   0 Bedrift             1 1 0 6 2026-07-06 10:54:07
58 Jubileum occasion NoSidebar visible   0 Jubileum             1 1 0 11 2026-07-06 10:55:34
59 Bursdag occasion NoSidebar visible   0 Bursdag             1 1 0 2 2026-07-06 10:54:30
64 Jul occasion NoSidebar visible   0 Jul             1 1 0 37 2026-07-06 10:55:36
66 Dekorasjon flower NoSidebar visible   1 Dekorasjon, finn et vakkert utvalg av dekorasjoner Finn et vakkert utvalg av bord, eller store dekorasjoner i en kurv, pott eller en vase, for absolutt friskhet og god holdbarhet. <p>Oppsatt borddekorasjon til &aring; pynte huset</p> <p>Finn et vakkert alternativt og utvalg av borddekorasjoner i en kurv, eller en vase, for absolutt friskhet og god holdbarhet.</p>       1 1 0 18 2026-07-06 10:54:49
70 Kondolanse occasion NoSidebar visible   0 Kondolanse             1 1 0 11 2026-07-06 10:55:42
71 Nyfodt occasion NoSidebar visible   0 Nyfødt             1 1 0 1 2026-07-06 10:56: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);