/api/v0/inventory/items

Spreetail’s Inventory API returns full inventory data for the Seller Partner. All active Product ID’s are included, even when 0 inventory is available. Products are identified by their Part Number, the Product ID (the Spreetail generated SPIN), and the UPC.

A summation of the current inventory state is included, as well as a breakdown on a pre-FC Node basis.

FieldContents
totalOnHandThe total sum of the product inventory within the Spreetail Fulfillment Centers. This includes items that are pending transfer in fulfillment centers. This is calculated as: "totalOnHand" = "totalPending" + "totalAvailable" + "totalFCProcessing" + "totalPendingFCTransfer" + "totalFCQualityControl"
totalInNetworkThe total sum of the product inventory within the Spreetail Fulfillment Network. This includes items that are inTransit between fulfillment centers. tottalInNetork = totalOnHand + totalInTransit
totalOrdersPendingPlanningThe current count of products that is waiting to be assigned to a Spreetail Fulfillment Center network for processing as a result of a customer order.
totalPendingThe current count of the products from orders that is waiting to leave the Spreetail Fulfillment Center network as a result of a customer purchase.
totalAvailableTotal number of currently sellable pieces for the product. Calculated by the total of Available by Fulfillment Center location summed, minus the network level Orders Pending Planning.
totalInTransitThe total number of pieces that are currently in-transit between Spreetail fulfillment centers.
totalInboundInTransitThe count of item pieces from the advanced shipping notice that are in transit to the Fulfillment Center.
totalPendingFCTransferThe count of item pieces that are in picking and packing paths for fulfillment center transfer. These units are not considered available inventory. Depending on the internal stage of this process over encumbered orders may reduce this quantity.
totalFCProcessingThe count of item pieces that are in fulfillment processes that are removed from Available status but still can be added to available as sellable, this includes internal processes such as bin to bin transfers, bin audits, and more.
totalFCQualityControlThe count of item pieces that are in quality process control for fulfillment center investigation. These units are not considered available inventory.
totalReturnsInProcessThe count of item pieces that are in returns in receiving and grading process.
totalPendingReturnsThe count of item pieces that are in returns not yet received. Units in this bucket may or may not be returned by customers, returns not received are removed from this count after 120 days.
totalReturnDamagedThe count of item pieces that are in the Fulfillment Center marked as damaged in the customer returns process.
totalDamagedThe count of item pieces that are in the Fulfillment Center marked as damaged in receiving or warehouse process.
totalInboundConfirmedThe count of item pieces that are in the Fulfillment Center receiving (PO) process that have been confirmed received.
totalPendingReceivingThe count of item pieces from the Bill of Lading that are in the Fulfillment Center receiving (PO) process.
totalLowInventoryWarningIdentifies if a Fulfillment Center has a low inventory True flag, if all Fulfillment Centers are False, this flag is False.
locationInventoryDetailsContains the detail breakdown of pieces on-hand in a given fulfillment center.
locationInventoryDetails.locationNameThe short identifier code for the fulfillment center.
locationInventoryDetails.quantityOnHandThe number of pieces available at that location.
locationInventoryDetails.quantityPendingThe current count of the products from orders that is waiting to leave the Spreetail Fulfillment Center network as a result of a customer purchase.
locationInventoryDetails.quantityInboundInTransitThe count of item pieces from the advanced shipping notice that are in transit to the Fulfillment Center.
locationInventoryDetails.quantityPendingReceivingThe count of item pieces from the Bill of Lading that are in the Fulfillment Center receiving (PO) process.
locationInventoryDetails.quantityInboundConfirmedThe count of item pieces that are in the Fulfillment Center receiving (PO) process that have been confirmed received.
locationInventoryDetails.quantityInTransitThe total number of pieces that are currently in-transit between Spreetail fulfillment centers. This quantity displayed in this field is for the intended receiving fulfillment Center.
locationInventoryDetails.quantityPendingFCTransferThe count of item pieces that are in picking and packing paths for fulfillment center transfer. These units are not considered available inventory. Depending on the internal stage of this process over encumbered orders may reduce this quantity.
locationInventoryDetails.quantityPendingReturnsThe count of item pieces that are in returns not yet received. Units in this bucket may or may not be returned by customers, returns not received are removed from this count after 120 days.
locationInventoryDetails.quantityReturnDamagedThe count of item pieces that are in the Fulfillment Center marked as damaged in the customer returns process.
locationInventoryDetails.quantityReturnsInProcessThe count of item pieces that are in returns in receiving and grading process.
locationInventoryDetails.quantityFCProcessingThe count of item pieces that are in fulfillment processes that are removed from Available status but still can be added to available as sellable, this includes internal processes such as bin to bin transfers, bin audits, and more.
locationInventoryDetails.quantityFCQualityControlThe count of item pieces that are in quality process control for fulfillment center investigation. These units are not considered available inventory.
locationInventoryDetails.quantityDamagedThe count of item pieces that are in the Fulfillment Center marked as damaged in receiving or warehouse process.
locationInventoryDetails.quantityAvailableTotal number of currently sellable pieces for the product in a shippable location and state.
locationInventoryDetails.lowInventoryWarningIdentifies if a Fulfillment Center has a low inventory True flag, this is based on a minimum quantity and velocity calculation. This calculation Spreetail has created a algorithm that will improve over time.

Sample Data Response

{
  "partNumber": "PRODUCT-SKU",
  "productId": "123456",
  "upc": "123456789012",
  "isBundle": false,
  "totalOnHand": 895,
  "totalOrdersPendingPlanning": 2,
  "totalPending": 5,
  "totalAvailable": 828,
  "totalInNetwork": 995,
  "totalInTransit": 10,
  "totalInboundInTransit": 100,
  "totalPendingFCTransfer": 50,
  "totalFCQUalityControl": 0,
  "totalReturnsInProcess": 0,
  "totalPendingReturns": 0,
  "totalReturnDamaged": 0,
  "totalDamaged": 0,
  "totalInboundConfirmed": 0,
  "totalPendingReceiving": 0,
  "totalLowInventoryWarning": true,
  "totalPendingReceiving": 20,
  "locationInventoryDetails": [
		{
        "locationName": "FC-NAME1",
        "quantityOnHand": 400,
        "quantityPending": 3,
        "quantityInboundInTransit": 0,
        "quantityPendingReceiving": 0,
        "quantityInboundConfirmed": 0,
        "quantityInTransit": 0,
        "quantityPendingFCTransfer": 50,
        "quantityPendingReturns": 0,
        "quantityReturnDamaged": 0,
        "quantityReturnsInProcess": 0,
        "quantityFCProcessing": 0,
        "quantityFCQualityControl": 0,
        "quantityDamaged": 0,
        "quantityAvailable": 347,
        "lowInventoryWarning": False,
		},
		{
        "locationName": "FC-NAME2",
        "quantityOnHand": 400,
        "quantityPending": 2,
        "quantityInboundInTransit": 0,
        "quantityPendingReceiving": 0,
        "quantityInboundConfirmed": 0,
        "quantityInTransit": 0,
        "quantityPendingFCTransfer": 50,
        "quantityPendingReturns": 0,
        "quantityReturnDamaged": 0,
        "quantityReturnsInProcess": 0,
        "quantityFCProcessing": 0,
        "quantityFCQualityControl": 0,
        "quantityDamaged": 0,
        "quantityAvailable": 348,
        "lowInventoryWarning": False,
		},
		{
        "locationName": "FC-NAME3",
        "quantityOnHand": 95,
        "quantityPending": 0,
        "quantityInboundInTransit": 100,
        "quantityPendingReceiving": 0,
        "quantityInboundConfirmed": 0,
        "quantityInTransit": 10,
        "quantityPendingFCTransfer": 0,
        "quantityPendingReturns": 0,
        "quantityReturnDamaged": 0,
        "quantityReturnsInProcess": 0,
        "quantityFCProcessing": 0,
        "quantityFCQualityControl": 0,
        "quantityDamaged": 0,
        "quantityAvailable": 95,
        "lowInventoryWarning": true,
		}
	]
} 

Inventory count details are currently updated once every 5 minutes.

Obtaining Inventory Data for a Specific Product

With a combination of the searchIn and searchFor query parameters, it is possible to retrieve inventory data for a single product.

searchIn may contain one of the following:

  • productId
  • upc
  • partNumber

searchFor is the value used to filter the inventory results.

Language
Credentials
http
Click Try It! to start a request and see the response here!