product_variants
6 rows where product_id = "q95gwlwmws"
This data as json, CSV (advanced)
| id ▼ | product_id | price | description | sort_order |
|---|---|---|---|---|
| 9676 | Red Love Joy bouquet q95gwlwmws | 419.0 | Small (ca 7 roses) | 1 |
| 9677 | Red Love Joy bouquet q95gwlwmws | 559.0 | Medium (ca 10 roses) | 2 |
| 9678 | Red Love Joy bouquet q95gwlwmws | 1019.0 | As Displayed (17 roses) | 3 |
| 9679 | Red Love Joy bouquet q95gwlwmws | 1185.0 | 20 Roses | 4 |
| 9680 | Red Love Joy bouquet q95gwlwmws | 1469.0 | Deluxe (ca 25 Roses) | 5 |
| 9681 | Red Love Joy bouquet q95gwlwmws | 1768.0 | Deluxe + (30 roses) | 6 |
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)
);