# 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.