/basicOpen/multiplatformFinance/shopify/bill/statement/list{
"operation": {
"method": "POST",
"path": "/basicOpen/multiplatformFinance/shopify/bill/statement/list"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 1,
"text": ""
},
"requestExample": "curl --location 'https://openapi.lingxing.com/basicOpen/multiplatformFinance/shopify/bill/statement/list?access_token=value×tamp=value&sign=value&app_key=value' \\\n--header 'Content-Type: application/json' \\\n--data '{\n \"offset\": 0,\n \"length\": 20,\n \"sids\": [123456],\n \"startDate\": \"2026-01-01\",\n \"endDate\": \"2026-01-31\",\n \"timeType\": 1,\n \"searchType\": 1,\n \"searchSingleValue\": \"#1001\",\n \"searchType1\": 3,\n \"searchSingleValue1\": \"MSKU-001\",\n \"financialStatuses\": [\"paid\"],\n \"fulfillmentStatuses\": [\"fulfilled\"],\n \"sortField\": \"orderDate\",\n \"sortType\": \"0\"\n}'",
"responseExample": {
"code": 0,
"message": "success",
"error_details": [],
"request_id": "a0d54debf93140f3b58d1ed81e8e3583",
"response_time": "2026-05-25 12:00:00",
"data": {
"list": [
{
"additionalFeeAmount": 0,
"allocatedShippingAmount": 5,
"allocatedShippingDiscount": 1,
"allocatedShippingTax": 0.3,
"children": [],
"currency": "USD",
"currencyIcon": "$",
"discountAmount": 3,
"discountAmountDetails": [
{
"fieldLabel": "商品折扣",
"fieldName": "itemDiscountAmount",
"fieldValue": 2
}
],
"discountItemAmount": 2,
"discountOtherAmount": 0,
"discountShippingAmount": 1,
"dutiesIncluded": "是",
"dutyAmount": 1.2,
"dutyAmountDetails": [
{
"fieldLabel": "商品关税",
"fieldName": "dutyItemAmount",
"fieldValue": 1.2
}
],
"dutyItemAmount": 1.2,
"dutyOtherAmount": 0,
"financialStatus": "paid",
"fulfilledAt": "2026-01-03 10:00:00",
"fulfilledQuantity": 2,
"fulfillmentStatus": "fulfilled",
"hasLineItems": 0,
"id": 100001,
"isMasterRow": true,
"isPrimaryRow": 1,
"itemAmount": 100,
"itemDiscountAmount": 2,
"itemDutyAmount": 1.2,
"itemDutyTaxAmount": 0.1,
"itemPrice": 50,
"itemSubtotalAfterDiscount": 98,
"itemTaxAmount": 5,
"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.5,
"otherFeeAmountDetails": [
{
"fieldLabel": "其他费用",
"fieldName": "otherFeeAmount",
"fieldValue": 0.5
}
],
"paidAt": "2026-01-01 09:35:00",
"refundAdjustmentAmount": 0,
"refundAfterFulfilledQuantity": 0,
"refundOtherAmount": 0,
"refundQuantity": 0,
"refundedAt": "",
"requiresShipping": "是",
"settlementTime": "2026-01-05 12:00:00",
"shippingAmount": 5,
"sourceEventId": "EVT-10001",
"storeId": 123456,
"storeName": "Shopify US Store",
"subtotalPrice": 98,
"taxAmount": 5.4,
"taxAmountDetails": [
{
"fieldLabel": "商品税费",
"fieldName": "taxItemAmount",
"fieldValue": 5
}
],
"taxDutyAmount": 0.1,
"taxItemAmount": 5,
"taxOtherAmount": 0,
"taxShippingAmount": 0.3,
"taxesIncluded": "是",
"tipAmount": 0,
"totalLineItemsPrice": 100,
"totalPrice": 108.1,
"transactionType": "sale"
}
],
"totalCount": 1,
"totalSum": {
"additionalFeeAmount": 0,
"allocatedShippingAmount": 5,
"allocatedShippingDiscount": 1,
"allocatedShippingTax": 0.3,
"currency": "USD",
"currencyIcon": "$",
"discountAmount": 3,
"dutyAmount": 1.2,
"dutyItemAmount": 1.2,
"fulfilledQuantity": 2,
"itemAmount": 100,
"itemDiscountAmount": 2,
"itemDutyAmount": 1.2,
"itemDutyTaxAmount": 0.1,
"itemSubtotalAfterDiscount": 98,
"itemTaxAmount": 5,
"orderedQuantity": 2,
"otherFeeAmount": 0.5,
"refundAfterFulfilledQuantity": 0,
"refundQuantity": 0,
"shippingAmount": 5,
"subtotalPrice": 98,
"taxAmount": 5.4,
"tipAmount": 0,
"totalCount": 1,
"totalLineItemsPrice": 100,
"totalPrice": 108.1
}
}
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | currencyCode | 目标货币代码 | string | — | Optional | 目标货币代码 |
| 2 | dutiesIncluded | 是否含关税 | integer | — | Optional | 是否含关税 0:否 1:是 不传:全部 |
| 3 | endDate | 结束时间 | string | — | Optional | 结束时间,格式:yyyy-MM-dd |
| 4 | financialStatuses | 支付状态 | array<any> | — | Optional | 支付状态 |
| 5 | fulfillmentStatuses | 履约状态 | array<any> | — | Optional | 履约状态 |
| 6 | length | 分页大小 | integer | — | Required | 分页大小,默认 20,最大 200 |
| 7 | offset | 分页偏移量 | integer | — | Required | 分页偏移量,默认 0 |
| 8 | searchExactly | 是否精确匹配 | boolean | — | Optional | 是否精确匹配 |
| 9 | searchExactly1 | 搜索1是否精确匹配 | boolean | — | Optional | 搜索1是否精确匹配 |
| 10 | searchMultiValue | 多个搜索值 | array<any> | — | Optional | 多个搜索值 |
| 11 | searchMultiValue1 | 搜索值1 | array<any> | — | Optional | 搜索值1,多个搜索值 |
| 12 | searchSingleValue | 单个搜索值 | string | — | Optional | 单个搜索值 |
| 13 | searchSingleValue1 | 搜索值1 | string | — | Optional | 搜索值1,单个搜索值 |
| 14 | searchType | 搜索类型 | integer | — | Optional | 搜索类型 1:平台单号 2:平台子单 |
| 15 | searchType1 | 搜索类型1 | integer | — | Optional | 搜索类型1 3:MSKU 4:MSKU ID |
| 16 | sids | 店铺ID数组 | array<any> | — | Optional | 店铺ID数组 |
| 17 | sortField | 排序字段 | string | — | Optional | 排序字段 |
| 18 | sortType | 排序方向 | string | — | Optional | 排序方向 0:DESC 1:ASC |
| 19 | startDate | 开始时间 | string | — | Optional | 开始时间,格式:yyyy-MM-dd |
| 20 | taxesIncluded | 是否含税 | integer | — | Optional | 是否含税 0:否 1:是 不传:全部 |
| 21 | timeType | 时间类型 | integer | — | Optional | 时间类型 1:结算时间 2:下单时间 |
| 22 | transactionTypes | 交易类型 | array<any> | — | Optional | 交易类型 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | integer | 0 | Required | 状态码,0:成功 |
| 2 | message | 消息提示 | string | success | Required | 消息提示 |
| 3 | error_details | 数据校验失败时的错误详情 | array<any> | — | Required | 数据校验失败时的错误详情 |
| 4 | request_id | 请求链路id | string | a0d54debf93140f3b58d1ed81e8e3583 | Required | 请求链路id |
| 5 | response_time | 响应时间 | string | 2026-05-25 12:00:00 | Required | 响应时间 |
| 6 | data | 响应数据 | object | — | Required | 响应数据 |
| 6.1 | list | 列表数据 | array<object> | — | Required | 列表数据 |
| 6.1.1 | additionalFeeAmount | 附加费 | number | 0 | Required | 附加费 |
| 6.1.2 | allocatedShippingAmount | 分摊运费 | number | 5 | Required | 分摊运费 |
| 6.1.3 | allocatedShippingDiscount | 分摊运费折扣 | number | 1 | Required | 分摊运费折扣 |
| 6.1.4 | allocatedShippingTax | 分摊运费税 | number | 0.3 | Required | 分摊运费税 |
| 6.1.5 | children | 一单多件子项列表 | array<any> | — | Required | 一单多件子项列表,结构同 data>>list |
| 6.1.6 | currency | 币种 | string | USD | Required | 币种 |
| 6.1.7 | currencyIcon | 币种图标 | string | $ | Required | 币种图标 |
| 6.1.8 | discountAmount | 折扣总额 | number | 3 | Required | 折扣总额 |
| 6.1.9 | discountAmountDetails | 折扣浮层项 | array<object> | — | Required | 折扣浮层项 |
| 6.1.9.1 | fieldLabel | 字段标签 | string | 商品折扣 | Required | 字段标签 |
| 6.1.9.2 | fieldName | 字段名 | string | itemDiscountAmount | Required | 字段名 |
| 6.1.9.3 | fieldValue | 字段值 | number | 2 | Required | 字段值 |
| 6.1.10 | discountItemAmount | 商品折扣 | number | 2 | Required | 商品折扣 |
| 6.1.11 | discountOtherAmount | 其他折扣 | number | 0 | Required | 其他折扣 |
| 6.1.12 | discountShippingAmount | 运费折扣 | number | 1 | Required | 运费折扣 |
| 6.1.13 | dutiesIncluded | 是否含关税 | string | 是 | Required | 是否含关税 |
| 6.1.14 | dutyAmount | 关税总额 | number | 1.2 | Required | 关税总额 |
| 6.1.15 | dutyAmountDetails | 关税浮层项 | array<any> | — | Required | 关税浮层项,结构同 discountAmountDetails |
| 6.1.16 | dutyItemAmount | 商品关税 | number | 1.2 | Required | 商品关税 |
| 6.1.17 | dutyOtherAmount | 其他关税 | number | 0 | Required | 其他关税 |
| 6.1.18 | financialStatus | 支付状态 | string | paid | Required | 支付状态 |
| 6.1.19 | fulfilledAt | 标发时间 | string | 2026-01-03 10:00:00 | Required | 标发时间 |
| 6.1.20 | fulfilledQuantity | 标发数量 | integer | 2 | Required | 标发数量 |
| 6.1.21 | fulfillmentStatus | 履约状态 | string | fulfilled | Required | 履约状态 |
| 6.1.22 | hasLineItems | 是否多件商品平铺 | integer | 0 | Required | 是否多件商品平铺 |
| 6.1.23 | id | 主键ID | integer | 100001 | Required | 主键ID |
| 6.1.24 | isMasterRow | 是否主行 | boolean | true | Required | 是否主行 |
| 6.1.25 | isPrimaryRow | 主单行标识 | integer | 1 | Required | 主单行标识 |
| 6.1.26 | itemAmount | 商品金额 | number | 100 | Required | 商品金额 |
| 6.1.27 | itemDiscountAmount | 商品折扣 | number | 2 | Required | 商品折扣 |
| 6.1.28 | itemDutyAmount | 商品级关税 | number | 1.2 | Required | 商品级关税 |
| 6.1.29 | itemDutyTaxAmount | 商品关税税费 | number | 0.1 | Required | 商品关税税费 |
| 6.1.30 | itemPrice | 商品价格 | number | 50 | Required | 商品价格 |
| 6.1.31 | itemSubtotalAfterDiscount | 商品金额(折扣后) | number | 98 | Required | 商品金额(折扣后) |
| 6.1.32 | itemTaxAmount | 商品税 | number | 5 | Required | 商品税 |
| 6.1.33 | lineItemCount | 订单商品总数 | integer | 1 | Required | 订单商品总数 |
| 6.1.34 | lineItemId | 平台子单号 | string | 200001 | Required | 平台子单号 |
| 6.1.35 | msku | msku | string | MSKU-001 | Required | MSKU |
| 6.1.36 | mskuId | MSKU ID | string | 300001 | Required | MSKU ID |
| 6.1.37 | mskuName | MSKU名称 | string | Wireless Mouse | Required | MSKU名称 |
| 6.1.38 | orderCreatedAt | 下单时间 | string | 2026-01-01 09:30:00 | Required | 下单时间 |
| 6.1.39 | orderId | 平台单号ID | string | 1000001 | Required | 平台单号ID |
| 6.1.40 | orderName | 平台单号 | string | #1001 | Required | 平台单号 |
| 6.1.41 | orderedQuantity | 下单数量 | integer | 2 | Required | 下单数量 |
| 6.1.42 | otherFeeAmount | 其他费用 | number | 0.5 | Required | 其他费用 |
| 6.1.43 | otherFeeAmountDetails | 其他费用浮层项 | array<any> | — | Required | 其他费用浮层项,结构同 discountAmountDetails |
| 6.1.44 | paidAt | 支付时间 | string | 2026-01-01 09:35:00 | Required | 支付时间 |
| 6.1.45 | refundAdjustmentAmount | 退款调整金额 | number | 0 | Required | 退款调整金额 |
| 6.1.46 | refundAfterFulfilledQuantity | 标发后退款量 | integer | 0 | Required | 标发后退款量 |
| 6.1.47 | refundOtherAmount | 其他退款金额 | number | 0 | Required | 其他退款金额 |
| 6.1.48 | refundQuantity | 退款数量 | integer | 0 | Required | 退款数量 |
| 6.1.49 | refundedAt | 退款时间 | string | — | Required | 退款时间 |
| 6.1.50 | requiresShipping | 是否需配送 | string | 是 | Required | 是否需配送 |
| 6.1.51 | settlementTime | 结算时间 | string | 2026-01-05 12:00:00 | Required | 结算时间 |
| 6.1.52 | shippingAmount | 运费 | number | 5 | Required | 运费 |
| 6.1.53 | sourceEventId | 源事件ID | string | EVT-10001 | Required | 源事件ID |
| 6.1.54 | storeId | 店铺ID | integer | 123456 | Required | 店铺ID |
| 6.1.55 | storeName | 店铺名称 | string | Shopify US Store | Required | 店铺名称 |
| 6.1.56 | subtotalPrice | 商品金额小计(折扣后) | number | 98 | Required | 商品金额小计(折扣后) |
| 6.1.57 | taxAmount | 税费总额 | number | 5.4 | Required | 税费总额 |
| 6.1.58 | taxAmountDetails | 税费浮层项 | array<any> | — | Required | 税费浮层项,结构同 discountAmountDetails |
| 6.1.59 | taxDutyAmount | 关税税费 | number | 0.1 | Required | 关税税费 |
| 6.1.60 | taxItemAmount | 商品税费 | number | 5 | Required | 商品税费 |
| 6.1.61 | taxOtherAmount | 其他税费 | number | 0 | Required | 其他税费 |
| 6.1.62 | taxShippingAmount | 运费税费 | number | 0.3 | Required | 运费税费 |
| 6.1.63 | taxesIncluded | 是否含税 | string | 是 | Required | 是否含税 |
| 6.1.64 | tipAmount | 小费 | number | 0 | Required | 小费 |
| 6.1.65 | totalLineItemsPrice | 商品金额小计 | number | 100 | Required | 商品金额小计 |
| 6.1.66 | totalPrice | 总计 | number | 108.1 | Required | 总计 |
| 6.1.67 | transactionType | 交易类型 | string | sale | Required | 交易类型 |
| 6.2 | totalCount | 总记录数 | integer | 1 | Required | 总记录数 |
| 6.3 | totalSum | 汇总数据 | object | — | Required | 汇总数据 |
| 6.3.1 | additionalFeeAmount | 附加费汇总 | number | 0 | Required | 附加费汇总 |
| 6.3.2 | allocatedShippingAmount | 分摊运费汇总 | number | 5 | Required | 分摊运费汇总 |
| 6.3.3 | allocatedShippingDiscount | 分摊运费折扣汇总 | number | 1 | Required | 分摊运费折扣汇总 |
| 6.3.4 | allocatedShippingTax | 分摊运费税汇总 | number | 0.3 | Required | 分摊运费税汇总 |
| 6.3.5 | currency | 货币代码 | string | USD | Required | 货币代码 |
| 6.3.6 | currencyIcon | 货币图标 | string | $ | Required | 货币图标 |
| 6.3.7 | discountAmount | 折扣总额汇总 | number | 3 | Required | 折扣总额汇总 |
| 6.3.8 | dutyAmount | 关税总额汇总 | number | 1.2 | Required | 关税总额汇总 |
| 6.3.9 | dutyItemAmount | 商品关税汇总 | number | 1.2 | Required | 商品关税汇总 |
| 6.3.10 | fulfilledQuantity | 标发数量汇总 | integer | 2 | Required | 标发数量汇总 |
| 6.3.11 | itemAmount | 商品金额汇总 | number | 100 | Required | 商品金额汇总 |
| 6.3.12 | itemDiscountAmount | 商品折扣汇总 | number | 2 | Required | 商品折扣汇总 |
| 6.3.13 | itemDutyAmount | 商品级关税汇总 | number | 1.2 | Required | 商品级关税汇总 |
| 6.3.14 | itemDutyTaxAmount | 商品关税税费汇总 | number | 0.1 | Required | 商品关税税费汇总 |
| 6.3.15 | itemSubtotalAfterDiscount | 商品金额(折扣后)汇总 | number | 98 | Required | 商品金额(折扣后)汇总 |
| 6.3.16 | itemTaxAmount | 商品税汇总 | number | 5 | Required | 商品税汇总 |
| 6.3.17 | orderedQuantity | 下单数量汇总 | integer | 2 | Required | 下单数量汇总 |
| 6.3.18 | otherFeeAmount | 其他费用汇总 | number | 0.5 | Required | 其他费用汇总 |
| 6.3.19 | refundAfterFulfilledQuantity | 标发后退款量汇总 | integer | 0 | Required | 标发后退款量汇总 |
| 6.3.20 | refundQuantity | 退款数量汇总 | integer | 0 | Required | 退款数量汇总 |
| 6.3.21 | shippingAmount | 运费汇总 | number | 5 | Required | 运费汇总 |
| 6.3.22 | subtotalPrice | 商品金额小计(折扣后)汇总 | number | 98 | Required | 商品金额小计(折扣后)汇总 |
| 6.3.23 | taxAmount | 税费总额汇总 | number | 5.4 | Required | 税费总额汇总 |
| 6.3.24 | tipAmount | 小费汇总 | number | 0 | Required | 小费汇总 |
| 6.3.25 | totalCount | 总记录数 | integer | 1 | Required | 总记录数 |
| 6.3.26 | totalLineItemsPrice | 商品金额小计汇总 | number | 100 | Required | 商品金额小计汇总 |
| 6.3.27 | totalPrice | 总计汇总 | number | 108.1 | Required | 总计汇总 |
The Shopify - 查询结算明细列表 API (/basicOpen/multiplatformFinance/shopify/bill/statement/list) of 领星ERP is curated by the API asset management module of the Qeasy Cloud data integration platform and kept in sync with 领星ERP version updates.
Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.