product_backend_data

Data scraped from admin backend (stock status, etc)

1 row where product_id = "7qxitqs1gf"

✎ 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
7qxitqs1gf 0 0 0 0   Freedom & Calla bridal bouquet exclusive design freedom-calla 0     0 0 0 0 0 {"siteid": "ccvxmy5xly", "id": "7qxitqs1gf", "edit": "1", "name": "Freedom & Calla", "newcategory": "Bridal Bouquets,Weddings", "saleprice": false, "special": "", "saleexpire": "", "price_one": "950", "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": "Freedom & Calla bridal bouquet exclusive design", "sad": false, "url": "freedom-calla", "headingone": "Freedom & Calla", "imagealt": "Freedom & Calla", "enableai": false, "aititle": "Freedom & Calla", "material": "", "videolink": "", "relatedproducts": "", "pid": "7qxitqs1gf", "cat": "7qxitqs1gf", "imagename": "", "product_category": "", "age_group": "", "weight": "", "length": "", "width": "", "height": "", "description": "<p>This combination of deep red roses and slightly fading calla lillies, achieve an exclusive and original design made for the couragous, outstanding bride who likes to stride in style and glamour. The bouquet is slightly larger than a regular classic bridal bouquet and stands out beautifully in colour and character. Playful and unsual structures are created with the combination of these two very different florals but the perfection of this design results in absolute harmonious beauty to compliment a stunning bride.</p>", "shortdesc": "", "recipe": "", "desc": "Dark red roses with a soft touch of calla lillies and greens form a very exclusive design creation made for an outstanding bride.", "aidesc": ""} 2026-02-04 06:15:06

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