shop: categories: 2 rows where master

Product categories with master category hierarchy

2 rows where master_category = "Bouquets"

descending

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
30	Floral Arrangements	flower	Bouquets	visible		0	Floral decorations made for all type of occasions	The ideal gift solution for parties, corporate events, new borns and all those times one would like to impress effortlessly.	<p style="text-align: left;">We create flower decorations in pots, plates, baskets and all sorts. It`s a very practical gift solution, as you don`t need to worry about a vase. These kind of decorations are made fresh, set in an oasis foam base, to keep hydrated and alive to last at least a week. We can make them low to go on a table centerpiece, or tall for stage decorations or grand entraces. Have a look at some of our work for inspiration and feel free to contact us for customised solutions!</p> <p style="text-align: center;"> </p>			Floral Arrangements		1	1	0	20	2026-02-04 09:44:32
51	Bouquets	flower	Bouquets	visible		0	Bonita Flowers Fresh Bouquets for all Occasions	We specialize in creating fresh cut floral bouquets with seasonal products as well as our directly imported roses from Colombia.	<p style="text-align: left;"> While Bonita Flowers specializes in long stemmed, colombian roses that are long lasting and come in a large range of varieties, you can also find a beautiful selection of mix bouquets in this category. We work with seasonal local products, as well as tropical imported, fresh cut flowers and create unique compositions for all occasions.</p> <p style="text-align: center;"> </p>			Bonita`s Flower Bouquets		1	1	0	43	2026-02-04 09:43:56

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