rr_get_product_expiry_risk
Estimate expiry risk for one product: see each location's inferred lots, expiry dates, expected sell-through, and units or cost at risk. Use it to target markdowns and avoid write-offs.
Instructions
Expiry risk for one product marked as expiring: at each location holding it, the recorded lots estimated to be still on hand (lot code, expiry date, and the date the lot becomes unusable), whether each is expected to sell before that date, and the units and cost at risk. These are estimates: Amazon does not report which lot it sold, so the lots on hand are inferred from arrival order (oldest first at Amazon FBA, earliest expiry first at the seller's own locations) and projected against the product's sales rate. A lot becomes unusable a set number of days before it expires: Amazon's removal window at FBA, the product's days-to-consume elsewhere. A location with status no_demand has no sales rate to project, so its lots are not scored. At Amazon FBA each position also carries old_stock_bound (the most older stock that can still be there, from Amazon's own count) and next_arrival: when the next shipment should arrive so the stock there is nearly sold through and the product stays in stock (status window with earliest and latest dates), or, when both cannot hold, the latest date that keeps it in stock and the units likely still there then (overlap), or late. The latest date is never later than ReplenishRadar's stock-out forecast allows (past its 30 days it is continued at the current rate, and says so). A dated next_arrival carries ship_by: when the shipment must leave to arrive in time, the arrival dates less the store's transit to Amazon (learned from its own received shipments, or its FBA transit setting); passed with arrives_if_sent_today when that date has gone; status unknown when ReplenishRadar has no transit it can stand behind, never a guessed default. A product not marked as expiring returns requires_expiration false and no positions. Cost fields are null unless the key may read cost data. For the lots at risk across the whole catalog, use rr_list_expiring_lots.
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "rr_get_product_expiry_risk"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sku | No | The product's SKU, used when item_id is not given. | |
| item_id | No | The product's item id. Give this or sku; item_id wins if both are given. |