categories
5 rows where master_category = "Cafe"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17 | Coffee | addon | Cafe | visible | 2 | Organic Fair Trade Coffee from Colombia to Norway | Colombian coffee is renowned to be one of the best kind, world wide. Café Sarria is directly imported from Colombia and freshly ground in Sweden and Norway | <p style="text-align: left;">Café Sarria´s colombian coffee beans are directly imported from the farms in a region called "Cauca". The fresh beans are brought to Sweden and Norway, where a family owned production roasts and grinds the beans. It doesn`t get more authentic and fresh if you`d like to drink Colombian coffee in this part of the world. We serve only Café Sarria in our local café in Oslo, and love to recommend you to include a package of pure aroma to the next flower bouquet you might order.</p> | Café Sarria | 1 | 1 | 0 | 4 | 2026-02-04 09:44:15 | ||||
| 65 | Bonita Coffee | flower | Cafe | visible | 1 | Bonita Café & Flowers in Oslo - Your new favourite place | The newest edition of Bonita Flowers has now been transformed into a tropical themed café with organic colombian coffee, fresh cold pressed juices & smoothies. | <p style="text-align: left;">We have created the perfect fusion of a warm and colourful Café, serving fresh juices, smoothies, colombian coffee and a selection of delicious snacks and lunches whilst being surrounded by extraordinary fresh cut flowers and tropical plants. Basically you are escaping into a south american atmosphere in the middle of Oslo and enjoying the relaxed and fun vibe. Here are some of our delicious products that you can now order direclty online, and have delivered in a nice basket or together with some of the lovely flower arrangements we make.</p> | Bonita Café & Flowers | 1 | 1 | 0 | 26 | 2026-02-04 09:43:54 | ||||
| 68 | Gifts | addon | Cafe | visible | 1 | Gifts and hampers to order for every occasion | Sending flowers with an extra gift makes for an immensely beautiful and complete gesture one doesn´t receive every day. | <p>Making someones day with a bouquet of flowers is a beautiful gesture, but if you want to go a bit further and make it an even more memorable moment, you can create that extra amazement by adding your special gift. <br />We can make hampers in all sizes, with fresh fruit, goodies, savoury or sweet snacks, gourmet delights and even with wine.<br /><em>(We do not sell the wine ourselves, as there is a monopol for this in Norway. If you bring us a bottle, we can include it in your hamper.)</em><br /><br /></p> | Hampers & Goodies | 1 | 1 | 0 | 14 | 2026-02-04 09:44:42 | ||||
| 84 | Lunch Menu | addon | Cafe | visible | 0 | The nutritious, delicious and satisfying lunch menu | Bonita`s lunch menu includes delicious home made wraps, salads, sandwhiches and soups, all prepared in our little café - flower oasis. | <p>If you are concious of your diet, but enjoy food way too much to compromise your delicious lunches, you can visit Bonita´s café and indulge in the home made delights of the lunch menu, or even have your favourites delivered to your office on a busy day. Bonita`s wraps are filled with goodness, prepared from scratch, with original and tasty fillings. So are the special salads and freshly made sandwhiches with multi grain bread rolls and low calory fillings. </p> | Lunch Menu | 1 | 1 | 0 | 3 | 2026-02-04 09:45:27 | ||||
| 106 | Smoothies And Juices | addon | Cafe | visible | 0 | Smoothies and juices made of pure fruit and veggies | Bonita Cafe is known for some of the best smoothies and juices in town, with only fresh and natural ingredients, no juice from the box, nothing but pure fruit! | <p>Bonita`s Smoothies are all made of 100% natural ingredients, some of which are our freshly imported tropical fruits from Colombia. We do not add any sugar or juice from the box, it`s all pure fruit with either water or milk, depending on which juice.<br />You can be assured to only be tasting pure, natural, deliciousness and feel refreshed, revived and not least - healthy!</p> | Smoothies & Juices | 1 | 1 | 0 | 0 | 2026-02-04 09:46:19 |
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);