轻易云
注册体验

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

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

查询利润统计 - MSKU

POST/bd/profit/statistics/open/msku/list
加工厂
{
  "operation": {
    "method": "POST",
    "path": "/bd/profit/statistics/open/msku/list"
  },
  "protocol": "HTTPS",
  "host": "https://openapi.lingxing.com",
  "rateLimit": {
    "tokenBucketCapacity": 10,
    "text": ""
  },
  "requestExample": {
    "offset": 0,
    "length": 1,
    "sids": [
      104
    ],
    "startDate": "2023-07-16",
    "endDate": "2023-07-21",
    "searchField": "msku",
    "searchValue": [
      "test123"
    ],
    "currencyCode": "CNY"
  },
  "responseExample": {
    "code": 0,
    "msg": null,
    "data": {
      "records": [
        {
          "totalFbaAndFbmQuantity": 0,
          "totalFbaAndFbmAmount": 0,
          "id": "52536",
          "dataDate": "2023-07-18",
          "smallImageUrl": "https://xxx/xxxx.jpg",
          "msku": "test123",
          "asin": "B07DFKF9SG",
          "sid": 104,
          "storeName": "A1MQMW3JWPNCBX-US",
          "countryCode": "US",
          "country": "美国",
          "localName": "123测试",
          "localSku": "23",
          "itemName": "Xenstar Swim Goggles,",
          "principalRealname": "xxx",
          "listingTagIds": "907224269891252258,907340940162893052",
          "categoryName": "",
          "brandName": "",
          "currencyCode": "USD  ",
          "currencyIcon": "$     ",
          "totalSalesQuantity": 0,
          "fbaSalesQuantity": 0,
          "fbmSalesQuantity": 0,
          "totalReshipQuantity": 1,
          "reshipFbmProductSalesQuantity": 0,
          "reshipFbmProductSaleRefundsQuantity": 1,
          "reshipFbaProductSalesQuantity": 0,
          "reshipFbaProductSaleRefundsQuantity": 0,
          "mcFbaFulfillmentFeesQuantity": 0,
          "totalAdsSales": 0,
          "adsSdSales": 0,
          "adsSpSales": 0,
          "totalAdsSalesQuantity": 0,
          "adsSdSalesQuantity": 0,
          "adsSpSalesQuantity": 0,
          "totalSalesAmount": 0,
          "fbaSaleAmount": 0,
          "fbmSaleAmount": 0,
          "totalSalesAmountWithTax": 0,
          "shippingCredits": 0,
          "promotionalRebates": 0,
          "fbaInventoryCredit": 0,
          "cashOnDelivery": 0,
          "otherInAmount": 0,
          "giftWrapCredits": 0,
          "guaranteeClaims": 0,
          "costOfPoIntegersGranted": 0,
          "fbaLiquidationProceeds": 0,
          "fbaLiquidationProceedsAdjustments": 0,
          "amazonShippingReimbursement": 0,
          "safeTReimbursement": 0,
          "netcoTransaction": 0,
          "reimbursements": 0,
          "clawbacks": 0,
          "sharedComminglingVatIncome": 0,
          "others": 0,
          "totalSalesRefunds": -0.01,
          "fbaSalesRefunds": 0,
          "fbmSalesRefunds": -0.01,
          "shippingCreditRefunds": 0,
          "giftWrapCreditRefunds": 0,
          "chargebacks": 0,
          "costOfPoIntegersReturned": 0,
          "promotionalRebateRefunds": 0,
          "totalFeeRefunds": 0,
          "sellingFeeRefunds": 0,
          "fbaTransactionFeeRefunds": 0,
          "refundAdministrationFees": 0,
          "otherTransactionFeeRefunds": 0,
          "refundForAdvertiser": 0,
          "pointsAdjusted": 0,
          "shippingLabelRefunds": 0,
          "refundsQuantity": 1,
          "refundsRate": 0,
          "fbaReturnsQuantity": 0,
          "fbaReturnsSaleableQuantity": 0,
          "fbaReturnsUnsaleableQuantity": 0,
          "platformFee": 0,
          "fbaDeliveryFee": 0,
          "otherTransactionFees": 0,
          "totalAdsCost": 0,
          "adsSpCost": 0,
          "adsSbCost": 0,
          "adsSbvCost": 0,
          "adsSdCost": 0,
          "sharedCostOfAdvertising": null,
          "promotionFee": 0,
          "sharedSubscriptionFee": 0,
          "sharedLdFee": 0,
          "sharedCouponFee": 0,
          "sharedEarlyReviewerProgramFee": 0,
          "sharedVineFee": 0,
          "totalStorageFee": 0,
          "fbaStorageFee": 0,
          "sharedFbaStorageFee": 0,
          "longTermStorageFee": 0,
          "sharedLongTermStorageFee": 0,
          "sharedStorageRenewalBilling": 0,
          "sharedFbaDisposalFee": 0,
          "sharedFbaRemovalFee": 0,
          "sharedFbaInboundTransportationProgramFee": 0,
          "sharedLabelingFee": 0,
          "sharedPolybaggingFee": 0,
          "sharedBubblewrapFee": 0,
          "sharedTapingFee": 0,
          "sharedFbaCustomerReturnFee": 0,
          "sharedFbaInboundDefectFee": 0,
          "sharedFbaOverageFee": 0,
          "sharedAmazonPartneredCarrierShipmentFee": 0,
          "sharedFbaInboundConvenienceFee": 0,
          "sharedItemFeeAdjustment": 0,
          "sharedOtherFbaInventoryFees": 0,
          "sharedFbaIntegerernationalInboundFee": 0,
          "adjustments": 0,
          "totalPlatformOtherFee": 0,
          "shippingLabelPurchases": 0,
          "sharedChargesToCreditCard": null,
          "sharedCarrierShippingLabelAdjustments": 0,
          "sharedLiquidationsFees": 0,
          "sharedManualProcessingFee": 0,
          "sharedOtherServiceFees": 0,
          "totalSalesTax": 0,
          "taxCollected": 0,
          "tcsIgstCollected": 0,
          "tcsSgstCollected": 0,
          "tcsCgstCollected": 0,
          "sharedComminglingVatExpenses": 0,
          "sharedTaxAdjustment": 0,
          "salesTaxRefund": -0.11,
          "taxRefunded": -0.11,
          "tcsIgstRefunded": 0,
          "tcsSgstRefunded": 0,
          "tcsCgstRefunded": 0,
          "salesTaxWithheld": 0,
          "refundTaxWithheld": 0.11,
          "tdsSection194ONet": 0,
          "customOrderFee": 0,
          "customOrderFeePrincipal": 0,
          "customOrderFeeCommission": 0,
          "estimateFeeStr": null,
          "cgPrice": 0,
          "hasCgPriceDetail": 0,
          "cgUnitPrice": 0,
          "proportionOfCg": 0,
          "cgTransportCosts": 0,
          "hasCgTransportCostsDetail": 0,
          "firstTripUnitPrice": 0,
          "proportionOfCgTransport": 0,
          "cgOtherCostsTotal": 0,
          "cgOtherUnitCosts": 0,
          "hasCgOtherCostsDetail": 0,
          "proportionOfCgOtherCosts": 0,
          "totalCost": 0,
          "proportionOfTotalCost": 0,
          "grossProfit": -0.01,
          "grossProfitWithTax": -0.01,
          "grossRate": 0,
          "grossRateWithTax": 0.0909,
          "taxCollectedGiftWrap": 0,
          "taxCollectedShipping": 0,
          "taxCollectedDiscount": 0,
          "taxCollectedProduct": 0,
          "taxRefundedGiftWrap": 0,
          "taxRefundedShipping": 0,
          "taxRefundedDiscount": 0,
          "taxRefundedProduct": 0,
          "alarmInfo": null
        }
      ],
      "total": 1
    }
  }
}

接口请求参数

序号字段名称类型默认值必填描述
1offset分页偏移量integer—可选分页偏移量
2length分页长度integer—可选分页长度,上限10000
3mids站点idarray<any>—可选站点id
4sids店铺idarray<any>—可选店铺id ,对应查询亚马逊店铺列表接口对应字段【sid】
5startDate开始时间string—必填开始时间,双闭区间【开始结束时间间隔最长不能跨度7天】
6endDate结束时间string—必填结束时间,双闭区间【开始结束时间间隔最长不能跨度7天】
7searchField搜索值类型string—可选搜索值类型:msku
8searchValue搜索值array<any>—可选搜索值
9currencyCode币种codestring—可选币种code

接口响应参数

序号字段名称类型默认值必填描述
1code状态码int—可选状态码,0 成功
2msg消息提示string—可选消息提示
3data响应数据array—可选响应数据
3.1total总数int—可选总数
3.2records查询数据列表array—可选查询数据列表
3.2.1totalFbaAndFbmQuantityfba和fbm销量加总int—可选fba和fbm销量加总,用于计算占比
3.2.2totalFbaAndFbmAmountfba和fbm销售额加总number—可选fba和fbm销售额加总,用于计算占比
3.2.3id记录id【非业务唯一键string—可选记录id【非业务唯一键,已废弃不再返回】
3.2.4dataDate日期string—可选日期
3.2.5smallImageUrl图片string—可选图片
3.2.6mskumskustring—可选msku
3.2.7asinasinstring—可选asin
3.2.8sidsidint—可选sid
3.2.9storeName店铺string—可选店铺
3.2.10countryCode国家编码string—可选国家编码
3.2.11country国家string—可选国家
3.2.12localName品名string—可选品名
3.2.13localSku本地SKUstring—可选本地SKU
3.2.14itemName标题string—可选标题
3.2.15principalRealname负责人string—可选负责人
3.2.16listingTagIdslisting标签idstring—可选listing标签id
3.2.17categoryName分类string—可选分类
3.2.18brandName品牌string—可选品牌
3.2.19currencyCode币种string—可选币种
3.2.20currencyIcon币种符号string—可选币种符号
3.2.21totalSalesQuantity销量int—可选销量
3.2.22fbaSalesQuantityFBA销量int—可选FBA销量
3.2.23fbmSalesQuantityFBM销量int—可选FBM销量
3.2.24totalReshipQuantity补换货量int—可选补换货量
3.2.25reshipFbmProductSalesQuantityFBM补(换)货量int—可选FBM补(换)货量
3.2.26reshipFbmProductSaleRefundsQuantityFBM补(换)货退回量int—可选FBM补(换)货退回量
3.2.27reshipFbaProductSalesQuantityFBA补(换)货量int—可选FBA补(换)货量
3.2.28reshipFbaProductSaleRefundsQuantityFBA补(换)货退回量int—可选FBA补(换)货退回量
3.2.29mcFbaFulfillmentFeesQuantity多渠道销量int—可选多渠道销量
3.2.30totalAdsSales广告销售额number—可选广告销售额
3.2.31adsSdSalessd广告销售额number—可选sd广告销售额
3.2.32adsSpSalessp广告销售额number—可选sp广告销售额
3.2.33totalAdsSalesQuantity广告销量number—可选广告销量
3.2.34adsSdSalesQuantitysd广告销量number—可选sd广告销量
3.2.35adsSpSalesQuantitysp广告销量number—可选sp广告销量
3.2.36totalSalesAmount销售额number—可选销售额
3.2.37fbaSaleAmountFBA销售额number—可选FBA销售额
3.2.38fbmSaleAmountFBM销售额number—可选FBM销售额
3.2.39totalSalesAmountWithTax含税销售额number—可选含税销售额
3.2.40shippingCredits买家运费number—可选买家运费
3.2.41promotionalRebates促销折扣number—可选促销折扣
3.2.42fbaInventoryCreditFBA库存赔偿number—可选FBA库存赔偿
3.2.43cashOnDeliverycashOnDeliverynumber—可选COD
3.2.44otherInAmount其他收入number—可选其他收入
3.2.45giftWrapCredits包装收入number—可选包装收入
3.2.46guaranteeClaims买家交易保障索赔额number—可选买家交易保障索赔额
3.2.47costOfPoIntegersGranted积分抵减收入number—可选积分抵减收入
3.2.48fbaLiquidationProceeds清算收入number—可选清算收入
3.2.49fbaLiquidationProceedsAdjustments清算调整number—可选清算调整
3.2.50amazonShippingReimbursement亚马逊运费赔偿number—可选亚马逊运费赔偿
3.2.51safeTReimbursementSafe-T索赔number—可选Safe-T索赔
3.2.52netcoTransactionNetco交易number—可选Netco交易
3.2.53reimbursements赔偿收入number—可选赔偿收入
3.2.54clawbacks追索收入number—可选追索收入
3.2.55sharedComminglingVatIncome混合VAT收入number—可选混合VAT收入
3.2.56others其他number—可选其他
3.2.57totalSalesRefunds收入退款额number—可选收入退款额
3.2.58fbaSalesRefundsFBA销售退款额number—可选FBA销售退款额
3.2.59fbmSalesRefundsFBM销售退款额number—可选FBM销售退款额
3.2.60shippingCreditRefunds买家运费退款额number—可选买家运费退款额
3.2.61giftWrapCreditRefunds买家包装退款额number—可选买家包装退款额
3.2.62chargebacks买家拒付number—可选买家拒付
3.2.63costOfPoIntegersReturned积分抵减退回number—可选积分抵减退回
3.2.64promotionalRebateRefunds促销折扣退款额number—可选促销折扣退款额
3.2.65totalFeeRefunds费用退款额number—可选费用退款额
3.2.66sellingFeeRefunds平台费退款额number—可选平台费退款额
3.2.67fbaTransactionFeeRefunds发货费退款额number—可选发货费退款额
3.2.68refundAdministrationFees交易费用退款额number—可选交易费用退款额
3.2.69otherTransactionFeeRefunds其他订单费退款额number—可选其他订单费退款额
3.2.70refundForAdvertiser广告退款额number—可选广告退款额
3.2.71pointsAdjusted积分费用number—可选积分费用
3.2.72shippingLabelRefunds运输标签费退款number—可选运输标签费退款
3.2.73refundsQuantity退款量int—可选退款量
3.2.74refundsRate退款率number—可选退款率
3.2.75fbaReturnsQuantity退货量int—可选退货量
3.2.76fbaReturnsSaleableQuantity退货量(可售)int—可选退货量(可售)
3.2.77fbaReturnsUnsaleableQuantity退货量(不可售)int—可选退货量(不可售)
3.2.78platformFee平台费number—可选平台费
3.2.79fbaDeliveryFeeFBA发货费number—可选FBA发货费
3.2.80otherTransactionFees其他订单费用number—可选其他订单费用
3.2.81totalAdsCost广告费number—可选广告费
3.2.82adsSpCostSP广告费number—可选SP广告费
3.2.83adsSbCostSB广告费number—可选SB广告费
3.2.84adsSbvCostSBV广告费number—可选SBV广告费
3.2.85adsSdCostSD广告费number—可选SD广告费
3.2.86sharedCostOfAdvertising差异分摊number—可选差异分摊
3.2.87promotionFee推广费number—可选推广费
3.2.88sharedAdsAlCostLive广告number—可选Live广告
3.2.89sharedAdsCcCost创作者计划number—可选创作者计划
3.2.90sharedAdsSspaotCostTV广告number—可选TV广告
3.2.91sharedAdsSarCost零售商赞助广告number—可选零售商赞助广告
3.2.92sharedSubscriptionFee订阅费number—可选订阅费
3.2.93sharedLdFee秒杀费number—可选秒杀费
3.2.94sharedCouponFee优惠券number—可选优惠券
3.2.95sharedEarlyReviewerProgramFee早期评论人计划number—可选早期评论人计划
3.2.96sharedVineFeesharedVineFeenumber—可选vine
3.2.97totalStorageFeeFBA仓储费number—可选FBA仓储费
3.2.98fbaStorageFee月度仓库费number—可选月度仓库费
3.2.99sharedFbaStorageFee月度仓储费差异number—可选月度仓储费差异
3.2.100longTermStorageFee长期仓储费number—可选长期仓储费
3.2.101sharedLongTermStorageFee长期仓储费差异number—可选长期仓储费差异
3.2.102sharedStorageRenewalBilling库存续订费用number—可选库存续订费用
3.2.103sharedFbaDisposalFeeFBA销毁费number—可选FBA销毁费
3.2.104sharedFbaRemovalFeeFBA移除费number—可选FBA移除费
3.2.105sharedFbaInboundTransportationProgramFee入仓手续费number—可选入仓手续费
3.2.106sharedLabelingFee标签费number—可选标签费
3.2.107sharedPolybaggingFee塑料包装费number—可选塑料包装费
3.2.108sharedBubblewrapFee泡沫包装费number—可选泡沫包装费
3.2.109sharedTapingFee胶带费number—可选胶带费
3.2.110sharedFbaCustomerReturnFeeFBA卖家退回费number—可选FBA卖家退回费
3.2.111sharedFbaInboundDefectFee计划外服务费number—可选计划外服务费
3.2.112sharedFbaOverageFee超量仓储费number—可选超量仓储费
3.2.113sharedAmazonPartneredCarrierShipmentFee合作承运费number—可选合作承运费
3.2.114sharedFbaInboundConvenienceFee入库配置费number—可选入库配置费
3.2.115sharedItemFeeAdjustment库存调整费用number—可选库存调整费用
3.2.116sharedOtherFbaInventoryFees其他仓储费number—可选其他仓储费
3.2.117sharedFbaIntegerernationalInboundFeeFBA国际物流货运费number—可选FBA国际物流货运费
3.2.118adjustments调整费用number—可选调整费用
3.2.119totalPlatformOtherFee平台其他费number—可选平台其他费
3.2.120shippingLabelPurchases运输标签费number—可选运输标签费
3.2.121sharedChargesToCreditCard信用卡扣款number—可选信用卡扣款
3.2.122sharedCarrierShippingLabelAdjustments承运人装运标签调整费number—可选承运人装运标签调整费
3.2.123sharedLiquidationsFees清算费number—可选清算费
3.2.124sharedManualProcessingFee人工处理费用number—可选人工处理费用
3.2.125sharedOtherServiceFees其他服务费number—可选其他服务费
3.2.126totalSalesTax销售税number—可选销售税
3.2.127taxCollectedVAT/GSTnumber—可选VAT/GST
3.2.128tcsIgstCollectedtcsIgstCollectednumber—可选TCS-IGST
3.2.129tcsSgstCollectedtcsSgstCollectednumber—可选TCS-SGST
3.2.130tcsCgstCollectedtcsCgstCollectednumber—可选TCS-CGST
3.2.131sharedComminglingVatExpenses混合VATnumber—可选混合VAT
3.2.132sharedTaxAdjustment销售税调整number—可选销售税调整
3.2.133salesTaxRefund销售税退款额number—可选销售税退款额
3.2.134taxRefundedVAT/GSTnumber—可选VAT/GST
3.2.135tcsIgstRefundedtcsIgstRefundednumber—可选TCS-IGST
3.2.136tcsSgstRefundedtcsSgstRefundednumber—可选TCS-SGST
3.2.137tcsCgstRefundedtcsCgstRefundednumber—可选TCS-CGST
3.2.138salesTaxWithheld市场税number—可选市场税
3.2.139refundTaxWithheld市场税退款额number—可选市场税退款额
3.2.140tdsSection194ONet混合网路费用number—可选混合网路费用
3.2.141customOrderFee订单其他费number—可选订单其他费
3.2.142customOrderFeePrincipal站外推广费-本金number—可选站外推广费-本金
3.2.143customOrderFeeCommission站外推广费-佣金number—可选站外推广费-佣金
3.2.144estimateFeeStr预估费用array—可选预估费用
3.2.144.1id费用idstring—可选费用id
3.2.144.2name费用名称string—可选费用名称
3.2.144.3amount费用金额number—可选费用金额
3.2.145cgPrice采购成本number—可选采购成本
3.2.146hasCgPriceDetail是否有采购成本明细int—可选是否有采购成本明细
3.2.147cgUnitPrice采购单价number—可选采购单价
3.2.148proportionOfCg采购占比number—可选采购占比
3.2.149cgTransportCosts头程运费number—可选头程运费
3.2.150hasCgTransportCostsDetail是否有物流(头程)成本明细int—可选是否有物流(头程)成本明细
3.2.151firstTripUnitPrice头程单价number—可选头程单价
3.2.152proportionOfCgTransport头程占比number—可选头程占比
3.2.153cgOtherCostsTotal其他成本number—可选其他成本
3.2.154cgOtherUnitCosts其他单价number—可选其他单价
3.2.155hasCgOtherCostsDetail是否有其他成本明细int—可选是否有其他成本明细
3.2.156proportionOfCgOtherCosts其他成本占比number—可选其他成本占比
3.2.157totalCost合计成本number—可选合计成本
3.2.158proportionOfTotalCost合计成本占比number—可选合计成本占比
3.2.159grossProfit毛利润number—可选毛利润
3.2.160grossProfitWithTax含税毛利润number—可选含税毛利润
3.2.161grossRate毛利率number—可选毛利率
3.2.162grossRateWithTax含税毛利率number—可选含税毛利率
3.2.163taxCollectedGiftWrap销售税-礼品包装税number—可选销售税-礼品包装税
3.2.164taxCollectedShipping销售税-买家运费税number—可选销售税-买家运费税
3.2.165taxCollectedDiscount销售税-促销折扣税number—可选销售税-促销折扣税
3.2.166taxCollectedProduct销售税-商品价格税number—可选销售税-商品价格税
3.2.167taxRefundedGiftWrap销售税退款-礼品包装税number—可选销售税退款-礼品包装税
3.2.168taxRefundedShipping销售税退款-买家运费税number—可选销售税退款-买家运费税
3.2.169taxRefundedDiscount销售税退款-促销折扣税number—可选销售税退款-促销折扣税
3.2.170taxRefundedProduct销售税退款-商品价格税number—可选销售税退款-商品价格税
3.2.171alarmInfo监控信息object—可选监控信息
3.2.171.1profitMetric监控指标string—可选监控指标: amount 销售额 gross 毛利润 gross_percent 毛利率 ads_sped 广告费 ads_sped_percent 广告费占比 warehouse_sped 仓储费 warehouse_sped_percent 仓储费占比
3.2.171.2valueType数值类型string—可选数值类型:absolute 绝对值、percent 百分比
3.2.171.3compareType比较类型string—可选比较类型:great_than、less_than
3.2.171.4compareValue比较值string&nbsp;可选比较值
3.2.172postedDateLocale按天汇总string—可选按天汇总
3.2.173sharedAdsSbSalessb广告销售额number—可选sb广告销售额
3.2.174sharedAdsSbvSalessbv广告销售额number—可选sbv广告销售额
3.2.175sharedAdsSbSalesQuantitysb广告销量int—可选sb广告销量
3.2.176sharedAdsSbvSalesQuantitysbv广告销量int—可选sbv广告销量
3.2.177sharedAdsAlCostLive广告number—可选Live广告
3.2.178sharedAdsCcCost创作者计划number—可选创作者计划
3.2.179sharedAdsSspaotCostST广告number—可选ST广告
3.2.180sharedAdsSarCost零售商赞助广告number—可选零售商赞助广告
3.2.181sharedAwdProcessingFeeAWD处理费number—可选AWD处理费
3.2.182sharedAwdTransportationFeeAWD运输费number—可选AWD运输费
3.2.183sharedAwdStorageFeeAWD仓储费number—可选AWD仓储费
3.2.184sharedStarStorageFee卫星仓仓储费number—可选卫星仓仓储费
3.2.185sharedFbaInboundDefectFee计划外服务费number—可选计划外服务费
3.2.186fbaStorageFeeAccrual月仓储费-本月计提number—可选月仓储费-本月计提
3.2.187fbaStorageFeeAccrualDifference月仓储费-上月冲销number—可选月仓储费-上月冲销
3.2.188longTermStorageFeeAccrual长期仓储费-本月计提number—可选长期仓储费-本月计提
3.2.189longTermStorageFeeAccrualDifference长期仓储费-上月冲销number—可选长期仓储费-上月冲销
3.2.190sharedMfnPostageFeemfn邮费number—可选mfn邮费
3.2.191sharedReceivablesDeductions透明计划标签费number—可选透明计划标签费
3.2.192sharedAmazonShippingChargeAdjustments亚马逊物流运费调整number—可选亚马逊物流运费调整

领星ERP的接口:查询利润统计 - MSKU(/bd/profit/statistics/open/msku/list),由轻易云数据集成平台 API 资产管理模块整理收纳,并随领星ERP版本更新同步更新。

需要对接这个接口?

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