Name: warehouse-product-description
Author: matthijs-neijenhuijs

Instruction file imported from matthijs-neijenhuijs/wms (.github/instructions/warehouse-product-description.instructions.md). Copyright stays with the author.

Products belong to a warehouse and are persisted in products.

Stock is persisted in stock_products with one row per product (unique(product_id)). Use the exact migration field names:

on_stock_quantity: physical stock currently present.
reserved_quantity: stock reserved for orders.
reserved_on_picklists: stock reserved while actively on picklists.
free_on_stock_quantity: available stock after reservation logic.

Product Constraints

Product uniqueness is warehouse-scoped:
- unique(warehouse_id, product_code)
- unique(warehouse_id, barcode)
- unique(warehouse_id, name)
Optional relations:
- vat_rate_id -> vat_rates.id
- brand_id -> brands.id

Implementation Notes

Always scope product and stock operations to warehouse_id.
Keep stock calculations deterministic and derived from order + picklist transitions.
Do not introduce alternative stock column names in code or prompts; use migration-aligned names only.

{ "ocm": "1", "id": "matthijs-neijenhuijs-wms-warehouse-product-description-i-f5bf2c", "kind": "skill", "name": "warehouse-product-description", "description": "Products belong to a warehouse and are persisted in `products`.", "publisher": "matthijs-neijenhuijs", "version": "1.0.0", "capabilities": { "domains": [ "general" ], "tags": [ "skill-md", "github-instructions" ], "languages": [ "en" ] }, "quality_prior": 0.6, "examples": [ "Products belong to a warehouse and are persisted in `products`." ], "primary": false, "metadata": { "source": { "provider": "github-instructions", "repository": "https://github.com/matthijs-neijenhuijs/wms", "path": ".github/instructions/warehouse-product-description.instructions.md", "ref": "7bee1a73a29dc30251b86379edc19014188fdef1", "url": "https://github.com/matthijs-neijenhuijs/wms/blob/7bee1a73a29dc30251b86379edc19014188fdef1/.github/instructions/warehouse-product-description.instructions.md", "key": "matthijs-neijenhuijs/wms/.github/instructions/warehouse-product-description.instructions.md" } }, "instructions": "Products belong to a warehouse and are persisted in `products`.\n\nStock is persisted in `stock_products` with one row per product (`unique(product_id)`). Use the exact migration field names:\n\n- `on_stock_quantity`: physical stock currently present.\n- `reserved_quantity`: stock reserved for orders.\n- `reserved_on_picklists`: stock reserved while actively on picklists.\n- `free_on_stock_quantity`: available stock after reservation logic.\n\n## Product Constraints\n- Product uniqueness is warehouse-scoped:\n\t- `unique(warehouse_id, product_code)`\n\t- `unique(warehouse_id, barcode)`\n\t- `unique(warehouse_", "cost": { "context_tokens": 243 } }

warehouse-product-description

About

Product Constraints

Implementation Notes

Use it

Manifest

Reviews