# 查询订单流水列表

调试诊断

接口应在服务器端调用,不可在前端(小程序、网页、APP等)直接调用,具体可参考接口调用指南

接口英文名:listorderflow

可通过该接口可获取订单的结算信息列表

# 1. 调用方式

# HTTPS 调用

POST https://api.weixin.qq.com/channels/ec/funds/listorderflow?access_token=ACCESS_TOKEN

# 云调用

  • 本接口不支持云调用

# 第三方调用

# 2. 请求参数

# 查询参数 Query String parameters

参数名类型必填示例说明
access_tokenstringACCESS_TOKEN接口调用凭证,可使用 access_token(微信小店商家)、authorizer_access_token(服务商代调用)

# 请求体 Request Payload

参数名类型必填说明枚举
order_settle_statenumber订单结算状态枚举值
order_statenumber订单状态枚举值
order_pay_methodnumber订单支付方式枚举值
order_idstring指定订单id查询-
pagination_infoobject分页信息-
create_time_rangeobject订单创建时间范围-

# Body.pagination_info Object Payload

分页信息

参数名类型必填说明
limitnumber页大小
offsetnumber偏移量
use_page_ctxboolean是否使用分页上下文,可以保证翻页的过程中订单不会遗漏和重复,此时 offset 不生效。
page_ctxstring分页上下文,每次翻页传入上一页回参的 page_ctx,第一页可不传或者传空字符串

# Body.create_time_range Object Payload

订单创建时间范围

参数名类型必填说明
beginnumber订单创建时间开始(闭区间)
endnumber订单创建时间结束(开区间)

# 3. 返回参数

# 返回体 Response Payload

参数名类型说明
errcodenumber-
errmsgstring-
total_countnumber满足条件的总数量,仅供参考(翻页的过程可能变动)
data_listobjarray订单流水列表
page_ctxstring如果使用分页上下文,则返回此字段

# Res.data_list(Array) Object Payload

订单流水列表

参数名类型说明
order_idstring订单id
order_statenumber订单状态
order_settle_statenumber订单结算状态
order_create_timenumber订单创建时间,单位(s)
order_paid_timenumber订单支付时间,单位(s)
order_pay_methodnumber订单支付方式
order_typenumber订单类型
mch_received_amountnumber商户实收金额,单位(分)
expense_amountnumber支出金额,单位(分)
mch_settle_amountnumber(预计)结算金额,单位(分)
mch_settle_timenumber(预计)商家货款结算时间
product_listobjarray商品列表
product_total_amountnumber商品总金额,单位(分)
freight_amountnumber运费金额,单位(分)
change_down_pricenumber改价金额,单位(分)
mch_discount_amountnumber商户优惠金额,单位(分)
score_discount_amountnumber积分抵扣金额,单位(分)
buyer_paid_amountnumber用户实付金额,单位(分)
promoter_discount_amountnumber达人优惠金额,单位(分)
platform_discount_amountnumber平台优惠金额,单位(分)
national_subsidy_discount_amountnumber国家补贴金额,单位(分)
freight_make_up_amountnumber补交运费
cross_shop_discount_amountnumber跨店优惠金额,单位(分)
buyer_refund_amountnumber用户退款金额,单位(分)
platform_discount_refund_amountnumber(预计)平台优惠退款金额,单位(分)
promoter_discount_refund_amountnumber达人优惠退款金额,单位(分)
original_platform_commission_amountnumber原技术服务费,单位(分)
platform_commission_amountnumber(预计)技术服务费,单位(分)
freight_insurance_subsidy_amountnumber运费险补贴减免技术服务费,单位(分)
supplier_commission_amountnumber(预计)机构服务费,单位(分)
supplier_commission_settle_statenumber机构服务费结算状态
promoter_commission_amountnumber(预计)达人服务费,单位(分)
promoter_commission_settle_statenumber达人服务费结算状态
freight_insurance_amountnumber(预计)运费险金额,单位(分)
freight_insurance_settle_statenumber运费险结算状态
freight_insurance_make_up_amountnumber运费险补缴他单金额,单位(分)
freight_insurance_make_up_order_id_listarray运费险补缴他单订单id列表
platform_commission_settle_timenumber(预计)技术服务费结算时间,单位(s)
promoter_commission_settle_timenumber(预计)达人服务费结算时间,单位(s)
supplier_commission_settle_timenumber(预计)机构服务费结算时间,单位(s)
freight_insurance_settle_timenumber(预计)运费险结算时间
freight_insurance_make_up_settle_timenumber(预计)运费险补缴他单结算时间
pre_freight_refund_amountnumber预付运费退回金额
post_settlement_expenseobject结算后支出
refund_before_settlementnumber结算前退款
other_expense_amountnumber其他支出
platform_commission_settle_statenumber平台服务费结算状态
freight_insurance_make_up_settle_statenumber运费险补缴他单结算状态
intra_city_shop_idnumber同城配送门店id

# Res.data_list(Array).product_listObject Payload

商品列表

参数名类型说明
product_idnumber商品id
param_listobjarray商品规格列表
sale_pricenumber商品销售价格,单位分
countnumber商品数量
product_namestring商品名称
is_giftboolean是否赠品

# Res.data_list(Array).product_list.param_listObject Payload

商品规格列表

参数名类型说明
keystring规格名称
valuestring规格值

# Res.data_list(Array).post_settlement_expense Object Payload

结算后支出

参数名类型说明
buyer_refund_amountnumber买家退款
platform_discount_refund_amountnumber平台优惠退款金额
promoter_refund_amountnumber达人退款金额
freight_insurance_make_up_amountnumber运费险保费
freight_insurance_make_up_settle_statenumber运费险补缴本单结算状态
freight_insurance_make_up_order_idnumber运费险补缴本单的订单id

# 4. 枚举信息

# Body.order_settle_state Enum

订单结算状态

枚举值描述
0无,查询全部
1待结算
2无需结算
60结算完成
100部分结算

# Body.order_state Enum

订单状态

枚举值描述
0全部
20待发货
30待收货
100订单完成

# Body.order_pay_method Enum

订单支付方式

枚举值描述
0全部
1普通支付
2先用后付

# 5. 注意事项

所有项目的结算状态,与order_settle_state相同

# 6. 代码示例

请求示例

{
    "order_settle_state": 1,
    "order_state": 30,
    "order_pay_method": 0,
    "order_create_time_range": {
        "begin": 1761926400,
        "end": 1762876799
    },
    "pagination_info": {
        "limit": 20,
        "offset": 0
    }
}

返回示例

```json

{
    "total_count": 1,
    "data_list": [
        {
            "supplier_commission_settle_state": 2,
            "expense_amount": 5994,
            "buyer_paid_amount": 299700,
            "original_platform_commission_amount": 5994,
            "score_discount_amount": 0,
            "promoter_discount_refund_amount": 0,
            "mch_settle_amount": 293706,
            "post_settlement_expense": {
                "promoter_refund_amount": 0,
                "buyer_refund_amount": 0,
                "platform_discount_refund_amount": 0
            },
            "buyer_refund_amount": 0,
            "freight_insurance_settle_state": 2,
            "change_down_price": 0,
            "order_type": 0,
            "pre_freight_refund_amount": 0,
            "other_expense_amount": 0,
            "platform_discount_amount": 0,
            "mch_received_amount": 299700,
            "promoter_discount_amount": 0,
            "order_paid_time": 1762854428,
            "refund_before_settlement": 0,
            "freight_amount": 0,
            "freight_insurance_make_up_settle_state": 2,
            "platform_commission_settle_state": 1,
            "promoter_commission_settle_state": 2,
            "order_create_time": 1762854411,
            "platform_commission_settle_time": 0,
            "order_id": "37000000000000000000",
            "product_total_amount": 299700,
            "platform_discount_transfer_state": 0,
            "order_settle_state": 1,
            "national_subsidy_discount_amount": 0,
            "order_state": 30,
            "cross_shop_discount_amount": 0,
            "platform_discount_refund_amount": 0,
            "mch_settle_time": 0,
            "freight_make_up_amount": 0,
            "product_list": [
                {
                    "count": 1,
                    "is_gift": false,
                    "product_id": 1647017194,
                    "param_list": [
                        {
                            "value": "规格名称1",
                            "key": "规格值1"
                        },
                        {
                            "value": "规格名称2",
                            "key": "规格值2"
                        }
                    ],
                    "sale_price": 299700,
                    "product_name": "商品名称"
                }
            ],
            "order_pay_method": 1,
            "mch_discount_amount": 0,
            "platform_commission_amount": 5994
        }
    ]
}

# 7. 错误码

以下是本接口的错误码列表,其他错误码可参考 通用错误码;调用接口遇到报错,可使用官方提供的 API 诊断工具 辅助定位和分析问题。

错误码错误描述解决方案
669900000参数错误具体查看errmsg
669900001系统异常请重试

# 8. 适用范围

本接口支持「微信小店」账号类型调用。其他账号类型如无特殊说明,均不可调用。

接口变更日志(1条)
2025 年 11 月 12 日
新增查询订单流水列表接口