Products
The Products Table helps you get information to match your products to existing product listings on Amazon Marketplace websites.
Select
The driver will use the Amazon Marketplace API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the driver.
For example, the following query is processed server side:
SELECT * FROM Products WHERE SearchTerms = '249-7638334-8161403'
SELECT * FROM Products WHERE idType = 'SellerSKU' AND idlist = '{SellerSku code}'
SELECT * FROM Products WHERE idType = 'ASIN' AND idlist = '{ASIN code}'
SELECT * FROM Products WHERE idType = 'GCID' AND idlist = '{GCID code}'
SELECT * FROM Products WHERE idType = 'UPC' AND idlist = '{UPC code}'
SELECT * FROM Products WHERE idType = 'EAN' AND idlist = '{EAN code}'
SELECT * FROM Products WHERE idType = 'ISBN' AND idlist = '{ISBN code}'
SELECT * FROM Products WHERE idType = 'JAN' AND idlist = '{JAN code}'
SELECT * FROM Products WHERE idType = 'JAN' AND idlist IN ('{JAN code}', '{ISBN code}', '{GCID code}')
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. | |
| SearchTerms | String | ||
| IdType | String | The product ID type.
The allowed values are ASIN, GCID, SellerSKU, UPC, EAN, ISBN, JAN. | |
| IdList | String | A list of product IDs. |