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 个(必填 2) · 响应参数 143 个 · 限流令牌桶容量 1
Updated At
2026-11-21

查询订单利润 - MSKU

POST/basicOpen/finance/mreport/OrderProfit
Factory
{
  "operation": {
    "method": "POST",
    "path": "/basicOpen/finance/mreport/OrderProfit"
  },
  "protocol": "HTTPS",
  "host": "https://openapi.lingxing.com",
  "rateLimit": {
    "tokenBucketCapacity": 1,
    "text": ""
  },
  "requestExample": "curl --location 'https://openapi.lingxing.com/basicOpen/finance/mreport/OrderProfit?access_token=value&timestamp=value&sign=value&app_key=value' \\\n--header 'Content-Type: application/json' \\\n--data '{\n    \"offset\": 0,\n    \"length\": 20,\n    \"sids\": [113,115],\n    \"startDate\": \"2023-02-01\",\n    \"endDate\": \"2023-12-05\",\n    \"searchField\": \"asin\",\n    \"searchValue\": [\"B09\"],\n    \"currencyCode\": \"CNY\"\n}'",
  "responseExample": {
    "code": 0,
    "message": "success",
    "error_details": [],
    "request_id": "574FB0B8-FD6E-8D29-91FD-295B55CF5398",
    "response_time": "2024-07-31 14:41:25",
    "data": [
      {
        "model": "MODEL-001",
        "currency_code": "USD",
        "currency_icon": "$",
        "gross_profit": "0.00",
        "gross_margin": "0.0000",
        "avg_gross_profit": "0.00",
        "volume": 0,
        "replacement_quantity": 0,
        "multi_channel_volume": 0,
        "ad_sales_amount": "0.00",
        "ad_volume": 0,
        "amount": "0.00",
        "afn_amount": "",
        "mfn_amount": "",
        "tax_amount": "0.00",
        "refund_amount": "0.00",
        "refund_amount_rate": "0.00",
        "shipping_cost": "0.00",
        "promotion_discount": "0.00",
        "pm_discount": "",
        "sp_discount": "",
        "return_quantity": 0,
        "return_rate": "0.0000",
        "selling_fee": "0.00",
        "fulfillment_fee": "0.00",
        "other_order_fee": "0.00",
        "spend": "0.00",
        "ads_sb_cost": "0.00",
        "ads_sbv_cost": "0.00",
        "ads_sd_cost": "0.00",
        "ads_sp_cost": "0.00",
        "purchase_costs": "0.00",
        "avg_purchase_costs": "0.00",
        "logistics_costs": "0.00",
        "avg_logistics_costs": "0.00",
        "other_costs": "0.00",
        "avg_other_costs": "0.00",
        "total_costs": "0.00",
        "price_list": [
          {
            "principal_uids": "10529123",
            "local_sku": "4990a126a7b36350f4916c8f642fa811",
            "item_name": "lingxing amazon product title A8442DB",
            "cate_title": "分类5",
            "local_name": "64fea5cf204b8d40d9b174d12d799a03",
            "sid": "2",
            "is_delete": "1",
            "brand_title": "",
            "volume": 0,
            "small_main_image_url": "",
            "site_url": "",
            "parent_asin": "BFF23E679B",
            "seller_sku": "5ebabc80e8d38aec1ee098fdc6bf99f9",
            "asin": "BFF23E679B",
            "status": "0"
          }
        ],
        "is_parent": false,
        "small_image_url": "",
        "parent_asins": [
          "BFF23E679B"
        ],
        "local_infos": [
          {
            "local_sku": "4990a126a7b36350f4916c8f642fa811",
            "local_name": "64fea5cf204b8d40d9b174d12d799a03"
          }
        ],
        "asins": [
          {
            "asin_url": "",
            "asin": "BFF23E679B"
          }
        ],
        "sids": [
          "2"
        ],
        "item_name": "",
        "categories": [
          "分类5"
        ],
        "seller_store_countries": [
          {
            "country": "美国",
            "name": ""
          }
        ],
        "brands": [],
        "refund_quantity": "",
        "principal_names": "",
        "ad_sales_amount_sp": "",
        "ad_sales_amount_sd": "",
        "ad_sales_amount_sb": "",
        "ad_sales_amount_sbv": "",
        "ad_volume_sp": "",
        "ad_volume_sd": "",
        "ad_volume_sb": "",
        "ad_volume_sbv": "",
        "afn_volume": "",
        "mfn_volume": ""
      }
    ]
  }
}

Request Parameters

No.FieldNameTypeDefaultRequiredDescription
1offset分页偏移量integer—Optional分页偏移量,默认0
2length分页长度integer—Optional分页长度,默认20,上限5000
3sids店铺idarray<any>—Optional店铺id ,对应查询亚马逊店铺列表接口对应字段【sid】
4startDate查询时间string—Required查询时间,双闭区间,格式:Y-m-d 或 Y-m-d H:i:s
5endDate查询时间string—Required查询时间,双闭区间,格式:Y-m-d 或 Y-m-d H:i:s
6searchField搜索值类型string—Optional搜索值类型: seller_sku 卖家SKU asin ASIN local_name 本地名称 local_sku 本地SKU model 型号 parent_asin 父ASIN;默认 seller_sku
7searchValue搜索的值array<any>—Optional搜索的值
8currencyCode币种code【默认原币种】string—Optional币种code【默认原币种】, 可选值:原币种,CNY,USD,EUR,JPY,AUD,CAD,MXN,GBP,INR,AED,SGD,SAR,BRL,SEK,PLN,TRY,HKD

Response Parameters

No.FieldNameTypeDefaultRequiredDescription
1code状态码integer—Required状态码,0:成功
2message消息提示string—Required消息提示
3error_details数据校验失败时的错误详情array<any>—Required数据校验失败时的错误详情
4request_id请求链路idstring—Required请求链路id
5response_time响应时间string—Required响应时间
6total总数integer—Required总数
7data数据array<object>—Required数据
7.1model型号stringMODEL-001Required型号,取内部 model 数组的第一个值;未返回或无值时为空字符串
7.2currency_code币种string—Required币种
7.3currency_icon币种符号string—Required币种符号
7.4gross_profit毛利润string—Required毛利润
7.5gross_margin毛利率string—Required毛利率
7.6avg_gross_profit平均毛利润string—Required平均毛利润
7.7volume销量number—Required销量
7.8replacement_quantity补换货量number—Required补换货量
7.9multi_channel_volume多渠道销量number—Required多渠道销量
7.10ad_sales_amount广告销售额string—Required广告销售额
7.11ad_volume广告销量number—Required广告销量
7.12amount销售额string—Required销售额
7.13tax_amount含税销售额string—Required含税销售额
7.14refund_amount退款金额string—Required退款金额
7.15refund_amount_rate退款率string—Required退款率
7.16shipping_cost买家运费string—Required买家运费
7.17promotion_discount促销折扣string—Required促销折扣
7.18return_quantity退货量number—Required退货量
7.19return_rate退货率string—Required退货率
7.20selling_fee平台费string—Required平台费
7.21fulfillment_feefba发货费(包含亚马逊物流客户退货费)string—Requiredfba发货费(包含亚马逊物流客户退货费)
7.22other_order_fee其他订单费用string—Required其他订单费用
7.23spend花费string—Required花费
7.24ads_sb_costsb花费string—Requiredsb花费
7.25ads_sbv_costsbv花费string—Requiredsbv花费
7.26ads_sd_costsd花费string—Requiredsd花费
7.27ads_sp_costsp花费string—Requiredsp花费
7.28purchase_costs采购成本string—Required采购成本
7.29avg_purchase_costs采购均价string—Required采购均价
7.30logistics_costs头程成本string—Required头程成本
7.31avg_logistics_costs头程均价string—Required头程均价
7.32other_costs其他成本string—Required其他成本
7.33avg_other_costs其他均价string—Required其他均价
7.34total_costs合计成本string—Required合计成本
7.35price_list商品基础信息array<object>—Required商品基础信息
7.35.1principal_uidsprincipal_uidsstring—Required
7.35.2local_skulocal_skustring—Requiredsku
7.35.3item_name标题string—Required标题
7.35.4cate_titlecate_titlestring—Required
7.35.5local_namelocal_namestring—Required
7.35.6sidsidstring—Required
7.35.7is_deleteis_deletestring—Required
7.35.8brand_titlebrand_titlestring—Required
7.35.9volumevolumenumber—Required
7.35.10small_main_image_urlsmall_main_image_urlstring—Required
7.35.11site_urlsite_urlstring—Required
7.35.12parent_asinparent_asinstring—Required
7.35.13seller_skuseller_skustring—Required
7.35.14asinasinstring—Required
7.35.15statusstatusstring—Required
7.36is_parent是否有子项boolean—Required是否有子项
7.37small_image_url图片链接string—Required图片链接
7.38parent_asins父asinarray<any>—Required父asin
7.39local_infos本地商品信息array<object>—Required本地商品信息
7.39.1local_skulocal_skustring—Required
7.39.2local_namelocal_namestring—Required
7.40asinsasinsarray<object>—Requiredasin
7.40.1asin_urlasin_urlstring—Required
7.40.2asinasinstring—Required
7.41sids店铺idarray<any>—Required店铺id,在msku维度数组中只有一条数据
7.42item_name品名string—Required品名
7.43categories分类array<any>—Required分类
7.44seller_store_countries国家array<object>—Required国家
7.44.1countrycountrystring—Required
7.44.2namenamestring—Required
7.45brands品牌array<any>—Required品牌
7.46refund_quantity退款量string—Required退款量
7.47principal_nameslisting负责人string—Requiredlisting负责人
7.48ad_sales_amount_spsp广告销售额number—Requiredsp广告销售额
7.49ad_sales_amount_sdsd广告销售额number—Requiredsd广告销售额
7.50ad_sales_amount_sbsb广告销售额number—Requiredsb广告销售额
7.51ad_sales_amount_sbvsbv广告销售额number—Requiredsbv广告销售额
7.52ad_volume_spsp广告销量integer—Requiredsp广告销量
7.53ad_volume_sdsd广告销量integer—Requiredsd广告销量
7.54ad_volume_sbsb广告销量integer—Requiredsb广告销量
7.55ad_volume_sbvsbv广告销量integer—Requiredsbv广告销量
7.56afn_volumefba销量integer—Requiredfba销量
7.57mfn_volumefbm销量integer—Requiredfbm销量
7.58afn_amountfba销售额number—Requiredfba销售额
7.59mfn_amountfbm销售额number—Requiredfbm销售额
7.60pm_discount价格折扣number—Required价格折扣
7.61sp_discount配送折扣number—Required配送折扣
7.62net_gross_margin净毛利率string—Required净毛利率
7.63avg_volume平均日销number—Required平均日销
7.64net_amount净销售额string—Required净销售额
7.65avg_net_amount平均售价string—Required平均售价
7.66selling_fee_rate平台费占比string—Required平台费占比
7.67fulfillment_fee_rateFBA发货费占比string—RequiredFBA发货费占比
7.68spend_rate广告费率string—Required广告费率
7.69total_stock_fee仓储费string—Required仓储费
7.70total_stock_fee_rate仓储费占比string—Required仓储费占比
7.71promotion_fee推广费string—Required推广费
7.72shared_fba_international_inbound_feeFBA国际物流运费string—RequiredFBA国际物流运费
7.73adjustments_fee调整费string—Required调整费
7.74selling_other_fee平台其他费string—Required平台其他费
7.75inventory_creditFBA库存赔偿string—RequiredFBA库存赔偿
7.76shared_fba_inbound_convenience_fee入库配置费string—Required入库配置费
7.77cost_of_points_granted积分收入string—Required积分收入
7.78shared_cost_of_advertising差异分摊string—Required差异分摊
7.79total_other_granted其它收入string—Required其它收入
7.80shared_fba_liquidation_proceeds清算收入string—Required清算收入
7.81shared_fba_liquidation_proceeds_adjustments清算调整string—Required清算调整
7.82shared_amazon_shipping_reimbursement亚马逊运费赔偿string—Required亚马逊运费赔偿
7.83shared_safe_t_reimbursementSafe-T索赔string—RequiredSafe-T索赔
7.84shared_netco_transactionNetco交易string—RequiredNetco交易
7.85shared_reimbursements赔偿收入string—Required赔偿收入
7.86shared_clawbacks追索收入string—Required追索收入
7.87shared_commingling_vat_income混合VAT收入string—Required混合VAT收入
7.88gift_wrap_credits包装收入string—Required包装收入
7.89a_to_z_guarantee_claims买家交易保障索赔额string—Required买家交易保障索赔额
7.90shared_others其他string—Required其他
7.91fba_storage_fee月仓储费string—Required月仓储费
7.92shared_fba_storage_fee月仓储费差异string—Required月仓储费差异
7.93long_term_storage_fee长期仓储费string—Required长期仓储费
7.94shared_long_term_storage_fee长期仓储费差异string—Required长期仓储费差异
7.95shared_storage_renewal_billing库存续订费string—Required库存续订费
7.96shared_fba_disposal_feeFBA销毁费string—RequiredFBA销毁费
7.97shared_fba_removal_feeFBA移除费string—RequiredFBA移除费
7.98shared_fba_inbound_transportation_program_fee入仓手续费string—Required入仓手续费
7.99shared_labeling_fee标签费string—Required标签费
7.100shared_polybagging_fee塑料包装费string—Required塑料包装费
7.101shared_bubblewrap_fee泡沫包装费string—Required泡沫包装费
7.102shared_taping_fee胶带费string—Required胶带费
7.103shared_awd_processing_feeAWD处理费string—RequiredAWD处理费
7.104shared_awd_transportation_feeAWD运输费string—RequiredAWD运输费
7.105shared_awd_storage_feeAWD仓储费string—RequiredAWD仓储费
7.106shared_star_storage_fee卫星仓仓储费string—Required卫星仓仓储费
7.107shared_fba_customer_return_feeFBA退回卖家费string—RequiredFBA退回卖家费
7.108shared_fba_inbound_defect_fee入库缺陷费string—Required入库缺陷费
7.109shared_fba_overage_fee超量仓储费string—Required超量仓储费
7.110shared_amazon_partnered_carrier_shipment_fee合作承运费string—Required合作承运费
7.111shared_item_fee_adjustment库存调整费用string—Required库存调整费用
7.112shared_other_fba_inventory_fees其他仓储费string—Required其他仓储费
7.113fba_fulfillment_feefba(对应订单列表FBA发货费)string—Requiredfba(对应订单列表FBA发货费)
7.114shared_fba_transaction_customer_return_fee亚马逊物流客户退货费string—Required亚马逊物流客户退货费
7.115off_site_promotion_fee站外推广费string—Required站外推广费

The 查询订单利润 - MSKU API (/basicOpen/finance/mreport/OrderProfit) 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.