categories
3 rows where master_category = "Roses"
This data as json, CSV (advanced)
Suggested facets: sort_order, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 31 | Colombian Roses | flower | Roses | visible | 3 | Exclusive, long stemmed roses from Colombia | Long lasting colombian roses at Bonita Flowers, are directly imported from the farms in Bogotá to our shops in Oslo, Norway. | <p style="text-align: left;">We specialize in the renowned colombian roses, which are directly imported to Oslo while being kept in regulated temperatures throughout the whole journey by plane. This travel method ensures optimal quality and freshness for our customers in Oslo and guarantees a very long vase life.<br /><br /></p> <p style="text-align: center;"> </p> | Colombian Roses | 1 | 1 | 0 | 12 | 2026-02-04 09:44:18 | ||||
| 63 | Fresh Cut Flowers | flower | Roses | visible | 3 | Fresh Cut Flowers - Exploring all varieties | A lovely selection of fresh cut flowers, including different type of lilies, gerberas, chrysanthemum, dahlias and many more. | <p>The vast choice of fresh cut flowers can often be overwhelming. Here is a selection of the finest, for you to endulge in and get inspired and to assist you in making a satifying choice, while being sured that we only work with top quality fresh cut flowers imported directly from Colombia, Kenya and Holland for absolute freshness and increased durability.</p> | Fresh Cut Flowers | 1 | 1 | 0 | 24 | 2026-02-04 09:44:36 | ||||
| 90 | Roses | flower | Roses | visible | 1 | Bonita Blomster - Colombian Roses in Oslo | Long stemmed Roses directly imported from Colombia available at Bonita Flowers in Oslo - Direct home, same day Delivery service | <p>Bonita Blomster in Norway, is known for being the number one florist when it comes to roses in general but particularly known for long stemmed roses, imported all the way from Colombia by airplane. The raw product arrives straight to Bonita`s facilities in Oslo where all preparations are made by the local team, right before putting the roses out in the shops on display. The durability is oustanding and the strength and size of these roses is exceptional, not to mention the incredible assortment of varieties you can choose from.</p> | Roses | 1 | 1 | 0 | 9 | 2026-02-04 09:46:11 |
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);