Building a Python Dashboard for Amazon Product Performance with SellerMagnetAPI
For Amazon businesses and market analysts, real-time product performance insights are crucial for competitive analysis, inventory management, and market research. Building a Python dashboard integrated with the SellerMagnetAPI provides a powerful solution for monitoring key metrics and making data-driven decisions.
This post guides you through the process of creating a Python dashboard that leverages SellerMagnetAPI to track Amazon product performance. We'll cover practical use cases, code examples, and the essential API endpoints to build a comprehensive monitoring tool. The blog post thumbnail will be auto-generated using SellerMagnet’s internal image generation API.
Why Build an Amazon Product Performance Dashboard?
- Competitive Analysis: Monitor competitor product performance and identify market trends.
- Inventory Management: Track sales rank and stock levels to optimize inventory.
- Market Research: Analyze product data to identify opportunities and make informed decisions.
Getting Started with SellerMagnetAPI
Before diving into the code, ensure you have an active SellerMagnetAPI subscription. This API provides access to real-time Amazon product data, which we’ll use to populate our dashboard.
To get started, you’ll need your API key. You can find it in your login account dashboard after your Try Free registration.
Core API Endpoints for Amazon Product Performance
SellerMagnetAPI offers several key endpoints that provide the data needed for a robust product performance dashboard. Let’s explore some of these:
1. Amazon Product Statistics
The Amazon Product Statistics endpoint retrieves detailed statistics for a specific Amazon product, including sales rank, review counts, and pricing history.
Endpoint: /amazon-product-statistics
Method: GET
Parameters:
asin(required): Product ASIN (e.g., "B08N5WRWNW")marketplaceId(required): Marketplace ID (e.g., "A1PA6795UKMFR9")api_key(required): Your API keygraphs(optional): Generate visually graphs for history data
Example Request:
curl 'https://sellermagnet-api.com/amazon-product-statistics?asin=B08N5WRWNW&marketplaceId=A1PA6795UKMFR9&api_key=YOUR_API_KEY&graphs=true'
Example Response:
{
"success": true,
"data": {
"asin": "B0CLTBHXWQ",
"productTitle": "Playstation 5 Console Edizione Digital Slim",
"buyBoxPrice": 41800,
"buyBoxFulfillment": "FBM",
"buyBoxSellerIdHistory": [
[
"2025-06-14 17:08:00",
"A2I59UVTUWUFH0"
]
],
"categoryTree": [
{
"catId": 412603031,
"name": "Videogiochi"
},
{
"catId": 20904349031,
"name": "PlayStation 5"
},
{
"catId": 20904364031,
"name": "Console"
}
],
"graphs": {
"amazonAsSellerPriceHistory": "https://sellermagnet-api-webspace.s3.eu-central-1.amazonaws.com/amazon/api/charts/B0CLTBHXWQ/1749913774/B0CLTBHXWQ_amazon_price_1749913773.png",
"lowestFBAPriceHistory": "https://sellermagnet-api-webspace.s3.eu-central-1.amazonaws.com/amazon/api/charts/B0CLTBHXWQ/1749913776/B0CLTBHXWQ_fba_price_1749913773.png",
"lowestFBMPriceHistory": "https://sellermagnet-api-webspace.s3.eu-central-1.amazonaws.com/amazon/api/charts/B0CLTBHXWQ/1749913775/B0CLTBHXWQ_fbm_price_1749913773.png",
"monthlySoldHistory": "https://sellermagnet-api-webspace.s3.eu-central-1.amazonaws.com/amazon/api/charts/B0CLTBHXWQ/1749913778/B0CLTBHXWQ_monthly_sold_1749913773.png",
"productRatingHistory": "https://sellermagnet-api-webspace.s3.eu-central-1.amazonaws.com/amazon/api/charts/B0CLTBHXWQ/1749913777/B0CLTBHXWQ_rating_1749913773.png"
},
"listedSince": "2023-12-30 01:00:00",
"lowestFBAPrice": 44999,
"lowestFBMPrice": 41700,
"marketplaceId": "APJ6JRA9NG5V4",
"marketplaceNewPriceHistory": [
[
"2025-06-14",
41700
]
],
"offers": {
"A11IL2PNWYJU7H": {
"isFBA": true,
"lastUpdated": "2025-06-14 17:08:00",
"priceHistory": [
[
"2025-06-14 06:22:00",
44999,
0
]
],
"stockHistory": [
[
"2025-05-29 11:32:00",
1
]
]
},
"A12FLY25DT7QO0": {
"isFBA": false,
"lastUpdated": "2025-06-14 17:08:00",
"priceHistory": [
[
"2025-06-09 15:32:00",
41800,
0
]
],
"stockHistory": [
[
"2025-06-14 13:34:00",
49
]
]
},
"A18KSDUE00UP6J": {
"isFBA": false,
"lastUpdated": "2025-06-14 17:08:00",
"priceHistory": [
[
"2025-05-29 11:32:00",
42890,
0
]
],
"stockHistory": [
[
"2025-05-30 18:30:00",
3
]
]
}
},
"productReviewAverage": 4.7,
"productTotalReviews": 3129,
"rootCategory": {
"id": 412603031,
"name": "Videogiochi"
},
"stats": {
"amazonAsSellerPriceHistory": [
[
"2025-06-14",
44999
]
],
"buyBoxPriceHistory": [
[
"2025-06-13",
41700
]
],
"monthlySoldHistory": [
[
"2025-06",
1000
]
],
"productRatingCountHistory": [
[
"2025-06-14 15:28:00",
3129
]
],
"productRatingHistory": [
[
"2025-02-02 01:30:00",
4.7
]
],
"salesRankHistory": [
[
"2025-06-14 01:58:00",
15
]
]
}
}
}
2. Amazon Product Lookup
Use the Amazon Product Lookup endpoint to retrieve detailed product information, such as title, description, images, and features.
Endpoint: /amazon-product-lookup
Method: GET
Parameters:
asin(required): Product ASIN (e.g., 'B08N5WRWNW')marketplaceId(required): Marketplace ID (e.g., 'A1PA6795UKMFR9')api_key(required): Your API key
Example Request:
curl 'https://sellermagnet-api.com/amazon-product-lookup?asin=B08N5WRWNW&marketplaceId=A1PA6795UKMFR9&api_key=YOUR_API_KEY'
Example Response:
{
"data": {
"productInfo": {
"additionalDetails": {
"ASIN": "B0CL61F39H",
"Batteries": "1 Lithium Ion batteries required. (included)",
"Best Sellers Rank": "Nr. 31 in Video Games Nr. 1 in PlayStation 5 Consoles",
"Customer Rating": "4.7 out of 5 stars",
"Date First Available": "December 10, 2023",
"Item Weight": "10.6 pounds",
"Item model number": "CFI-2015",
"Manufacturer": "Sony",
"Number of Reviews": "7,092 ratings",
"Product Dimensions": "14 x 17 x 7 inches; 10.6 Pounds",
"Release date": "December 10, 2023",
"Type of item": "Video Game"
},
"asin": "B0CL61F39H",
"bestsellerRanks": {
"main_category": {
"name": "Video Games",
"rank": 31
},
"subcategory": {
"name": "PlayStation",
"rank": 1
}
},
"bulletPoints": [
"Model Number CFI-2000",
"Includes DualSense Wireless Controller, 1TB SSD, Disc Drive, 2 Horizontal Stand Feet, HDMI Cable, AC power cord, USB cable, printed materials, ASTRO\u2019s PLAYROOM (Pre-installed game)",
"Vertical Stand sold separately"
],
"buyBoxInfo": {
"currencyCode": "USD",
"currencyName": "United States Dollar",
"currencySymbol": "$",
"price": 444.99,
"sellerId": "A3853PJW50SJG8"
},
"categories": {
"bestsellerCategory": [
{
"id": "20972781011",
"index": 1,
"name": "PlayStation 5",
"url": "https://www.amazon.com/b/ref=dp_bc_2?ie=UTF8&node=20972781011"
},
{
"id": "20972796011",
"index": 2,
"name": "Consoles",
"url": "https://www.amazon.com/b/ref=dp_bc_3?ie=UTF8&node=20972796011"
}
],
"rootCategory": {
"id": "468642",
"name": "Video Games",
"url": "https://www.amazon.com/computer-video-games-hardware-accessories/b/ref=dp_bc_1?ie=UTF8&node=468642"
}
},
"description": [
"Model Number CFI-2000",
"Includes DualSense Wireless Controller, 1TB SSD, Disc Drive, 2 Horizontal Stand Feet, HDMI Cable, AC power cord, USB cable, printed materials, ASTRO\u2019s PLAYROOM (Pre-installed game)",
"Vertical Stand sold separately",
"The PS5 console unleashes new gaming possibilities that you never anticipated. Experience lightning fast loading with an ultra-high speed SSD, deeper immersion with support for haptic feedback, adaptive triggers, and 3D Audio*, and an all-new generation of incredible PlayStation games. Lightning Speed - Harness the power of a custom CPU, GPU, and SSD with Integrated I/O that rewrite the rules of what a PlayStation console can do. Stunning Games - Marvel at incredible graphics and experience new PS5 features. Play a back catalog of supported PS4 games. Breathtaking Immersion - Discover a deeper gaming experience with support for haptic feedback, adaptive triggers, and 3D Audio technology. Vertical stand sold separately. *3D audio via built-in TV speakers or analog/USB stereo headphones. Set up and latest system software update required."
],
"details": {
"ASIN": "B0CL61F39H",
"Batteries": "1 Lithium Ion batteries required. (included)",
"Date First Available": "December 10, 2023",
"Item Weight": "10.6 pounds",
"Item model number": "CFI-2015",
"Manufacturer": "Sony",
"Platform": "PlayStation 5",
"Product Dimensions": "14 x 17 x 7 inches; 10.6 Pounds",
"Release date": "December 10, 2023",
"Type of item": "Video Game"
},
"hasAPlusContent": true,
"images": [
"https://m.media-amazon.com/images/I/41ECK5cY-2L._SL1000_.jpg",
"https://m.media-amazon.com/images/I/41srF-iY93L._SL1000_.jpg",
"https://m.media-amazon.com/images/I/41tVr19I3zL._SL1000_.jpg",
"https://m.media-amazon.com/images/I/41HMaO9jO3L._SL1000_.jpg",
"https://m.media-amazon.com/images/I/61e8hPmeoYL._SL1000_.jpg",
"https://m.media-amazon.com/images/I/61Gj1Kc5R5L._SL1000_.jpg",
"https://m.media-amazon.com/images/I/61r6PutKGwL._SL1000_.jpg",
"https://m.media-amazon.com/images/I/717Id5h1fhL._SL1000_.jpg"
],
"link": "https://www.amazon.com/dp/B0CL61F39H",
"listedSinceDate": "2023-12-10",
"mainImage": "https://m.media-amazon.com/images/I/31kTNmpm6vL.jpg",
"marketplaceId": "ATVPDKIKX0DER",
"reviews": {
"averageRating": 4.7,
"reviewSummary": "4.7 out of 5 stars",
"totalReviews": 7092
},
"title": "PlayStation\u00ae5 console (slim)",
"variations": [
{
"asin": "B0F6968Y5G",
"attributes": {
"Pattern Name": "PS5 w/ Black Ops Bundle",
"Style": "PlayStation\u00ae5 Digital Edition (slim)"
}
},
{
"asin": "B0CL5KNB9M",
"attributes": {
"Pattern Name": "PS5 Only",
"Style": "PlayStation\u00ae5 Digital Edition (slim)"
}
},
{
"asin": "B0CL61F39H",
"attributes": {
"Pattern Name": "PS5 Only",
"Style": "PlayStation\u00ae5 console (slim)"
}
},
{
"asin": "B0F691TJTP",
"attributes": {
"Pattern Name": "PS5 w/ Black Ops Bundle",
"Style": "PlayStation\u00ae5 console (slim)"
}
},
{
"asin": "B0FD54CGQ8",
"attributes": {
"Pattern Name": "PS5 w/ $100 PlayStation Store GC",
"Style": "PlayStation\u00ae5 Digital Edition (slim)"
}
},
{
"asin": "B0FD4WGVH5",
"attributes": {
"Pattern Name": "PS5 w/ $100 PlayStation Store GC",
"Style": "PlayStation\u00ae5 console (slim)"
}
}
],
"videos": [
"https://m.media-amazon.com/S/vse-vms-transcoding-artifact-us-east-1-prod/8af0ddf1-55f5-4e71-9463-39602c3edbae/default.jobtemplate.hls.m3u8",
"https://m.media-amazon.com/S/vse-vms-transcoding-artifact-us-east-1-prod/50938d5c-2a9b-427a-b766-21b7cd63502e/default.jobtemplate.hls.m3u8"
]
}
},
"success": true
}
3. Amazon Product Offers
The Amazon Product Offers endpoint lists offers for a specific product, including price, seller, condition, and availability.
Endpoint: /amazon-product-offers
Method: GET
Parameters:
asin(required): Product ASIN (e.g., 'B08N5WRWNW')marketplaceId(required): Marketplace ID (e.g., 'A1PA6795UKMFR9')geo_location(optional): Detailed Geo Location ZIP CODEapi_key(required): Your API key
Example Request:
curl 'https://sellermagnet-api.com/amazon-product-offers?asin=B08N5WRWNW&marketplaceId=A1PA6795UKMFR9&api_key=YOUR_API_KEY'
Example Response:
{
"data": {
"asin": "B0CL61F39H",
"buyBox": {
"condition": "New",
"deliveryDate": "2025-06-28",
"fulfillmentType": "FBA",
"inventory": 30,
"positivePercentage": 0,
"priceWithoutShipping": 499,
"sellerId": "Amazon",
"sellerName": "Amazon",
"shippingPrice": 0,
"totalPrice": 499,
"totalReviews": 0
},
"currency": {
"code": "USD",
"name": "United States Dollar",
"symbol": "$"
},
"marketplaceId": "ATVPDKIKX0DER",
"offers": [
{
"condition": "New",
"deliveryDate": "2025-06-28",
"fulfillmentType": "FBA",
"inventory": 30,
"positivePercentage": 0,
"priceWithoutShipping": 499,
"sellerId": "Amazon",
"sellerName": "Amazon",
"shippingPrice": 0,
"totalPrice": 499,
"totalReviews": 0
},
{
"condition": "Used - Very Good",
"deliveryDate": "2025-07-07",
"fulfillmentType": "FBM",
"inventory": 10,
"positivePercentage": 78,
"priceWithoutShipping": 409.99,
"sellerId": "A17J18A7XABQI9",
"sellerName": "PRICE 2 SAVE",
"shippingPrice": 0,
"totalPrice": 409.99,
"totalReviews": 6892
},
{
"condition": "Used - Good",
"deliveryDate": "2025-06-26",
"fulfillmentType": "FBM",
"inventory": 1,
"positivePercentage": 87,
"priceWithoutShipping": 409.99,
"sellerId": "A1YU28SVL05CUG",
"sellerName": "premier liquidation",
"shippingPrice": 9.84,
"totalPrice": 419.83,
"totalReviews": 1177
}
],
"productLink": "https://www.amazon.com/dp/B0CL61F39H",
"productMainImage": "https://m.media-amazon.com/images/I/31kTNmpm6vL.jpg",
"productTitle": "PlayStation\u00ae5 console (slim)"
},
"success": true
}
Building the Python Dashboard
With the SellerMagnetAPI endpoints in hand, we can start building our Python dashboard. We’ll use libraries such as requests for API calls, pandas for data manipulation, and a dashboarding framework like Dash or Streamlit for visualization.
Example Code Snippet (using `requests` and `pandas`):
import requests
import pandas as pd
API_KEY = "YOUR_API_KEY"
MARKETPLACE_ID = "A1PA6795UKMFR9"
ASIN = "B08N5WRWNW"
# Function to fetch product statistics
def get_product_stats(asin, marketplace_id, api_key):
url = f"https://sellermagnet-api.com/amazon-product-statistics?asin={asin}&marketplaceId={marketplace_id}&api_key={api_key}"
response = requests.get(url)
if response.status_code == 200:
return response.json()
else:
print(f"Error: {response.status_code}")
return None
# Fetch product statistics
product_stats = get_product_stats(ASIN, MARKETPLACE_ID, API_KEY)
if product_stats and product_stats['success']:
data = product_stats['data']
df = pd.DataFrame([data])
print(df[['asin', 'productTitle', 'buyBoxPrice', 'buyBoxFulfillment']])
else:
print("Failed to retrieve product statistics.")
This code snippet demonstrates how to fetch product statistics using the Amazon Product Statistics endpoint. Adapt this code to incorporate other endpoints and create interactive visualizations within your dashboard.
Additional SellerMagnetAPI Endpoints
Consider these other SellerMagnetAPI endpoints for a more complete dashboard:
- Amazon Seller Review: Fetch review details for a specific Amazon seller.
- Amazon Bestsellers: Fetch top-selling products in a specific category.
- Amazon Product Search Estimated Sells: Retrieve estimated sales data for an Amazon product by ASIN.
- Search Amazon: Search Amazon products by keyword.
- Amazon ASIN/ISBN/EAN Converter: Convert between ASIN and EAN identifiers for Amazon products.
Enterprise Use Cases
- Automated Reporting: Schedule daily or weekly reports on key product metrics using DataPipeline.
- Alerting System: Set up alerts for significant changes in sales rank, pricing, or competitor activity.
- Custom Integrations: Integrate the dashboard data into existing CRM or ERP systems.
Conclusion
Building a Python dashboard with SellerMagnetAPI empowers Amazon businesses and market analysts with the insights needed to make data-driven decisions. By leveraging the power of real-time data and customizable visualizations, you can gain a competitive edge and optimize your Amazon strategy. Explore the Documentation and Code Examples to start building your dashboard today!
Unlock the full potential of Amazon data with SellerMagnetAPI! Check out our Pricing and Contact us for enterprise solutions. Don't wait, Try Free now! Stay up to date and find valuable content on our Blog.