InventorySupply
Returns information about the availability of inventory that a seller has in Amazon's fulfillment network and in current inbound shipments. You can check the current availability status for your Fulfillment by Amazon inventory as well as discover when availability status changes.
Select
The 本製品 will use the Amazon Marketplace API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.
Note: Attributes 'GranularityType' and 'GranularityId' are required to query the view. You must set GranularityId to the MarketplaceId from the API matching your region.
- SellerSKU supports the '=', 'IN' comparisons.
- GranularityType supports the '='comparison.
- GranularityId supports the '=' comparison.
- MarketplaceId supports the '=' comparison.
- StartDateTime supports the '=', '<', '>', '<=', '>=' comparisons.
Following are example queries which are processed server side:
SELECT * FROM InventorySupply WHERE GranularityType = 'Marketplace' AND GranularityId = 'ATVPDKIKX0DER' AND SellerSKU = '123'
SELECT * FROM InventorySupply WHERE GranularityType = 'Marketplace' AND GranularityId = 'ATVPDKIKX0DER' AND StartDateTime > '2020-01-01'
Columns
| Name | Type | References | Description |
| UID [KEY] | String | Auto Generated Primary Key field. | |
| FNSKU | String | The Fulfillment Network SKU (FNSKU) of the item. The FNSKU is a unique identifier for each inventory item stored in an Amazon fulfillment center. | |
| SellerSKU | String | The Seller SKU of the item. Required if the QueryStartDateTime is not specified. | |
| ASIN | String | The Amazon Standard Identification Number (ASIN) of the item. | |
| Condition | String | The condition of the item. | |
| GranularityType | String | The granularity type for the inventory aggregation level. Acceptable value(s) are: 'Marketplace'. | |
| GranularityId | String | The granularity ID for the inventory aggregation level. | |
| TotalQuantity | Integer | The total number of units in an inbound shipment or in Amazon fulfillment centers. | |
| ProductName | String | The localized language product title of the item within the specific marketplace. | |
| LastUpdatedTime | String | The date and time that any quantity was last updated. | |
| FulfillableQuantity | Integer | The item quantity that can be picked, packed, and shipped. | |
| InboundWorkingQuantity | Integer | The item quantity that can be picked, packed, and shipped. | |
| InboundShippedQuantity | Integer | The item quantity that can be picked, packed, and shipped. | |
| InboundReceivingQuantity | Integer | The item quantity that can be picked, packed, and shipped. | |
| TotalReservedQuantity | Integer | The total number of units in Amazon's fulfillment network that are currently being picked, packed, and shipped. | |
| PendingCustomerOrderQuantity | Integer | The number of units reserved for customer orders. | |
| PendingTransshipmentQuantity | Integer | The number of units being transferred from one fulfillment center to another. | |
| FcProcessingQuantity | Integer | The number of units that have been sidelined at the fulfillment center for additional processing. | |
| TotalUnfulfillableQuantity | Integer | The total number of units in Amazon's fulfillment network in unsellable condition. | |
| CustomerDamagedQuantity | Integer | The number of units in customer damaged disposition. | |
| WarehouseDamagedQuantity | Integer | The number of units in warehouse damaged disposition. | |
| DistributorDamagedQuantity | Integer | The number of units in distributor damaged disposition. | |
| CarrierDamagedQuantity | Integer | The number of units in carrier damaged disposition. | |
| DefectiveQuantity | Integer | The number of units in defective disposition. | |
| ExpiredQuantity | Integer | The number of units in expired disposition. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| StartDateTime | Datetime | A start date and time in ISO8601 format. If specified, all inventory summaries that have changed since then are returned. You must specify a date and time that is no earlier than 18 months prior to the current date and time. | |
| MarketplaceId | String | The marketplace ID for the marketplace for which to return inventory summaries. |