product_backend_data

Data scraped from admin backend (stock status, etc)

1 row where product_id = "wswf55li4z"

✎ 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
wswf55li4z 0 0 0 0   Elven Forest Florals for the annual Christmas present elven-forest-florals 0   0000-00-00 0 0 0 0 0 {"siteid": "ccvxmy5xly", "id": "wswf55li4z", "edit": "1", "name": "Elven Forest Florals", "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": "Elven Forest Florals for the annual Christmas present", "sad": false, "url": "elven-forest-florals", "headingone": "Elven Forest Florals", "imagealt": "Elven Forest Florals", "enableai": false, "aititle": "Elven Forest Florals", "material": "", "videolink": "", "relatedproducts": "", "pid": "wswf55li4z", "cat": "wswf55li4z", "imagename": "", "product_category": "", "age_group": "", "weight": "", "length": "", "width": "", "height": "", "description": "<p>Our Elven forest design contains some beautiful shades of purple, greens and berry blues amidst the classic and refreshing white Mondial rose to brighten it up a bit. The silver Christmas bauble adds the special spark to this decoration which is otherwise inspired but a magical forrest theme. <br />The winter months in Norway, Oslo, are dark and cold, so we like to mix it up a bit with some less traditional ideas, to offer alternatives to the usual reds and white. This floral basket contains nothing but fresh flowers, sourced directly from the market and colombian rose farms. <br />The durabilty of these flowers is exceptional, which makes it even more joyous to gift one of these beauties. You get to accompany your lucky friends and family through a stunning an… 2026-02-04 06:27:23

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