All Collections
Data Sources
Amazon
Amazon Product Pricing Tracker
Amazon Product Pricing Tracker
Openbridge Support avatar
Written by Openbridge Support
Updated over a week ago

Get access to ASIN-level product tracker data directly from Amazon. The pricing data unlocks new opportunities for your efforts with competitive intelligence, sales rank tracking, buy box insights, and more.

Here is a collection of key data elements included in the feeds:

  1. ASIN & Seller ID: Identifies the product and the seller.

  2. Lowest Prices: Includes details about the lowest prices for different conditions and fulfillment channels.

  3. Sales Rank: Provides the sales ranking of the product in specific categories.

  4. Price Details: Includes listing price, shipping cost, and points value.

  5. Item Condition: Indicates the condition of the items (e.g., New, Used, Collectible).

  6. Total Offer Count: The number of total offers available for the ASIN.

  7. Number of Offers by Condition and Fulfillment Channel: Breakdown of offers based on their condition (e.g., New, Used) and fulfillment channel.

  8. Buy Box Winner & Featured Merchant: Indicates if the seller is a Buy Box winner or a featured merchant.

  9. Buy Box Prices: Details of prices for Buy Box eligible offers.

  10. Buy Box Eligible Offers: Information about offers eligible for the Buy Box is critical as the Buy Box winner is often the default choice for customers.

  11. Ships From: Location details from where the product is shipped.

  12. Fulfillment by Amazon (FBA): Indicates whether Amazon fulfills the order.

  13. Prime Information: Whether the offer is prime eligible and its type.

  14. Seller Feedback Rating and Counts: This represents the percentage of positive feedback and the total number of feedback entries received by the seller.

This rich, extensive ASIN-level product data comes directly from Amazon to your private cloud warehouse or data lake every hour. There are no bots or screen scraping.

Limits

Currently, each subscription can support 100 ASINs per Seller account as we look to optimize for the Amazon limits. We hope to raise this higher as we observe the performance of Amazon's system.

Timing

Data is collected as hourly 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 pricing on 9/13/23. However, over time, you will build your own historical snapshots, which accrue value the longer you collect the data.

Pricing API Datasets

There are five pricing data sets, each aligning with how Amazon packages the information.

  1. sp_pp_competitive_price_by_asin_offers_*

  2. sp_pp_item_offers_detail_*

  3. sp_pp_item_offers_*

  4. sp_pp_competitive_summary_offers_*

  5. sp_pp_competitive_price_by_asin_*

sp_pp_competitive_price_by_asin_offers_* Table Summary

This table includes information on competitive pricing for specific products (ASINs) across different marketplaces. Here's a breakdown of the key columns:

  • ob_sellingpartner_id: Identifier for the selling partner.

  • ob_marketplace_id: Marketplace identifier.

  • ob_asin: Amazon Standard Identification Number, which uniquely identifies a product.

  • ob_seller_sku: Seller's stock-keeping unit, appears to be missing in the sample.

  • competitive_price_id: Identifier for the competitive price.

  • price_landed_price_currency_code: Currency code for the landed price.

  • price_landed_price_amount: Landed price amount.

  • price_listing_price_currency_code: Currency code for the listing price.

  • price_listing_price_amount: Listing price amount.

  • ob_date: Date of the record.

  • ob_transaction_id: Transaction identifier.

  • ob_file_name: File name associated with the record.

  • ob_processed_at: Timestamp when the record was processed.

  • ob_modified_date: Date when the record was last modified.

Other columns indicate additional details about the offers, including quantities, discount types, and whether the offer belongs to the requester. This table is useful for analyzing competitive pricing strategies across different marketplaces.

sp_pp_item_offers_detail_*Table Summary

This table provides detailed information about offers for specific products (ASINs) in various marketplaces. Key columns include:

  • ob_sellingpartner_id: Identifier for the selling partner.

  • ob_marketplace_id: Marketplace identifier.

  • ob_asin: Amazon Standard Identification Number.

  • ob_sku: Stock-keeping unit, appears to be missing in the sample.

  • ob_item_condition: Condition of the item (e.g., New).

  • my_offer: Indicates if the offer is from the querying seller, data missing in the sample.

  • offer_type: Type of the offer, data missing in the sample.

  • sub_condition: More detailed condition of the item.

  • seller_id: Identifier for the seller.

  • is_fulfilled_by_amazon: Indicates if the offer is fulfilled by Amazon.

  • prime_information_is_prime: Indicates if the offer is available for Amazon Prime.

  • is_buy_box_winner: Indicates if the offer is the current Buy Box winner.

  • is_featured_merchant: Indicates if the seller is a featured merchant.

  • ob_date: Date of the record.

  • ob_transaction_id: Transaction identifier.

  • ob_file_name: File name associated with the record.

  • ob_processed_at: Timestamp when the record was processed.

  • ob_modified_date: Date when the record was last modified.

This table seems particularly useful for analyzing the details of offers, including seller information, fulfillment methods, and prime eligibility, which are crucial for competitive positioning on Amazon.

sp_pp_item_offers_* Table Summary

This table provides a comprehensive overview of offers for specific products (ASINs) across different conditions and fulfillment channels:

  • ob_sellingpartner_id: Identifier for the selling partner.

  • ob_marketplace_id: Marketplace identifier.

  • asin: Amazon Standard Identification Number.

  • sku: Stock-keeping unit, missing in the sample.

  • item_condition: The condition of the item (e.g., New, Used).

  • total_offer_count: The total number of offers for the item.

  • number_of_offers_x_condition: The number of offers for specific conditions (repeated for different conditions).

  • number_of_offers_x_fulfillment_channel: Number of offers per fulfillment channel (repeated for different channels).

  • buy_box_eligible_offers_x_condition: Information about Buy Box eligible offers (repeated for different conditions).

  • offers_available_time: The time the offers are available.

  • ob_date: Date of the record.

  • ob_transaction_id: Transaction identifier.

  • ob_file_name: File name associated with the record.

  • ob_processed_at: Timestamp when the record was processed.

  • ob_modified_date: Date when the record was last modified.

This extensive table provides a detailed view of the offer landscape for products, including the number of offers, their conditions, and eligibility for the Buy Box, which is crucial for competitive analysis on Amazon.

sp_pp_competitive_summary_offers_* Table Summary

This table summarizes competitive offers for specific products (ASINs) across different marketplaces. Key columns include:

  • ob_sellingpartner_id: Identifier for the selling partner.

  • ob_marketplace_id: Marketplace identifier.

  • ob_asin: Amazon Standard Identification Number.

  • seller_id: Identifier for the seller.

  • condition: Condition of the item (e.g., New, Used).

  • fulfillment_type: Type of fulfillment (e.g., AFN for Amazon Fulfillment Network).

  • listing_price_currency_code: Currency code for the listing price.

  • listing_price_amount: Amount of the listing price.

  • is_featured_offer: Indicates if the offer is a featured offer.

  • featured_offer_segments: Information about segments of featured offers.

  • ob_date: Date of the record.

  • ob_transaction_id: Transaction identifier.

  • ob_file_name: File name associated with the record.

  • ob_processed_at: Timestamp when the record was processed.

  • ob_modified_date: Date when the record was last modified.

The table is useful for analyzing competitive offers regarding pricing, fulfillment, and feature status in various marketplaces.

sp_pp_competitive_price_by_asin_* Table Summary

This table focuses on competitive pricing information for specific products (ASINs) across various marketplaces. The key columns include:

  • ob_sellingpartner_id: Identifier for the selling partner.

  • ob_marketplace_id: Marketplace identifier.

  • seller_sku: Seller's stock-keeping unit, missing in the sample.

  • asin: Amazon Standard Identification Number.

  • competitive_pricing_number_of_offer_listings_x_count: Count of offer listings for different conditions (repeated for various conditions).

  • competitive_pricing_number_of_offer_listings_x_condition: Condition types for offer listings.

  • sales_rankings_x_product_category_id: Sales ranking category IDs (repeated for various categories).

  • sales_rankings_x_rank: Sales ranks (repeated for various categories).

  • ob_date: Date of the record.

  • ob_transaction_id: Transaction identifier.

  • ob_file_name: File name associated with the record.

  • ob_processed_at: Timestamp when the record was processed.

  • ob_modified_date: Date when the record was last modified.

This table is useful for understanding the competitive landscape regarding the number of offers and their ranking in various categories.

Did this answer your question?