product_backend_data

Data scraped from admin backend (stock status, etc)

1 row where instock = 1 and product_id = "09a8kna9g8"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: scraped_at (date)

instock 1

product_id ▼ instock inventory useinventory autostock sku title url_slug saleprice special saleexpire alcohol floral addon restricted vase raw_data scraped_at
09a8kna9g8 1 0 0 0   50 eller Hundre langstilkede roser importert fra Colombia krem-hvite-roser 0   0000-00-00 0 0 0 0 0 {"siteid": "ccvxmy5xly", "id": "09a8kna9g8", "edit": "1", "name": "Krem Hvite Roser", "newcategory": "Buketter,Hvit,Jubileum,Kondolanse,Kondolanse buketter", "saleprice": false, "special": "", "saleexpire": "0000-00-00", "price_one": "2200", "desc_one": "As Displayed (50 stk)", "price_two": "4399", "desc_two": "As Displayed (100 stk)", "price_three": "", "desc_three": "", "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": "50 eller Hundre langstilkede roser importert fra Colombia", "sad": false, "url": "krem-hvite-roser", "headingone": "Cream White Roses", "imagealt": "", "enableai": false, "aititle": "Krem Hvite Roser", "material": "", "videolink": "", "relatedproducts": "", "pid": "09a8kna9g8", "cat": "09a8kna9g8", "imagename": "", "product_category": "", "age_group": "", "weight": "", "length": "", "width": "", "height": "", "description": "<p><span style=\"font-weight: 400;\">Hvis du ønsker Ã¥ lage et stort inntrykk, har du funnet din perfekte match i en verden av blomsterdekor.</span></p>\n<p><span style=\"font-weight: 400;\">Denne praktfulle dekorasjonen er en perfekt, klassisk rund bukett med en femti eller hundre roser. De er ikke bare hvilke som helst roser. Rosene vi bruker til denne absolutte bestselgeren, er ikke mindre enn prestisje, langvarig og langstilkede  colombianske rosesort kalt \"Vendela\". Den subtile og elegante «off white», kremfarget rose, ren eleganse og eksklusivitet.</span></p>\n<p><span style=\"font-weight: 400;\">Dette er ikke en bukett for enhver anledning, i og med at det vil være ganske vanskelig Ã¥ toppe den. Enkelheten er en av de største dyder,… 2026-02-04 06:11:53

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)
);