products

All products from the webshop

4 rows where categories_raw = "Bonita Coffee:Chocolates" sorted by name descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: description, created_at (date), updated_at (date)

language 1

categories_raw 1

  • Bonita Coffee:Chocolates · 4 ✖
id name ▲ colour description page_title url_slug categories_raw language created_at updated_at
e4nsr1dyd7 Sfinx Pralines       sfinx-pralines Bonita Coffee:Chocolates en 2026-02-03 21:08:40 2026-02-03 21:08:40
k8vfbml17l Ferrero Rocher       ferrero-rocher Bonita Coffee:Chocolates en 2026-02-03 21:08:40 2026-02-03 21:08:40
jxl0u7bzwb Belgian Chocolate Pralines   A box of some the finest belgian chocolate pralines, wrapped nicely as a present   belgian-chocolate-pralines Bonita Coffee:Chocolates en 2026-02-03 21:08:40 2026-02-03 21:08:40
630e6e4sff After Eight Chocolates       after-eight-chocolates Bonita Coffee:Chocolates en 2026-02-03 21:08:40 2026-02-03 21:08:40

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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
);
CREATE INDEX idx_products_language ON products(language);
CREATE INDEX idx_products_name ON products(name);