Pull every Ozon SKU under a Russian category path with sales, revenue, price, rating, stock, and turnover.
Coding
MPSTATS-Ozon品牌商品查询
Try itList every Ozon brand SKU with sales, revenue, price, rating, stock, and turnover for competitor and structure analysis.
What it does
Given an exact Ozon brand display name, returns every product sold under that brand with units sold, revenue, price, rating, review count, stock balance, turnover days, and lost profit. Supports AND-combined numeric filters (e.g. rating >= 4.5, balance > 0, lost_profit >= 100000), sort by sales/revenue/price/rating, pagination up to 100 rows per page, RUB by default with optional server-side currency conversion, and a toggle to fold in FBS seller-fulfilled stock and sales. Brand name must match the storefront spelling exactly; there is no fuzzy match.
When to use it
- Top-selling SKUs for a specific Ozon brand
- Revenue structure of a brand sorted by revenue
- High-rating, in-stock SKUs within a brand
- Out-of-stock SKUs driving high lost profit within a brand
The skill document
MPSTATS Ozon Brand Products
This skill drills into all Ozon (Russia) products sold under a given brand display name, returning each SKU's sales, revenue, price, rating, stock, turnover, lost profit, and more. Built for brand competitor audits, brand SKU structure analysis, and bestseller dissection.
Core Concepts
Brand display name: brandName must match what's shown on the Ozon storefront — typically Russian (Cyrillic) or Latin (adidas, Xiaomi). Do not pass a category path, a seller ID, or an internal brand code here. If unsure of the exact spelling, resolve via mpstats-ozon-product-search first.
Filters are AND-combined: The filters array supports multiple numeric conditions ANDed together. Each filter is {field, op, value, value2?}. Common fields and operators are in the Filter Reference below.
Currency & rate: Default currency is RUB. Set currency: "USD" (or another code) to have monetary fields converted server-side; currencyRate lets you override the default rate if desired.
FBO / FBS mix: includeFbs: true folds FBS (seller-shipped) stock + sales into the numbers; false keeps them FBO-only.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| brandName | string | yes | Ozon brand display name (Russian or Latin) |
| startDate | string | no | Stats window start, YYYY-MM-DD; latest = yesterday |
| endDate | string | no | Stats window end, YYYY-MM-DD; latest = yesterday |
| page | integer | no | Page number, starts at 1 |
| pageSize | integer | no | Rows per page, 1-100, default 100 |
| sortField | string | no | snake_case column: sales, revenue, final_price, balance, rating, ... |
| sortDirection | string | no | asc or desc |
| currency | string | no | Currency code, default RUB; e.g. USD, EUR, CNY |
| currencyRate | integer | no | Custom rate when non-default currency is used |
| includeFbs | boolean | no | Include FBS data |
| filters | array | no | Numeric filter conditions (see below) |
Filter Reference
Each filters entry: {"field": "", "op": "", "value": , "value2": }.
Common fields: sales (monthly units), final_price (selling price RUB), rating (0-5), comments (review count), balance (stock), revenue (sales amount RUB), days_in_stock, turnover_days, lost_profit, category_position.
Operators: GTE, LTE, GT, LT, EQ, NOT_EQ, BETWEEN (requires value2 as the upper bound).
调用方式
- API 端点:
POST /mpstats/ozon/brandProducts(完整参数/响应/错误码见references/api.md) - Python 脚本:
python scripts/mpstats_ozon_brand_products.py '' [--inline] - 成本约束:本工具会消耗积分;同一会话同一参数组合默认只调用一次,脚本带 24h 本地缓存。失败/空结果不得自动换关键词、翻页或改邮编连续试探;需要继续检索时先向用户说明会产生额外消耗。
输出策略(脚本默认行为):
- 始终将完整响应写入
/linkfox///data/linkfox-mpstats-ozon-brand-products-.json(为脚本执行时的工作目录,在 Claude Code 里即当前项目目录;取自环境变量SESSION_ID,按用户任务自动聚合;禁止写入 /tmp,当前目录不可写则报错) - 响应体 ≤ 8 KB:落盘后把完整 JSON 打印到 stdout
- 响应体 > 8 KB:落盘后 stdout 只输出摘要(顶层字段、常见计数如
total/costToken、最大列表字段的长度 + 前 3 条样本) - 加
--inline强制全量打印到 stdout(同样落盘)
读数据建议:先看摘要判断是否足够;需要具体字段时优先用 jq或ConvertFrom-Json 从保存的 json 文件按需抽取,避免整份 JSON 进入上下文。
解决认证和积分问题
发生以下异常情况时,采用 references/onboarding.md 引导解决问题:
异常情况
- 未配置API Key:环境变量未配置
LINKFOX_AGENT_API_KEY,也未配置LINKFOXAGENT_API_KEY。 - 响应401或402状态码
- 响应提示积分或余额不足:消息含"积分余额不足/计费不足/余额不足/quota exceeded/insufficient balance/套餐到期/需充值/请充值",或类似含义的内容。
Usage Examples
1. Top-50 by sales for brand adidas
{
"brandName": "adidas",
"sortField": "sales",
"sortDirection": "desc",
"pageSize": 50
}
2. High-rating, mid-price filter
{
"brandName": "Xiaomi",
"filters": [
{"field": "rating", "op": "GTE", "value": 4.5},
{"field": "final_price", "op": "BETWEEN", "value": 1000, "value2": 5000}
],
"sortField": "revenue",
"sortDirection": "desc"
}
3. USD-converted output
{
"brandName": "Nike",
"currency": "USD",
"sortField": "revenue"
}
4. Include FBS + only in-stock items
{
"brandName": "adidas",
"includeFbs": true,
"filters": [{"field": "balance", "op": "GT", "value": 0}]
}
5. Lost-profit hunters (out-of-stock pain)
{
"brandName": "Nike",
"filters": [{"field": "lost_profit", "op": "GTE", "value": 100000}],
"sortField": "lost_profit",
"sortDirection": "desc"
}
Display Rules
- Compact brand table — key columns:
productId,title,price,monthlySalesUnits,monthlySalesRevenue,rating,reviewCount,balance,turnoverDays,lostProfit. - Revenue share context —
revenueSharePercentis the SKU's share within this brand result set, 0-100; clarify the base when presenting. - Currency labeling — always state the currency in the table header; if
currencywas overridden, note "已按 USD 换算". - Russian titles — preserve original; translate on user request.
- Pagination — report total and guide the user to next page or narrower filters when total exceeds the returned page.
- No business advice — present the data; don't project future sales from a snapshot.
Important Limitations
- Exact brand-name match — no fuzzy search; typos return empty results. Verify via
mpstats-ozon-product-searchif unsure. - Page cap — max 100 rows per page; paginate for larger brands.
- Date window —
endDatecannot be today or a future date (T-1 data). - Currency conversion — server-side; historical rates may differ slightly from the user's reference rate.
- Russian-only titles — translate only when asked.
User Expression & Scenario Quick Reference
Applicable — Brand-scoped Ozon product metrics:
| User Says | Scenario |
|---|---|
| "Show me adidas's top-selling Ozon SKUs" | Brand bestseller drill |
| "What does Xiaomi sell on Ozon, sorted by revenue" | Brand revenue structure |
| "Which brand-X SKUs have rating ≥4.5 and stock >0" | Brand quality filter |
| "Are brand-X's stockouts causing big lost profit" | Lost-profit hunter |
| "Convert brand-X's Ozon sales to USD" | Currency-normalized audit |
Not applicable — Needs beyond brand drill-down:
- Unknown exact brand name → first use
mpstats-ozon-product-search - Category-level comparison across brands → use
mpstats-ozon-category-products - Seller-scoped analysis → use
mpstats-ozon-seller-products - Single-SKU time-series → use
mpstats-ozon-product-trend - Wildberries / other Russian marketplaces → not covered
Boundary judgment: Use this skill when the question centers on one brand and you want the per-SKU rollup under it. For "which brand dominates category X" use category drill-down and compare brand rows server-side.
积分消耗规则
按动态规则计费:消耗积分 = 12。列表为空返回 0
重要:本技能的服务按倍数动态计算,可能一次性消耗大量积分,必须提醒用户,由用户决定是否继续。
Feedback:
Auto-detect and report feedback via the Feedback API when any of the following apply:
- The functionality or purpose described in this skill does not match actual behavior
- The skill's results do not match the user's intent
- The user expresses dissatisfaction or praise about this skill
- Anything you believe could be improved
Call the feedback API as specified in references/api.md. Do not interrupt the user's flow.
For more high-quality, professional cross-border e-commerce skills, set LinkFox Skills.
Questions people ask
- What if I don't know the exact brand spelling?
- Brand name must match the Ozon storefront spelling exactly; there is no fuzzy match. Use mpstats-ozon-product-search first to resolve the correct name, otherwise the call returns empty.
- Can revenue be converted to USD or other currencies?
- Yes. Pass the currency parameter (e.g. USD, EUR, CNY) and the server converts monetary fields; historical rates may differ slightly from your reference rate. currencyRate lets you override the default rate.
- How are multiple filters combined?
- All entries in the filters array are AND-combined. Operators include GTE, LTE, GT, LT, EQ, NOT_EQ, and BETWEEN, where BETWEEN requires value2 as the upper bound.
- Does this include FBS seller-fulfilled data?
- By default the result is FBO-only. Set includeFbs: true to fold in FBS stock and sales into the numbers.
- What does the call cost and what are the limits?
- Each call consumes 12 credits by default; empty results return 0. Max 100 rows per page (paginate for larger brands), and endDate cannot be today or a future date.
Related skills
Pull every SKU under an Ozon seller ID with sales, revenue, price, rating, stock, turnover, and lost-profit metrics.
MPSTATS Ozon 俄罗斯站单个 SKU 的分日时间序列表现。按日期粒度返回一个 Ozon 商品的销量、价格、库存、评分等指标,可选附带搜索位次/可见性数据,用于验证增长趋势、季节性、异常波动。当用户提到 Ozon 趋势、Ozon 销量趋势、Ozon 价格走势、Ozon 分日数据、Ozon 库存走势、Ozon 搜索位次、Ozon 商品历史、MPSTATS trend, Ozon daily performance, Ozon time series, Ozon search visibility, Russian marketplace product history 时触发此技能。即使用户未明确说"MPSTATS",只要意图是看某个 Ozon 商品的分日/时间段走势,也应触发此技能。
Batch-fetch up to 100 Ozon (Russia) SKUs with price, sales, stock, rating and period-over-period metrics per call.
MPSTATS Ozon 俄罗斯站商品搜索与反查。按俄语关键词或 SKU 在 MPSTATS 数据库中检索 Ozon 商品,返回商品 ID、标题、品牌和卖家信息,是 Ozon 选品与竞品链路的起点。当用户提到 Ozon 选品、Ozon 商品搜索、俄罗斯电商选品、Ozon 关键词搜索、Ozon SKU 查询、MPSTATS Ozon、Ozon product search, MPSTATS Ozon, Russian marketplace, Ozon SKU lookup, Ozon keyword search 时触发此技能。即使用户未明确提到"MPSTATS",只要其意图是在 Ozon 俄罗斯站按关键词或 SKU 发现或反查商品,也应触发此技能。
Seerfar Ozon 商品报表搜索:按销量、销售额、销量/销售额增长率、购物车转化率、下单转化率、价格、评分、评论数、QA数、变体数、浏览量、毛利率、退货取消率、广告费用份额、重量/体积、上架时间、品牌、卖家、配送方式、标签等多维指标筛选 Ozon 商品,返回每个商品的 SKU、标题、价格(卢布)、销量、销售额、损失销售额、转化率、评分、评论、品牌、卖家、配送方式、上架天数/月数等完整商品报表字段,用于 Ozon 选品、竞品商品分析、热销商品挖掘、价格带/转化带筛选。当用户提到 Ozon 商品报表、Ozon 选品、Ozon 商品筛选、Ozon 商品分析、Ozon 热销商品、Ozon 竞品商品分析、Ozon product report, Ozon product screener, filter Ozon products by sales, Ozon best-seller mining, Seerfar Ozon 商品报表时触发此技能。即使用户未明确提到"Seerfar",只要其意图是按多指标筛选 Ozon 商品并查看商品级报表,也应触发此技能。