淘宝电商API订单接口,买家卖家订单接口等相关数据,企业信息化产业

220 阅读5分钟

一、获取卖家店铺订单背景

订单是卖家的核心数据,卖家的很多日常工作都是围绕着订单展开,应用的基本功能就是要保证订单实时、完整的展示在卖家面前。由于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
    }
}