product_backend_data

Data scraped from admin backend (stock status, etc)

1 row where instock = 0 and product_id = "3gldjbd4mk"

✎ 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
3gldjbd4mk 0 0 0 0   Pink Sandy - Nydelige roserdekorasjon i boks pink-sandy 0   0000-00-00 0 0 0 0 0 {"siteid": "ccvxmy5xly", "id": "3gldjbd4mk", "edit": "1", "name": "Pink Sandy", "newcategory": "Pink", "saleprice": false, "special": "", "saleexpire": "0000-00-00", "price_one": "1200", "desc_one": "Som vist", "price_two": "", "desc_two": "", "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": false, "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": "Pink Sandy - Nydelige roserdekorasjon i boks", "sad": false, "url": "pink-sandy", "headingone": "Pink Sandy", "imagealt": "Pink Sandy", "enableai": false, "aititle": "Pink Sandy", "material": "", "videolink": "", "relatedproducts": "", "pid": "3gldjbd4mk", "cat": "3gldjbd4mk", "imagename": "", "product_category": "", "age_group": "", "weight": "", "length": "", "width": "", "height": "", "description": "<p><span style=\"font-weight: 400;\">Blomsterkasser er et originalt og langvarig gave alternativ! Denne moderne blomsterkassen har colombianske roser av beste kvalitet som lyser opp hjemme! Den delikate blandingen av kremede champagne hvite roser og den rustikke rosa med et hint av grønt gjør denne blomsterkassen til en absolutt klassiker for de fleste anledninger.</span></p>\n<p><span style=\"font-weight: 400;\">Pink Sand Flower Box kommer i grønn oase svamp som gjør pleien enda enklere! Bare tilsett litt vann nå og da!</span></p>", "shortdesc": "", "recipe": "", "desc": "Denne vakre dekorasjon av blomstere i eske er laget med langvarige rosa og kremhvite roser direkte importert fra Colombia", "aidesc": ""} 2026-02-04 06:13:12

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