product_backend_data

Data scraped from admin backend (stock status, etc)

1 row where instock = 0 and product_id = "amq0zfvlmz"

✎ 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
amq0zfvlmz 0 0 0 0   The mysterious deep purple rose decoration in a box forbidden-beauty 0     0 0 0 0 0 {"siteid": "ccvxmy5xly", "id": "amq0zfvlmz", "edit": "1", "name": "Forbidden Beauty", "newcategory": "Purple", "saleprice": false, "special": "", "saleexpire": "", "price_one": "990", "desc_one": "As Displayed", "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": "", "autostock": false, "emailnotify": false, "colour": "", "alcohol": false, "floral": false, "addon": false, "restricted": false, "showadvanced": false, "size": "", "sku": "", "pet": false, "hospital": false, "vase": false, "title": "The mysterious deep purple rose decoration in a box", "sad": false, "url": "forbidden-beauty", "headingone": "Forbidden Beauty", "imagealt": "Forbidden Beauty", "enableai": false, "aititle": "Forbidden Beauty", "material": "", "videolink": "", "relatedproducts": "", "pid": "amq0zfvlmz", "cat": "amq0zfvlmz", "imagename": "", "product_category": "", "age_group": "", "weight": "", "length": "", "width": "", "height": "", "description": "<p>This fantastic decoration is beautifully put together with some of our most precious deep purple roses, directly imported from Colombia. The variety is called \"Moody Blues\" and is outstanding among the many other rose varieties we bring. <br />It is one of the largest roses, with an enchanting scent once the pedals unfold. The decoration includes some refreshing white chrysanthemum and a pallet of violet carnations, alstroemerias and seasonal fillers. <br />We call it the forbidden beauty, because it is composed of an unusual mix of purple coloured floras, making this a unique and intensely beautiful decoration. <br />Suitable for those with strong characters, that love to stand out and try something different. </p>\n<p>The rose in a box decoration is our newest design, which proves to be very popular amongst our wide range … 2026-02-04 06:16:15

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