轻易云
注册体验

领星ERP查询利润统计(旧) - MSKU接口

所属平台
领星ERP
类型
WebAPI
作用
QUERY
接口版本
1.0
适配器
\Adapter\LingXing\LXQueryAdapter
授权方式
OTHER
描述
统计 · POST · 请求参数 8 个(必填 4) · 响应参数 37 个 · 限流令牌桶容量 1
更新日期
2026-11-21

查询利润统计(旧) - MSKU

POST/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
  }
}

接口请求参数

序号字段名称类型默认值必填描述
1start_date起始日期string—必填起始日期
2end_date起始日期string—必填起始日期
3offset分页偏移量integer—必填分页偏移量
4length分页长度integer—必填分页长度,上限200
5sids店铺idstring—可选店铺id,通过逗号分隔可以多选,默认返回全部 ,对应查询亚马逊店铺列表接口对应字段【sid】
6currency_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
7sort_field排序字段string—可选排序字段:asin
8sort_typesort_typestring—可选desc:倒序 asc:顺序

接口响应参数

序号字段名称类型默认值必填描述
1code状态码integer—必填状态码,0 成功
2message消息提示stringsuccess必填消息提示
3error_details错误信息array<any>—必填错误信息
4request_id请求链路idstring8D680B8B-3C6F-3E16-F055-73DC70EAD977必填请求链路id
5response_time响应时间string2020-05-18 11:23:47必填响应时间
6data响应数据array<object>—必填响应数据
6.1mskumskustring—必填MSKU
6.2asinasinstring—必填Asin
6.3item_name标题string—必填标题
6.4local_name品名string—必填品名
6.5local_skulocal_skustring—必填SKU
6.6seller店铺string—必填店铺
6.7sid店铺idinteger—必填店铺id
6.8marketplace国家string—必填国家
6.9asin_name负责人string—必填负责人
6.10category_text分类string—必填分类
6.11product_brand_text品牌string—必填品牌
6.12icon币种-符号string—必填币种-符号
6.13code币种string—必填币种
6.14total_amount销售额string—必填销售额
6.15total_volume销量number—必填销量
6.16replenishment_num多渠道销量number—必填多渠道销量
6.17refund_num退款量number—必填退款量
6.18refund_amount退款number—必填退款
6.19refund_rate退款率string—必填退款率
6.20channel_fee发货费number—必填发货费
6.21commission_amount平台费number—必填平台费
6.22promotion_amount促销费number—必填促销费
6.23order_quantity广告订单量number—必填广告订单量
6.24sales_amount广告销售额number—必填广告销售额
6.25total_spend广告费number—必填广告费
6.26total_cg_price采购成本number—必填采购成本
6.27other_order_fee测评费number—必填测评费
6.28total_cg_transport_costs头程费用number—必填头程费用
6.29gross_profit毛利润number—必填毛利润
6.30profit_rate毛利率string—必填毛利率
7total记录数integer&nbsp;必填记录数

领星ERP的接口:查询利润统计(旧) - MSKU(/erp/sc/routing/finance/ProfitStatis/profitMsku),由轻易云数据集成平台 API 资产管理模块整理收纳,并随领星ERP版本更新同步更新。

需要对接这个接口?

轻易云已预置该接口的适配能力,联系我们即可开始配置数据集成。