Qeasy Cloud
Get Started

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

Platform
领星ERP
Type
WebAPI
Effect
QUERY
API Version
1.0
Adapter
\Adapter\LingXing\LXQueryAdapter
Auth Mode
OTHER
Description
统计 · POST · 请求参数 8 个(必填 4) · 响应参数 37 个 · 限流令牌桶容量 1
Updated At
2026-11-21

查询利润统计(旧) - MSKU

POST/erp/sc/routing/finance/ProfitStatis/profitMsku
Factory
{
  "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
  }
}

Request Parameters

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

Response Parameters

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

Need to integrate this API?

Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.