利润报表 - 明细列表查询
POST
/basicOpen/finance/settlement/profitList接口信息
| API Path | 请求协议 | 请求方式 | 令牌桶容量 |
|---|---|---|---|
/basicOpen/finance/settlement/profitList | HTTPS | POST | 1 |
请求参数
summaryFieldstring必填summaryTypeintegerpageNuminteger必填pageSizeinteger必填startDatestringendDatestringdateRangeTypeintegersidsarray<any>platformCodesarray<any>areasarray<any>countriesarray<any>brandsarray<any>categoriesarray<any>developersarray<any>currencystringqueryModeintegertransactionTypesarray<any>fulfilmentTypesarray<any>hasOriginalOrderintegersearchFieldintegersearchValuesarray<any>orderSearchFieldintegerorderSearchValuesarray<any>sortFieldstringsortTypestring请求cURL示例
curl --location 'https://openapi.lingxing.com/basicOpen/finance/settlement/profitList?access_token=value×tamp=value&sign=value&app_key=value' \
--header 'Content-Type: application/json' \
--data '{
"summaryField": "1",
"pageNum": 1,
"pageSize": 20,
"startDate": "2025-11-01",
"endDate": "2025-11-30",
"fulfilmentTypes": [1]
}'
返回结果
Json Object
codeinteger必填messagestring必填error_detailsarray<any>必填request_idstring必填response_timestring必填dataobject必填隐藏子属性
configListarray<object>必填隐藏子属性
itemTypeinteger必填itemTypeNamestring必填itemFieldstring必填itemNamestring必填parentItemNamestring必填displayFormatinteger必填displayFormatNamestring必填sortOrderinteger必填tooltipstring必填fieldsarray<object>必填隐藏子属性
fieldNamestring必填displayNamestring必填platformCodesarray<any>必填dataListarray<object>必填隐藏子属性
platformCodestring必填platformNamestring必填storeIdstring必填storeNamestring必填areastring必填countrystring必填currencystring必填currencyIconstring必填mskustring必填mskuIdstring必填asinstring必填localSkustring必填spuIdstring必填skcstring必填productNamestring必填brandstring必填categorystring必填developerstring必填costSourcestring必填platformOrderNostring必填orderItemNostring必填packageNostring必填stockOrderNostring必填waybillNostring必填transactionTypestring必填uniqueIdstring必填purchaseDatestring必填purchaseTimestring必填settlementTimestring必填shipmentDatestring必填shipmentTimestring必填hasOriginalOrderboolean必填fulfilmentTypestring必填profitItemsobject必填totalobject必填隐藏子属性
currencystring必填currencyIconstring必填profitItemsobject必填totalCountinteger必填totalinteger必填返回成功示例
以下示例按实际响应结构整理。为便于阅读,configList 和 profitItems 仅展示部分字段;实际字段会随平台及利润配置动态变化。店铺、商品、单据、内部 ID 和金额均已使用脱敏示例值。
queryMode=1(列表)
queryMode=1 时,profitItems 返回二级利润项目(对应页面的列表表头,比如销售额)。
{
"code": 0,
"message": "success",
"error_details": [],
"request_id": "example-request-id-query-mode-1",
"response_time": "2026-09-04 09:22:59",
"data": {
"configList": [
{
"displayFormat": 2,
"displayFormatName": "金额",
"fields": null,
"itemField": "platformSettlement",
"itemName": "平台结算",
"itemType": 5,
"itemTypeName": "利润",
"parentItemName": "利润",
"sortOrder": 1000,
"tooltip": ""
},
{
"displayFormat": 2,
"displayFormatName": "金额",
"fields": [
{
"displayName": "商品金额",
"fieldName": "commonProductAmount",
"platformCodes": [
"10011"
]
}
],
"itemField": "salesAmount",
"itemName": "销售额",
"itemType": 1,
"itemTypeName": "收入",
"parentItemName": "平台收入",
"sortOrder": 3000,
"tooltip": ""
}
],
"dataList": [
{
"area": "美国",
"asin": null,
"brand": "示例品牌",
"category": "示例分类",
"costSource": "固定值",
"country": "美国",
"currency": "USD",
"currencyIcon": "$",
"developer": "示例开发人",
"hasOriginalOrder": true,
"localSku": "SKU-001",
"msku": "MSKU-001",
"mskuId": "example-msku-id",
"orderItemNo": "",
"packageNo": null,
"platformCode": "10011",
"platformName": "TikTok",
"platformOrderNo": "example-platform-order-no",
"productName": "示例商品",
"profitItems": {
"platformSettlement": 75.25,
"salesAmount": 100.0,
"platformCommission": -5.0,
"platformDeliveryFee": -10.0,
"productCost": -20.0,
"profit": 30.0,
"profitMargin": "30.00%"
},
"purchaseDate": "2026-08-01",
"purchaseTime": "2026-08-01 10:00:00",
"settlementTime": "2026-08-03",
"shipmentDate": null,
"shipmentTime": "2026-08-02 08:00:00",
"skc": "",
"spuId": "example-spu-id",
"stockOrderNo": null,
"storeId": "example-store-id",
"storeName": "示例店铺",
"transactionType": "销售",
"uniqueId": "example-unique-id",
"waybillNo": "",
"fulfilmentType": "平台发货"
}
],
"total": {
"currency": "USD",
"currencyIcon": "$",
"profitItems": {
"platformSettlement": 150.5,
"salesAmount": 200.0,
"platformCommission": -10.0,
"platformDeliveryFee": -20.0,
"productCost": -40.0,
"profit": 60.0,
"profitMargin": "30.00%"
}
},
"totalCount": 2
},
"total": 2
}
queryMode=2(明细)
queryMode=2 时,profitItems 返回二级利润项目和明细费用项(二级利润项目对应页面的列表表头,比如销售额;明细费用项对应列表的浮层,比如商品金额)。下例中的 tiktokTransactionFee、tiktokSmartMarketingFee 和 tiktokGst 均为明细费用项示例。
{
"code": 0,
"message": "success",
"error_details": [],
"request_id": "example-request-id-query-mode-2",
"response_time": "2026-09-04 09:22:59",
"data": {
"configList": [
{
"displayFormat": 2,
"displayFormatName": "金额",
"fields": null,
"itemField": "platformSettlement",
"itemName": "平台结算",
"itemType": 5,
"itemTypeName": "利润",
"parentItemName": "利润",
"sortOrder": 1000,
"tooltip": ""
},
{
"displayFormat": 2,
"displayFormatName": "金额",
"fields": [
{
"displayName": "商品金额",
"fieldName": "commonProductAmount",
"platformCodes": [
"10011"
]
}
],
"itemField": "salesAmount",
"itemName": "销售额",
"itemType": 1,
"itemTypeName": "收入",
"parentItemName": "平台收入",
"sortOrder": 3000,
"tooltip": ""
}
],
"dataList": [
{
"area": "美国",
"asin": null,
"brand": "示例品牌",
"category": "示例分类",
"costSource": "固定值",
"country": "美国",
"currency": "USD",
"currencyIcon": "$",
"developer": "示例开发人",
"hasOriginalOrder": true,
"localSku": "SKU-001",
"msku": "MSKU-001",
"mskuId": "example-msku-id",
"orderItemNo": "",
"packageNo": null,
"platformCode": "10011",
"platformName": "TikTok",
"platformOrderNo": "example-platform-order-no",
"productName": "示例商品",
"profitItems": {
"platformSettlement": 75.25,
"salesAmount": 100.0,
"platformCommission": -5.0,
"platformDeliveryFee": -10.0,
"productCost": -20.0,
"profit": 30.0,
"profitMargin": "30.00%",
"commonProductAmount": 100.0,
"commonPlatformCommission": -5.0,
"tiktokTransactionFee": -1.0,
"tiktokSmartMarketingFee": -2.5,
"tiktokGst": 0.0
},
"purchaseDate": "2026-08-01",
"purchaseTime": "2026-08-01 10:00:00",
"settlementTime": "2026-08-03",
"shipmentDate": null,
"shipmentTime": "2026-08-02 08:00:00",
"skc": "",
"spuId": "example-spu-id",
"stockOrderNo": null,
"storeId": "example-store-id",
"storeName": "示例店铺",
"transactionType": "销售",
"uniqueId": "example-unique-id",
"waybillNo": "",
"fulfilmentType": "平台发货"
}
],
"total": {
"currency": "USD",
"currencyIcon": "$",
"profitItems": {
"platformSettlement": 150.5,
"salesAmount": 200.0,
"platformCommission": -10.0,
"platformDeliveryFee": -20.0,
"productCost": -40.0,
"profit": 60.0,
"profitMargin": "30.00%",
"commonProductAmount": 200.0,
"commonPlatformCommission": -10.0,
"tiktokTransactionFee": -2.0,
"tiktokSmartMarketingFee": -5.0,
"tiktokGst": 0.0
}
},
"totalCount": 2
},
"total": 2
}
附加说明
唯一键组合规则
- 订单维度:uniqueId
- 店铺维度:平台 + 店铺
- MSKU维度:平台 + 店铺 + MSKU ID + MSKU + SKU
- SKU维度:平台 + 店铺 + SKU
- 开发人维度:平台 + 开发人
- 负责人维度:平台 + 负责人
- SPU维度:平台 + 店铺 + SPU ID
当 summaryType 不等于 0/null 时,非订单维度需在上述组合基础上追加结算时间。