product_backend_data

Data scraped from admin backend (stock status, etc)

1 row where instock = 0 and product_id = "8an09ir36u"

✎ 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
8an09ir36u 0 0 0 0   Violet Gold Flower decoration for Christmas violet-gold 0   0000-00-00 0 0 0 0 0 {"siteid": "ccvxmy5xly", "id": "8an09ir36u", "edit": "1", "name": "Violet Gold", "newcategory": "Christmas,Winter", "saleprice": false, "special": "", "saleexpire": "0000-00-00", "price_one": "380", "desc_one": "Small (As displayed)", "price_two": "550", "desc_two": "Medium", "price_three": "850", "desc_three": "Large", "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": "", "autostock": false, "emailnotify": false, "colour": "", "alcohol": false, "floral": false, "addon": false, "restricted": false, "showadvanced": false, "size": "", "sku": "", "pet": false, "hospital": false, "vase": false, "title": "Violet Gold Flower decoration for Christmas", "sad": false, "url": "violet-gold", "headingone": "Violet Gold", "imagealt": "Violet Gold", "enableai": false, "aititle": "Violet Gold", "material": "", "videolink": "", "relatedproducts": "", "pid": "8an09ir36u", "cat": "8an09ir36u", "imagename": "", "product_category": "", "age_group": "", "weight": "", "length": "", "width": "", "height": "", "description": "<p>The Violet Gold decoration is another one to add to our beautiful Christmas Candle Bloom collection. <br />We combine a chunky white candle here, with a dreamy decor of fresh flowers surrounding the candle. Even though we only use fresh flowers, you can be assured that this decoration will last you several weeks, to accompany the lovely ambience of a shimmery and shining candle during the cold and dark winter days. <br />We do like to mix it a bit but using less conventional colours, as you can probably find red and white flowers all over Oslo at this time of the year. <br />But why not go for some subtle pink and purple shades to combine with the wonderful \"Vendela\" Rose and some golden sparkly branches for that seasonal touch. <br />Who says you can´t create your own colour pallet, as long as you create an atmo… 2026-02-04 06:15:21

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