product_backend_data

Data scraped from admin backend (stock status, etc)

1 row where product_id = "lgqpp0lvui"

✎ 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
lgqpp0lvui 1 0 0 0   Ida amore, Pure elegance of bright colored flowers ida-amore 0     0 0 0 0 0 {"siteid": "ccvxmy5xly", "id": "lgqpp0lvui", "edit": "1", "name": "Ida Amore", "newcategory": "Homepage No,Homepage Specials,Orange,Oransj,Pink,Rosa,Sommer,Spring,Summer,Var", "saleprice": false, "special": "", "saleexpire": "", "price_one": "690", "desc_one": "Small (ca 7 pcs)", "price_two": "1215", "desc_two": "Medium ca 12 roses", "price_three": "2100", "desc_three": "As Display (ca 18 roses)", "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": "Ida amore, Pure elegance of bright colored flowers", "sad": false, "url": "ida-amore", "headingone": "Ida Amore", "imagealt": "Ida Amore", "enableai": false, "aititle": "Pure White Peony Decor", "material": "", "videolink": "", "relatedproducts": "", "pid": "lgqpp0lvui", "cat": "lgqpp0lvui", "imagename": "", "product_category": "", "age_group": "", "weight": "", "length": "", "width": "", "height": "", "description": "<p>PLEASE NOTE THAT THIS PRODUCT IS ONLY AVAILABLE FOR A SHORT PERIOD JUST BEFORE AND DURING THE SPRING AND <span style=\"color: inherit;\">SUMMER. (usually between April and August)</span></p>\n<p>Fresh and warm bouquet to brighten your living room.<br><br>You can select if you would like to order this bouquet with or without a clear glass vase. <br></p><p>Please be aware that we always aim to send the freshes of all cut flowers when preparing your orders. Therefore it could be that the flowers are not yet all open, at time of delivery. <br>They will open faster in warm temparatures (or normal room temperature). But by sending the newest stock, we can guarantee a longer vase life. </p>", "shortdesc": "", "recipe": "", "des… 2026-07-06 11:08:42

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