ListingsItemsOffers
Returns details about a listings item offers for a selling partner.
The following filter is required:
- SellerId: You can specify SellerId either as a criteria condition in WHERE filters or in the connection string.
SELECT * FROM ListingsItemsOffers WHERE 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.
The allowed values are B2B, B2C. | |
| PriceAmount | Decimal | Purchase price amount of the listings item. | |
| PriceCurrency | String | Purchase price currency of the listings item. | |
| Points | Integer | 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). | |
| SellerId | String | A selling partner identifier, such as a merchant account or vendor code. |