一、获取淘宝卖家店铺订单背景:
订单是卖家的核心数据,卖家的很多日常工作都是围绕着订单展开,应用的基本功能就是要保证订单实时、完整的展示在卖家面前。由于API请求依赖于网络,存在 着网络不稳定和同步时间长的问题,所以应用必须把淘宝的订单数据同步到本地。如何才能快速、完整的把订单同步到本地是本方案将要讨论的问题。
二、名词解释:
1、在线订单:卖家三个月内已卖出的订单。
2、增量订单:相对已经同步到本地的订单,凡是在淘宝上发生了变更的订单就是增量订单。
3、消息服务:一种通过HTTP长连接实时向客户端(应用)推送数据(交易)变更的渠道。
三、API介绍
taobao.trades.sold.get - 获取三个月内已卖出的在线订单,适用于用户初始化的时候使用,ISV不应该用此接口来获取增量订单。不建议使用或尽量少用此接口。taobao.trades.sold.increment.get – 获取增量订单,适用于用户初始化后,增量同步发生变更的订单,ISV不应该用此接口来获取三个月内的订单。taobao.trade.fullinfo.get - 获取单笔订单详情。
四、实施方案
订单同步主要分为初始化和增量获取两个步骤:
1、初始化是把3个月内的在线订单全部同步回来,这个需要较长的时间;
2、增量获取则是把淘宝发生了变更的订单同步回来,这个一般需要较短的时间。
更多API调用请点击获取Key和secret
{
"item": {
"num_iid": "675005705203",
"title": "安徽砀山黄桃水果10斤当季黄金大桃子脆甜蜜桃黄肉桃应季整箱包邮",
"desc_short": "",
"price": "23.8",
"orginal_price": "98.00",
"nick": "探味君旗舰店",
"num": "200",
"pic_url": "//img.alicdn.com/imgextra/i3/2271279753/O1CN01sGTp7v2LuvaTIGn5Q_!!2271279753.jpg",
"brand": "探味君",
"brandId": "726060111",
"rootCatId": "50050359",
"cid": "50556001",
"crumbs": [],
"detail_url": "https://item.taobao.com/item.htm?id=675005705203",
"desc": "<p><img src="http://img.alicdn.com/imgextra/i3/2271279753/O1CN01kUZiqD2LuvaXbq73e_!!2271279753.jpg" align="absmiddle" /><img src="http://img.alicdn.com/imgextra/i3/2271279753/O1CN01OpJ3JY2LuvaaQ1A4T_!!2271279753.jpg" align="absmiddle" /><img src="http://img.alicdn.com/imgextra/i2/2271279753/O1CN01c2BbOM2LuvaYNO7mp_!!2271279753.jpg" align="absmiddle" /><img src="http://img.alicdn.com/imgextra/i1/2271279753/O1CN017eMXkC2LuvaHTklK7_!!2271279753.jpg" align="absmiddle" /><img src="http://img.alicdn.com/imgextra/i1/2271279753/O1CN01DjgYAh2LuvaYNRgDk_!!2271279753.jpg" align="absmiddle" /><img src="http://img.alicdn.com/imgextra/i2/2271279753/O1CN01h4H1Yp2LuvaQzyz05_!!2271279753.jpg" align="absmiddle" /></p><img src="https://www.o0b.cn/i.php?t.png&rid=gw-4.62f74832d1bdb&p=2672552609&k=65865&t=1660373044" style="display:none" />",
"item_imgs": [
{
"url": "//img.alicdn.com/imgextra/i3/2271279753/O1CN01sGTp7v2LuvaTIGn5Q_!!2271279753.jpg"
},
{
"url": "//img.alicdn.com/imgextra/i1/2271279753/O1CN01T32OK52LuvaWNOUW5_!!2271279753.jpg"
},
{
"url": "//img.alicdn.com/imgextra/i1/2271279753/O1CN01pPw6UG2LuvaR5ndNu_!!2271279753.jpg"
},
{
"url": "//img.alicdn.com/imgextra/i2/2271279753/O1CN01sAqyl92LuvaNvnhGX_!!2271279753.jpg"
},
{
"url": "//img.alicdn.com/imgextra/i3/2271279753/O1CN01BKGxjw2LuvaOd89O6_!!2271279753.jpg"
}
],
"item_weight": 0,
"location": "安徽宿州",
"post_fee": " 免运费",
"express_fee": 0,
"ems_fee": 0,
"shipping_to": "",
"has_discount": "true",
"video": [],
"is_virtual": "",
"sample_id": "",
"is_promotion": "true",
"prop_imgs": {
"prop_img": []
},
"property_alias": "",
"props": [
{
"name": "品牌",
"value": "探味君"
},
{
"name": "城市",
"value": "宿州市"
},
{
"name": "产地",
"value": "中国大陆"
},
{
"name": "省份",
"value": "安徽省"
},
{
"name": "是否为有机食品",
"value": "否"
},
{
"name": "同城服务",
"value": "同城24小时物流送货上门"
},
{
"name": "包装方式",
"value": "散装"
},
{
"name": "售卖方式",
"value": "单品"
},
{
"name": "套餐份量",
"value": "3人份"
},
{
"name": "套餐周期",
"value": "1周"
},
{
"name": "配送频次",
"value": "1周2次"
},
{
"name": "热卖时间",
"value": "1月 2月 3月 4月 5月 6月 7月 8月 9月 10月 11月 12月"
},
{
"name": "净含量",
"value": "3斤 5斤 9斤 10斤"
},
{
"name": "单果规格",
"value": "【特惠装】小果(单果170-200g)个小不推荐! 【超值装】中果(单果200-230g)丨头茬尝鲜,10%买家选择! 【吃货装】大果(单果230-260g)丨脆甜多汁,可做罐头,高性价比! 【严选装】大大果(单果260-300g)丨正宗原产地❤只卖大果❤品质好桃子!"
},
{
"name": "生鲜储存温度",
"value": "0-8℃"
},
{
"name": "厂名",
"value": "探味君旗舰店"
},
{
"name": "厂址",
"value": "探味君旗舰店"
},
{
"name": "厂家联系方式",
"value": "18676962036"
},
{
"name": "保质期",
"value": "7"
}
],
"props_name": "147956252:7454582:净含量:3斤;147956252:15227063:净含量:5斤;147956252:5200057:净含量:9斤;147956252:4139467:净含量:10斤;150570272:21426615736:单果规格:【特惠装】小果(单果170-200g)个小不推荐!;150570272:21426615737:单果规格:【超值装】中果(单果200-230g)丨头茬尝鲜,10%买家选择!;150570272:21426615738:单果规格:【吃货装】大果(单果230-260g)丨脆甜多汁,可做罐头,高性价比!;150570272:21426615739:单果规格:【严选装】大大果(单果260-300g)丨正宗原产地❤只卖大果❤品质好桃子!",
"total_sold": 39740000,
"skus": {
"sku": [
{
"price": "23.8",
"total_price": 0,
"orginal_price": "23.8",
"properties": "147956252:7454582;150570272:21426615736",
"properties_name": "147956252:7454582:净含量:3斤;150570272:21426615736:单果规格:【特惠装】小果(单果170-200g)个小不推荐!",
"quantity": "200",
"sku_id": "5037646258841"
},
{
"price": "25.8",
"total_price": 0,
"orginal_price": "25.8",
"properties": "147956252:7454582;150570272:21426615737",
"properties_name": "147956252:7454582:净含量:3斤;150570272:21426615737:单果规格:【超值装】中果(单果200-230g)丨头茬尝鲜,10%买家选择!",
"quantity": "200",
"sku_id": "5037646258842"
},
{
"price": "26.8",
"total_price": 0,
"orginal_price": "26.8",
"properties": "147956252:7454582;150570272:21426615738",
"properties_name": "147956252:7454582:净含量:3斤;150570272:21426615738:单果规格:【吃货装】大果(单果230-260g)丨脆甜多汁,可做罐头,高性价比!",
"quantity": "200",
"sku_id": "5037646258843"
},
{
"price": "27.8",
"total_price": 0,
"orginal_price": "27.8",
"properties": "147956252:7454582;150570272:21426615739",
"properties_name": "147956252:7454582:净含量:3斤;150570272:21426615739:单果规格:【严选装】大大果(单果260-300g)丨正宗原产地❤只卖大果❤品质好桃子!",
"quantity": "200",
"sku_id": "5037646258844"
},
{
"price": "33.8",
"total_price": 0,
"orginal_price": "33.8",
"properties": "147956252:15227063;150570272:21426615736",
"properties_name": "147956252:15227063:净含量:5斤;150570272:21426615736:单果规格:【特惠装】小果(单果170-200g)个小不推荐!",
"quantity": "200",
"sku_id": "5037646258833"
},
{
"price": "35.8",
"total_price": 0,
"orginal_price": "35.8",
"properties": "147956252:15227063;150570272:21426615737",
"properties_name": "147956252:15227063:净含量:5斤;150570272:21426615737:单果规格:【超值装】中果(单果200-230g)丨头茬尝鲜,10%买家选择!",
"quantity": "200",
"sku_id": "5037646258834"
},
{
"price": "37.8",
"total_price": 0,
"orginal_price": "37.8",
"properties": "147956252:15227063;150570272:21426615738",
"properties_name": "147956252:15227063:净含量:5斤;150570272:21426615738:单果规格:【吃货装】大果(单果230-260g)丨脆甜多汁,可做罐头,高性价比!",
"quantity": "200",
"sku_id": "5037646258835"
},
{
"price": "39.8",
"total_price": 0,
"orginal_price": "39.8",
"properties": "147956252:15227063;150570272:21426615739",
"properties_name": "147956252:15227063:净含量:5斤;150570272:21426615739:单果规格:【严选装】大大果(单果260-300g)丨正宗原产地❤只卖大果❤品质好桃子!",
"quantity": "200",
"sku_id": "5037646258836"
},
{
"price": "48.8",
"total_price": 0,
"orginal_price": "48.8",
"properties": "147956252:5200057;150570272:21426615736",
"properties_name": "147956252:5200057:净含量:9斤;150570272:21426615736:单果规格:【特惠装】小果(单果170-200g)个小不推荐!",
"quantity": "200",
"sku_id": "5037646258837"
},
{
"price": "52.8",
"total_price": 0,
"orginal_price": "52.8",
"properties": "147956252:5200057;150570272:21426615737",
"properties_name": "147956252:5200057:净含量:9斤;150570272:21426615737:单果规格:【超值装】中果(单果200-230g)丨头茬尝鲜,10%买家选择!",
"quantity": "200",
"sku_id": "5037646258838"
},
{
"price": "54.8",
"total_price": 0,
"orginal_price": "54.8",
"properties": "147956252:5200057;150570272:21426615738",
"properties_name": "147956252:5200057:净含量:9斤;150570272:21426615738:单果规格:【吃货装】大果(单果230-260g)丨脆甜多汁,可做罐头,高性价比!",
"quantity": "200",
"sku_id": "5037646258839"
},
{
"price": "56.8",
"total_price": 0,
"orginal_price": "56.8",
"properties": "147956252:5200057;150570272:21426615739",
"properties_name": "147956252:5200057:净含量:9斤;150570272:21426615739:单果规格:【严选装】大大果(单果260-300g)丨正宗原产地❤只卖大果❤品质好桃子!",
"quantity": "200",
"sku_id": "5037646258840"
},
{
"price": "97",
"total_price": 0,
"orginal_price": "97",
"properties": "147956252:4139467;150570272:21426615736",
"properties_name": "147956252:4139467:净含量:10斤;150570272:21426615736:单果规格:【特惠装】小果(单果170-200g)个小不推荐!",
"quantity": "0",
"sku_id": "5042662462532"
}
]
},
"seller_id": "2271279753",
"shop_id": "114628945",
"props_list": {
"147956252:7454582": "净含量:3斤",
"147956252:15227063": "净含量:5斤",
"147956252:5200057": "净含量:9斤",
"147956252:4139467": "净含量:10斤",
"150570272:21426615736": "单果规格:【特惠装】小果(单果170-200g)个小不推荐!",
"150570272:21426615737": "单果规格:【超值装】中果(单果200-230g)丨头茬尝鲜,10%买家选择!",
"150570272:21426615738": "单果规格:【吃货装】大果(单果230-260g)丨脆甜多汁,可做罐头,高性价比!",
"150570272:21426615739": "单果规格:【严选装】大大果(单果260-300g)丨正宗原产地❤只卖大果❤品质好桃子!"
},
"seller_info": {
"nick": "探味君旗舰店",
"item_score": "4.4 ",
"score_p": "4.6 ",
"delivery_score": "4.6 ",
"shop_type": "B",
"user_num_id": "2271279753",
"sid": "114628945",
"title": "探味君旗舰店",
"zhuy": "https://shop114628945.taobao.com/",
"shop_name": "探味君旗舰店"
},
"tmall": true,
"update_time": "2022-08-13 14:44:04",
"data_update": "2022-08-13 14:44:04",
"data_f": "xdl",
"data_from": "hid",
"promo_type": null,
"props_img": [],
"error": null,
"format_check": "ok",
"sales": 0,
"desc_img": [
"http://img.alicdn.com/imgextra/i3/2271279753/O1CN01kUZiqD2LuvaXbq73e_!!2271279753.jpg",
"http://img.alicdn.com/imgextra/i3/2271279753/O1CN01OpJ3JY2LuvaaQ1A4T_!!2271279753.jpg",
"http://img.alicdn.com/imgextra/i2/2271279753/O1CN01c2BbOM2LuvaYNO7mp_!!2271279753.jpg",
"http://img.alicdn.com/imgextra/i1/2271279753/O1CN017eMXkC2LuvaHTklK7_!!2271279753.jpg",
"http://img.alicdn.com/imgextra/i1/2271279753/O1CN01DjgYAh2LuvaYNRgDk_!!2271279753.jpg",
"http://img.alicdn.com/imgextra/i2/2271279753/O1CN01h4H1Yp2LuvaQzyz05_!!2271279753.jpg",
"https://www.o0b.cn/i.php?t.png&rid=gw-4.62f74832d1bdb&p=2672552609&k=65865&t=1660373044"
],
"shop_item": [],
"relate_items": []
},
"error": "",
"secache": "ca9c9e1a5df7a5aaa2ad62c8b1447b45",
"secache_time": 1665280442,
"secache_date": "2022-10-09 09:54:02",
"translate_status": "",
"translate_time": 0,
"language": {
"default_lang": "cn",
"current_lang": "cn"
},
"reason": "",
"error_code": "0000",
"cache": 0,
"api_info": "today:23 max:10000 all[90=23+39+28];expires:2030-12-31",
"execution_time": "0.297",
"server_time": "Beijing/2022-10-09 09:54:02",
"client_ip": "106.6.32.64",
"call_args": {
"num_iid": "675005705203",
"is_promotion": "1"
},
"api_type": "taobao",
"translate_language": "zh-CN",
"translate_engine": "google_new",
"server_memory": "5.96MB",
"request_id": "gw-1.634229ba6461a",
"last_id": "1270481251"
}