Lingxing
切换旧版

查询结算利润(利润报表) - msku

POST/basicOpen/multiplatform/profit/report/msku

接口信息

API Path请求协议请求方式令牌桶容量
/basicOpen/multiplatform/profit/report/mskuHTTPSPOST1

请求参数

offsetnumber必填
分页偏移量,默认0
lengthnumber必填
分页长度,默认20,最大200
platformCodeSarray<any>
平台id:
10002 Shopify
10003 eBay
10005 AliExpress
10006 Shopee
10008 walmart
10011 Tiktok
10021 Shein平台模式
10022 Temu全托
10024 Temu半托
10028 Shein半托管
midsstring
国家id,多个使用英文逗号分隔
sidsstring
店铺id,多个使用英文逗号分隔 ,对应查询多平台店铺信息接口对应字段【store_id】
currencyCodestring
币种code:
原币种
USD
EUR
GBP
CNY
startDatestring必填
开始时间【结算日期】,闭区间,格式:Y-m-d
endDatestring必填
结束时间【结算日期】,闭区间,格式:Y-m-d
searchFieldstring
搜索值类型:
msku MSKU
local_sku SKU
platform_order_no 平台单号
searchValuestring
搜索值
developersarray<any>
开发人
cidsarray<any>
分类
bidsarray<any>
品牌

请求示例

{
    "offset": 0,
    "length": 100,
    "platformCodeS": ["10024"],
    "mids": "NA,MX,BR,US,CA",
    "sids": "110424575139430912",
    "currencyCode": "USD",
    "startDate": "2024-01-01",
    "endDate": "2024-06-30",
    "searchField": "local_sku",
    "searchValue": "test",
    "developers": [128581],
    "cids": [14],
    "bids": [2]
}

返回结果

Json Object

参数名说明必填类型示例
code状态码,0 成功是[number]0
message消息提示是[string]success
error_details错误信息是[array]
request_id请求链路id是[string]6b6cfa6db9564a13afc284ec69cba07b.1728726118087
response_time响应时间是[string]2024-10-12 17:41:59
data响应数据是[object]
data>>totalSum总计是[object]
data>>totalSum>>currencyCode币种是[string]CNY
data>>totalSum>>currencyIcon货币图标是[string]¥
data>>totalSum>>salesNum销量是[number]281
data>>totalSum>>replacementNum补货量是[number]0
data>>totalSum>>salesAmount销售额是[number]557799.61
data>>totalSum>>promotionDiscountAmount促销折扣是[number]0
data>>totalSum>>buyerFreightAmount买家运费是[number]0
data>>totalSum>>platformOtherIncomeAmount其他收入是[number]0
data>>totalSum>>incomeRefundAmount收入退款额是[number]0
data>>totalSum>>feeRefundAmount费用退款额是[number]0
data>>totalSum>>refundAmount退款金额是[number]0
data>>totalSum>>refundNum退款量是[string]0.00
data>>totalSum>>refundRate退款率是[number]0
data>>totalSum>>returnedGoodsNum退货量是[number]0
data>>totalSum>>returnedGoodsRate退货率是[number]0
data>>totalSum>>promotionAmount平台费是[number]0
data>>totalSum>>platformLogisticsAmount平台物流费是[number]0
data>>totalSum>>promotionExtendAmount推广费是[number]0
data>>totalSum>>advertisementAmount广告费是[number]0
data>>totalSum>>adjustmentCostAmount调整费是[number]0
data>>totalSum>>platformStorageAmount平台仓储费是[number]0
data>>totalSum>>platformFineAmount平台罚款是[number]0
data>>totalSum>>platformOtherAmount平台其他费是[number]0
data>>totalSum>>taxAmount销售税是[number]0
data>>totalSum>>marketTaxAmount市场税是[number]0
data>>totalSum>>customOtherProductAmount商品其他费是[number]0
data>>totalSum>>customOtherSellerAmount店铺其他费是[number]0
data>>totalSum>>customOtherSalesOrderAmount订单其他费是[number]0
data>>totalSum>>purchaseAmount采购成本是[number]0
data>>totalSum>>transportationAmount头程成本是[number]0
data>>totalSum>>tailAmount尾程成本是[number]0
data>>totalSum>>otherAmount其他成本是[number]0
data>>totalSum>>grossProfit毛利润是[number]557799.61
data>>totalSum>>grossProfitRate毛利率是[number]1
data>>list列表是[array]
data>>list>>storeId店铺id是[number]110453560302608900
data>>list>>storeName店铺是[string]
data>>list>>platformCode平台编码是[string]10024
data>>list>>platformName平台是[string]temu
data>>list>>mskuMSKU是[string]ES33HB5025-PG000
data>>list>>productName品名是[string]
data>>list>>localSkuSKU是[string]
data>>list>>deliveryDate下单时间(废弃字段,仅订单维度返回)是[string]
data>>list>>countryName国家是[null]
data>>list>>bname分类是[null]
data>>list>>cname品牌是[string]
data>>list>>developer开发人是[string]
data>>list>>currencyCode币种是[string]USD
data>>list>>currencyIcon货币图标是[string]$
data>>list>>salesNum销量是[number]281
data>>list>>replacementNum补货量是[number]0
data>>list>>salesAmount销售额是[number]87669.88
data>>list>>promotionDiscountAmount促销折扣是[number]0
data>>list>>buyerFreightAmount买家运费是[number]0
data>>list>>platformOtherIncomeAmount其他收入是[number]0
data>>list>>incomeRefundAmount收入退款额是[number]0
data>>list>>feeRefundAmount费用退款额是[number]0
data>>list>>refundAmount退款金额是[number]0
data>>list>>refundNum退款量是[string]0.00
data>>list>>refundRate退款率是[number]0
data>>list>>returnedGoodsNum退货量是[number]0
data>>list>>returnedGoodsRate退货率是[number]0
data>>list>>promotionAmount平台费是[number]0
data>>list>>platformLogisticsAmount平台物流费是[number]0
data>>list>>promotionExtendAmount推广费是[number]0
data>>list>>advertisementAmount广告费是[number]0
data>>list>>adjustmentCostAmount调整费是[number]0
data>>list>>platformStorageAmount平台仓储费是[number]0
data>>list>>platformFineAmount平台罚款是[number]0
data>>list>>platformOtherAmount平台其他费是[number]0
data>>list>>taxAmount销售税是[number]0
data>>list>>marketTaxAmount市场税是[number]0
data>>list>>customOtherProductAmount商品其他费是[number]0
data>>list>>customOtherSellerAmount店铺其他费是[number]0
data>>list>>customOtherSalesOrderAmount订单其他费是[number]0
data>>list>>purchaseAmount采购成本是[number]0
data>>list>>transportationAmount头程成本是[number]0
data>>list>>tailAmount尾程成本是[number]0
data>>list>>otherAmount其他成本是[number]0
data>>list>>grossProfit毛利润是[number]87669.88
data>>list>>grossProfitRate毛利率是[number]1
data>>list>>otherTaxesFees其他税费否[number]
data>>list>>subsidyAmount补贴金额否[number]
沃尔玛平台字段补充
data>>list>>platformWfsStorageAmountWFS仓储费否[number]
data>>list>>platformWfsRemoveAmountWFS移除费否[number]
data>>list>>wfsWarehousFeeWFS入仓费否[number]
data>>list>>wfsPrepServiceFeeWFS上架前处理费否[number]
data>>list>>wfsInventoryTransferFeeWFS存货转仓费否[number]
data>>list>>wfsInventoryRTVFeeWFS RTV费否[number]
data>>list>>productCommission商品佣金否[number]
data>>list>>shippingCommission运费佣金否[number]
data>>list>>wfsAdjustmentCostAmountWFS调整费否[number]
data>>list>>creditAdjustmentFee信用额度调整费否[number]
data>>list>>returnAdjustmentFee退货调整费否[number]
data>>list>>platformDetailOtherAmount其他费否[number]
data>>list>>commentAcceleratorFee评论加速器费否[number]
data>>list>>walmartSavingsBenefit沃尔玛资助节省否[number]
data>>list>>wfsLostInventoryFeeWFS库存丢失费否[number]
data>>list>>wfsFoundInventoryFeeWFS库存找回费否[number]
data>>list>>wfsDamageInWarehouseFeeWFS库存损坏费否[number]
data>>list>>wfsReceivingErrorChargeBackFeeWFS接收错误收费否[number]
data>>list>>wfsChargeFeeWFS调整收费否[number]
data>>list>>wfsShipmentFeeWFS发货费否[number]
data>>list>>walmartReturnServiceFee沃尔玛退货服务费否[number]
data>>list>>wfsReturnFeeWFS退货费否[number]
data>>list>>platformAdvertisingFee平台广告费否[number]
data>>list>>semMarketingFee自助搜索引擎营销费否[number]
data>>list>>reserveCreditedBackAmount释放储备金否[number]
data>>list>>excessRefundAdjustmentAmount超额退款调整否[number]
data>>list>>walmartProductAdvertisingCreditsFee沃尔玛产品广告积分否[number]
data>>list>>walmartPromoCode沃尔玛促销编码否[number]
data>>list>>walmartExtraDiscount沃尔玛额外折扣否[number]
data>>list>>platformMultiChannelFulfillmentFee多渠道配送费否[number]
data>>list>>platformReserveFund预留储备金否[number]
Shopee平台字段补充
data>>list>>sellerDiscount卖家折扣否[number]
data>>list>>shopeeDiscountShopee平台折扣否[number]
data>>list>>discountFromCoinShopee币折扣否[number]
data>>list>>discountFromVoucherShopeeShopee优惠券折扣否[number]
data>>list>>discountFromVoucherSeller卖家优惠券折扣否[number]
data>>list>>paymentPromotion支付折扣否[number]
data>>list>>sellerCoinCashBack卖家Shopee币回扣否[number]
data>>list>>shippingFeeDiscountFrom3pl三方运费折扣否[number]
data>>list>>sellerShippingDiscount卖家运费折扣否[number]
data>>list>>creditCardPromotion信用卡折扣否[number]
data>>list>>sellerLostCompensation损失补偿否[number]
data>>list>>shopeeShippingRebate运费补偿否[number]
data>>list>>sipSubsidySIP补贴否[number]
data>>list>>sellerReturnRefund退款金额否[number]
data>>list>>drcAdjustableRefund争议退款否[number]
data>>list>>proratedCoinsValueOffsetReturnItemsShopee币抵消退款否[number]
data>>list>>proratedShopeeVoucherOffsetReturnItemsShopee优惠券抵消退款否[number]
data>>list>>proratedSellerVoucherOffsetReturnItems卖家优惠券抵消退款否[number]
data>>list>>proratedPaymentChannelPromoBankOffsetReturnItems银行支付促销抵消退款否[number]
data>>list>>proratedPaymentChannelPromoShopeeOffsetReturnItemsShopee支付促销抵消退款否[number]
data>>list>>sellerProtectionFeeClaimAmount退货运费平台退款否[number]
data>>list>>commissionFee平台佣金否[number]
data>>list>>amsCommissionFee联盟营销佣金否[number]
data>>list>>actualShippingFee实际运费否[number]
data>>list>>reverseShippingFee退货运费否[number]
data>>list>>finalReturnToSellerShippingFee配送失败运费否[number]
data>>list>>serviceFee服务费否[number]
data>>list>>buyerTransactionFee买家交易手续费否[number]
data>>list>>sellerTransactionFee卖家交易手续费否[number]
data>>list>>creditCardTransactionFee信用卡交易手续费否[number]
data>>list>>campaignFee活动费否[number]
data>>list>>shippingSellerProtectionFeeAmount卖家保护费否[number]
data>>list>>deliverySellerProtectionFeePremiumAmount特别活动服务费否[number]
data>>list>>overseasReturnServiceFee海外退货服务费否[number]
data>>list>>crossBorderTax跨境税否[number]
data>>list>>escrowTax第三方托管税否[number]
data>>list>>shippingFeeSst运费税否[number]
data>>list>>reverseShippingFeeSst退货运费税否[number]
data>>list>>salesTaxOnLvg低值销售税否[number]
data>>list>>finalProductVatTax商品增值税否[number]
data>>list>>finalShippingVatTax运费增值税否[number]
data>>list>>finalEscrowProductGstGST商品增值税否[number]
data>>list>>finalEscrowShippingGstGST运费增值税否[number]
data>>list>>vatOnImportedGoods进口增值税否[number]
data>>list>>selleroOrderProcessingFee平台基础建设费否[number]
data>>list>>buyerPaidPackagingFee买家支付包装费否[number]
data>>list>>withholdingPitTax预扣个人所得税否[number]
data>>list>>withholdingVatTax预扣增值税否[number]
data>>list>>withholdingTax菲律宾市场税否[number]
Temu全托管平台字段补充
data>>list>>afterSalesDeduction售后问题扣款否[number]
data>>list>>stockingViolation备货违规费否[number]
data>>list>>qualityBreach质量事故违规费否[number]
data>>list>>ecoFeeForGood商品环保费否[number]
data>>list>>logisticsEcoPackagingFee物流包装环保费(已扣费)否[number]
data>>list>>withholdingServiceFee代扣服务费否[number]
data>>list>>promotionServiceFee推广服务费否[number]
data>>list>>eprAuthorizedAgencyFeeWithholdingEPR授权代理费代扣代缴否[number]
data>>list>>platformOtherAdditionalAmount平台其他费 - 其他费否[number]
data>>list>>ecoFeeForRefundGood商品环保费(退款)否[number]
eBay平台字段补充
data>>list>>ebaySubscriptionFeeeBay订阅费否[number]
data>>list>>ebayPublicationFeeeBay刊登费否[number]
data>>list>>regulatoryOperatingFee监管运营费否[number]
data>>list>>platformDetailOtherAmount其它费否[number]
Lazada平台字段补充
data>>list>>fundedCommissionFromSellerVirtualCreditSVC平台佣金否[number]
data>>list>>reversalPromotionalChargesVouchers优惠券促销费用退款否[number]
data>>list>>reverseSellerVirtualCreditCoFundVoucherSVC联合出资优惠券退款否[number]
data>>list>>sellerVirtualCreditCoFundVoucherSVC联合出资优惠券否[number]
data>>list>>shippingFeeSubsidyBySeller卖家运费补贴否[number]
data>>list>>promotionDiscountOtherAmount促销折扣 - 其他费否[number]
data>>list>>promotionOtherAmount平台费 - 其他费否[number]
data>>list>>feeRefundOtherAmount费用退款额 - 其他费否[number]
data>>list>>lazCoinsDiscountLazCoinsDiscount金币折扣否[number]
TikTok平台字段补充
data>>list>>sellerDiscountAmount卖家折扣否[number]
data>>list>>shippingFeeDiscountAmount运费折扣否[number]
data>>list>>codServiceFeeAmountCOD费否[number]
data>>list>>refundSubtotalBeforeDiscountAmount销售额退款否[number]
data>>list>>sellerDiscountRefundAmount商家折扣退款否[number]
data>>list>>refundCodServiceFeeAmountCOD费退款否[number]
data>>list>>affiliateCommissionAmount达人佣金否[number]
data>>list>>affiliatePartnerCommissionAmount达人伙伴佣金否[number]
data>>list>>tspCommissionAmountTSP佣金否[number]
data>>list>>actualShippingFeeAmount实际运费否[number]
data>>list>>returnShippingFeeAmount退货运费否[number]
data>>list>>replacementShippingFeeAmount替换运费否[number]
data>>list>>exchangeShippingFeeAmount换货运费否[number]
data>>list>>signatureConfirmationFeeAmount签名确认费否[number]
data>>list>>shippingInsuranceFeeAmount物流保险费否[number]
data>>list>>transactionFeeAmount交易费否[number]
data>>list>>creditCardHandlingFeeAmount信用卡处理费否[number]
data>>list>>sfpServiceFeeAmountSFP服务费否[number]
data>>list>>liveSpecialsFeeAmount直播特别项目费否[number]
data>>list>>bonusCashbackServiceFeeAmount奖金返现服务费否[number]
data>>list>>mallServiceFeeAmountTK商城服务费否[number]
data>>list>>voucherXtraServiceFeeAmountVoucher Xtra服务费否[number]
data>>list>>flashSalesServiceFeeAmount限时促销服务费否[number]
data>>list>>cofundedPromotionServiceFeeAmount共同出资促销服务费否[number]
data>>list>>preOrderServiceFeeAmount预售服务费否[number]
data>>list>>sstAmount马来西亚销售服务税否[number]
data>>list>>gstAmount新加坡商品服务税否[number]
data>>list>>salesTaxRefundAmount销售税退款额否[number]
data>>list>>standardVatAmount普通增值税否[number]
data>>list>>importVatAmount进口增值税否[number]
data>>list>>ivaAmount墨西哥增值税否[number]
data>>list>>isrAmount墨西哥联邦所得税否[number]
data>>list>>antiDumpingDutyAmount反倾销税否[number]
data>>list>>customsDutyAmount关税否[number]
data>>list>>customsClearanceAmount清关费否[number]
data>>list>>chargeBack争议退回否[number]
data>>list>>customerServiceCompensation客户服务补偿否[number]
data>>list>>deductionsIncurredBySeller卖家责任扣款否[number]
data>>list>>gmvPaymentForAdsGMV广告扣费否[number]
data>>list>>platformCommissionAdjustment平台佣金调整否[number]
data>>list>>platformCommissionCompensation平台佣金补偿否[number]
data>>list>>promotionAdjustment优惠调整否[number]
data>>list>>rebate推荐费折扣否[number]
data>>list>>platformCompensation平台补偿否[number]
data>>list>>platformReimbursement平台退款报销否[number]
data>>list>>cofundedCreatorRewards共同出资创作者激励否[number]
data>>list>>logisticsReimbursement物流赔偿否[number]
data>>list>>shippingFeeAdjustment运费调整否[number]
data>>list>>shippingFeeCompensation运费补偿否[number]
data>>list>>shippingFeeRebate运费回扣否[number]
data>>list>>sampleShippingFee样品运费否[number]
data>>list>>otherAdjustment其他调整费否[number]
data>>list>>fbtWarehouseServiceFeeFBT仓储服务费否[number]
data>>list>>platformPenalty平台罚款否[number]
data>>list>>sellerPaylaterHandlingFeeAmount先买后付手续费否[number]
data>>list>>dtHandlingFeeAmountDT配送手续费否[number]
data>>list>>affiliateCommissionDeposit联盟营销佣金收入否[number]
data>>list>>affiliateCommissionRelease联盟佣金释放否[number]
data>>list>>tapShopAdsCommissionTapShop广告佣金否[number]
data>>list>>shippingFeeGuaranteeServiceFee物流保障服务费否[number]
data>>list>>eprPobServiceFeeAmount合规服务费否[number]
data>>list>>feePerItemSoldAmount单件商品销售服务费否[number]
data>>list>>installationServiceFee安装服务费否[number]
data>>list>>cofundedCreatorBonusAmount共同资助创作者奖金否[number]
data>>list>>failedDeliverySubsidyAmount配送失败补贴金额否[number]
data>>list>>fbtFreeShippingFeeAmountFBT免运费金额否[number]
data>>list>>freeReturnSubsidyAmount免费退货补贴金额否[number]
data>>list>>returnShippingFeePaidBuyerAmount卖家运费退回否[number]
data>>list>>returnShippingLabelFeeAmount退货标签费用否[number]
data>>list>>shippingFeeGuaranteeReimbursement物流保障服务费报销否[number]
data>>list>>promoShippingIncentiveAmount促销运费激励金额否[number]
data>>list>>returnRefundSubsidyAmount退货运费补偿款否[number]
data>>list>>shippingFeeGuaranteeReimbursement物流保障服务费报销否[number]
data>>list>>promoShippingIncentiveAmount促销运费激励金额否[number]
data>>list>>returnRefundSubsidyAmount退货运费补偿款否[number]
data>>list>>fbtFulfillmentFeeReimbursementAmountFBT发货费补偿款否[number]
data>>list>>marketingBenefitsPackageFee广告套餐包否[number]
data>>list>>externalAffiliateMarketingFeeAmountEAMS项目服务费否[number]
data>>list>>fbtFulfillmentFeeReimbursementAmountFBT发货费补偿款否[number]
total总数是[number]1

返回成功示例

{
    "code": 0,
    "message": "success",
    "error_details": [],
    "request_id": "a0d54debf93140f3b58d1ed81e8e3583.107.17289850958114669",
    "response_time": "2024-10-15 17:38:16",
    "data": {
        "totalSum": {
            "currencyCode": "CNY",
            "currencyIcon": "¥",
            "salesNum": 281,
            "replacementNum": 0,
            "salesAmount": 557799.61,
            "promotionDiscountAmount": 0.00,
            "buyerFreightAmount": 0.00,
            "platformOtherIncomeAmount": 0.00,
            "incomeRefundAmount": 0.00,
            "feeRefundAmount": 0.00,
            "refundAmount": 0.00,
            "refundNum": "0.00",
            "refundRate": 0.00,
            "returnedGoodsNum": 0,
            "returnedGoodsRate": 0.00,
            "promotionAmount": 0.00,
            "platformLogisticsAmount": 0.00,
            "promotionExtendAmount": 0.00,
            "advertisementAmount": 0.00,
            "adjustmentCostAmount": 0.00,
            "platformStorageAmount": 0.00,
            "platformFineAmount": 0.00,
            "platformOtherAmount": 0.00,
            "taxAmount": 0.00,
            "marketTaxAmount": 0.00,
            "customOtherProductAmount": 0.00,
            "customOtherSellerAmount": 0.00,
            "customOtherSalesOrderAmount": 0.00,
            "purchaseAmount": 0.00,
            "transportationAmount": 0.00,
            "tailAmount": 0.00,
            "otherAmount": 0.00,
            "grossProfit": 557799.61,
            "grossProfitRate": 1.00
        },
        "list": [
            {
                "storeId": 110453560302608896,
                "storeName": "",
                "platformCode": "10024",
                "platformName": "temu",
                "msku": "ES33HB5025-PG000",
                "productName": "",
                "localSku": "",
                "deliveryDate": "",
                "countryName": null,
                "bname": null,
                "cname": "",
                "developer": "",
                "currencyCode": "USD",
                "currencyIcon": "$",
                "salesNum": 281,
                "replacementNum": 0,
                "salesAmount": 87669.88,
                "promotionDiscountAmount": 0.00,
                "buyerFreightAmount": 0.00,
                "platformOtherIncomeAmount": 0.00,
                "incomeRefundAmount": 0.00,
                "feeRefundAmount": 0.00,
                "refundAmount": 0.00,
                "refundNum": "0.00",
                "refundRate": 0.00,
                "returnedGoodsNum": 0,
                "returnedGoodsRate": 0.00,
                "promotionAmount": 0.00,
                "platformLogisticsAmount": 0.00,
                "promotionExtendAmount": 0.00,
                "advertisementAmount": 0.00,
                "adjustmentCostAmount": 0.00,
                "platformStorageAmount": 0.00,
                "platformFineAmount": 0.00,
                "platformOtherAmount": 0.00,
                "taxAmount": 0.00,
                "marketTaxAmount": 0.00,
                "customOtherProductAmount": 0.00,
                "customOtherSellerAmount": 0.00,
                "customOtherSalesOrderAmount": 0.00,
                "purchaseAmount": 0.00,
                "transportationAmount": 0.00,
                "tailAmount": 0.00,
                "otherAmount": 0.00,
                "grossProfit": 87669.88,
                "grossProfitRate": 1.00
            }
        ]
    },
    "total": 1
}

附加说明

  1. 斜体字段表示为可选的下拉明细费用项,如无需求可不获取。