management: produce catalog v2 — inventory columns, form fields, deploy triggers #35

New issue

Closed

opened 2026-08-24 08:27:40 +00:00 by yuris · 0 comments

yuris commented

2026-08-24 08:27:40 +00:00

Owner

Teach apps/management to produce catalog v2. Add brand, partNumber, category, weightGrams, shippable (default true), and installService to the inventory table with a generated, committed migration (all nullable or defaulted, so safe on existing rows). Extend getPublicCatalog to select and map the new fields, deriving price from sellPrice (0 → null, the established convention in the bot stock tools) and inStock from stock > 0, while keeping buyPrice, avgCost, suppliers, and the raw stock number out of the payload. Add sellPrice, stock, and the six new columns to STOREFRONT_COLUMNS — price and availability are public now, so stock-decrementing orders trigger a store rebuild, which the workflow's cancel-in-progress concurrency group collapses. Carry the fields through validators, inventory actions, MCP tools, queries, types, and the stok UI (add modal, edit form, details sheet, plus a category table column only), and update the demo seed.

Acceptance: pnpm --filter garage test and pnpm --filter garage lint pass, with affectsStorefront rebuilding on sellPrice/stock and still not on buyPrice/avgCost; the public catalog endpoint returns schemaVersion: 2 with every new field and no cost or stock-count leakage.

Teach `apps/management` to produce catalog v2. Add `brand`, `partNumber`, `category`, `weightGrams`, `shippable` (default true), and `installService` to the `inventory` table with a generated, committed migration (all nullable or defaulted, so safe on existing rows). Extend `getPublicCatalog` to select and map the new fields, deriving `price` from `sellPrice` (`0` → `null`, the established convention in the bot stock tools) and `inStock` from `stock > 0`, while keeping `buyPrice`, `avgCost`, suppliers, and the raw stock number out of the payload. Add `sellPrice`, `stock`, and the six new columns to `STOREFRONT_COLUMNS` — price and availability are public now, so stock-decrementing orders trigger a store rebuild, which the workflow's `cancel-in-progress` concurrency group collapses. Carry the fields through validators, inventory actions, MCP tools, queries, types, and the stok UI (add modal, edit form, details sheet, plus a `category` table column only), and update the demo seed. Acceptance: `pnpm --filter garage test` and `pnpm --filter garage lint` pass, with `affectsStorefront` rebuilding on `sellPrice`/`stock` and still not on `buyPrice`/`avgCost`; the public catalog endpoint returns `schemaVersion: 2` with every new field and no cost or stock-count leakage.

yuris closed this issue

2026-08-24 10:14:35 +00:00

yuris referenced this issue from a commit

2026-08-24 10:34:16 +00:00

feat(management): produce catalog v2 — inventory columns, form fields, deploy triggers (#35)

yuris referenced this issue

2026-08-24 10:34:37 +00:00

feat(store): overhaul into a shop that can also install — design tokens, catalog v2, cart with WhatsApp checkout #39