订单列表
本接口为增强型订单列表接口，除了订单列表标准的查询条件之外，还可以按买家留言、订单旗帜、卖家备注、宝贝Id等条件查询订单。
说明：
商家首次订购授权后，一般1，2分钟后即可使用本接口，时间取决于商家的历史订单数据多寡。
一、请求参数
请求URL:
| 参数名 | 类型 | 必须 | 示例值 | 说明 |
|---|---|---|---|---|
| appid | String | true | uwkahf@jfs92 | 合作伙伴AppId |
| timestamp | String | true | 1633618722 | 当前时间戳 |
| seller_nick | String | true | kingdo | 1688账号 |
| sign | String | true | 999de41d862efaa6f1084ead3b3ba480 | 如何计算生成见示例代码 |
| start_created | Date | true | 查询1个月内交易创建时间开始。格式:yyyy-MM-dd HH:mm:ss | |
| end_created | Date | true | 查询交易创建时间结束。格式:yyyy-MM-dd HH:mm:ss | |
| buyer_open_uid | String | fasle | 淘宝买家昵称实施模糊化后, 买家唯一身份标识， 此值可传空字符串 | |
| status | String | false | 2 | 交易状态，1-> waitbuyerpay:等待买家付款; 2->waitsellersend:等待卖家发货; 3-> waitlogisticstakein:等待物流公司揽件; 4-> waitbuyerreceive:等待买家收货; 5-> waitbuyersign:等待买家签收; 6-> signinsuccess:买家已签收; 7-> confirm_goods:已收货; 8-> success:交易成功; 9-> cancel:交易取消; 10-> terminated:交易终止; 11-> 未枚举:其他状态 |
| page_no | int | false | 当前页,默认1 | |
| page_size | int | false | 每页大小， 最大500, 每100为一个阶梯 | |
| buyer_message | String | false | 买家留言 ，受buyer_message_op控制 | |
| buyer_message_op | String | false | 对买家留言的操作。 all 或是不传值,买家留言将不参与查询; eq: 等于 ; ne: 不等于; like: 模糊匹配（包含） | |
| seller_memo | String | false | 卖家备注，受seller_memo_op控制 | |
| seller_memo_op | String | false | 对卖家备注的操作。 all 或是不传值,卖家备注将不参与查询; eq: 等于 ; ne: 不等于; like: 模糊匹配（包含） | |
| seller_flag | int | false | 订单旗帜不传入，表示全部 。 0: 默认（即没有插过旗） 1为红色图标，2为蓝色图标，3为绿色图标，4为黄色图标 | |
| num_iid | long | false | 商品id | |
| tid | string | false | 订单号, 如果多个订单号，请用英文逗号”,”隔开 | |
| refunding | long | false | 订单退款状态，默认为全部 ， 0: 表示没有退款中的订单， 1：表示有退款中的订单 | |
| date_type | int | false | 查询时间（start_created和end_created）的时间类型， 0：按订单创建时间查询 ，1 ：按订单更新时间查询 | |
| order_asc | String | false | 查询时间（start_created和end_created）的排序，DESC：按时间降序返回，ASC： 按时间升序返回 | |
| sysid | String | 100 | 可空， 默认105 |
二、请求示例代码
Java
@Test public void TaoBaoOrderExtList() throws Exception { String seller_nick = Config.alibabaSellerNick; //业务参数 Map<String, String> data = new HashMap<String, String>(); data.put("appid", Config.AppId); data.put("seller_nick", seller_nick); Long timestamp = System.currentTimeMillis() / 1000; data.put("timestamp", timestamp.toString()); data.put("start_created", "2024-05-28 00:00:00"); data.put("end_created", "2024-05-30 23:10:59");// data.put("date_type", "1");// data.put("order_asc", "DESC"); data.put("status", "2");// data.put("buyer_message_op", "ne");// data.put("buyer_message", "不要搞错");// data.put("seller_memo_op", "like");// data.put("seller_memo", "加急发货");// data.put("seller_flag", "1");// data.put("refunding", "1");// data.put("tid", "2494295280998769316"); data.put("page_no", "1"); data.put("page_size", "10"); data.put("sign", Utils.Sign(data, Config.AppSecret)); // 调用服务API String response = doHttpRequest(Config.AlibabaOrderExtListUrl, data);
}三、返回结果
返回结果如下
{ "code": 0, "message": "ok", "data": { "total": 62, "items": [ { "nativeLogistics": { "caid": "DE3q8ISo6sQMaHHHMC6Qv86mUh9c4z3DficPCN53AXyN1v0iavJsBu7Hj5kiabJHM2ibicejSZo-DnZxQpIicj880g22RO3dxkVwa2sia7eym0Hu9zhYy0ibibIVSCyqx0aCCBicOKL1WHdttL", "address": "某条路路*弄*号*室", "area": "杨浦区", "areaCode": "310110", "city": "上海市", "contactPerson": "张*", "mobile": "151****0000", "province": "上海", "zip": "000000" }, "productItems": [ { "productID": 787976764203, "guaranteesTerms": [ { "assuranceInfo": "卖家承诺买家签收货物后7天内，在“商品完好”的情形下，向买家提供退货服务。", "assuranceType": "qtwlybt", "qualityAssuranceType": "7天无理由退货", "shortCode": "qtwlybt" }, { "shortCode": "qtwlybt_2" }, { "assuranceInfo": "卖家在承诺买家保障服务的基础上，向买家提供“48小时发货延必赔”的服务。在买家通过支付宝担保交易完成付款或通过货到付款下单成功后，卖家承诺在买家支付成功起48小时内发货。如卖家未履行前述承诺，买家可在指定期限内发起维权，并申请赔付。", "assuranceType": "ssbxsfh", "qualityAssuranceType": "48小时发货", "shortCode": "D" }, { "shortCode": "D_2" }, { "assuranceInfo": "“在符合一定的退款申请原因、时效和退款金额范围内，可享受0秒退款服务。", "assuranceType": "jstk_p", "qualityAssuranceType": "极速退款", "shortCode": "jstk_p" } ], "type": "common", "orderSharedPromotionFee": "0", "price": "69", "tbId": 3876532491612498400, "specId": "333ed9840c8b0521e492370e5345dbbe", "subItemID": 3876532491612498400, "skuInfos": [ { "name": "颜色", "value": "黑白方格" }, { "name": "尺码", "value": "26/S" } ], "itemDiscountFee": "0", "quantityFactor": "1", "unit": "件", "name": "超薄裙子女夏季2024新款半身裙薄款长款冰丝百搭显瘦时尚潮流裙裤", "status": "waitsellersend", "gmtModified": "20240506162940000+0800", "productImgUrl": [ "http://cbu01.alicdn.com/img/ibank/O1CN01dvssfP1Bs2xInkFlU_!!0-0-cib.80x80.jpg", "http://cbu01.alicdn.com/img/ibank/O1CN01dvssfP1Bs2xInkFlU_!!0-0-cib.jpg" ], "statusStr": "等待卖家发货", "actualPaidFee": 6900, "crossPromotionFee": "0", "productSnapshotUrl": "https://trade.1688.com/order/offer_snapshot.htm?order_entry_id=3876532491612498520", "itemAmount": "69", "quantity": 1, "subItemIDString": "3876532491612498520", "gmtCreate": "20240506162935000+0800", "productCargoNumber": "YYSP2017A33", "logisticsStatus": 1, "skuID": 5549191331204 }, { "productID": 792892854846, "guaranteesTerms": [ { "assuranceInfo": "卖家承诺买家签收货物后7天内，在“商品完好”的情形下，向买家提供退货服务。", "assuranceType": "qtwlybt", "qualityAssuranceType": "7天无理由退货", "shortCode": "qtwlybt" }, { "shortCode": "qtwlybt_2" }, { "assuranceInfo": "卖家在承诺买家保障服务的基础上，向买家提供“24小时发货延必赔”的服务。在买家通过支付宝担保交易完成付款或通过货到付款下单成功后，卖家承诺在买家支付成功起24小时内发货。如卖家未履行前述承诺，买家可在指定期限内发起维权，并申请赔付。", "assuranceType": "essxsfh", "qualityAssuranceType": "24小时发货", "shortCode": "C" }, { "shortCode": "C_2" }, { "assuranceInfo": "“在符合一定的退款申请原因、时效和退款金额范围内，可享受0秒退款服务。", "assuranceType": "jstk_p", "qualityAssuranceType": "极速退款", "shortCode": "jstk_p" } ], "type": "common", "orderSharedPromotionFee": "0", "price": "24", "tbId": 3876532491613498400, "specId": "84e7ee080deb9ae2225ed81b66f81aa8", "subItemID": 3876532491613498400, "skuInfos": [ { "name": "颜色", "value": "黑紫" }, { "name": "尺码", "value": "35" } ], "itemDiscountFee": "0", "quantityFactor": "1", "unit": "双", "name": "2024跨境新款大码35-45tenis橡胶袜子鞋户外旅游运动女鞋", "status": "waitsellersend", "gmtModified": "20240506162940000+0800", "productImgUrl": [ "http://cbu01.alicdn.com/img/ibank/O1CN01L1z3cB1Bs2wNiLl2H_!!0-0-cib.80x80.jpg", "http://cbu01.alicdn.com/img/ibank/O1CN01L1z3cB1Bs2wNiLl2H_!!0-0-cib.jpg" ], "statusStr": "等待卖家发货", "actualPaidFee": 2400, "crossPromotionFee": "0", "productSnapshotUrl": "https://trade.1688.com/order/offer_snapshot.htm?order_entry_id=3876532491613498520", "itemAmount": "24", "quantity": 1, "subItemIDString": "3876532491613498520", "gmtCreate": "20240506162935000+0800", "productCargoNumber": "1855", "logisticsStatus": 1, "skuID": 5415467545150 } ], "extAttributes": [ { "value": "0", "key": "b_i24h" }, { "value": "0", "key": "b_i48h" } ], "orderRateInfo": { "buyerRateStatus": 5, "sellerRateStatus": 5 }, "baseInfo": { "businessType": "cn", "createTime": "20240506162935000+0800", "id": 3876532491611498500, "modifyTime": "20240506162940000+0800", "shippingFee": "4.3", "status": "waitsellersend", "totalAmount": "97.3", "discount": "0", "buyerContact": { "phone": "86-************555", "imInPlatform": "a*", "name": "服*", "companyName": "AOP对外xxx" }, "tradeType": "50060", "idOfStr": "3876532491611498520", "buyerLoginId": "a*", "sellerLoginId": "a*", "buyerAlipayId": "2088611492691533", "sellerAlipayId": "2088522185245811", "sumProductPayment": "93", "flowTemplateCode": "assureTrade", "buyerLevel": "L6", "sellerContact": { "phone": "8-888-5676544", "imInPlatform": "a*", "name": "测试xxxx", "companyName": "xxxxxxxx" }, "newStepOrderList": [ { "gmtStart": "20240506162935000+0800", "stepNo": 1, "lastStep": true, "stepName": "全款交易", "activeStatus": 1, "payStatus": 2, "logisticsStatus": 1, "payFee": "97.3", "paidFee": "97.3", "adjustFee": "0", "discountFee": "0", "postFee": "4.3", "paidPostFee": "4.3" } ], "couponFee": "0", "tradeTypeDesc": "4.0担保交易", "payChannelList": ["账期支付"], "tradeTypeCode": "assureTrade", "payChannelCodeList": ["account_period"], "ccid": "MDdZp3lhWD0ZM7+H18C1gUqTHL2PxBomkdlTsuHnQ28wc=", "buyerOpenUid": "BBBSfGKuvWKXzU1nn-VGpGISA", "payTime": "20240506162941000+0800" }
}
] }}说明： code为0表示成功，非0为失败，message会包含失败原因。total为符合查询的总记录数，可根据返回的总记录数进行分页查询， data字段包含订单列表的数据， 返回的字段说明见文档