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.

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.

The connector retrieves data across seven key areas, each corresponding to a specific table in the database:

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`

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`

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`

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`

Classifies each item into a specific product type.

- `ob_marketplace`

- `ob_selling_partner_id`

- `ob_asin`

- `ob_id`

- `ob_id_type`

- `product_type`

Contains links to product images, including dimensions.

- `ob_marketplace`

- `ob_selling_partner_id`

- `ob_asin`

- `ob_id`

- `ob_id_type`

- `variant`

- `link`

- `height`

- `width`

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`

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.

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.