product_backend_data

Data scraped from admin backend (stock status, etc)

1 row where product_id = "woyikpkbrw"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: scraped_at (date)

instock 1

  • 0 1
product_id ▼ instock inventory useinventory autostock sku title url_slug saleprice special saleexpire alcohol floral addon restricted vase raw_data scraped_at
woyikpkbrw 0 0 0 0   Breezy violet and pink rose decoration for autumn autumn-violet 0     0 0 0 0 0 {"siteid": "ccvxmy5xly", "id": "woyikpkbrw", "edit": "1", "name": "Autumn Violet", "newcategory": "Autumn,Autumn Plants,Multicolor,Pink,Purple", "saleprice": false, "special": "", "saleexpire": "", "price_one": "590", "desc_one": "As Displayed", "price_two": "750", "desc_two": "Medium", "price_three": "950", "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": "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": "Breezy violet and pink rose decoration for autumn", "sad": false, "url": "autumn-violet", "headingone": "Autumn Violet", "imagealt": "Autumn Violet", "enableai": false, "aititle": "Autumn Violet", "material": "", "videolink": "", "relatedproducts": "", "pid": "woyikpkbrw", "cat": "woyikpkbrw", "imagename": "", "product_category": "", "age_group": "", "weight": "", "length": "", "width": "", "height": "", "description": "<p>This fantastic como is the new fresh style for autumn in 2018. It brings together some of our best rose varieties, directly imported from Colombia. We call them Moody Blues, Esperance and Pink Mondial, and the special twist to this design is featuring of cabbage like greens to reflect the post summer season, in which we start to embrace the breeze in the air and enjoy the subtle change of temperature as the cosy Halloween and pre Christmas phase approaches. <br /><br />The blue green eucalyptus details reseembles a certain coldness in the air, and a gentle touch of orange fillers underline the traditional autumn colours in an original way. </p>\n<p> </p>\n<p>Chose your ideal size, </p>\n<p>As displayed 590,- </p>\n<p>Medium (approx 35cm height and min. 15 roses) 750,-</p>\n<p>Large (a… 2026-02-04 06:27:19

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