---id: catalogtype: conceptowner: justincomponent: storefront-apidescribes:  - src/catalog.ts  - migrations/0001_products.sqlreviewed: 2026-10-01---# CatalogThe catalog is the `products` table in D1 ([[0001-d1-for-shop-data]]). A product has a slug id, a name, a description, a price in whole cents ([[0003-money-in-whole-cents]]), a stock count and an optional image.## ReadingShoppers see only active products. `GET /products` lists them by name, then id, so the order is stable when two products share a name. `GET /products/:id` answers 404 for a product that is inactive, the same as for one that does not exist, so a retired product disappears from the shop without breaking old links into an error page.The list returns the first 100 active products. That covers the current catalog; a larger one needs paging.## WritingThe merchant writes products with `PUT /admin/products/:id` and the admin token. The call is an upsert: the same request creates the product or replaces its fields, which makes it safe to retry and easy to drive from a spreadsheet export. Validation lives in `parseProductInput`:- the id is a lowercase slug of at most 64 characters, because it appears in URLs and image keys;- `price_cents` is a whole number above zero;- `stock` is a whole number, zero or more (the table also has a `CHECK` for it);- `active` defaults to true.To retire a product, set `active: false`. Rows are never deleted, because cart items and orders refer to them.