product_backend_data

Data scraped from admin backend (stock status, etc)

1 row where instock = 0 and product_id = "63ga623g65"

✎ 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
63ga623g65 0 0 0 0   Bonita Cafe and Flowers Gift card is the perfect present bonita-gift-card 0     0 0 0 0 0 {"siteid": "ccvxmy5xly", "id": "63ga623g65", "edit": "1", "name": "Bonita Gift Card ", "newcategory": "Birthday,Bonita Coffee,Christmas", "saleprice": false, "special": "", "saleexpire": "", "price_one": "300", "desc_one": "Small incl. Pralines", "price_two": "500", "desc_two": "Medium incl. Pralines", "price_three": "800", "desc_three": "Large inc. Pralines", "price_four": "1000", "desc_four": "Deluxe incl. Pralines", "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": "Bonita Cafe and Flowers Gift card is the perfect present", "sad": false, "url": "bonita-gift-card", "headingone": "Bonita Gift Card with Pralines", "imagealt": "Bonita Gift Card", "enableai": false, "aititle": "Bonita Gift Card ", "material": "", "videolink": "", "relatedproducts": "", "pid": "63ga623g65", "cat": "63ga623g65", "imagename": "", "product_category": "", "age_group": "", "weight": "", "length": "", "width": "", "height": "", "description": "<p><strong>IMPORTANT NOTICE:</strong><br /><strong>Please note, that due to technical limitations, we can not adjust delivery fees at the check out process, but given the nature of this product we acknowledge that the transport cost should be less as it doesn´t require a designated driver and can be sent through regular mail.</strong><br /><strong>We therefore include a box of exclusive Belgium pralines with the full value of the gift card, in order to make up for the delivery fees. The remaining amount will cover postage fees.<br />Thank you for your understanding!</strong></p>\n<p> </p>\n<p>With this fabulous solution you have just ticked a whole lot of boxes for this seasons ideal gift. <br />By giving… 2026-02-04 06:14:21

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