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. | |
| AdultProduct | Boolean | Identifies an Amazon catalog item is intended for an adult audience or is sexual in nature. | |
| Autographed | Boolean | Identifies an Amazon catalog item is autographed by a player or celebrity. | |
| Brand | String | Name of the brand associated with an Amazon catalog item. | |
| BrowseClassificationClassificationId | String | Classification Id (browse node) associated with an Amazon catalog item. | |
| BrowseClassificationDisplayName | String | Classification Name (browse node) associated with an Amazon catalog item. | |
| Color | String | Name of the color associated with an Amazon catalog item. | |
| ContributorsRole | String | Role of an individual contributor in the creation of an item, such as author or actor. | |
| ContributorsName | String | Name of the contributor. | |
| ItemClassification | String | Classification type associated with the Amazon catalog item. | |
| ItemName | String | Name, or title, associated with an Amazon catalog item. | |
| Manufacturer | String | Name of the manufacturer associated with an Amazon catalog item. | |
| Memorabilia | Boolean | Identifies an Amazon catalog item is memorabilia valued for its connection with historical events, culture, or entertainment. | |
| ModelNumber | String | Model number associated with an Amazon catalog item. | |
| PackageQuantity | Integer | Quantity of an Amazon catalog item in one package. | |
| PartNumber | String | Part number associated with an Amazon catalog item. | |
| ReleaseDate | String | First date on which an Amazon catalog item is shippable to customers. | |
| Size | String | Name of the size associated with an Amazon catalog item. | |
| Style | String | Name of the style associated with an Amazon catalog item. | |
| TradeInEligible | Boolean | Identifies an Amazon catalog item is eligible for trade-in. | |
| WebsiteDisplayGroup | String | Identifier of the website display group associated with an Amazon catalog item. | |
| WebsiteDisplayGroupName | String | Display name of the website display group associated with an Amazon catalog item. | |
| Attributes | String | A JSON object containing structured item attribute data keyed by attribute name. Catalog item attributes conform to the related Amazon product type definitions available in the Selling Partner API for Product Type Definitions. | |
| Dimensions | String | A JSON object of the dimensions for an item in the Amazon catalog. | |
| Identifiers | String | A JSON object of the identifiers associated with the item in the Amazon catalog, such as UPC and EAN identifiers. | |
| Images | String | A JSON object of the images for an item in the Amazon catalog. | |
| ProductTypes | String | A JSON object of the product types associated with the Amazon catalog item. | |
| Relationships | String | A JSON object of the relationship details of an Amazon catalog item (for example, variations). | |
| SalesRankings | String | A JSON object of the sales ranks of an Amazon catalog item. | |
| VendorDetails | String | A JSON object of the vendor details associated with an Amazon catalog item. Vendor details are available to vendors only. | |
| ASIN | String | Amazon Standard Identification Number that identifies a product. | |
| EAN | String | A European Article Number that uniquely identifies the catalog item, manufacturer, and its attributes. | |
| GTIN | String | A Global Trade Item Number that uniquely identifies a product. | |
| 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. | |
| MINSAN | String | A Minsan Code that uniquely identifies an item. | |
| 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. | |
| IncludedData | String | A comma-delimited list of item details to request. If none are specified, will default to returning summaries data. Values: attributes, dimensions, identifiers, images, productTypes, relationships, salesRanks, summaries, vendorDetails. | |
| Locale | String | Locale for retrieving localized summaries. Defaults to the primary locale of the marketplace. | |
| SellerId | String | A selling partner identifier, such as a seller account or vendor code. Note: Required when setting identifier SellerSKU. | |
| PageSize | String | Number of results to be returned per page. | |
| Query | String | Keyword(s) to use to search for items in the catalog. | |
| BrandNames | String | A comma-delimited list of brand names to limit the search for keywords-based queries. Note: Cannot be used with identifiers. | |
| ClassificationIds | String | A comma-delimited list of classification identifiers to limit the search for keywords-based queries. Note: Cannot be used with identifiers. | |
| KeywordsLocale | String | The language of the keywords provided for keywords-based queries. Defaults to the primary locale of the marketplace. Note: Cannot be used with identifiers. | |
| MarketplaceId | String | Specifies the marketplace for which items are returned. |