# Search for Orders
# Dxplaination of Interface Call Request
http请求方式：POST
https://api.weixin.qq.com/product/order/search?access_token=xxxxxxxxx
# Example of request parameters
{
"start_pay_time": "2020-03-25 12:05:25",
"end_pay_time": "2020-04-25 12:05:25",
"title": "标题关键字",
"sku_code": "12321",
"user_name": "张三",
"tel_number": "13700000000",
"on_aftersale_order_exist": 0,
"status": 20,
"source": 1, //订单来源，默认0, 0:全部, 1:小商店自营订单, 2:带货订单
"order_id": 123, // 选填，只搜一个订单时使用
"page": 1,
"page_size": 10
}
# Examples of back-up
{
"errcode": 0,
"errmsg":"ok",
"orders":
[
{
"order_id": 12123121332,
"status": 20,
"create_time": "2020-03-25 13:05:25",
"update_time": "2020-03-25 14:05:25",
"order_detail": {
"product_infos":
[
{
"product_id": 234245,
"sku_id": 23424,
"sku_cnt": 10,
"on_aftersale_sku_cnt": 10,
"finish_aftersale_sku_cnt": 0,
"title": "健身环",
"thumb_img": "http://img10.360buyimg.com/n1/s450x450_jfs/t1/85865/39/13611/488083/5e590a40E4bdf69c0/55c9bf645ea2b727.jpg",
"sku_attrs":
[
{
"attr_key": "选择颜色",
"attr_value": "红蓝主机"
}
],
"sale_price": 2000,
"market_price": 2000
},
...
],
"pay_info": {
"pay_method": "微信支付",
"prepay_id": "42526234625",
"transaction_id": "131456479687",
"prepay_time": "2020-03-25 14:04:25",
"pay_time": "2020-03-25 14:05:25"
},
"price_info": {
"product_price": 20000,
"order_price": 10500,
"freight": 500,
"discounted_price": 10000,
"is_discounted": true
},
"delivery_info": {
"address_info": {
"user_name": "陈先生",
"postal_code": "2435245",
"province_name": "广东",
"city_name": "广州",
"county_name": "海珠区",
"detail_info": "大塘",
"national_code": "234234",
"tel_number": "24534252"
},
"delivery_method": "快递",
"express_fee":
[
{
"shipping_method": "ShippingMethod_Express"
}
],
"delivery_product_info":
[
{
"waybill_id": "134654612313",
"delivery_id": "STO",
"delivery_time": "1620738080",
"deliver_type": "DELIVERY_TYPE_OPTIONAL_EXPRESS",
"delivery_address": {
"user_name": "陈先生",
"postal_code": "2435245",
"province_name": "广东",
"city_name": "广州",
"county_name": "海珠区",
"detail_info": "大塘",
"national_code": "234234",
"tel_number": "24534252"
},
"product_infos":
[
{
"product_id": 234245,
"sku_id": 23424,
"product_cnt": 1
}
]
},
...
],
"ship_done_time": "1620738080",
"insurance_info": {
"type": "InsuranceSourceType_None",
"insurance_price": 0
},
"deliver_type": "DELIVERY_TYPE_OPTIONAL_EXPRESS",
"offline_delivery_time": 0,
"offline_pickup_time": 0
}
},
"aftersale_detail": {
"aftersale_order_list":
[
{
"aftersale_order_id": 1234,
"status": 13
},
...
],
"on_aftersale_order_cnt": 1
},
"openid": "oDNt95V1edm_RT8K5GSLW4dQYciE",
"ext_info": {
"customer_notes": "发顺丰",
"merchant_notes": "库存不足，取消"
},
"order_type": 0
},
...
],
"total_num": 20
}
# Dxplaination of request parameters
| 参数 | type | Is it compulsory? | Introductions |
|---|---|---|---|
| start_pay_time | string | no | Search start time for order payment time, format yyyyy-MM-dd HH: mm: ss, e.g. 2021-06-08 10000000, not earlier than 1970-01-01 08000000 |
| end_pay_time | string | no | Search end time for order payment time, format yyyy-MM-dd HH: mm: ss, e.g. 2021-06-08 10000000, not earlier than 1970-01-01 0800000000 |
| title | string | no | Item Title Keywords |
| sku_code | string | no | Product Codes |
| user_name | string | no | recipient |
| tel_number | string | no | Recipient phone number |
| on_aftersale_order_exist | number | no | Do not fill this parameter: All orders 0: No orders are being sold, 1: Orders with a number of orders being sold greater than equal to 1 |
| status | number | no | Order status, default search for paid orders when not filled, enumeration values see RequestOrderStatus |
| source | number | no | Order Source, default 0, 1: Mini Store proprietary order, 2: delivered order |
| order_id | number | no | Select and use when searching for only one order |
| page | number | yes | What Page (Minimum Fill 1) |
| page_size | number | yes | Number of pages (no more than 1000) |
# Dxplaination of callback parameters
| 参数 | type | Introductions |
|---|---|---|
| errcode | string | Error code |
| errmsg | string | Error message |
| orders | array Order | List of orders, structure defined in Get order details Order |
| total_num | number | Total Orders |
# Enumeration - RequestOrderStatus
| 枚举值 | describe |
|---|---|
| 10 | Payment to be made |
| 15 | Group Activity Pay successfully Wait to be in a group |
| 16 | The payment was successful waiting for the merchant to take the order (same-town delivery, offline pick-up) |
| 17 | The payment was successfully pending write-off |
| 20 | To be shipped |
| 21 | Part of shipment |
| 30 | To be received |
| 100 | complete |
| 181 | Orders are automatically cancelled and refunded (coupons, group buying, etc.) |
| 190 | Vendors cancel orders when the item is oversold |
| 200 | Orders are cancelled after all goods are sold. |
| 250 | Order cancellation (including cancellation of unpaid users, automatic cancellation of overtime unpaid payments, aftersales cancellation, oversold merchant cancellation, automatic refund cancellation of cancelled coupons or group orders) |
# Return code
| 返回码 | Error Type |
|---|---|
| -1 | System exceptions |
| -2 | Token too long |
| 9401020 | The parameter is incorrect. |