get https://example.com/api/v0/inventory-aging/details
This Inventory Aging API will provide prioritized inventory aging report data. Users can searchIn ProductId
, UPC
, PartNumber
Field | Contents |
---|---|
inventoryAgeLastUpdated | The date this inventory age report last updated. The aging data will refresh daily at 5 AM CST(US). The date is in UTC. |
totalAverageAge | Total average age of all the product inventories belonging to this brand. It is the weighted average, which is Sum(productAverageInventoryAge * productTotalRemainingQuantity)/ Sum(productTotalRemainingQuantity) of all the products |
totalRemainingQuantity | Sum of all the products' productTotalRemainingQuantity |
inventoryAgeDetails | A list of product inventory age details, including product identifiers, total remaining quantity, average inventory age and shipment inventory age details of this product |
productId | 6-digit product ID |
partNumber | Part number of this product |
upc | UPC of the product |
productAverageInventoryAge | The average inventory age of this product |
productTotalRemainingQuantity | Total remaining quantity of this product |
shipmentInventoryAgeDetails | A list of inventory details by shipment. One product id can have multiple shipments. |
shipmentId | Shipment ID. |
inventoriedDate | The date this shipment was inventoried into the warehouse. The date is in UTC. |
remainingQuantity | The product quantity remaining in this shipment |
age | Inventory age of products within this shipment |
Sample Data Response
{
"data": {
"inventoryAgeLastUpdated": "2025-07-08T10:00:09.372+00:00",
"totalAverageAge": 25,
"totalRemainingQuantity": 131,
"inventoryAgeDetails": [
{
"productId": 123456,
"partNumber": "12CP-GR-L",
"upc": "752010811111",
"productAverageInventoryAge": 25,
"productTotalRemainingQuantity": 131,
"shipmentInventoryAgeDetails": [
{
"shipmentId": 305407,
"inventoriedDate": "2025-06-13T13:09:40+00:00",
"remainingQuantity": 100,
"age": 25
},
{
"shipmentId": 305413,
"inventoriedDate": "2025-06-12T22:35:14+00:00",
"remainingQuantity": 31,
"age": 26
}
]
}
],
"pagination": {
"page": 1,
"totalPages": 1
}
},
"requestId": "0HNDU5OASGPJR:0000000E"
}