product_variants

Price variants/sizes for each product

5 rows where product_id = "j5an542k5w"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ product_id price description sort_order
492 Juicy Joy j5an542k5w 569.0 Liten 10 roser 1
493 Juicy Joy j5an542k5w 889.0 Medium 15 roser 2
494 Juicy Joy j5an542k5w 1189.0 Large 20 roser 3
495 Juicy Joy j5an542k5w 1469.0 Large+ 25 roser 4
496 Juicy Joy j5an542k5w 1769.0 Som vist 30 roser 5

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE product_variants (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    product_id TEXT NOT NULL,
    price REAL,
    description TEXT,
    sort_order INTEGER,
    FOREIGN KEY (product_id) REFERENCES products(id),
    UNIQUE(product_id, sort_order)
);