Stock lookup
get_stockLook up product stock levels by name, SKU, or category. Returns quantity, reorder level, shortfall, and 90-day sales, with the most critical stock first.
Instructions
Look up product stock levels.
Use for questions like "How many cordless drills do we have?", "Which products are below reorder level?" or "Show stock for Safety Equipment". Returns stock quantity, reorder level, shortfall and units sold in the last 90 days. Results are sorted with the most critical stock first (max 50 rows).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | No | Words to match in product name, SKU or category, e.g. 'drill 18V' or 'PT-0004'. Empty = all products. | |
| category | No | Exact category filter, e.g. 'Power Tools'. | |
| below_reorder_only | No | Only products whose stock is below their reorder level. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||