product_backend_data

Data scraped from admin backend (stock status, etc)

1 row where product_id = "rjnjj5ad4p"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: scraped_at (date)

instock 1

  • 1 1
product_id ▼ instock inventory useinventory autostock sku title url_slug saleprice special saleexpire alcohol floral addon restricted vase raw_data scraped_at
rjnjj5ad4p 1 0 0 0   Clementine Tulipaner - en fantastisk minimalistisk bukett clementine-tulipaner 0   0000-00-00 0 0 0 0 0 {"siteid": "ccvxmy5xly", "id": "rjnjj5ad4p", "edit": "1", "name": "Clementine Tulipaner og ruskus", "newcategory": "Buketter,Oransj,Seasonal Product,Snittblomster", "saleprice": false, "special": "", "saleexpire": "0000-00-00", "price_one": "440", "desc_one": "(20stk + ruskus)", "price_two": "620", "desc_two": "(30stk+ ruskus)", "price_three": "860", "desc_three": "(40stk+ ruskus", "price_four": "", "desc_four": "", "price_five": "", "desc_five": "", "price_six": "", "desc_six": "", "price_seven": "", "desc_seven": "", "price_eight": "", "desc_eight": "", "instock": true, "subscribe": false, "useinventory": false, "inventory": "0", "autostock": false, "emailnotify": false, "colour": "", "alcohol": false, "floral": false, "addon": false, "restricted": false, "showadvanced": false, "size": "", "sku": "", "pet": false, "hospital": false, "vase": false, "title": "Clementine Tulipaner - en fantastisk minimalistisk bukett ", "sad": false, "url": "clementine-tulipaner", "headingone": "Clementine Tulipaner", "imagealt": "Clementine Tulipaner", "enableai": false, "aititle": "Clementine Tulipaner", "material": "", "videolink": "", "relatedproducts": "", "pid": "rjnjj5ad4p", "cat": "rjnjj5ad4p", "imagename": "", "product_category": "", "age_group": "", "weight": "", "length": "", "width": "", "height": "", "description": "<p><span style=\"font-weight: 400;\">Det som er helt fantastiske med disse tulipanene er de utrolig fine nyanser hver eneste blomst har! NÃ¥r disse Clementine Orange tulipaner blomstrer, er de forskjellige oransje nyanser synlige pÃ¥ tulipanens kronblad. Disse tulipanene vil lyse opp noen hjemme fordi hver blomst ser ut som solnedgangen. Det vil gi liv og glede til hjemmet til den som mottar disse tulipanene pÃ¥ dørstokken. Derfor letter Bonita Blomster for leveringstjenester i Oslo!</span></p>", "shortdesc": "", "recipe": "", "desc": "Denne fantastisk minimalistiske buketten med tulipaner er den perfekte og enkle gave eller dekorasjon til ditt eget hjem for Ã¥ lyse opp hver eneste dag", "aidesc": ""} 2026-02-04 06:24:33

Advanced export

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

CSV options: 

CREATE TABLE product_backend_data (
    product_id TEXT PRIMARY KEY,
    instock INTEGER,  -- 1 = in stock, 0 = out of stock
    inventory INTEGER,  -- Number of items available
    useinventory INTEGER,  -- Track inventory?
    autostock INTEGER,  -- Stop selling when out of stock?
    sku TEXT,
    title TEXT,  -- SEO title
    url_slug TEXT,  -- Backend URL slug
    saleprice INTEGER,  -- Is on sale?
    special TEXT,  -- Special/sale price
    saleexpire TEXT,  -- Sale expiry date
    alcohol INTEGER,
    floral INTEGER,
    addon INTEGER,
    restricted INTEGER,
    vase INTEGER,
    raw_data TEXT,  -- Full JSON of scraped data
    scraped_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (product_id) REFERENCES products(id)
);