ListingsItemsOffers
Returns details about a listings item offers for a selling partner.
The following filters are required:
- SKU
- SellerId: You can either specify SellerId as a pseudo-column condition in WHERE filters, or in the connection string.
SELECT * FROM ListingsItemsOffers WHERE SKU = '12345' AND SellerId = 'XXXXXXXXXXXXXX'
Columns
| Name | Type | References | Description |
| SKU | String | A selling partner provided identifier for an Amazon listing | |
| MarketplaceId | String | A marketplace identifier. Identifies the Amazon marketplace for the listings item. | |
| OfferType | String | Type of offer for the listings item.
使用できる値は次のとおりです。B2B, B2C | |
| PriceAmount | String | Purchase price amount of the listings item. | |
| PriceCurrency | String | Purchase price currency of the listings item. | |
| Points | String | The number of Amazon Points offered with the purchase of an item, and their monetary value. Note that the Points element is only returned in Japan (JP). |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| SellerId | String | A selling partner identifier, such as a merchant account or vendor code. |