product_backend_data

Data scraped from admin backend (stock status, etc)

1 row where instock = 1 and product_id = "uj08pco8fs"

✎ 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
uj08pco8fs 1 0 0 0   Silver Crown wreath decoration for funerals silver-crown 0     0 0 0 0 0 {"siteid": "ccvxmy5xly", "id": "uj08pco8fs", "edit": "1", "name": "Silver Crown", "newcategory": "Funerals,Kranser,Sympathy,Wreath Decoration", "saleprice": false, "special": "", "saleexpire": "", "price_one": "1500", "desc_one": "small", "price_two": "1800", "desc_two": "medium", "price_three": "2500", "desc_three": "large", "price_four": "3000", "desc_four": "Deluxe", "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": "Silver Crown wreath decoration for funerals ", "sad": false, "url": "silver-crown", "headingone": "Silver Crown", "imagealt": "Silver Crown", "enableai": false, "aititle": "Silver Crown", "material": "", "videolink": "", "relatedproducts": "", "pid": "uj08pco8fs", "cat": "uj08pco8fs", "imagename": "", "product_category": "", "age_group": "", "weight": "", "length": "", "width": "", "height": "", "description": "<p>This beautiful crown of elegance is a combination of orchid and roses with a touch of modern color features in an overall natural look</p>\n<p>The cream white colombian roses are surrounded by silver grey eucaluptus leaves and some very unique lime green orchids with dark burgundy center which is complimented by the same coloured supreme carnations to bring out this unique colour. </p>\n<p>This design is one of a kind and particularly suitable for the autumn or winter.</p>\n<p> </p>\n<p>Small: Base with approx. 25cm diameter </p>\n<p>Medium: Base with approx. 35cm diameter</p>\n<p>Deluxe: Base with approx. 45cm diameter</p>", "shortdesc": "", "recipe": "", "desc": "This beautiful crown of elegance is a combination of orchid and roses with a touch of modern color features in an overall nat… 2026-02-04 06:26:11

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