get_on_hand_vs_pos
Compare current on-hand stock with point-of-sale sales for a SKU to identify replenishment needs and size orders.
Instructions
Current on-hand plus POS sales for a SKU at a store (category buyer view).
Returns inventory, last-24h POS (by default), delta = units_sold − available, and a product block (name, case_pack, supplier lead_time_days) for order sizing. If delta >= 6, call create_replenishment (prefer multiples of case_pack).
Args: store_id: Store identifier (e.g. 47 or 102). sku: Product SKU (e.g. 8847291 for Madeta butter 250g). reason: Why you are checking on-hand vs POS (required for audit). since: Optional ISO-8601 start of the POS window. If omitted, defaults to 24 hours ago (UTC).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sku | Yes | ||
| since | No | ||
| reason | Yes | ||
| store_id | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |