获取订单列表
搜索当前会话用户作为卖家已卖出的交易数据(只能获取到三个月以内的交易信息)
-
返回的数据结果是以订单的创建时间倒序排列的。
-
返回的数据结果只包含了订单的部分数据,可通过接口“获取订单详情”获取订单的详细内容。
一、请求参数
请求URL:
| 参数名 | 类型 | 说明 | 示例 |
|---|---|---|---|
| appid | String | 合作伙伴AppId | uwkahf@jfs92 |
| timestamp | String | 当前时间戳 | |
| tb_seller_nick | String | 淘宝卖家店铺登录账号,非店铺名称 | kingdo |
| sign | String | 接口签名 | 如何计算生成见示例代码 |
| start_created | 必填, Date | 查询三个月内交易创建时间开始。格式:yyyy-MM-dd HH:mm:ss | |
| end_created | 必填, Date | 查询交易创建时间结束。格式:yyyy-MM-dd HH:mm:ss | |
| status | String | 可选, 交易状态 ,默认查询所有交易状态的数据, 除了默认值外每次只能查询一种状态。WAIT_BUYER_PAY:等待买家付款 WAIT_SELLER_SEND_GOODS:等待卖家发货 、 SELLER_CONSIGNED_PART:卖家部分发货 WAIT_BUYER_CONFIRM_GOODS:等待买家确认收货 TRADE_BUYER_SIGNED:买家已签收(货到付款专用) TRADE_FINISHED:交易成功 TRADE_CLOSED:交易关闭 | |
| page_no | int | 可选, 当前页,默认1 | |
| page_size | int | 可选, 每页大小, 最大30 | |
| use_has_next | bool | 是否启用has_next的分页方式,如果指定true,则返回的结果中不包含总记录数total_results(此值一直为0) ,但是会新增一个是否存在下一页的的字段has_next,通过此种方式获取增量交易,接口调用成功率在原有的基础上有所提升。 | |
| type | string | 交易类型列表,同时查询多种交易类型可用逗号分隔。默认同时查询guarantee_trade,auto_delivery,ec,cod,step 这5 种的交易类型的数据;查询所有交易类型的数据,需要设置下面全部可选值。可选值:fixed(一口价)auction(拍卖)guarantee_trade(一口价、拍卖)step(分阶段付款,万人团,阶梯团订单)independent_simple_trade(旺店入门版交易)independent_shop_trade(旺店标准版交易)auto_delivery(自动发货)ec(直冲)cod(货到付款)game_equipment(游戏装备)shopex_trade(ShopEX交易)netcn_trade(万网交易)external_trade(统一外部交易)instant_trade (即时到账)b2c_cod(大商家货到付款)hotel_trade(酒店类型交易)super_market_trade(商超交易)super_market_cod_trade(商超货到付款交易)taohua(淘花网交易类型)waimai(外卖交易类型)o2o_offlinetrade(O2O交易)nopaid(即时到帐/趣味猜交易类型)step (万人团) eticket(电子凭证) tmall_i18n(天猫国际);nopaid (无付款交易)insurance_plus(保险)finance(基金)注:guarantee_trade是一个组合查询条件,并不是一种交易类型,获取批量或单个订单中不会返回此种类型的订单。pre_auth_type(预授权0元购) lazada(获取lazada订单类型) | |
| sysid | String | 可空, 代表不同的应用,具体请咨询客服 |
二、请求示例代码
Java
@Test public void getTradeList() throws Exception { String tb_seller_nick = Config.TBSellerNick ; //要查询的淘宝商家 //业务参数 Map<String, String> data = new HashMap<String, String>(); data.put("appid", Config.AppId); // data.put("sysid", "103"); // 代表不同的应用,具体请咨询客服 data.put("tb_seller_nick", tb_seller_nick); Long timestamp = System.currentTimeMillis() / 1000; data.put("timestamp", timestamp.toString()); Calendar calendar=Calendar.getInstance(); calendar.add(Calendar.DAY_OF_MONTH, -14); SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); data.put("start_created", df.format(calendar.getTime())); Date end = new Date(); data.put("end_created", df.format(end)); data.put("status", "WAIT_BUYER_CONFIRM_GOODS"); data.put("page_no", "1"); data.put("page_size","20"); data.put("use_has_next","false"); // data.put("type", "guarantee_trade,auto_delivery,ec,cod,step,o2o_offlinetrade"); data.put("sign", Utils.Sign(data,Config.AppSecret)); // 调用服务API doHttpRequest(Config.TaoBaoOrderListUrl ,data);
}三、返回结果
{ "code": 0, "message": "ok", "data": { "request_id": "wp2nnhmkffap", "total_results": 1, //搜索到的交易信息总数 "has_next": true, // 表示是否还有下一页,取决于入参数use_has_next的值,如果为true,则返回has_next字段 "trades": { "trade": [ { "adjust_fee": "0.00", //卖家手工调整金额 "alipay_id": 2088002269364279, "alipay_no": "2020082022001164271458231416", "buyer_area": "移动", "buyer_nick": "superman", "buyer_obtain_point_fee": 0, "buyer_rate": false, "cod_fee": "0.00", "cod_status": "NEW_CREATED", "created": "2020-08-20 01:24:21", "discount_fee": "0.00", "encrypt_alipay_id": "2088002269364279", "is_brand_sale": false, "is_force_wlb": false, "is_lgtype": false, "modified": "2020-08-20 01:24:29", "num": 1, // 购买数量 "num_iid": 544876335798, // 宝贝ID "orders": { // 订单明细 "order": [ { "adjust_fee": "0.00", "buyer_rate": false, "cid": 50015766, "discount_fee": "0.00", "divide_order_fee": "0.50", "is_daixiao": false, "num": 1, // 购买数量 "num_iid": 544876335798, // 宝贝ID "oid": "1189348257255565830", "outer_iid": "lianhua007", "outer_sku_id": "red35", // sku商家编码 "payment": "0.50", // 付款金额 "pic_path": "https://img.alicdn.com/bao/uploaded/i2/661153176/TB23bWverBmpuFjSZFuXXaG_XXa_!!661153176.jpg", "price": "0.50", // 价格 "refund_status": "NO_REFUND", "seller_rate": false, "seller_type": "C", "sku_id": "3977338583164", "sku_properties_name": "尺码:35;颜色:red", //sku属性 "status": "WAIT_SELLER_SEND_GOODS", // 订单状态 "title": "联华超市提取货券xx", // 宝贝名称 "total_fee": "0.50" // 小计金额 } ] }, "pay_time": "2020-08-20 01:24:28", "payment": "0.50", // 实付金额 "pic_path": "https://img.alicdn.com/bao/uploaded/i2/661153176/TB23bWverBmpuFjSZFuXXaG_XXa_!!661153176.jpg", "point_fee": 0, "post_fee": "0.00", "price": "0.50", "real_point_fee": 0, "received_payment": "0.00", "receiver_address": "世纪大道200号", // 收货人的详细地址 "receiver_city": "上海市", // 城市 "receiver_town":"XX镇", //收件人镇 "receiver_district": "浦东新区", // 区 "receiver_mobile": "13816121231", //收货人手机 "receiver_phone": "", "receiver_name": "陈先生", //收货人姓名 "receiver_state": "上海", // 收货人省份 "receiver_zip": "200120", //收货人邮编 "seller_flag": 0, // 卖家插的旗帜, 1 :红 ,2: 黄 ,3: 绿 ,4: 蓝 ,5: 紫 "has_buyer_message":true, //是否有买家留言 ,如果是的话,可通过订单详情接口获取具体的买家留言。 "seller_nick": "百鞋", "seller_rate": false, "shipping_type": "post", "status": "WAIT_SELLER_SEND_GOODS", // 订单状态 "tid": "1189348257255565831", // 订单号 "title": "d[s64535320]", // 交易标题,以店铺名作为此标题的值 "total_fee": "0.50", //商家金额 "type": "fixed", "oaid": "1h12M4LqkhUkt1ibEk6VyZv2gRsECYSQayzH33CwBP1s3CmkVyx1m4SItNJ6ZhgUibyzr9RA", "buyer_open_uid":"AAEt90gYAAjcqSrFKsJnK_Ba" } ] } }}说明: code为0表示成功,非0为失败,message会包含失败原因。 data字段包含订单列表的数据。返回字段说明:https://open.taobao.com/api.htm?cid=1&docId=46&docType=2