product_backend_data

Data scraped from admin backend (stock status, etc)

1 row where product_id = "1w558kf6jn"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: scraped_at (date)

instock 1

  • 1 1
product_id ▼ instock inventory useinventory autostock sku title url_slug saleprice special saleexpire alcohol floral addon restricted vase raw_data scraped_at
1w558kf6jn 1 0 0 0   Colombias number one long stemmed rose variety esperance 0     0 0 0 0 0 {"siteid": "ccvxmy5xly", "id": "1w558kf6jn", "edit": "1", "name": "Esperance", "newcategory": "Colombian Roses,Colombianske Roser,Flerfarget,Multicolor,Pink,Rosa,Roses", "saleprice": false, "special": "", "saleexpire": "", "price_one": "45", "desc_one": "each ", "price_two": "450", "desc_two": "10 stems", "price_three": "670", "desc_three": "15 stems", "price_four": "880", "desc_four": "20 stems", "price_five": "1110", "desc_five": "25 stems", "price_six": "1330", "desc_six": "30 stems", "price_seven": "1770", "desc_seven": "40 stems", "price_eight": "2200", "desc_eight": "50 stems", "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": "Colombias number one long stemmed rose variety ", "sad": false, "url": "esperance", "headingone": "Esperance", "imagealt": "Esperance", "enableai": false, "aititle": "Esperance", "material": "", "videolink": "", "relatedproducts": "", "pid": "1w558kf6jn", "cat": "1w558kf6jn", "imagename": "", "product_category": "", "age_group": "", "weight": "", "length": "", "width": "", "height": "", "description": "<p> </p>\n<p>The \"Esperance\" rose has been one of our all time best sellers for more than 10 years. It is one of Colombias most renowned rose varieties and has been exported world wide in very large quantities due to its high deman across the countries. <br />We first introduced Norway to this exclusive product, when locals had never seen such gigantic roses before, and ever since, it has changed the market. <br />Not only does the Esperance rose amaze due to it´s size, but the durability is also oustanding and can hardly be compared to any other variety. <br /><br /></p>", "shortdesc": "", "recipe": "", "desc": "Light pink rose with a touch of green and white edges, is the secret of this naturally beautiful rose directly i… 2026-02-04 06:12:43

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