API接口获取订单详情和商品详情

116 阅读11分钟

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