product_backend_data

Data scraped from admin backend (stock status, etc)

1 row where product_id = "my3h4pzbgc"

✎ 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
my3h4pzbgc 0 0 0 0   A unique and exclusive floral design for our national day nations-bella-flor 0     0 0 0 0 0 {"siteid": "ccvxmy5xly", "id": "my3h4pzbgc", "edit": "1", "name": "Nations Bella Flor", "newcategory": "Corporate Solutions,Floral Arrangements,Norwegian National Day,White", "saleprice": false, "special": "", "saleexpire": "", "price_one": "995", "desc_one": "Onesize", "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": "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 unique and exclusive floral design for our national day", "sad": false, "url": "nations-bella-flor", "headingone": "National Day Flowers", "imagealt": "17.mai Flowers", "enableai": false, "aititle": "Nations Bella Flor", "material": "", "videolink": "", "relatedproducts": "", "pid": "my3h4pzbgc", "cat": "my3h4pzbgc", "imagename": "", "product_category": "", "age_group": "", "weight": "", "length": "", "width": "", "height": "", "description": "<p>17th of May marks a special day in Norwegian history. In Norway this day is celebrated with pride, joy, lots of champagne, ice cream and other goodies. The flowers play an important part in our festive decorations at work, home, school. You can scroll the city and enjoy wonderful seasonal flowers blooming in the strong and vibrant national colours. <br />This particular decoration is designed to minimalise its presence and focus on excellence and top quality of our special \"Mondial\" Roses directly imported from colombia. <br />They are extra large and have an outstanding durability. The \"rose in the box\" concept has won great popularity world wide and we are implementing this new trend to one of our favourite traditions on Norway´s national day. <br />… 2026-02-04 06:22: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)
);