# 查询订单列表 ## OpenAPI Specification ```yaml openapi: 3.0.1 info: title: '' description: '' version: 1.0.0 paths: /api/open/order/list: post: summary: 查询订单列表 deprecated: false description: |- ERP同步订单流程说明： 第一步：在开放平台的自研应用中填写订单推送地址 第二步：通过订单推送接口，接收订单信息 第三步：通过订单查询接口，获取订单详情 注意： 1、update_time 为最近6个月内的时间范围 2、通过订单列表总计能获取1w条数据 tags: - 订单 parameters: - name: appid in: query description: '' required: true example: '{{appid}}' schema: type: string - name: timestamp in: query description: 当前时间戳（单位秒，5分钟内有效） required: false example: '{{timestamp}}' schema: type: integer default: '{{timestamp}}' - name: seller_id in: query description: 商家ID（仅商务对接传入，自研/第三方ERP对接忽略即可） example: '{{seller_id}}' schema: type: integer - name: sign in: query description: 签名MD5值（参考签名说明） required: true example: '{{sign}}' schema: type: string requestBody: content: application/json: schema: type: object x-apifox-orders: - authorize_id - order_status - refund_status - order_time - pay_time - consign_time - confirm_time - refund_time - update_time - page_no - page_size properties: authorize_id: type: integer format: int64 title: 店铺授权ID order_status: &ref_1 title: 订单状态 $ref: '#/components/schemas/order_status' refund_status: &ref_2 $ref: '#/components/schemas/refund_status' title: 退款状态 order_time: &ref_0 title: 买家下单时间 $ref: '#/components/schemas/time_range' deprecated: true pay_time: *ref_0 consign_time: *ref_0 confirm_time: *ref_0 refund_time: *ref_0 update_time: *ref_0 page_no: type: integer title: 页码 minimum: 1 default: 1 maximum: 100 format: int32 page_size: type: integer title: 每页行数 description: 当翻页获取的条数（page_no*page_size）超过1万，接口将报错，请尽可能的细化搜索条件 default: 50 minimum: 1 maximum: 100 format: int32 x-apifox-ignore-properties: [] example: page_size: 10 page_no: 1 order_status: 22 responses: '200': description: '' content: application/json: schema: type: object properties: code: type: integer additionalProperties: false format: int32 default: 0 msg: type: string additionalProperties: false default: OK data: type: object properties: list: type: array items: $ref: '#/components/schemas/order_detail' count: type: integer format: int32 title: 查询总数 page_no: type: integer format: int32 title: 页码 page_size: type: integer format: int32 title: 每页行数 required: - list - count - page_no - page_size x-apifox-orders: - list - count - page_no - page_size x-apifox-ignore-properties: [] required: - code - msg - data x-apifox-orders: - code - msg - data x-apifox-ignore-properties: [] examples: '1': summary: 成功示例 value: code: 0 msg: OK data: list: - order_no: '3364202298717566229' order_status: 22 order_time: 1685087039 total_amount: 8000 pay_amount: 1 pay_no: '2023052622001114731441899001' pay_time: 1685087067 refund_status: 0 refund_time: 0 receiver_mobile: '15889106633' receiver_name: 萧祁锐 prov_name: 广东省 city_name: 深圳市 area_name: 南山区 town_name: 粤海街道 address: 桂庙新村 waybill_no: JT3032658260816 express_code: other express_name: '' express_fee: 0 consign_type: 1 consign_time: 1685087379 confirm_time: 1685951386 cancel_reason: '' cancel_time: 0 create_time: 1685087040 update_time: 1685951390 buyer_eid: 6R97619OKz5WmtZ/cgibMA== buyer_nick: 蓝兔子与精灵 seller_eid: 6R97619OKz5WmtZ/cgibMA== seller_name: 逗逼猴子321123 seller_remark: '' goods: quantity: 1 price: 8000 product_id: 421611860404485 item_id: 709548670377 outer_id: '1111' sku_id: 0 sku_outer_id: '' sku_text: '' title: 佳韵宝哺乳枕 买完后闺蜜又送了一个 标签都还没拆 便宜 images: - >- http://img.alicdn.com/bao/uploaded/i4/O1CN01VciDtc1gFLShhFzH9_!!53-fleamarket.heic service_support: '' is_privacy: false - order_no: '3364342266781566229' order_status: 22 order_time: 1685088183 total_amount: 4350 pay_amount: 1 pay_no: '2023052622001114731441822171' pay_time: 1685088230 refund_status: 0 refund_time: 0 receiver_mobile: '15889106633' receiver_name: 萧祁锐 prov_name: 广东省 city_name: 深圳市 area_name: 南山区 town_name: 粤海街道 address: 桂庙新村 waybill_no: '' express_code: '' express_name: '' express_fee: 0 consign_type: 2 consign_time: 1686821376 confirm_time: 1687685382 cancel_reason: '' cancel_time: 0 create_time: 1685088185 update_time: 1687685386 buyer_eid: 6R97619OKz5WmtZ/cgibMA== buyer_nick: 蓝兔子与精灵 seller_eid: 6R97619OKz5WmtZ/cgibMA== seller_name: 逗逼猴子321123 seller_remark: 订单卖家备注 goods: quantity: 1 price: 4350 product_id: 421611860506885 item_id: 708245707949 outer_id: '' sku_id: 5146011339969 sku_outer_id: '' sku_text: 【款式】:充电款 title: 小黄鸭宝宝洗澡花洒戏水玩具小孩电动喷水婴儿沐浴儿童男孩女孩 images: - >- http://img.alicdn.com/bao/uploaded/i4/O1CN01iuNpnP1gFLRZFghNL_!!53-fleamarket.heic service_support: '' is_privacy: false '2': summary: 异常示例 value: code: 100004 msg: 请求参数错误, the value "{{timestamp}}" cannot parsed as int headers: {} x-apifox-name: 成功 x-200:失败: description: '' content: application/json: schema: type: object properties: code: type: integer format: int32 examples: - 500 additionalProperties: false msg: type: string examples: - Internal Server Error additionalProperties: false required: - code - msg x-apifox-orders: - code - msg x-apifox-ignore-properties: [] headers: {} x-apifox-name: 失败 security: [] x-apifox-folder: 订单 x-apifox-status: released x-run-in-apifox: https://app.apifox.com/web/project/2973339/apis/api-95074856-run components: schemas: time_range: type: array items: type: integer format: int64 x-apifox-mock: '@timestamp' title: 时间范围 description: 第一个元素值为开始时间戳,第二个元素值为结束时间戳 minItems: 2 maxItems: 2 x-apifox-folder: '' refund_status: type: integer title: 退款状态 format: int32 enum: - 0 - 1 - 2 - 3 - 4 - 5 - 6 - 8 default: 0 x-apifox-enum: - name: 未申请退款 value: 0 description: 表示买家没有申请退款 - name: 待商家处理 value: 1 description: 买家已经申请退款，等待卖家同意 - name: 待买家退货 value: 2 description: 卖家已经同意退款，等待买家退货 - name: 待商家收货 value: 3 description: 买家已经退货，等待卖家确认收货 - name: 退款关闭 value: 4 description: 买家取消退款/超时未处理自动关闭 - name: 退款成功 value: 5 description: 卖家同意退款/超时未处理自动退款 - name: 已拒绝退款 value: 6 description: 卖家拒绝退款 - name: 待确认退货地址 value: 8 description: 等待卖家确认退货地址 x-apifox-folder: '' order_status: type: integer title: 订单状态 enum: - 11 - 12 - 21 - 22 - 23 - 24 format: int32 x-apifox-enum: - name: '' value: 11 description: 待付款 - name: '' value: 12 description: 待发货 - name: '' value: 21 description: 已发货 - name: '' value: 22 description: 已完成 - name: '' value: 23 description: 已退款 - name: '' value: 24 description: 已关闭 x-apifox-folder: '' order_detail: type: object properties: order_no: type: string title: 闲鱼订单号 examples: - '2226688164543566229' order_type: title: 订单类型 $ref: '#/components/schemas/order_type' order_status: *ref_1 order_time: type: integer format: int32 title: 买家下单时间 examples: - '1636021636' total_amount: type: integer format: int64 title: 订单下单金额（分） examples: - '16000' pay_amount: type: integer title: 订单实付金额（分） format: int64 examples: - '1' pay_time: type: integer format: int32 title: 订单支付时间 examples: - '1636021791' pay_no: type: string title: 支付宝交易号 examples: - '2021110422001114735717689066' refund_status: *ref_2 refund_amount: type: integer title: 订单已退款金额 format: int64 examples: - '1' description: 注意：多次退款的总金额 refund_time: type: integer title: 订单退款时间 description: 仅退款成功有值 format: int32 examples: - 1636077361 receiver_name: type: string examples: - 张三 description: 仅待发货状态返回 title: 收货人姓名 receiver_mobile: type: string description: 仅待发货状态返回 examples: - '13800138000' title: 收货人号码 prov_name: type: string examples: - 广东省 description: 仅待发货状态返回 title: 收货省份 city_name: type: string examples: - 深圳市 description: 仅待发货状态返回 title: 收货城市 area_name: type: string examples: - 南山区 description: 仅待发货状态返回 title: 收货地区 town_name: type: string examples: - 粤海街道 description: 仅待发货状态返回 title: 收货街道 address: type: string examples: - 桂庙新村100室 description: 仅待发货状态返回 title: 收货详细地址 waybill_no: type: string title: 快递单号 examples: - SF23817389113 express_code: type: string title: 快递公司代码 examples: - shunfeng express_name: type: string title: 快递公司名称 examples: - 顺丰速运 express_fee: type: integer format: int32 title: 运费（分） examples: - '0' consign_time: type: integer format: int32 title: 订单发货时间 examples: - '1636021854' consign_type: type: integer title: 订单发货类型 format: int32 enum: - 1 - 2 description: |- 枚举值： 1 : 物流发货 2 : 虚拟发货 x-apifox-enum: - name: '' value: 1 description: 物流发货 - name: '' value: 2 description: 虚拟发货 confirm_time: type: integer format: int32 title: 订单成交时间 examples: - '1636077361' cancel_reason: type: string title: 订单取消原因 examples: - 不想要了 cancel_time: type: integer format: int32 title: 订单取消时间 examples: - '1636077361' create_time: type: integer format: int32 title: 订单创建时间 update_time: type: integer format: int32 title: 订单更新时间 examples: - '1636077365' buyer_eid: type: string title: 买家标识 examples: - 6R97619OKz5WmtZ/cgibMA== description: 闲鱼体系内唯一的用户标识 buyer_nick: type: string title: 买家昵称 examples: - 疯狂小子 seller_eid: type: string title: 卖家标识 examples: - 6R97619OKz5WmtZ/cgibMA== description: 与闲鱼店铺`user_identity`字段一致（闲鱼内唯一且不变） seller_name: type: string title: 卖家会员名 examples: - tb924343042 description: 与闲鱼店铺`user_name`字段一致（存在变更的可能性） seller_remark: type: string title: 卖家备注 examples: - 疫情期间暂停发货 idle_biz_type: type: integer format: int32 enum: - 20 x-apifox-enum: - value: 20 name: 拼团订单 description: '' examples: - 20 title: 子业务类型 description: |- 枚举值： 20：拼团订单 pin_group_status: type: integer title: 拼团状态 description: |- 枚举值： 1：拼团中 2：拼团成功 3：拼团超时 format: int32 examples: - 1 enum: - 1 - 2 - 3 x-apifox-enum: - value: 1 name: 拼团中 description: '' - value: 2 name: 拼团成功 description: '' - value: 3 name: 拼团超时 description: '' is_tax_included: type: boolean title: 是否包含税费 description: 目前仅用于跨境订单 goods: type: object properties: quantity: type: integer format: int32 title: 购买数量 examples: - '2' price: type: integer format: int64 title: 商品单价（分） examples: - '8000' product_id: type: integer title: 管家商品ID format: int64 item_id: type: integer title: 闲鱼商品ID examples: - '659437081448' format: int64 outer_id: type: string title: 商家编码 examples: - GJKCS01234 sku_id: type: integer title: 管家SKU规格ID format: int64 examples: - 219530767978567 sku_outer_id: type: string title: 商家SKU编码 examples: - gjkcs404 sku_text: type: string title: SKU规格 examples: - 颜色:黑色;大小:小 title: type: string title: 商品标题 examples: - 公交卡测试 images: type: array items: type: string title: 商品主图 service_support: title: 商品服务项 $ref: '#/components/schemas/service_support' required: - quantity - price - product_id - item_id - outer_id - sku_id - sku_outer_id - sku_text - title - images - service_support title: 商品信息 x-apifox-orders: - quantity - price - product_id - item_id - outer_id - sku_id - sku_outer_id - sku_text - title - images - service_support x-apifox-ignore-properties: [] is_privacy: type: boolean title: 是否为隐私号订单 description: 仅待发货状态返回 required: - order_no - order_type - order_status - order_time - total_amount - pay_amount - pay_time - pay_no - refund_status - refund_amount - refund_time - waybill_no - express_code - express_name - express_fee - consign_time - consign_type - confirm_time - cancel_reason - cancel_time - create_time - update_time - buyer_eid - buyer_nick - seller_eid - seller_name - seller_remark - idle_biz_type - pin_group_status - goods x-apifox-orders: - order_no - order_type - order_status - order_time - total_amount - pay_amount - pay_time - pay_no - refund_status - refund_amount - refund_time - receiver_name - receiver_mobile - prov_name - city_name - area_name - town_name - address - waybill_no - express_code - express_name - express_fee - consign_time - consign_type - confirm_time - cancel_reason - cancel_time - create_time - update_time - buyer_eid - buyer_nick - seller_eid - seller_name - seller_remark - idle_biz_type - pin_group_status - is_tax_included - goods - is_privacy title: 订单详情 x-apifox-ignore-properties: [] x-apifox-folder: '' service_support: type: string title: 商品服务项 description: |- 多个时用英文逗号`,`拼接 枚举值： SDR : 七天无理由退货 NFR : 描述不符包邮退 VNR : 描述不符全额退（虚拟类） FD_10MS : 10分钟极速发货（虚拟类） FD_24HS : 24小时极速发货 FD_48HS : 48小时极速发货 FD_GPA : 正品保障（包赔） NFGC : 不符必赔 NFR_30D : 30天描述不符可退 RSI : 运费退货险 F3P : 假⼀赔三 RISK_30D : 30天收货 RISK_90D : 90天收货 examples: - SDR,NFR x-apifox-folder: '' order_type: type: integer title: 订单类型 format: int32 enum: - 1 - 2 - 3 - 4 - 7 - 8 - 9 - 10 - 11 - 12 - 14 - 15 - 24 - 20 x-apifox-enum: - name: '' value: 1 description: 普通订单 - name: '' value: 2 description: 分销订单 - name: '' value: 3 description: 验货宝订单 - name: '' value: 4 description: 拍卖订单 - name: '' value: 7 description: 卡密订单 - name: '' value: 8 description: 直充订单 - name: '' value: 9 description: 严选订单 - name: '' value: 10 description: 特卖订单 - value: 11 name: '' description: 潮玩订单 - value: 12 name: '' description: 捡漏订单 - value: 14 name: '' description: 预售订单 - value: 15 name: '' description: 拼团订单 - value: 24 name: '' description: 跨境订单 - value: 20 name: '' description: 订金订单 x-apifox-folder: '' securitySchemes: apiKey: type: apikey description: Enter JWT Bearer token **_only_** name: Authorization in: header servers: - url: https://open.goofish.pro description: 新版正式环境 security: [] ```