轻易云
注册体验

领星ERPShopify - 查询结算明细列表接口

所属平台
领星ERP
类型
WebAPI
作用
QUERY
接口版本
1.0
适配器
\Adapter\LingXing\LXQueryAdapter
授权方式
OTHER
描述
多平台 / 财务 / Shopify财务 · POST · 请求参数 22 个(必填 2) · 响应参数 106 个 · 限流令牌桶容量 1
更新日期
2026-11-21

Shopify - 查询结算明细列表

POST/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&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
      }
    }
  }
}

接口请求参数

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

接口响应参数

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

领星ERP的接口:Shopify - 查询结算明细列表(/basicOpen/multiplatformFinance/shopify/bill/statement/list),由轻易云数据集成平台 API 资产管理模块整理收纳,并随领星ERP版本更新同步更新。

需要对接这个接口?

轻易云已预置该接口的适配能力,联系我们即可开始配置数据集成。