ListingsItemsSummaries
Returns details about a listings item summaries 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 ListingsItemsSummaries WHERE SKU = '12345' AND SellerId = 'XXXXXXXXXXXXXX'
Columns
| Name | Type | References | Description |
| SKU | String | A selling partner provided identifier for an Amazon listing. | |
| Asin | String | Amazon Standard Identification Number (ASIN) of the listings item. | |
| ConditionType | String | Identifies the condition of the listings item.
The allowed values are new_new, new_open_box, new_oem, refurbished_refurbished, used_like_new, used_very_good, used_good, used_acceptable, collectible_like_new, collectible_very_good, collectible_good, collectible_acceptable, club_club. | |
| CreatedDate | Datetime | Date the listings item was created, in ISO 8601 format. | |
| ItemName | String | Name, or title, associated with an Amazon catalog item. | |
| LastUpdatedDate | Datetime | Date the listings item was last updated, in ISO 8601 format. | |
| MainImageLink | String | Link, or URL, for the main image. | |
| MainImageHeight | Integer | Height of the main image in pixels. | |
| MainImageWidth | Integer | Width of the main image in pixels. | |
| MarketplaceId | String | A marketplace identifier. Identifies the Amazon marketplace for the listings item. | |
| ProductType | String | The Amazon product type of the listings item. | |
| Status | String | Statuses that apply to the listings item. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| SellerId | String | A selling partner identifier, such as a merchant account or vendor code. |