products
7 rows where categories_raw = "Bonita Coffee" sorted by name descending
This data as json, CSV (advanced)
Suggested facets: updated_at, created_at (date), updated_at (date), deleted_at (date)
| id | name ▲ | colour | description | page_title | url_slug | categories_raw | language | created_at | updated_at | deleted_at |
|---|---|---|---|---|---|---|---|---|---|---|
| srk2x87bvn | Tropical Pineapple | Delicious and healthy snacking with dried Pineapples, no artificial flavourings ! Ideal to add in your gift basket | tropical-pineapple | Bonita Coffee | en | 2026-02-03 21:08:40 | 2026-02-03 21:08:40 | |||
| 4cno83jarg | Tropical Mango | Delicious and healthy snacking with dried Mangos, no artificial flavourings ! Ideal to add in your gift basket | tropical-mango | Bonita Coffee | en | 2026-02-03 21:08:40 | 2026-02-03 21:08:40 | |||
| u4bes9qrql | Taste of Nature - Cranberry | The ultimate wholesome, nutritious, gluten free snack bar packed with high fibre and delicious, healthy cranberries | taste-of-nature-cranberry | Bonita Coffee | en | 2026-02-03 21:08:40 | 2026-02-03 21:08:40 | |||
| t8xsghhbor | Taste of Nature - Almond bar | The ultimate wholesome, nutritious snack bar packed with high fibre and healthy carbs | taste-of-nature-almond-bar | Bonita Coffee | en | 2026-02-03 21:08:40 | 2026-02-03 21:08:40 | |||
| oj9ov4h2l1 | Naturales Honey Tea | NATURALES Propolis product, made of only natural ingredients with no artificials ! Comes with 4 flavours of herbal extract in raw honey. | naturales-honey-tea | Bonita Coffee | en | 2026-02-03 21:08:40 | 2026-02-03 21:08:40 | |||
| 73omm56ixo | Colombian Coffee | Colombian Fairtrade COFFEE BEANS - light | colombian-coffee | Bonita Coffee | en | 2026-02-03 21:08:40 | 2026-02-03 21:08:40 | |||
| 01i3hv6has | Berry Delight | Gluten , Wheat and Dairy free HEALTHY snacks. Ideal for a gift basket | berry-delight | Bonita Coffee | en | 2026-02-03 21:08:40 | 2026-07-06 14:20:26.215374 | 2026-07-06 14:20:26.215374 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE products (
id TEXT PRIMARY KEY,
name TEXT NOT NULL,
colour TEXT,
description TEXT,
page_title TEXT,
url_slug TEXT,
categories_raw TEXT, -- Original colon-separated categories from CSV
language TEXT, -- 'no', 'en', or NULL if unknown
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
, deleted_at TIMESTAMP);
CREATE INDEX idx_products_language ON products(language);
CREATE INDEX idx_products_name ON products(name);