CatalogItems
The Catalog Items table helps you retrieve item details for items in the catalog.
The following filters are required:
- MarketplaceId
- One of the following: Query, SellerSKU, UPC, EAN, ISBN, JAN
SELECT * FROM CatalogItems WHERE MarketplaceID = 'XXXXXXXXXXXXX' AND ISBN = 'XXXXXXXXXXXXX'
Columns
| Name | Type | References | Description |
| MarketplaceASIN [KEY] | String | The Marketplace ASIN. | |
| MarketplaceASINMarketplaceId | String | The MarketplaceId of Marketplace ASIN. | |
| SKUIdentifierMarketplaceId | String | The SKUIdentifier of MarketplaceId. | |
| SKUIdentifierSelerId | String | The MarketplaceId of SellerId. | |
| SKUIdentifierSellerSKU | String | The MarketplaceId of SellerSKU. | |
| AttributeSets | String | The product attributes. | |
| Relationships | String | The product relationships. | |
| SalesRankings | String | The product sales rankings. |
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 | |
| Query | String | Keyword(s) to use to search for items in the catalog. Example: 'harry potter books'. | |
| SellerSKU | String | Used to identify an item in the given marketplace. SellerSKU is qualified by the seller's SellerId | |
| UPC | String | A 12-digit bar code used for retail packaging. | |
| EAN | String | A European article number that uniquely identifies the catalog item, manufacturer, and its attributes. | |
| ISBN | String | The unique commercial book identifier used to identify books internationally. | |
| JAN | String | A Japanese article number that uniquely identifies the product, manufacturer, and its attributes. | |
| MarketplaceId | String | Specifies the marketplace for which items are returned. |