categories
6 rows where master_category = "Plants"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5 | Green Indoor | addon | Plants | visible | 2 | Green Indoor Plants for absolute freshness in your home | Select from our range of fresh indoor plants, to find the perfect addition to your interior design concept. May it be for office or home, you´ll find it here. | <p>No interior space is complete without the final touch of some green plants or flowers. Find your ideal plant here, amongst our selection of indoor plants for all kinds of environments and with special tips and instructions of seasonal favourites for optimal durability and great growing capacity in your home.</p> | Green Indoor | 1 | 1 | 0 | 11 | 2026-02-04 09:44:43 | ||||
| 7 | Hydrangeas | addon | Plants | visible | 7 | Bonita Blomster - Hydrangeas Plants and Fresh Cut Flowers | Hydrangeas, extra large flowers, available in many increibly unique colours come as seasonal plants or fresh cut flowers. | <p>The Hydrangea plants and flowers are unique in their existence, in some way very fragile, yet incredibly greatful, in the sense that you might think your plant has dried out and died, but if you just keep taking care of it with love, you will notice it revive instantly. <br />The amazing variety of colours available of this plan or cut flowers, is probably partly, what makes this flowers to popular. </p> | Hydrangeas | 1 | 1 | 0 | 3 | 2026-02-04 09:45:10 | ||||
| 36 | Plants | addon | Plants | visible | 1 | Bonita Blomster - A selection of plants for each season | A selection of indoor and outdoor plants of all sorts, suitable for all seasons throughout the year, and ideal to give your home some extra life. | <p>Bonita Blomster specializes in plants of all kinds, always offering a great selection of indoor as well as outdoor plants, according the season. You will find some great inspiration in their local shops, where all these plants are displayed in great style and taken care of with love and passion for the lovely creations that nature brings into our lives.</p> | Plants | 1 | 1 | 0 | 31 | 2026-02-04 09:45:54 | ||||
| 57 | Green Outdoor | addon | Plants | visible | 4 | Green Outdoor plants for each season of the year | Outdoor plants are an essential for our garden decoration and to make a propper entrance. Find the right plant fo the right season here at Bonita Flowers. | <p>Gardens, Terraces or Entrances are not the same without plants and flowers. Bonita Flowers will help you to adorn these, and even deliver, if needed. <br>Find your Favorite plants here or call us for special requests. We can get everything that is in season for you. Our story in Odinsgate has a large variety of outdoors plants, that will vary with the season</p> | Green Outdoor | 1 | 1 | 0 | 5 | 2026-02-04 09:44:45 | ||||
| 76 | Pots and Baskets | addon | Plants | visible | 7 | Pots and Baskets for your indoor and outdoor plants | A fine selection of pots and baskets in ceramic, stone, glass and willow to cover all needs and styles for your home or office interior. | <p>Find yourself the perfect pot or basket to complement your new indoor or outdoor plants. You can choose between different styles and materials to complement the rest of your interior design, in a stylish and seamsless way. Our selection is timeless and practical in order to provide you with the ideal solution.</p> | Pots & Baskets | 1 | 1 | 0 | 7 | 2026-02-04 09:45:56 | ||||
| 81 | Orchids | addon | Plants | visible | 5 | Phalaenopsis Orchids, the Oriental Beauty | Bonita Flowers offers only top quality orchids. Two stemmed beauties with extra large flowers and available in various colours. | <p>Orchids are one of those flowers that are popular amongst everyone, timeless and elegant - always in style. Bonita offers top quality varieties, available in several colours with two tall stems that carry lovelyl extra large flowers, which can last throughout the whole year. If the flowers fall after some time, the orchid will come back and revive, bringing new blossoms for you, so be patient and treat your plant with love and care.</p> | Orchids | 1 | 1 | 0 | 4 | 2026-02-04 09:45:44 |
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);