一、获取卖家店铺订单背景
订单是卖家的核心数据,卖家的很多日常工作都是围绕着订单展开,应用的基本功能就是要保证订单实时、完整的展示在卖家面前。由于API请求依赖于网络,存在 着网络不稳定和同步时间长的问题,所以应用必须把淘宝的订单数据同步到本地。如何才能快速、完整的把订单同步到本地是本方案将要讨论的问题。
二、名词解释
在线订单:卖家三个月内已卖出的订单。
增量订单:相对已经同步到本地的订单,凡是在淘宝上发生了变更的订单就是增量订单。
消息服务:一种通过HTTP长连接实时向客户端(应用)推送数据(交易)变更的渠道。
三、API介绍
taobao.trades.sold.get - 获取三个月内已卖出的在线订单,适用于用户初始化的时候使用,ISV不应该用此接口来获取增量订单。不建议使用或尽量少用此接口。
taobao.trades.sold.increment.get – 获取增量订单,适用于用户初始化后,增量同步发生变更的订单,ISV不应该用此接口来获取三个月内的订单。
taobao.trade.fullinfo.get - 获取单笔订单详情。
四、实施方案
订单同步主要分为初始化和增量获取两个步骤:
1、初始化是把3个月内的在线订单全部同步回来,这个需要较长的时间;
2、增量获取则是把淘宝发生了变更的订单同步回来,这个一般需要较短的时间。
API接口获取key和secret测试
JAVAPHP.NETCURLPythonNodeJSC/C++Python3GOPHP7JAVA8.NET6
TaobaoClient client = new DefaultTaobaoClient(url, appkey, secret);
TradesSoldGetRequest req = new TradesSoldGetRequest();
req.setFields("tid,type,status,payment,orders,rx_audit_status");
req.setStartCreated(StringUtils.parseDateTime("2000-01-01 00:00:00"));
req.setEndCreated(StringUtils.parseDateTime("2000-01-01 23:59:59"));
req.setStatus("ALL_WAIT_PAY");
req.setBuyerNick("zhangsan");
req.setType("game_equipment");
req.setExtType("service");
req.setRateStatus("RATE_UNBUYER");
req.setTag("time_card");
req.setPageNo(1L);
req.setPageSize(40L);
req.setUseHasNext(true);
req.setBuyerOpenId("AAHm5d-EAAeGwJedwSHpg8bT");
TradesSoldGetResponse rsp = client.execute(req, sessionKey);
System.out.println(rsp.getBody());
XML JSON
{
"trades_sold_get_response":{
"total_results":100,
"trades":{
"trade":[
{
"seller_nick":"我在测试",
"buyer_open_uid":"AAHk5d-EAAeGwJedwSFu0XXX",
"title":"麦包包",
"type":"fixed(一口价)",
"created":"2000-01-01 00:00:00",
"tid":2231958349,
"acookie_id":"1a11a0987628772c002ec7d0eec2a352",
"sid":"NP1021246146",
"seller_rate":true,
"buyer_rate":true,
"status":"TRADE_NO_CREATE_PAY",
"payment":"200.07",
"discount_fee":"200.07",
"adjust_fee":"200.07",
"post_fee":"200.07",
"total_fee":"200.07",
"pay_time":"2000-01-01 00:00:00",
"end_time":"2000-01-01 00:00:00",
"modified":"2000-01-01 00:00:00",
"async_modified":"2000-01-01 00:00:00",
"consign_time":"2000-01-01 00:00:00",
"received_payment":"200.07",
"commission_fee":"200.07",
"alipay_no":"2009112081173831",
"alipay_id":2011082299567459,
"buyer_area":"浙江省杭州市",
"nut_feature":";buyernick:tester;card:123;buyerArea:杭州",
"pic_path":"http://img08.taobao.net/bao/uploaded/i8/T1jVXXXePbXXaoPB6a_091917.jpg",
"num_iid":3424234,
"price":"200.07",
"cod_fee":"12.07",
"cod_status":"EW_CREATED(订单已创建)",
"shipping_type":"free",
"num":1,
"point_fee":0,
"real_point_fee":0,
"buyer_obtain_point_fee":0,
"receiver_name":"东方不败",
"receiver_state":"浙江省",
"receiver_city":"杭州市",
"receiver_district":"西湖区",
"receiver_town":"三墎镇",
"receiver_address":"淘宝城911号",
"receiver_zip":"223700",
"receiver_mobile":"13512501826",
"receiver_phone":"13819175372",
"seller_flag":1,
"is_lgtype":true,
"lg_aging_type":"次日达",
"lg_aging":"2012-06-19 15:16:14",
"is_brand_sale":true,
"is_force_wlb":true,
"has_buyer_message":true,
"credit_card_fee":"30.5",
"trade_from":"WAP,JHS",
"step_trade_status":"FRONT_NOPAID_FINAL_NOPAID",
"step_paid_fee":"525.70",
"mark_desc":"该订单需要延长收货时间",
"has_yfx":true,
"yfx_fee":"0.50",
"yfx_id":"135751716473138",
"yfx_type":"taojinbi",
"trade_source":"ownshop",
"send_time":"2000-01-01",
"seller_can_rate":true,
"is_part_consign":true,
"is_wt":true,
"is_daixiao":true,
"o2o":"crm",
"o2o_guide_id":"123456",
"o2o_guide_name":"西湖门店导购员1",
"o2o_shop_id":"123456",
"o2o_shop_name":"西湖门店",
"o2o_delivery":"inshop",
"o2o_out_trade_id":"123456",
"orders":{
"order":[
{
"title":"山寨版测试机器",
"pic_path":"http://img08.taobao.net/bao/uploaded/i8/T1jVXXXePbXXaoPB6a_091917.jpg",
"price":"200.07",
"num_iid":2342344,
"sku_id":"5937146",
"outer_iid":"152e442aefe88dd41cb0879232c0dcb0",
"outer_sku_id":"81893848",
"refund_status":"SUCCESS(退款成功)",
"status":"TRADE_NO_CREATE_PAY",
"oid":2231958349,
"total_fee":"200.07",
"payment":"200.07",
"discount_fee":"200.07",
"adjust_fee":"1.01",
"divide_order_fee":"21.00",
"part_mjz_discount":"21.00",
"sku_properties_name":"颜色:桔色;尺码:M",
"item_meal_id":2564854632,
"item_meal_name":"M8原装电池:便携支架:M8专用座充:莫凡保护袋",
"num":1,
"buyer_rate":true,
"seller_rate":true,
"refund_id":"2231958349",
"seller_type":"B(商城商家)",
"cid":123456,
"end_time":"2012-04-07 00:00:00",
"consign_time":"2013-01-13 15:23:00",
"shipping_type":"post",
"logistics_company":"顺风快递",
"invoice_no":"05432465",
"bind_oid":23194074143138,
"is_daixiao":true,
"ticket_outer_id":"123456abcd",
"ticket_expdate_key":"100FFFFFF02374020000002001020304000A",
"is_www":true,
"store_code":"南京QDHEWL-0004",
"tmser_spu_code":"家装干支装服务",
"sub_order_tax_fee":"0",
"sub_order_tax_rate":"0",
"zhengji_status":"1",
"md_qualification":"true_access",
"md_fee":"999",
"sub_order_tax_promotion_fee":"0",
"tax_free":true,
"tax_coupon_discount":"0",
"special_refund_type":"priceProtect",
"is_devalue_fee":true,
"is_idle":"1",
"promise_collect_time":"2000-01-01 00:00:00",
"is_force_dc":true,
"shp_info":{
"ship_info":[
{
"transport_type":"express,seller,instant等"
}
]
}
}
]
},
"service_orders":{
"service_order":[
{
"oid":110770592823138,
"item_oid":110770592803138,
"service_id":2342344,
"service_detail_url":"http://wt.taobao.com/plan.htm?plan_id=planId",
"num":1,
"price":"39.09",
"payment":"29.98",
"title":"滚筒洗衣机",
"total_fee":"39.09",
"buyer_nick":"小倩2005",
"refund_id":"2231958349",
"seller_nick":"麦包包",
"pic_path":"http://img08.taobao.com/bao/upload/i8/T1jVXXXePb_a0908.jpg",
"tmser_spu_code":"家装干支装服务"
}
]
},
"zero_purchase":true,
"receiver_country":"中国",
"order_tax_fee":"0",
"shop_pick":"1",
"rx_audit_status":"0",
"post_gate_declare":true,
"cross_bonded_declare":true,
"order_tax_promotion_fee":"0",
"service_type":"timedd,jiaju",
"is_o2o_passport":true,
"tmall_delivery":true,
"threepl_timing":true,
"cn_service":"84_50",
"cutoff_minutes":"660",
"es_time":"4",
"delivery_time":"2018-06-09 12:13:14",
"collect_time":"2018-06-09 12:13:14",
"dispatch_time":"2018-06-09 12:13:14",
"sign_time":"2018-06-09 12:13:14",
"delivery_cps":"STO",
"es_range":"09:00-12:00",
"es_date":"2018-06-09",
"os_range":"09:00-12:00",
"os_date":"2018-06-09",
"asdp_biz_type":"logistics_upgrade",
"asdp_ads":"201",
"drug_register":"1",
"promise_sign_time":"2000-01-01 00:00:00",
"oaid":"2w2RYE45iahnF4aiaJ7pHKCJ3Hwnbgnq2PH3AfpQVyWZNHKS9wNgAAOUfCVt9XZMetogNHwc",
"scenario_group":"TXD_B2C_FRESH_HALFDAY",
"is_force_dc":true,
"buyer_nick":"我在测试"
}
]
},
"has_next":true
}
}
标签:00,fee,req,接口,订单,01,电商,true
From: https://blog.51cto.com/u_15973577/6930273