home / stock_adj

repack_pairs

1 row

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at (date)

id ▼ label source_sku source_name target_sku target_name ratio active created_at
1 น้ำยาปรับผ้านุ่ม 3800L to 370g MONGA Mono soft น้ำยาปรับผ้านุ่ม 3800 ml MONBO Mono soft น้ำยาปรับผ้านุ่ม 370 ml 10.0 0 2026-05-05 13:48:17

Advanced export

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

CSV options:

CREATE TABLE repack_pairs (
                id              INTEGER PRIMARY KEY AUTOINCREMENT,
                label           TEXT NOT NULL,
                source_sku      TEXT NOT NULL,
                source_name     TEXT NOT NULL,
                target_sku      TEXT NOT NULL,
                target_name     TEXT NOT NULL,
                ratio           REAL NOT NULL,   -- 1 source = ratio target
                active          INTEGER DEFAULT 1,
                created_at      TEXT DEFAULT (datetime('now','localtime'))
            );
Powered by Datasette · Queries took 18.703ms