The Amazon Catalog API Data Connector is designed to facilitate collecting and loading detailed Amazon product information into a target database. This documentation outlines the operational aspects of the connector, the data structure of each table, and its contents.
Use Cases
This connector allows businesses to analyze both owned and competitive products by tracking competitors' product offerings, pricing strategies (through integration with pricing data), and sales performance.
By examining the `sales_ranks` and `summaries` tables, businesses can monitor how competitors' products are ranked within the same categories, understand the features and attributes (like brand, color, size) that might be contributing to their success, and observe any changes in product assortments or new product introductions.
This insight is invaluable for adjusting pricing and marketing strategies and making informed product development or enhancement decisions. Monitoring changes in the `images` and `identifiers` tables can also provide insights into competitors' marketing strategies and brand positioning. This comprehensive view enables businesses to stay ahead in highly competitive markets by adapting strategies based on real-time data and trends.
Data Sets and Tables
The connector retrieves data across seven key areas, each corresponding to a specific table in the database:
sp_catalog_items_by_ids_dimensions
Contains the physical dimensions and weights of items and their packaging.
- `ob_marketplace`
- `ob_selling_partner_id`
- `ob_asin`
- `ob_id`
- `ob_id_type`
- `item_height_unit`
- `item_height_value`
- `item_length_unit`
- `item_length_value`
- `item_width_unit`
- `item_width_value`
- `item_weight_unit`
- `item_weight_value`
- `package_height_unit`
- `package_height_value`
- `package_length_unit`
- `package_length_value`
- `package_width_unit`
- `package_width_value`
- `package_weight_unit`
- `package_weight_value`
- `ob_date`
- `ob_transaction_id`
- `ob_file_name`
- `ob_processed_at`
- `ob_modified_date`
sp_catalog_items_by_ids_summaries
Offers general product information, including brand, manufacturer, and item classification.
- (General information columns)
- `adult_product`
- `autographed`
- `brand`
- `browse_classification_display_name`
- `browse_classification_classification_id`
- `color`
- (Contributors fields, e.g., `contributors_0_role_display_name` to `contributors_9_value`)
- `item_classification`
- `item_name`
- `manufacturer`
- `memorabilia`
- `model_number`
- `package_quantity`
- `part_number`
- `release_date`
- `size`
- `style`
- `trade_in_eligible`
- `website_display_group`
- `website_display_group_name`
sp_catalog_items_by_ids_sales_ranks
Details the sales ranking of items within their categories.
- `ob_marketplace`
- `ob_selling_partner_id`
- `ob_asin`
- `ob_id`
- `ob_id_type`
- `classification_id`
- `website_display_group`
- `title`
- `link`
- `rank`
sp_catalog_items_by_ids_relationships
Outlines relationships between products, including parent-child associations.
- `ob_marketplace`
- `ob_selling_partner_id`
- `ob_asin`
- `ob_id`
- `ob_id_type`
- (Child and parent ASIN fields, e.g., `child_asins_0` to `child_asins_4`)
- (Variation theme attributes, `variation_theme_attributes_0` to `variation_theme_attributes_4`, `variation_theme_theme`)
- `type`
sp_catalog_items_by_ids_product_types
Classifies each item into a specific product type.
- `ob_marketplace`
- `ob_selling_partner_id`
- `ob_asin`
- `ob_id`
- `ob_id_type`
- `product_type`
sp_catalog_items_by_ids_images
Contains links to product images, including dimensions.
- `ob_marketplace`
- `ob_selling_partner_id`
- `ob_asin`
- `ob_id`
- `ob_id_type`
- `variant`
- `link`
- `height`
- `width`
sp_catalog_items_by_ids_identifiers
Lists various identifiers for products, such as ASINs and UPCs.
- `ob_marketplace`
- `ob_selling_partner_id`
- `ob_asin`
- `ob_id`
- `ob_id_type`
- `identifier_type`
- `identifier`
Limits
Currently, each subscription can support 100 ASINs per Seller or Vendor account as we look to optimize for Amazon's limits. We would like to raise this as we observe Amazon's system's performance.
Timing
Data is collected as daily snapshots, meaning Amazon provides the information as of that point in time when we request the data each hour. We can not request historical data as Amazon does not support requesting a snapshot of catalog data on a given date, like 9/13/23. However, over time, you will build your historical snapshots, which accrue value the longer you collect the data.