product_backend_data

Data scraped from admin backend (stock status, etc)

1 row where instock = 1 and product_id = "7fg5711ee4"

✎ 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
7fg5711ee4 1 0 0 0   A white and romantic pink bouquet with playful greenery naturally-white 0     0 0 0 0 0 {"siteid": "ccvxmy5xly", "id": "7fg5711ee4", "edit": "1", "name": "Classic Bridal bouquet", "newcategory": "Bridal Bouquets,Brudebuketter,Weddings", "saleprice": false, "special": "", "saleexpire": "", "price_one": "1200", "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": 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": "A white and romantic pink bouquet with playful greenery", "sad": false, "url": "naturally-white", "headingone": "Naturally White", "imagealt": "Naturally White", "enableai": false, "aititle": "Classic Bridal bouquet", "material": "", "videolink": "", "relatedproducts": "", "pid": "7fg5711ee4", "cat": "7fg5711ee4", "imagename": "", "product_category": "", "age_group": "", "weight": "", "length": "", "width": "", "height": "", "description": "<p>The composition of this lovely pure white and pink creation, is marked by its playful character of how the greenery is embedded in this clean and classic bouquet. It refreshes the whole look to enhance the youthful bride in her gorgeous appearance on a beautiful day. This design is suitable for summer or winter weddings, as the white roses can both stand for brightness and warmth, as well as ice and snow. </p>", "shortdesc": "", "recipe": "", "desc": "White roses, hortensias and greens, composed in a playful manner with a little creative twist for a youthful and modern bride.", "aidesc": ""} 2026-02-04 06:14:58

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