轻易云
注册体验

领星ERP查询订单利润 - MSKU接口

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

查询订单利润 - MSKU

POST/basicOpen/finance/mreport/OrderProfit
加工厂
{
  "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": ""
      }
    ]
  }
}

接口请求参数

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

接口响应参数

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

领星ERP的接口:查询订单利润 - MSKU(/basicOpen/finance/mreport/OrderProfit),由轻易云数据集成平台 API 资产管理模块整理收纳,并随领星ERP版本更新同步更新。

需要对接这个接口?

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