rr_list_expiring_lots
Lists lots at risk of expiring unsold or already past their unusable date, ordered by earliest cutoff, showing remaining and at-risk units by product and location to guide markdowns or write-offs.
Instructions
List the lots across the whole catalog that are estimated to be left unsold when they become unusable (status at_risk), or that have already reached that date with units left (past_cutoff), earliest unusable date first, at Amazon FBA and at the seller's own locations. Each row names the product, the location, the lot code, the expiry and unusable dates, the units remaining and the units at risk. These are estimates: Amazon does not report which lot it sold, so the lots on hand are inferred from arrival order and projected against each product's sales rate. An empty list does not mean nothing will expire. summary counts, across the whole catalog whatever status asks for, what the list cannot show: positions_without_demand and units_without_demand (lots at a location with no sales rate to project), units_with_no_lot (stock with no lot on record), units_without_expiry_date (lots recorded with no expiry date), positions_at_disconnected_stores, positions_unreadable, and positions_arrival_overlap (Amazon locations whose next shipment must arrive before the stock there is nearly sold through to stay in stock, or is already late; each row carries its location's next_arrival with its ship_by dates), positions_ship_by_unknown (Amazon locations with an arrival date and no ship-by date, because the store's transit to Amazon is not known); products_with_expiring_stock is how many products marked as expiring have stock on hand at all. Cost fields are null unless the key may read cost data. For every lot of one product, including those on track to sell, use rr_get_product_expiry_risk.
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_list_expiring_lots"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Rows per page (default 100, max 500). | |
| cursor | No | next_cursor from the previous page. Pass it with the same other inputs until has_more is false. | |
| status | No | Only lots with this status. Omit for both. |