Qeasy Cloud
Get Started

领星ERP Shopify - 查询结算明细列表 API

Platform
领星ERP
Type
WebAPI
Effect
QUERY
API Version
1.0
Adapter
\Adapter\LingXing\LXQueryAdapter
Auth Mode
OTHER
Description
多平台 / 财务 / Shopify财务 · POST · 请求参数 22 个(必填 2) · 响应参数 106 个 · 限流令牌桶容量 1
Updated At
2026-11-21

Shopify - 查询结算明细列表

POST/basicOpen/multiplatformFinance/shopify/bill/statement/list
Factory
{
  "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&timestamp=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
      }
    }
  }
}

Request Parameters

No.FieldNameTypeDefaultRequiredDescription
1currencyCode目标货币代码string—Optional目标货币代码
2dutiesIncluded是否含关税integer—Optional是否含关税 0:否 1:是 不传:全部
3endDate结束时间string—Optional结束时间,格式:yyyy-MM-dd
4financialStatuses支付状态array<any>—Optional支付状态
5fulfillmentStatuses履约状态array<any>—Optional履约状态
6length分页大小integer—Required分页大小,默认 20,最大 200
7offset分页偏移量integer—Required分页偏移量,默认 0
8searchExactly是否精确匹配boolean—Optional是否精确匹配
9searchExactly1搜索1是否精确匹配boolean—Optional搜索1是否精确匹配
10searchMultiValue多个搜索值array<any>—Optional多个搜索值
11searchMultiValue1搜索值1array<any>—Optional搜索值1,多个搜索值
12searchSingleValue单个搜索值string—Optional单个搜索值
13searchSingleValue1搜索值1string—Optional搜索值1,单个搜索值
14searchType搜索类型integer—Optional搜索类型 1:平台单号 2:平台子单
15searchType1搜索类型1integer—Optional搜索类型1 3:MSKU 4:MSKU ID
16sids店铺ID数组array<any>—Optional店铺ID数组
17sortField排序字段string—Optional排序字段
18sortType排序方向string—Optional排序方向 0:DESC 1:ASC
19startDate开始时间string—Optional开始时间,格式:yyyy-MM-dd
20taxesIncluded是否含税integer—Optional是否含税 0:否 1:是 不传:全部
21timeType时间类型integer—Optional时间类型 1:结算时间 2:下单时间
22transactionTypes交易类型array<any>—Optional交易类型

Response Parameters

No.FieldNameTypeDefaultRequiredDescription
1code状态码integer0Required状态码,0:成功
2message消息提示stringsuccessRequired消息提示
3error_details数据校验失败时的错误详情array<any>—Required数据校验失败时的错误详情
4request_id请求链路idstringa0d54debf93140f3b58d1ed81e8e3583Required请求链路id
5response_time响应时间string2026-05-25 12:00:00Required响应时间
6data响应数据object—Required响应数据
6.1list列表数据array<object>—Required列表数据
6.1.1additionalFeeAmount附加费number0Required附加费
6.1.2allocatedShippingAmount分摊运费number5Required分摊运费
6.1.3allocatedShippingDiscount分摊运费折扣number1Required分摊运费折扣
6.1.4allocatedShippingTax分摊运费税number0.3Required分摊运费税
6.1.5children一单多件子项列表array<any>—Required一单多件子项列表,结构同 data>>list
6.1.6currency币种stringUSDRequired币种
6.1.7currencyIcon币种图标string$Required币种图标
6.1.8discountAmount折扣总额number3Required折扣总额
6.1.9discountAmountDetails折扣浮层项array<object>—Required折扣浮层项
6.1.9.1fieldLabel字段标签string商品折扣Required字段标签
6.1.9.2fieldName字段名stringitemDiscountAmountRequired字段名
6.1.9.3fieldValue字段值number2Required字段值
6.1.10discountItemAmount商品折扣number2Required商品折扣
6.1.11discountOtherAmount其他折扣number0Required其他折扣
6.1.12discountShippingAmount运费折扣number1Required运费折扣
6.1.13dutiesIncluded是否含关税string是Required是否含关税
6.1.14dutyAmount关税总额number1.2Required关税总额
6.1.15dutyAmountDetails关税浮层项array<any>—Required关税浮层项,结构同 discountAmountDetails
6.1.16dutyItemAmount商品关税number1.2Required商品关税
6.1.17dutyOtherAmount其他关税number0Required其他关税
6.1.18financialStatus支付状态stringpaidRequired支付状态
6.1.19fulfilledAt标发时间string2026-01-03 10:00:00Required标发时间
6.1.20fulfilledQuantity标发数量integer2Required标发数量
6.1.21fulfillmentStatus履约状态stringfulfilledRequired履约状态
6.1.22hasLineItems是否多件商品平铺integer0Required是否多件商品平铺
6.1.23id主键IDinteger100001Required主键ID
6.1.24isMasterRow是否主行booleantrueRequired是否主行
6.1.25isPrimaryRow主单行标识integer1Required主单行标识
6.1.26itemAmount商品金额number100Required商品金额
6.1.27itemDiscountAmount商品折扣number2Required商品折扣
6.1.28itemDutyAmount商品级关税number1.2Required商品级关税
6.1.29itemDutyTaxAmount商品关税税费number0.1Required商品关税税费
6.1.30itemPrice商品价格number50Required商品价格
6.1.31itemSubtotalAfterDiscount商品金额(折扣后)number98Required商品金额(折扣后)
6.1.32itemTaxAmount商品税number5Required商品税
6.1.33lineItemCount订单商品总数integer1Required订单商品总数
6.1.34lineItemId平台子单号string200001Required平台子单号
6.1.35mskumskustringMSKU-001RequiredMSKU
6.1.36mskuIdMSKU IDstring300001RequiredMSKU ID
6.1.37mskuNameMSKU名称stringWireless MouseRequiredMSKU名称
6.1.38orderCreatedAt下单时间string2026-01-01 09:30:00Required下单时间
6.1.39orderId平台单号IDstring1000001Required平台单号ID
6.1.40orderName平台单号string#1001Required平台单号
6.1.41orderedQuantity下单数量integer2Required下单数量
6.1.42otherFeeAmount其他费用number0.5Required其他费用
6.1.43otherFeeAmountDetails其他费用浮层项array<any>—Required其他费用浮层项,结构同 discountAmountDetails
6.1.44paidAt支付时间string2026-01-01 09:35:00Required支付时间
6.1.45refundAdjustmentAmount退款调整金额number0Required退款调整金额
6.1.46refundAfterFulfilledQuantity标发后退款量integer0Required标发后退款量
6.1.47refundOtherAmount其他退款金额number0Required其他退款金额
6.1.48refundQuantity退款数量integer0Required退款数量
6.1.49refundedAt退款时间string—Required退款时间
6.1.50requiresShipping是否需配送string是Required是否需配送
6.1.51settlementTime结算时间string2026-01-05 12:00:00Required结算时间
6.1.52shippingAmount运费number5Required运费
6.1.53sourceEventId源事件IDstringEVT-10001Required源事件ID
6.1.54storeId店铺IDinteger123456Required店铺ID
6.1.55storeName店铺名称stringShopify US StoreRequired店铺名称
6.1.56subtotalPrice商品金额小计(折扣后)number98Required商品金额小计(折扣后)
6.1.57taxAmount税费总额number5.4Required税费总额
6.1.58taxAmountDetails税费浮层项array<any>—Required税费浮层项,结构同 discountAmountDetails
6.1.59taxDutyAmount关税税费number0.1Required关税税费
6.1.60taxItemAmount商品税费number5Required商品税费
6.1.61taxOtherAmount其他税费number0Required其他税费
6.1.62taxShippingAmount运费税费number0.3Required运费税费
6.1.63taxesIncluded是否含税string是Required是否含税
6.1.64tipAmount小费number0Required小费
6.1.65totalLineItemsPrice商品金额小计number100Required商品金额小计
6.1.66totalPrice总计number108.1Required总计
6.1.67transactionType交易类型stringsaleRequired交易类型
6.2totalCount总记录数integer1Required总记录数
6.3totalSum汇总数据object—Required汇总数据
6.3.1additionalFeeAmount附加费汇总number0Required附加费汇总
6.3.2allocatedShippingAmount分摊运费汇总number5Required分摊运费汇总
6.3.3allocatedShippingDiscount分摊运费折扣汇总number1Required分摊运费折扣汇总
6.3.4allocatedShippingTax分摊运费税汇总number0.3Required分摊运费税汇总
6.3.5currency货币代码stringUSDRequired货币代码
6.3.6currencyIcon货币图标string$Required货币图标
6.3.7discountAmount折扣总额汇总number3Required折扣总额汇总
6.3.8dutyAmount关税总额汇总number1.2Required关税总额汇总
6.3.9dutyItemAmount商品关税汇总number1.2Required商品关税汇总
6.3.10fulfilledQuantity标发数量汇总integer2Required标发数量汇总
6.3.11itemAmount商品金额汇总number100Required商品金额汇总
6.3.12itemDiscountAmount商品折扣汇总number2Required商品折扣汇总
6.3.13itemDutyAmount商品级关税汇总number1.2Required商品级关税汇总
6.3.14itemDutyTaxAmount商品关税税费汇总number0.1Required商品关税税费汇总
6.3.15itemSubtotalAfterDiscount商品金额(折扣后)汇总number98Required商品金额(折扣后)汇总
6.3.16itemTaxAmount商品税汇总number5Required商品税汇总
6.3.17orderedQuantity下单数量汇总integer2Required下单数量汇总
6.3.18otherFeeAmount其他费用汇总number0.5Required其他费用汇总
6.3.19refundAfterFulfilledQuantity标发后退款量汇总integer0Required标发后退款量汇总
6.3.20refundQuantity退款数量汇总integer0Required退款数量汇总
6.3.21shippingAmount运费汇总number5Required运费汇总
6.3.22subtotalPrice商品金额小计(折扣后)汇总number98Required商品金额小计(折扣后)汇总
6.3.23taxAmount税费总额汇总number5.4Required税费总额汇总
6.3.24tipAmount小费汇总number0Required小费汇总
6.3.25totalCount总记录数integer1Required总记录数
6.3.26totalLineItemsPrice商品金额小计汇总number100Required商品金额小计汇总
6.3.27totalPrice总计汇总number108.1Required总计汇总

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.

Need to integrate this API?

Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.