linkfox-mpstats-ozon-category-products

Compare original and translation side by side

🇺🇸

Original

English

🇨🇳

Translation

Chinese

MPSTATS Ozon Category Products

MPSTATS Ozon 类目商品查询

This skill drills into all Ozon (Russia) products under a given Russian category path, returning each SKU's sales, revenue, price, rating, stock, turnover, lost profit, and more. Designed for category bestseller mining, blue-ocean niche discovery, and brand-landscape scanning within a specific category.

本技能可按指定的俄语类目路径下钻查看Ozon（俄罗斯站点）的全部商品，返回每个SKU的销量、销售额、价格、评分、库存、周转、损失利润等指标。适用于类目爆款挖掘、蓝海市场洞察、特定类目品牌格局分析场景。

Core Concepts

核心概念

Russian full-path requirement:

categoryPath

must be the full Russian category path as used on the Ozon platform, with levels separated by

— for example,

Одежда/Женская одежда/Футболки и топы женские

. A partial path, English translation, or root-only value will generally return empty results.

Where to find the path: Typical workflows resolve the path via an upstream Ozon category-search step (if available in your toolchain) or by pulling a known SKU's

category

field from

mpstats-ozon-product-detail

mpstats-ozon-product-search

Filters are AND-combined:

filters

carries multi-field numeric conditions, each

{field, op, value, value2?}

. See the Filter Reference.

Currency: Default

RUB

. Override with

currency

(USD, EUR, CNY, ...) and optionally

currencyRate

FBO / FBS:

includeFbs: true

folds FBS into stock / sales numbers;

false

keeps FBO-only.

俄语完整路径要求：

categoryPath

必须为Ozon平台使用的完整俄语类目路径，层级之间用

分隔——例如

Одежда/Женская одежда/Футболки и топы женские

。使用部分路径、英文翻译或仅根路径通常会返回空结果。

路径获取方式：通常可通过上游Ozon类目搜索步骤（若工具链中包含该功能）获取路径，或从

mpstats-ozon-product-detail

mpstats-ozon-product-search

接口中提取已知SKU的

category

字段来获取。

筛选条件逻辑：

filters

参数支持多字段数值条件，每个条件格式为

{field, op, value, value2?}

，具体请参考筛选条件说明。

货币设置：默认货币为

RUB

（卢布）。可通过

currency

参数（支持USD、EUR、CNY等）自定义货币类型，还可选择设置

currencyRate

自定义汇率。

FBO/FBS模式：设置

includeFbs: true

时，库存/销量数据将包含FBS模式的数据；设置为

false

时，仅保留FBO模式的数据。

Parameters

参数说明

Parameter	Type	Required	Description
categoryPath	string	yes	Full Russian category path separated by `/`
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` / `desc`
currency	string	no	Currency code, default `RUB`
currencyRate	integer	no	Custom rate when non-default currency is used
includeFbs	boolean	no	Include FBS data
filters	array	no	Numeric filter list (see below)

参数名称	类型	是否必填	描述
categoryPath	string	是	用 `/` 分隔的完整俄语类目路径
startDate	string	否	统计周期起始日期，格式为 `YYYY-MM-DD` ；默认最新日期为昨日
endDate	string	否	统计周期结束日期，格式为 `YYYY-MM-DD` ；默认最新日期为昨日
page	integer	否	页码，从1开始
pageSize	integer	否	每页行数，范围1-100，默认值为100
sortField	string	否	排序字段（蛇形命名）： `sales` 、 `revenue` 、 `final_price` 、 `balance` 、 `rating` 等
sortDirection	string	否	排序方向： `asc` （升序）/ `desc` （降序）
currency	string	否	货币代码，默认值为 `RUB`
currencyRate	integer	否	使用非默认货币时的自定义汇率
includeFbs	boolean	否	是否包含FBS数据
filters	array	否	数值筛选条件列表（详见下文）

Filter Reference

筛选条件说明

Each

filters

entry:

{"field": "<snake_case>", "op": "<OP>", "value": <num>, "value2": <num?>}

Common fields:

sales

(monthly units),

final_price

(price RUB),

rating

(0-5),

comments

(reviews),

balance

(stock),

revenue

(amount RUB),

days_in_stock

turnover_days

lost_profit

category_position

Operators:

GTE

LTE

GT

LT

EQ

NOT_EQ

BETWEEN

(requires

value2

每个

filters

条件的格式为：

{"field": "<snake_case>", "op": "<OP>", "value": <num>, "value2": <num?>}

。

常用字段：

sales

（月销量）、

final_price

（售价，单位卢布）、

rating

（评分，0-5）、

comments

（评论数）、

balance

（库存）、

revenue

（销售额，单位卢布）、

days_in_stock

（库存天数）、

turnover_days

（周转天数）、

lost_profit

（损失利润）、

category_position

（类目排名）。

操作符：

GTE

（大于等于）、

LTE

（小于等于）、

GT

（大于）、

LT

（小于）、

EQ

（等于）、

NOT_EQ

（不等于）、

BETWEEN

（介于两者之间，需指定

value2

）。

API Usage

API 使用说明

This tool calls the LinkFox tool gateway API. See

references/api.md

for calling conventions, request parameters, response structure, and error codes. You can also execute

scripts/mpstats_ozon_category_products.py

directly for ad-hoc queries.

本工具调用LinkFox工具网关API。调用规范、请求参数、响应结构及错误码请参考

references/api.md

。您也可直接执行

scripts/mpstats_ozon_category_products.py

脚本进行临时查询。

Usage Examples

使用示例

1. Women's T-shirts — top by sales

json

{
  "categoryPath": "Одежда/Женская одежда/Футболки и топы женские",
  "sortField": "sales",
  "sortDirection": "desc",
  "pageSize": 100
}

2. Blue-ocean hunt (sales ≥ 50, rating ≥ 4.5)

json

{
  "categoryPath": "Одежда/Женская одежда/Футболки и топы женские",
  "filters": [
    {"field": "sales", "op": "GTE", "value": 50},
    {"field": "rating", "op": "GTE", "value": 4.5}
  ],
  "sortField": "revenue",
  "sortDirection": "desc"
}

3. Mid-price + strong turnover

json

{
  "categoryPath": "Электроника/Наушники",
  "filters": [
    {"field": "final_price", "op": "BETWEEN", "value": 1500, "value2": 5000},
    {"field": "turnover_days", "op": "LTE", "value": 30}
  ]
}

4. USD-converted ranking for cross-market comparison

json

{
  "categoryPath": "Электроника/Смартфоны",
  "currency": "USD",
  "sortField": "revenue",
  "sortDirection": "desc"
}

5. High lost-profit category scan

json

{
  "categoryPath": "Одежда/Мужская одежда/Куртки мужские",
  "filters": [{"field": "lost_profit", "op": "GTE", "value": 500000}],
  "sortField": "lost_profit",
  "sortDirection": "desc"
}

1. 女士T恤——按销量排序取TOP

json

{
  "categoryPath": "Одежда/Женская одежда/Футболки и топы женские",
  "sortField": "sales",
  "sortDirection": "desc",
  "pageSize": 100
}

2. 蓝海市场挖掘（销量≥50，评分≥4.5）

json

{
  "categoryPath": "Одежда/Женская одежда/Футболки и топы женские",
  "filters": [
    {"field": "sales", "op": "GTE", "value": 50},
    {"field": "rating", "op": "GTE", "value": 4.5}
  ],
  "sortField": "revenue",
  "sortDirection": "desc"
}

3. 中端价位+高周转商品

json

{
  "categoryPath": "Электроника/Наушники",
  "filters": [
    {"field": "final_price", "op": "BETWEEN", "value": 1500, "value2": 5000},
    {"field": "turnover_days", "op": "LTE", "value": 30}
  ]
}

4. 换算为美元的排名（用于跨市场对比）

json

{
  "categoryPath": "Электроника/Смартфоны",
  "currency": "USD",
  "sortField": "revenue",
  "sortDirection": "desc"
}

5. 高损失利润类目排查

json

{
  "categoryPath": "Одежда/Мужская одежда/Куртки мужские",
  "filters": [{"field": "lost_profit", "op": "GTE", "value": 500000}],
  "sortField": "lost_profit",
  "sortDirection": "desc"
}

Display Rules

展示规则

Compact category table — key columns:

productId

title

brand

sellerName

price

monthlySalesUnits

monthlySalesRevenue

rating

balance

position

revenueSharePercent

Revenue share = within this category query — 0-100%; clarify the basis when presenting.
Russian titles / brands — preserve original; translate on demand.
Currency labeling — state the currency; if converted, note
```
"已按 USD 换算"
```
.
Pagination — report
```
total
```
; for large categories (tens of thousands of SKUs) suggest tightening filters rather than naively paging through.
Category position — lower is better; mention this when showing
```
categoryPosition
```
.

精简类目表格——核心列包括：

productId

、

title

、

brand

、

sellerName

、

price

、

monthlySalesUnits

、

monthlySalesRevenue

、

rating

、

balance

、

position

、

revenueSharePercent

。

销售额占比——指在本次类目查询范围内的占比（0-100%）；展示时需明确说明计算依据。
俄语标题/品牌——保留原文；可按需提供翻译。
货币标注——明确标注货币类型；若进行了货币换算，需注明
```
"已按 USD 换算"
```
（示例）。
分页处理——需返回
```
total
```
（总条数）；对于包含数万SKU的大类目，建议缩小筛选范围，而非单纯分页浏览。
类目排名——数值越小排名越靠前；展示
```
categoryPosition
```
时需说明此规则。

Important Limitations

重要限制

Russian full path only — partial or translated paths return empty.
Path discovery is upstream — this endpoint does not browse the category tree; resolve the path via product detail / search first.
Page cap — max 100 rows per page.
T-1 data —
```
endDate
```
cannot be today or a future date.
No business advice — data-only view.

仅支持完整俄语路径——使用部分路径或翻译后的路径将返回空结果。
路径需上游获取——本接口不支持类目树浏览；需先通过商品详情/搜索接口获取路径。
分页上限——每页最多返回100条数据。
数据延迟一天——
```
endDate
```
不能设置为今日或未来日期。
不提供业务建议——仅返回数据视图。

User Expression & Scenario Quick Reference

用户表述与场景速查

Applicable — Category-scoped Ozon product metrics:

User Says	Scenario
"Bestsellers in category X on Ozon"	Category bestseller mining
"Find blue-ocean SKUs in niche Y"	Blue-ocean niche scan
"Show mid-price, fast-turnover items in this category"	Multi-criteria niche filter
"Which brands dominate this Ozon category"	Brand-landscape pre-cut (then group by brand client-side)
"Huge lost-profit opportunities in category X"	Out-of-stock pain hunting

Not applicable — Needs beyond category drill-down:

Unknown category path → use
```
mpstats-ozon-product-search
```
or product detail to discover the exact Russian path
Brand-scoped drill →
```
mpstats-ozon-brand-products
```
Seller-scoped drill →
```
mpstats-ozon-seller-products
```
Single-SKU time-series →
```
mpstats-ozon-product-trend
```
Wildberries / other Russian marketplaces → not covered

Boundary judgment: Use this skill when the dimension is a category path and you want the per-SKU roll-up under it. For cross-category comparisons you must run multiple calls and fuse results at the Agent layer.

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.

适用场景——类目维度的Ozon商品指标查询：

用户表述	场景
"Ozon平台X类目下的爆款商品"	类目爆款挖掘
"在Y细分领域寻找蓝海SKU"	蓝海市场细分领域排查
"展示该类目下中端价位、高周转的商品"	多条件细分领域筛选
"哪些品牌在Ozon该类目占据主导地位"	品牌格局初步分析（需在客户端按品牌分组）
"X类目下存在大量损失利润的机会"	缺货痛点挖掘

不适用场景——超出类目下钻范围的需求：

未知类目路径 → 使用
```
mpstats-ozon-product-search
```
或商品详情接口获取准确的俄语类目路径
品牌维度下钻 → 使用
```
mpstats-ozon-brand-products
```
技能
卖家维度下钻 → 使用
```
mpstats-ozon-seller-products
```
技能
单个SKU的时间序列分析 → 使用
```
mpstats-ozon-product-trend
```
技能
Wildberries或其他俄罗斯电商平台 → 不在本技能覆盖范围内

边界判断：当查询维度为类目路径，且需要获取该路径下每个SKU的汇总数据时，使用本技能。若需进行跨类目对比，需多次调用本技能并在Agent层合并结果。

反馈机制：当出现以下情况时，自动检测并通过Feedback API提交反馈：

本技能描述的功能或用途与实际行为不符
本技能的结果不符合用户意图
用户对本技能表达不满或赞扬
任何您认为可以改进的内容请按照
```
references/api.md
```
中的说明调用反馈API，请勿打断用户流程。

如需更多高质量、专业的跨境电商技能，请访问LinkFox Skills。