Shopify - 查询结算明细列表
POST
/basicOpen/multiplatformFinance/shopify/bill/statement/listShopify-查询结算明细列表，支持按店铺、订单、MSKU、支付状态、履约状态、交易类型和时间范围查询 Shopify 结算明细。
接口信息
| API Path | 请求协议 | 请求方式 | 令牌桶容量 |
|---|---|---|---|
/basicOpen/multiplatformFinance/shopify/bill/statement/list | HTTPS | POST | 1 |
请求参数
currencyCodestringdutiesIncludedintegerendDatestringfinancialStatusesarray<any>fulfillmentStatusesarray<any>lengthinteger必填offsetinteger必填searchExactlybooleansearchExactly1booleansearchMultiValuearray<any>searchMultiValue1array<any>searchSingleValuestringsearchSingleValue1stringsearchTypeintegersearchType1integersidsarray<any>sortFieldstringsortTypestringstartDatestringtaxesIncludedintegertimeTypeintegertransactionTypesarray<any>请求cURL示例
curl --location 'https://openapi.lingxing.com/basicOpen/multiplatformFinance/shopify/bill/statement/list?access_token=value×tamp=value&sign=value&app_key=value' \
--header 'Content-Type: application/json' \
--data '{
"offset": 0,
"length": 20,
"sids": [123456],
"startDate": "2026-01-01",
"endDate": "2026-01-31",
"timeType": 1,
"searchType": 1,
"searchSingleValue": "#1001",
"searchType1": 3,
"searchSingleValue1": "MSKU-001",
"financialStatuses": ["paid"],
"fulfillmentStatuses": ["fulfilled"],
"sortField": "orderDate",
"sortType": "0"
}'返回结果
JSON Object
codeinteger必填messagestring必填error_detailsarray<any>必填request_idstring必填response_timestring必填dataobject必填隐藏子属性
listarray<object>必填隐藏子属性
additionalFeeAmountnumber必填allocatedShippingAmountnumber必填allocatedShippingDiscountnumber必填allocatedShippingTaxnumber必填childrenarray<any>必填currencystring必填currencyIconstring必填discountAmountnumber必填discountAmountDetailsarray<object>必填隐藏子属性
fieldLabelstring必填fieldNamestring必填fieldValuenumber必填discountItemAmountnumber必填discountOtherAmountnumber必填discountShippingAmountnumber必填dutiesIncludedstring必填dutyAmountnumber必填dutyAmountDetailsarray<any>必填dutyItemAmountnumber必填dutyOtherAmountnumber必填financialStatusstring必填fulfilledAtstring必填fulfilledQuantityinteger必填fulfillmentStatusstring必填hasLineItemsinteger必填idinteger必填isMasterRowboolean必填isPrimaryRowinteger必填itemAmountnumber必填itemDiscountAmountnumber必填itemDutyAmountnumber必填itemDutyTaxAmountnumber必填itemPricenumber必填itemSubtotalAfterDiscountnumber必填itemTaxAmountnumber必填lineItemCountinteger必填lineItemIdstring必填mskustring必填mskuIdstring必填mskuNamestring必填orderCreatedAtstring必填orderIdstring必填orderNamestring必填orderedQuantityinteger必填otherFeeAmountnumber必填otherFeeAmountDetailsarray<any>必填paidAtstring必填refundAdjustmentAmountnumber必填refundAfterFulfilledQuantityinteger必填refundOtherAmountnumber必填refundQuantityinteger必填refundedAtstring必填requiresShippingstring必填settlementTimestring必填shippingAmountnumber必填sourceEventIdstring必填storeIdinteger必填storeNamestring必填subtotalPricenumber必填taxAmountnumber必填taxAmountDetailsarray<any>必填taxDutyAmountnumber必填taxItemAmountnumber必填taxOtherAmountnumber必填taxShippingAmountnumber必填taxesIncludedstring必填tipAmountnumber必填totalLineItemsPricenumber必填totalPricenumber必填transactionTypestring必填totalCountinteger必填totalSumobject必填隐藏子属性
additionalFeeAmountnumber必填allocatedShippingAmountnumber必填allocatedShippingDiscountnumber必填allocatedShippingTaxnumber必填currencystring必填currencyIconstring必填discountAmountnumber必填dutyAmountnumber必填dutyItemAmountnumber必填fulfilledQuantityinteger必填itemAmountnumber必填itemDiscountAmountnumber必填itemDutyAmountnumber必填itemDutyTaxAmountnumber必填itemSubtotalAfterDiscountnumber必填itemTaxAmountnumber必填orderedQuantityinteger必填otherFeeAmountnumber必填refundAfterFulfilledQuantityinteger必填refundQuantityinteger必填shippingAmountnumber必填subtotalPricenumber必填taxAmountnumber必填tipAmountnumber必填totalCountinteger必填totalLineItemsPricenumber必填totalPricenumber必填返回成功示例
{
"code": 0,
"message": "success",
"error_details": [],
"request_id": "a0d54debf93140f3b58d1ed81e8e3583",
"response_time": "2026-05-25 12:00:00",
"data": {
"list": [
{
"additionalFeeAmount": 0.00,
"allocatedShippingAmount": 5.00,
"allocatedShippingDiscount": 1.00,
"allocatedShippingTax": 0.30,
"children": [],
"currency": "USD",
"currencyIcon": "$",
"discountAmount": 3.00,
"discountAmountDetails": [
{
"fieldLabel": "商品折扣",
"fieldName": "itemDiscountAmount",
"fieldValue": 2.00
}
],
"discountItemAmount": 2.00,
"discountOtherAmount": 0.00,
"discountShippingAmount": 1.00,
"dutiesIncluded": "是",
"dutyAmount": 1.20,
"dutyAmountDetails": [
{
"fieldLabel": "商品关税",
"fieldName": "dutyItemAmount",
"fieldValue": 1.20
}
],
"dutyItemAmount": 1.20,
"dutyOtherAmount": 0.00,
"financialStatus": "paid",
"fulfilledAt": "2026-01-03 10:00:00",
"fulfilledQuantity": 2,
"fulfillmentStatus": "fulfilled",
"hasLineItems": 0,
"id": 100001,
"isMasterRow": true,
"isPrimaryRow": 1,
"itemAmount": 100.00,
"itemDiscountAmount": 2.00,
"itemDutyAmount": 1.20,
"itemDutyTaxAmount": 0.10,
"itemPrice": 50.00,
"itemSubtotalAfterDiscount": 98.00,
"itemTaxAmount": 5.00,
"lineItemCount": 1,
"lineItemId": "200001",
"msku": "MSKU-001",
"mskuId": "300001",
"mskuName": "Wireless Mouse",
"orderCreatedAt": "2026-01-01 09:30:00",
"orderId": "1000001",
"orderName": "#1001",
"orderedQuantity": 2,
"otherFeeAmount": 0.50,
"otherFeeAmountDetails": [
{
"fieldLabel": "其他费用",
"fieldName": "otherFeeAmount",
"fieldValue": 0.50
}
],
"paidAt": "2026-01-01 09:35:00",
"refundAdjustmentAmount": 0.00,
"refundAfterFulfilledQuantity": 0,
"refundOtherAmount": 0.00,
"refundQuantity": 0,
"refundedAt": "",
"requiresShipping": "是",
"settlementTime": "2026-01-05 12:00:00",
"shippingAmount": 5.00,
"sourceEventId": "EVT-10001",
"storeId": 123456,
"storeName": "Shopify US Store",
"subtotalPrice": 98.00,
"taxAmount": 5.40,
"taxAmountDetails": [
{
"fieldLabel": "商品税费",
"fieldName": "taxItemAmount",
"fieldValue": 5.00
}
],
"taxDutyAmount": 0.10,
"taxItemAmount": 5.00,
"taxOtherAmount": 0.00,
"taxShippingAmount": 0.30,
"taxesIncluded": "是",
"tipAmount": 0.00,
"totalLineItemsPrice": 100.00,
"totalPrice": 108.10,
"transactionType": "sale"
}
],
"totalCount": 1,
"totalSum": {
"additionalFeeAmount": 0.00,
"allocatedShippingAmount": 5.00,
"allocatedShippingDiscount": 1.00,
"allocatedShippingTax": 0.30,
"currency": "USD",
"currencyIcon": "$",
"discountAmount": 3.00,
"dutyAmount": 1.20,
"dutyItemAmount": 1.20,
"fulfilledQuantity": 2,
"itemAmount": 100.00,
"itemDiscountAmount": 2.00,
"itemDutyAmount": 1.20,
"itemDutyTaxAmount": 0.10,
"itemSubtotalAfterDiscount": 98.00,
"itemTaxAmount": 5.00,
"orderedQuantity": 2,
"otherFeeAmount": 0.50,
"refundAfterFulfilledQuantity": 0,
"refundQuantity": 0,
"shippingAmount": 5.00,
"subtotalPrice": 98.00,
"taxAmount": 5.40,
"tipAmount": 0.00,
"totalCount": 1,
"totalLineItemsPrice": 100.00,
"totalPrice": 108.10
}
}
}