Sorftime Product Detail
This skill guides you on how to query Amazon product detail and historical trend data by ASIN via Sorftime, helping Amazon sellers analyze product performance, pricing strategy, and competitive positioning.
Core Concepts
Sorftime Product Detail provides comprehensive product-level data by ASIN, with historical trend data going back to 2021. It covers sales volume & revenue trends, price & promotion tracking, multi-level BSR ranking history, and real-time profit analysis with FBA fee breakdown.
Key differentiator: This tool returns trend/time-series data for individual products. If you need to search/filter products across a category, brand, or seller, use the Sorftime Product Search skill instead.
Data Fields
Response data covers the following categories (see references/api.md for complete field reference):
- Basic info: title, brand, ASIN, listing URL, images (main + A+), store name, bullet points, product badges, off-sale status, last update date, weight, size
- Variations: parent ASIN, variation count, child ASINs, variation attributes
- Pricing & profit: sale price, coupon, platform fee, FBA fees (with detail breakdown), FBM shipping cost, profit amount & rate
- Sales: official monthly sales (Amazon-published)
- Rankings: BSR rank, category tree, sub-category rankings, listing date, days online
- Ratings: rating score, rating count, star distribution (1-5 star percentages)
- Seller: Buybox seller name/ID/country, FBA status, seller count
- Listing features: A+ content, video, brand store, feature ratings, product info, properties
- Promotions: brand promotion, deal type, extra savings
- Trends (time-series): BSR rank, sub-BSR rank, daily/monthly sales volume, daily/monthly revenue, price, list price, deal status
Supported Marketplaces
US (United States), GB (United Kingdom), DE (Germany), FR (France), IN (India), CA (Canada), JP (Japan), ES (Spain), IT (Italy), MX (Mexico), AE (United Arab Emirates), AU (Australia), BR (Brazil), SA (Saudi Arabia)
Default marketplace is US. Use us when the user doesn't specify a marketplace.
Note: Sorftime uses lowercase codes (e.g., us, gb, de), and UK is coded as gb (not uk).
How to Invoke
- API Endpoint:
POST /sorftime/amazon/productDetail (complete params/response/error codes in references/api.md)
- Python Script:
python scripts/amazon_market_product_detail.py '<JSON params>' [--inline]
- Cost constraint: This tool consumes credits; the same session and parameter combination is called only once by default, with a 24h local cache in the script. On failure or empty results, do not automatically retry with different keywords, pagination, or postal codes; inform the user about additional consumption before continuing to search.
Output strategy (script default behavior):
- Always write the full response to
<cwd>/nexscope/<YYYY-MM-DD>/<session>/data/nexscope-sorftime-amazon-product-detail-<timestamp>.json (<cwd> is the working directory at script execution time, i.e. the current project directory in Claude Code; <session> is taken from the SESSION_ID env var, auto-grouped by user task; do not write to /tmp, error if current directory is not writable)
- Response body <= 8 KB: print full JSON to stdout after saving
- Response body > 8 KB: print only summary to stdout after saving (top-level fields, common counts like
total/costToken, length of largest list field + first 3 samples)
- Add
--inline to force full output to stdout (still saves to disk)
Data reading tip: Check the summary first to decide if it's enough; when specific fields are needed, prefer using jq or ConvertFrom-Json to extract from the saved json file on demand, avoiding loading the entire JSON into context.
How to Build Queries
The key parameters are asin and marketplace (both required), plus optional trend date range controls.
Principles for Building Queries
- Always specify the marketplace: Use lowercase site codes, e.g.,
us, de, jp
- Choose trend inclusion carefully: Default includes trends (last 15 days). Set
includeTrend: 2 if only basic product info is needed - this saves cost and speeds up response
- Specify date range for historical analysis: Use
queryTrendStartDate and queryTrendEndDate (yyyy-MM-dd) when users need trends beyond the default 15 days. Be aware this costs double
- Batch ASINs when comparing: Up to 10 ASINs can be queried at once, comma-separated - use this for competitive comparison rather than calling one at a time
Query Examples for Common Scenarios
1. Quick product check (default 15-day trend)
asin: B00FLYWNYQ, marketplace: us
2. Long-range trend analysis (specify dates)
asin: B00FLYWNYQ, marketplace: us
queryTrendStartDate: 2025-01-01, queryTrendEndDate: 2025-03-31
3. Batch ASIN comparison
asin: B0088PUEPK,B00U26V4VQ,B0CVM8TXHP, marketplace: us
4. Product info only, no trends
asin: B0088PUEPK, marketplace: us, includeTrend: 2
5. BSR ranking history (German market)
asin: B00FLYWNYQ, marketplace: de
queryTrendStartDate: 2024-06-01, queryTrendEndDate: 2025-01-01
Trend Data Interpretation
Trend arrays use an interleaved format: even indices are dates, odd indices are values.
[20250101, 150, 20250102, 180, 20250103, 165, ...]
^date ^val ^date ^val ^date ^val
- Sales volume/revenue trends: value of
-1 means "cannot estimate" (e.g., category changed to Amazon Renewed)
- Price trends: units are in local currency smallest unit (cents for USD);
-1 means no available price that day
- BSR rank trends: for
bsrRankTrend, format is [{NodeId: xxx, Rank: [date, rank, ...]}] per sub-category
- Deal trend: value
1 = has active Deal that day, 0 = no Deal
Display Rules
- Present data only: Show query results in clear tables without subjective business advice
- Ranking clarification: When showing ranking data, remind users that lower values mean better rankings
- Price unit awareness: Trend data uses smallest currency unit (cents for USD). Convert to standard currency when displaying to users
- Sales estimation caveat: Values of
-1 in sales/revenue fields mean "cannot estimate" - explain this to the user rather than showing -1 directly
- Trend visualization: When showing trend data, present key data points in a readable table rather than dumping raw arrays
- Off-sale handling: When
offSale is true, clearly inform the user the product is currently unavailable/off-sale
- Error handling: When a query fails, explain the reason based on the
msg field and suggest adjusting query criteria
Important Limitations
- Max 10 ASINs per query
- Trend cost: Default returns last 15 days; querying > 15 days costs double
- Non-structured data: Results do not support secondary analysis via
_dataQuery_executeDynamicQuery
- Sales estimation: Products in non-standard categories (e.g., Amazon Renewed) may return -1 for sales fields
User Expression & Scenario Quick Reference
Applicable -- Product detail and trend queries by ASIN:
| User Says |
Scenario |
| "Check the sales trend for this ASIN" |
Sales trend |
| "How has this product's price changed recently" |
Price history |
| "Help me see the profit margin for this product" |
Profit analysis |
| "BSR ranking trend for this ASIN" |
Ranking history |
| "Compare data across these ASINs" |
Multi-ASIN comparison |
| "What's the FBA fee for this product" |
FBA fee breakdown |
| "How long has this product been listed, what's the rating" |
Basic product info |
| "Is this product still on sale" |
Off-sale status check |
| "Does this product have Deal promotion history" |
Deal history |
| "Show me the variant information for this product" |
Variation details |
Not applicable -- Needs beyond single-product detail:
- Searching/filtering products across a category or brand (use Sorftime Product Search)
- ABA search term ranking data (use ABA Data Explorer)
- Advertising / PPC strategy
- Product reviews content analysis
- Patent or trademark checks
Boundary judgment: When users say "product analysis" or "competitor comparison", if it boils down to checking specific ASINs' detail data and trend curves, then this skill applies. If they're asking to discover or filter products across a market, it does not apply.
Authentication
Set the NEXSCOPE_API_KEY environment variable. If credentials are missing or expire, visit https://www.nexscope.ai/help/skills-external-access?co-from=skillNS to top up credits.
1---2name: ecommerce-amazon-market-product-detail3description: Query Amazon product detail and historical trends by ASIN using Sorftime data, covering 14 marketplaces. Trigger when the user mentions Sorftime product detail, ASIN detail query, sales trends, price curves, price history, BSR ranking history, BSR trends, profit analysis, FBA fee analysis, gross margin, product trend analysis, daily/monthly sales, revenue trends, Deal promotion history, product detail, sales trend, price history, BSR ranking, profit analysis, FBA fees. Even if the user does not explicitly mention "Sorftime", if their need involves querying Amazon product detail or historical trend data by ASIN, this skill should also be triggered.4---56# Sorftime Product Detail78This skill guides you on how to query Amazon product detail and historical trend data by ASIN via Sorftime, helping Amazon sellers analyze product performance, pricing strategy, and competitive positioning.910## Core Concepts1112Sorftime Product Detail provides comprehensive product-level data by ASIN, with historical trend data going back to 2021. It covers sales volume & revenue trends, price & promotion tracking, multi-level BSR ranking history, and real-time profit analysis with FBA fee breakdown.1314**Key differentiator**: This tool returns trend/time-series data for individual products. If you need to search/filter products across a category, brand, or seller, use the Sorftime Product Search skill instead.1516## Data Fields1718Response data covers the following categories (see `references/api.md` for complete field reference):1920- **Basic info**: title, brand, ASIN, listing URL, images (main + A+), store name, bullet points, product badges, off-sale status, last update date, weight, size21- **Variations**: parent ASIN, variation count, child ASINs, variation attributes22- **Pricing & profit**: sale price, coupon, platform fee, FBA fees (with detail breakdown), FBM shipping cost, profit amount & rate23- **Sales**: official monthly sales (Amazon-published)24- **Rankings**: BSR rank, category tree, sub-category rankings, listing date, days online25- **Ratings**: rating score, rating count, star distribution (1-5 star percentages)26- **Seller**: Buybox seller name/ID/country, FBA status, seller count27- **Listing features**: A+ content, video, brand store, feature ratings, product info, properties28- **Promotions**: brand promotion, deal type, extra savings29- **Trends** (time-series): BSR rank, sub-BSR rank, daily/monthly sales volume, daily/monthly revenue, price, list price, deal status3031## Supported Marketplaces3233US (United States), GB (United Kingdom), DE (Germany), FR (France), IN (India), CA (Canada), JP (Japan), ES (Spain), IT (Italy), MX (Mexico), AE (United Arab Emirates), AU (Australia), BR (Brazil), SA (Saudi Arabia)3435Default marketplace is **US**. Use `us` when the user doesn't specify a marketplace.3637**Note**: Sorftime uses lowercase codes (e.g., `us`, `gb`, `de`), and UK is coded as `gb` (not `uk`).3839## How to Invoke4041- **API Endpoint**: `POST /sorftime/amazon/productDetail` (complete params/response/error codes in `references/api.md`)42- **Python Script**: `python scripts/amazon_market_product_detail.py '<JSON params>' [--inline]`43- **Cost constraint**: This tool consumes credits; the same session and parameter combination is called only once by default, with a 24h local cache in the script. On failure or empty results, do not automatically retry with different keywords, pagination, or postal codes; inform the user about additional consumption before continuing to search.4445**Output strategy (script default behavior)**:46- **Always** write the full response to `<cwd>/nexscope/<YYYY-MM-DD>/<session>/data/nexscope-sorftime-amazon-product-detail-<timestamp>.json` (`<cwd>` is the working directory at script execution time, i.e. the current project directory in Claude Code; `<session>` is taken from the `SESSION_ID` env var, auto-grouped by user task; **do not write to /tmp**, error if current directory is not writable)47- Response body <= 8 KB: print full JSON to stdout after saving48- Response body > 8 KB: print only summary to stdout after saving (top-level fields, common counts like `total`/`costToken`, length of largest list field + first 3 samples)49- Add `--inline` to force full output to stdout (still saves to disk)5051**Data reading tip**: Check the summary first to decide if it's enough; when specific fields are needed, prefer using `jq` or `ConvertFrom-Json` to extract from the saved json file on demand, avoiding loading the entire JSON into context.5253## How to Build Queries5455The key parameters are `asin` and `marketplace` (both required), plus optional trend date range controls.5657### Principles for Building Queries58591. **Always specify the marketplace**: Use lowercase site codes, e.g., `us`, `de`, `jp`602. **Choose trend inclusion carefully**: Default includes trends (last 15 days). Set `includeTrend: 2` if only basic product info is needed - this saves cost and speeds up response613. **Specify date range for historical analysis**: Use `queryTrendStartDate` and `queryTrendEndDate` (yyyy-MM-dd) when users need trends beyond the default 15 days. Be aware this costs double624. **Batch ASINs when comparing**: Up to 10 ASINs can be queried at once, comma-separated - use this for competitive comparison rather than calling one at a time6364### Query Examples for Common Scenarios6566**1. Quick product check (default 15-day trend)**67```68asin: B00FLYWNYQ, marketplace: us69```7071**2. Long-range trend analysis (specify dates)**72```73asin: B00FLYWNYQ, marketplace: us74queryTrendStartDate: 2025-01-01, queryTrendEndDate: 2025-03-3175```7677**3. Batch ASIN comparison**78```79asin: B0088PUEPK,B00U26V4VQ,B0CVM8TXHP, marketplace: us80```8182**4. Product info only, no trends**83```84asin: B0088PUEPK, marketplace: us, includeTrend: 285```8687**5. BSR ranking history (German market)**88```89asin: B00FLYWNYQ, marketplace: de90queryTrendStartDate: 2024-06-01, queryTrendEndDate: 2025-01-0191```9293## Trend Data Interpretation9495Trend arrays use an interleaved format: even indices are dates, odd indices are values.9697```98[20250101, 150, 20250102, 180, 20250103, 165, ...]99 ^date ^val ^date ^val ^date ^val100```101102- **Sales volume/revenue trends**: value of `-1` means "cannot estimate" (e.g., category changed to Amazon Renewed)103- **Price trends**: units are in local currency smallest unit (cents for USD); `-1` means no available price that day104- **BSR rank trends**: for `bsrRankTrend`, format is `[{NodeId: xxx, Rank: [date, rank, ...]}]` per sub-category105- **Deal trend**: value `1` = has active Deal that day, `0` = no Deal106107## Display Rules1081091. **Present data only**: Show query results in clear tables without subjective business advice1102. **Ranking clarification**: When showing ranking data, remind users that lower values mean better rankings1113. **Price unit awareness**: Trend data uses smallest currency unit (cents for USD). Convert to standard currency when displaying to users1124. **Sales estimation caveat**: Values of `-1` in sales/revenue fields mean "cannot estimate" - explain this to the user rather than showing -1 directly1135. **Trend visualization**: When showing trend data, present key data points in a readable table rather than dumping raw arrays1146. **Off-sale handling**: When `offSale` is true, clearly inform the user the product is currently unavailable/off-sale1157. **Error handling**: When a query fails, explain the reason based on the `msg` field and suggest adjusting query criteria116117## Important Limitations118119- **Max 10 ASINs** per query120- **Trend cost**: Default returns last 15 days; querying > 15 days costs double121- **Non-structured data**: Results do not support secondary analysis via `_dataQuery_executeDynamicQuery`122- **Sales estimation**: Products in non-standard categories (e.g., Amazon Renewed) may return -1 for sales fields123124## User Expression & Scenario Quick Reference125126**Applicable** -- Product detail and trend queries by ASIN:127128| User Says | Scenario |129|-----------|----------|130| "Check the sales trend for this ASIN" | Sales trend |131| "How has this product's price changed recently" | Price history |132| "Help me see the profit margin for this product" | Profit analysis |133| "BSR ranking trend for this ASIN" | Ranking history |134| "Compare data across these ASINs" | Multi-ASIN comparison |135| "What's the FBA fee for this product" | FBA fee breakdown |136| "How long has this product been listed, what's the rating" | Basic product info |137| "Is this product still on sale" | Off-sale status check |138| "Does this product have Deal promotion history" | Deal history |139| "Show me the variant information for this product" | Variation details |140141**Not applicable** -- Needs beyond single-product detail:142- Searching/filtering products across a category or brand (use Sorftime Product Search)143- ABA search term ranking data (use ABA Data Explorer)144- Advertising / PPC strategy145- Product reviews content analysis146- Patent or trademark checks147148**Boundary judgment**: When users say "product analysis" or "competitor comparison", if it boils down to checking specific ASINs' detail data and trend curves, then this skill applies. If they're asking to discover or filter products across a market, it does not apply.149150## Authentication151152Set the `NEXSCOPE_API_KEY` environment variable. If credentials are missing or expire, visit https://www.nexscope.ai/help/skills-external-access?co-from=skillNS to top up credits.
nexscope-ai