/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
}
}| 序号 | 字段 | 名称 | 类型 | 默认值 | 必填 | 描述 |
|---|---|---|---|---|---|---|
| 1 | start_date | 起始日期 | string | — | 必填 | 起始日期 |
| 2 | end_date | 起始日期 | string | — | 必填 | 起始日期 |
| 3 | offset | 分页偏移量 | integer | — | 必填 | 分页偏移量 |
| 4 | length | 分页长度 | integer | — | 必填 | 分页长度,上限200 |
| 5 | sids | 店铺id | string | — | 可选 | 店铺id,通过逗号分隔可以多选,默认返回全部 ,对应查询亚马逊店铺列表接口对应字段【sid】 |
| 6 | currency_type | 币种 | string | — | 可选 | 币种,默认原币种 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 | — | 可选 | 排序字段:asin |
| 8 | sort_type | sort_type | string | — | 可选 | desc:倒序 asc:顺序 |
| 序号 | 字段 | 名称 | 类型 | 默认值 | 必填 | 描述 |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | integer | — | 必填 | 状态码,0 成功 |
| 2 | message | 消息提示 | string | success | 必填 | 消息提示 |
| 3 | error_details | 错误信息 | array<any> | — | 必填 | 错误信息 |
| 4 | request_id | 请求链路id | string | 8D680B8B-3C6F-3E16-F055-73DC70EAD977 | 必填 | 请求链路id |
| 5 | response_time | 响应时间 | string | 2020-05-18 11:23:47 | 必填 | 响应时间 |
| 6 | data | 响应数据 | array<object> | — | 必填 | 响应数据 |
| 6.1 | msku | msku | string | — | 必填 | MSKU |
| 6.2 | asin | asin | string | — | 必填 | Asin |
| 6.3 | item_name | 标题 | string | — | 必填 | 标题 |
| 6.4 | local_name | 品名 | string | — | 必填 | 品名 |
| 6.5 | local_sku | local_sku | string | — | 必填 | SKU |
| 6.6 | seller | 店铺 | string | — | 必填 | 店铺 |
| 6.7 | sid | 店铺id | integer | — | 必填 | 店铺id |
| 6.8 | marketplace | 国家 | string | — | 必填 | 国家 |
| 6.9 | asin_name | 负责人 | string | — | 必填 | 负责人 |
| 6.10 | category_text | 分类 | string | — | 必填 | 分类 |
| 6.11 | product_brand_text | 品牌 | string | — | 必填 | 品牌 |
| 6.12 | icon | 币种-符号 | string | — | 必填 | 币种-符号 |
| 6.13 | code | 币种 | string | — | 必填 | 币种 |
| 6.14 | total_amount | 销售额 | string | — | 必填 | 销售额 |
| 6.15 | total_volume | 销量 | number | — | 必填 | 销量 |
| 6.16 | replenishment_num | 多渠道销量 | number | — | 必填 | 多渠道销量 |
| 6.17 | refund_num | 退款量 | number | — | 必填 | 退款量 |
| 6.18 | refund_amount | 退款 | number | — | 必填 | 退款 |
| 6.19 | refund_rate | 退款率 | string | — | 必填 | 退款率 |
| 6.20 | channel_fee | 发货费 | number | — | 必填 | 发货费 |
| 6.21 | commission_amount | 平台费 | number | — | 必填 | 平台费 |
| 6.22 | promotion_amount | 促销费 | number | — | 必填 | 促销费 |
| 6.23 | order_quantity | 广告订单量 | number | — | 必填 | 广告订单量 |
| 6.24 | sales_amount | 广告销售额 | number | — | 必填 | 广告销售额 |
| 6.25 | total_spend | 广告费 | number | — | 必填 | 广告费 |
| 6.26 | total_cg_price | 采购成本 | number | — | 必填 | 采购成本 |
| 6.27 | other_order_fee | 测评费 | number | — | 必填 | 测评费 |
| 6.28 | total_cg_transport_costs | 头程费用 | number | — | 必填 | 头程费用 |
| 6.29 | gross_profit | 毛利润 | number | — | 必填 | 毛利润 |
| 6.30 | profit_rate | 毛利率 | string | — | 必填 | 毛利率 |
| 7 | total | 记录数 | integer | | 必填 | 记录数 |
领星ERP的接口:查询利润统计(旧) - MSKU(/erp/sc/routing/finance/ProfitStatis/profitMsku),由轻易云数据集成平台 API 资产管理模块整理收纳,并随领星ERP版本更新同步更新。