/erp/sc/routing/finance/ProfitStatis/profitMsku{
"operation": {
"method": "POST",
"path": "/erp/sc/routing/finance/ProfitStatis/profitMsku"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 1,
"text": ""
},
"requestExample": {
"start_date": "2020-08-01",
"end_date": "2024-08-07",
"offset": 0,
"length": 200,
"sids": "1,109",
"currency_type": "2",
"sort_field": "asin",
"sort_type": "desc"
},
"responseExample": {
"code": 0,
"message": "success",
"error_details": [],
"request_id": "F4CD40E1-7CB9-38DC-B196-5B17D375454E",
"response_time": "2024-08-08 19:26:34",
"data": [
{
"msku": "JJ002",
"asin": "B0BBB14W7B",
"item_name": "Super J Running Belt for Gym Workout Exercise Stable Sports Waist Bag Ultra Light Bounce Free",
"local_name": "liyi-1",
"local_sku": "liyi-1",
"seller": "篮球 美国",
"sid": "109",
"marketplace": "美国",
"asin_name": "超级管理员;林鸿基;刘瑞娟",
"category_text": "服装",
"product_brand_text": "LY",
"icon": "$",
"code": "USD",
"total_amount": 0,
"total_volume": "0",
"replenishment_num": "2",
"refund_num": "0",
"refund_amount": 0,
"refund_rate": "0.00%",
"channel_fee": -9.6,
"commission_amount": 0,
"promotion_amount": 0,
"order_quantity": "0",
"sales_amount": 0,
"total_spend": 0,
"total_cg_price": 0,
"other_order_fee": 0,
"total_cg_transport_costs": 0,
"gross_profit": -9.6,
"profit_rate": "0.00%"
},
{
"msku": "HOLDER001",
"asin": "B0BB389BKQ",
"item_name": "NP Phone Holder",
"local_name": "",
"local_sku": "",
"seller": "篮球 美国",
"sid": "109",
"marketplace": "美国",
"asin_name": "001-LXF;彭志帆;林鸿基;邱定楷",
"category_text": "-",
"product_brand_text": "",
"icon": "$",
"code": "USD",
"total_amount": 0,
"total_volume": "0",
"replenishment_num": "2",
"refund_num": "0",
"refund_amount": 0,
"refund_rate": "0.00%",
"channel_fee": -10.15,
"commission_amount": 0,
"promotion_amount": 0,
"order_quantity": "0",
"sales_amount": 0,
"total_spend": 0,
"total_cg_price": -0.59,
"other_order_fee": 0,
"total_cg_transport_costs": -4.21,
"gross_profit": -14.96,
"profit_rate": "0.00%"
}
],
"total": 29
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | start_date | 起始日期 | string | — | Required | 起始日期 |
| 2 | end_date | 起始日期 | string | — | Required | 起始日期 |
| 3 | offset | 分页偏移量 | integer | — | Required | 分页偏移量 |
| 4 | length | 分页长度 | integer | — | Required | 分页长度,上限200 |
| 5 | sids | 店铺id | string | — | Optional | 店铺id,通过逗号分隔可以多选,默认返回全部 ,对应查询亚马逊店铺列表接口对应字段【sid】 |
| 6 | currency_type | 币种 | string | — | Optional | 币种,默认原币种 1 人民币-CNY 2 美元-USD 3 欧元-EUR 4 日元-JPY 5 澳元-AUD 6 加拿大元-CAD 7 墨西哥比索-MXN 8 英镑-GBP 9 印度卢比-INR 10 阿联酋迪拉姆-AED 11 新加坡元-SGD 12 沙特阿拉伯-SAR 13 巴西-BRL 14 瑞典-SEK 15 波兰-PLN 16 土耳其-TRY |
| 7 | sort_field | 排序字段 | string | — | Optional | 排序字段:asin |
| 8 | sort_type | sort_type | string | — | Optional | desc:倒序 asc:顺序 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | integer | — | Required | 状态码,0 成功 |
| 2 | message | 消息提示 | string | success | Required | 消息提示 |
| 3 | error_details | 错误信息 | array<any> | — | Required | 错误信息 |
| 4 | request_id | 请求链路id | string | 8D680B8B-3C6F-3E16-F055-73DC70EAD977 | Required | 请求链路id |
| 5 | response_time | 响应时间 | string | 2020-05-18 11:23:47 | Required | 响应时间 |
| 6 | data | 响应数据 | array<object> | — | Required | 响应数据 |
| 6.1 | msku | msku | string | — | Required | MSKU |
| 6.2 | asin | asin | string | — | Required | Asin |
| 6.3 | item_name | 标题 | string | — | Required | 标题 |
| 6.4 | local_name | 品名 | string | — | Required | 品名 |
| 6.5 | local_sku | local_sku | string | — | Required | SKU |
| 6.6 | seller | 店铺 | string | — | Required | 店铺 |
| 6.7 | sid | 店铺id | integer | — | Required | 店铺id |
| 6.8 | marketplace | 国家 | string | — | Required | 国家 |
| 6.9 | asin_name | 负责人 | string | — | Required | 负责人 |
| 6.10 | category_text | 分类 | string | — | Required | 分类 |
| 6.11 | product_brand_text | 品牌 | string | — | Required | 品牌 |
| 6.12 | icon | 币种-符号 | string | — | Required | 币种-符号 |
| 6.13 | code | 币种 | string | — | Required | 币种 |
| 6.14 | total_amount | 销售额 | string | — | Required | 销售额 |
| 6.15 | total_volume | 销量 | number | — | Required | 销量 |
| 6.16 | replenishment_num | 多渠道销量 | number | — | Required | 多渠道销量 |
| 6.17 | refund_num | 退款量 | number | — | Required | 退款量 |
| 6.18 | refund_amount | 退款 | number | — | Required | 退款 |
| 6.19 | refund_rate | 退款率 | string | — | Required | 退款率 |
| 6.20 | channel_fee | 发货费 | number | — | Required | 发货费 |
| 6.21 | commission_amount | 平台费 | number | — | Required | 平台费 |
| 6.22 | promotion_amount | 促销费 | number | — | Required | 促销费 |
| 6.23 | order_quantity | 广告订单量 | number | — | Required | 广告订单量 |
| 6.24 | sales_amount | 广告销售额 | number | — | Required | 广告销售额 |
| 6.25 | total_spend | 广告费 | number | — | Required | 广告费 |
| 6.26 | total_cg_price | 采购成本 | number | — | Required | 采购成本 |
| 6.27 | other_order_fee | 测评费 | number | — | Required | 测评费 |
| 6.28 | total_cg_transport_costs | 头程费用 | number | — | Required | 头程费用 |
| 6.29 | gross_profit | 毛利润 | number | — | Required | 毛利润 |
| 6.30 | profit_rate | 毛利率 | string | — | Required | 毛利率 |
| 7 | total | 记录数 | integer | | Required | 记录数 |
The 查询利润统计(旧) - MSKU API (/erp/sc/routing/finance/ProfitStatis/profitMsku) of 领星ERP is curated by the API asset management module of the Qeasy Cloud data integration platform and kept in sync with 领星ERP version updates.
Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.