product_variants
4 rows where product_id = "ddkrxeeubk"
This data as json, CSV (advanced)
| id ▼ | product_id | price | description | sort_order |
|---|---|---|---|---|
| 1078 | Sunset Centerpiece ddkrxeeubk | 550.0 | Medium | 1 |
| 1079 | Sunset Centerpiece ddkrxeeubk | 750.0 | As Displayed | 2 |
| 1080 | Sunset Centerpiece ddkrxeeubk | 950.0 | Large | 3 |
| 1081 | Sunset Centerpiece ddkrxeeubk | 1200.0 | Deluxe | 4 |
Advanced export
JSON shape: default, array, newline-delimited, object
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)
);