**序言:相信大家都会有监控某网页的需求及网站的商品价格更新的需求,比如招标网信息更新监控,淘宝网商品信息更新监控,网上商城商品信息更新监控等等。供大家获得一手信息或者价格变化情况;同时方便经销商,厂家、供货商等监控商品价格异动,防止零售出现乱开价的现象,保护厂家,经销商、供货商的合法权益,有利于净化价格市场。接口价格低至几厘,量大甚至免费,详细请加我,或者私聊我,或者是点击注册账号获取key和secret,直接获取免费测试。
点击获取测试key和secret
方法:要监控竞争对手产品的价格调整,所以用Python写了改价自动钉钉群提醒的脚本,以下是实现原理:
一、数据库准备
本人使用的mysql:
创建了三张表:
1、数据源表:最初的产品价格表
2、匹配表:跟数据源表进行价格匹配
3、更新表:记录更新的价格记录
二、工具(Python爬虫)
将最初的数据抓取存入数据源表中,作为数据匹配源;
然后进行第二次数据抓取存取匹配表中,跟源表数据进行匹配;
通过sql语句查询出两张表不同的产品以及更改的价格,
如果数据没有更改,则结束程序;
否则将这部分信息替换源数据表,这样下次匹配就不会再匹配到旧的数据,并且存入更新表作为价格更改的记录。
再将这部分数据传入进钉钉机器人,就可以实现产品价格更改提醒。
爬虫脚本可以定时执行,时间根据自己需求而定半小时、一小时都可以。
三、搜索接口展示(淘宝天猫/1688/京东等等,共有20多个平台可以实现):
三、请求参数
请求参数:q=女装&start_price=0&end_price=0&page=1&cat=0&discount_only=&sort=&page_size=&seller_info=&nick=&ppath=&imgid=&filter=
参数说明:q:搜索关键字
cat:分类ID
start_price:开始价格
end_price:结束价格
sort:排序[bid,_bid,bid2,_bid2,_sale,credit]
(bid:总价,bid2:商品价格,sale:销量,credit信用,加_前缀为从大到小排序)
page:页数
四、响应参数
名称 类型 示例值 描述
items items[] 按关键字搜索商品
page Int 1 页码
page_size Int 44 接口返回数量
real_total_results Int 1900 宝贝数量
total_results Int 1900 宝贝数量
pagecount Int 120 总页数
item item[] 宝贝详情数据
title String 法式复古山本超仙chic仙女赫本网红初春很仙法国小众裙子两件套装 商品标题
pic_url String //img.alicdn.com/bao/uploaded/i3/3083218865/O1CN012FMDaiwxkenJGaM!!0-item_pic.jpg 宝贝图片
promotion_price Float 178.00 优惠价
price Float 178.00 价格
sales Int 890 销量
num_iid Bigint 577437133060 宝贝ID
sample_id String 商品风格标识ID
seller_nick String 初穆旗舰店 掌柜昵称
post_fee Float 10.00 物流费用
area String 山东 店铺所在地
detail_url String //detail.tmall.com/item.htm?id=586794298909&ns=1&abbucket=0 宝贝链接
seller_info Mix {“level”: 99, “shop_type”: “B”, “user_num_id”: “2217148345”, “cid”: 0, “delivery_score”: “”, “item_score”: “”, “score_p”: “”} 卖家信息
五、请求示例:(CURL、PHP 、PHPsdk 、Java 、C# 、Python…)
-- 请求示例 url 默认请求参数已经URL编码处理
curl -i "https://注册key和secret拿到服务器地址/taobao/item_search/?key=<您自己的apiKey>&secret=<您自己的apiSecret>&q=女装&start_price=0&end_price=0&page=1&cat=0&discount_only=&sort=&page_size=&seller_info=&nick=&ppath=&imgid=&filter="
响应示例:
{
"item": {
"num_iid": "572050066584",
"name": "尺码:S;颜色分类:白色衬衫",
"img": "//img.alicdn.com/imgextra/i2/3542320334/TB2gPaOyYSYBuNjSspiXXXNzpXa_!!3542320334.jpg",
"price": "135",
"orginal_price": "135",
"express_fee": null,
"title": "雪纺白色衬衫女长袖面试职业正装2018秋新款OL防走光工作服打底衣",
"detail_link": "https://item.taobao.com/item.htm?id=572050066584",
"pic_url": "//img.alicdn.com/imgextra/i2/3542320334/TB2zGWny4SYBuNjSsphXXbGvVXa_!!3542320334.jpg",
"quantity": "257",
"properties": "20509:28314;1627207:3714507",
"sku_id": "3880971359554"
},
"secache": "1ada3a5e5067def024375a479537a3f4",
"secache_time": 1615346439,
"secache_date": "2021-03-10 11:20:39",
"error": "",
"reason": "",
"error_code": "0000",
"cache": 0,
"api_info": "today:47 max:10000",
"execution_time": 2.065,
"server_time": "Beijing/2021-03-10 11:20:39",
"client_ip": "106.6.35.144",
"call_args": {
"num_iid": "572050066584"
},
"api_type": "taobao",
"translate_language": "zh-CN",
"translate_engine": "google_cn",
"server_memory": "5.24MB",
"request_id": "gw-4.60483b05e4591"
}
商品详情接口响应参数示例:
{
"item": {
"num_iid": "520813250866",
"title": "三刃木折叠刀过安检创意迷你钥匙扣钥匙刀军刀随身多功能小刀包邮",
"desc_short": "",
"price": 25.8,
"total_price": 0,
"suggestive_price": 0,
"orginal_price": "25.80",
"nick": "欢乐购客栈",
"num": "832",
"min_num": 0,
"detail_url": "http://item.taobao.com/item.htm?id=520813250866",
"pic_url": "//img.alicdn.com/imgextra/i4/2596264565/TB2p30elFXXXXXQXpXXXXXXXXXX_!!2596264565.jpg",
"brand": "三刃木",
"brandId": "4036703",
"rootCatId": "50013886",
"cid": "50014822",
"favcount": "4824",
"fanscount": "1469",
"crumbs": [],
"created_time": "",
"modified_time": "",
"delist_time": "",
"desc": "<p style=\"text-align:center;\"><span style=\"color:#ff0000;\"><span style=\"font-size:24.0px;\"><strong>小店所有产品都支持刻字,如需刻字,拍之前联系客服即可。</strong></span></span></p> <p style=\"text-align:center;\"><span style=\"font-size:18.0px;\"><strong>炎炎夏日来临,一把随身携带便携式的折叠小刀,<span style=\"color:#ff0000;\">带开瓶器功能</span>,喝酒不用愁。(钥匙刀不带开瓶器功能)</strong></span></p> <p style=\"text-align:center;\"><strong style=\"color:#000000;line-height:1.5;\"><span style=\"font-size:18.0px;\"><span style=\"line-height:18.0px;\">可以当吊牌项链装饰,也可当钥匙扣挂饰, 水果刀 开瓶器 户外防身.</span></span></strong></p> <p style=\"text-align:center;\"><strong style=\"line-height:1.5;\"><span style=\"font-size:24.0px;\">部分客户跟我们反映链子质量还不够好,因此小店已重新订购一批质量更好的链子赠送,<span style=\"color:#ff0000;\">加量不加价</span>,只为让你买的更舒心,戴的更放心。</span></strong></p> <p style=\"text-align:center;\"><span style=\"font-size:36.0px;\"><strong>购买就送<span style=\"color:#ff0000;\">工具刀卡和链子</span>一条</strong></span></p> <p style=\"text-align:center;\"><span style=\"font-size:36.0px;\"><strong><img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i3/2596264565/TB2Sci2jXXXXXXFXpXXXXXXXXXX_!!2596264565.png\" size=\"611x442\"> </strong></span></p> <p style=\"text-align:center;\"><span style=\"font-size:18.0px;\"><strong>璀璨钻石套餐包含【SK016D钥匙扣+GJ019C折叠刀+GJ017D工具卡】</strong></span><img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i3/2596264565/TB2wWohmXXXXXX8XXXXXXXXXXXX_!!2596264565.jpg\" size=\"750x600\" /></p> <p style=\"text-align:center;\"><span style=\"font-size:18.0px;\"><strong>超凡大师套餐包括【304不锈钢钥匙扣+GJ019C折叠刀+GJ017D工具卡】</strong></span><a href=\"//item.taobao.com/item.htm?id=520798805877\" target=\"_blank\"><img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i4/2596264565/TB2_uiXnFXXXXXBXXXXXXXXXXXX_!!2596264565.jpg_q90.jpg\" style=\"float:none;margin:0.0px;\" /></a></p> <p style=\"text-align:center;\"> </p> <p style=\"text-align:center;\"><span style=\"font-size:18.0px;\"><strong>最强王者套餐包括【钛钢钥匙扣+GJ019C折叠刀+GJ017D工具卡】<a href=\"//item.taobao.com/item.htm?id=520801586805\" target=\"_blank\"><img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i4/2596264565/TB2Gm9xnFXXXXbmXXXXXXXXXXXX_!!2596264565.jpg_q90.jpg\" style=\"float:none;margin:0.0px;\" /></a> </strong></span></p> <p style=\"text-align:center;\"><img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i3/2596264565/TB28Ox4b77OyuJjSsplXXXqdpXa_!!2596264565.jpg\" size=\"749x553\"> <img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i1/2596264565/TB2.mTddVXXXXbeXpXXXXXXXXXX_!!2596264565.jpg\" style=\"line-height:1.5;\" size=\"750x653\"><img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i3/2596264565/TB21Ro.jl0lpuFjSszdXXcdxFXa_!!2596264565.jpg\" size=\"750x653\"> <img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i4/2596264565/TB2q9CelVXXXXcUXXXXXXXXXXXX_!!2596264565.jpg\" size=\"750x340\"><img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i3/2596264565/TB21EX9lVXXXXaXXpXXXXXXXXXX_!!2596264565.jpg\" size=\"750x416\"><img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i3/2596264565/TB2udCylVXXXXXgXXXXXXXXXXXX_!!2596264565.jpg_q90.jpg\"><img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i1/2596264565/TB2EARxjB8lpuFjSspaXXXJKpXa_!!2596264565.jpg\" size=\"750x515\"> <img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i3/2596264565/TB2ssuwlVXXXXafXXXXXXXXXXXX_!!2596264565.jpg_q90.jpg\"><img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i2/2596264565/TB2nAHqgyC9MuFjSZFoXXbUzFXa_!!2596264565.jpg\" size=\"750x606\"> <img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i3/2596264565/TB2ahCelVXXXXc_XXXXXXXXXXXX_!!2596264565.jpg_q90.jpg\"><img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i3/2596264565/TB2w1JnjwRkpuFjy1zeXXc.6FXa_!!2596264565.jpg\" size=\"750x469\"> <img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i3/2596264565/TB2C902lVXXXXbnXpXXXXXXXXXX_!!2596264565.jpg_q90.jpg\"><img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i1/2596264565/TB2sGR3lVXXXXblXpXXXXXXXXXX_!!2596264565.jpg_q90.jpg\"><img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i1/2596264565/TB2ZBGxlVXXXXXMXXXXXXXXXXXX_!!2596264565.jpg_q90.jpg\"><img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i1/2596264565/TB2MjWklVXXXXcaXXXXXXXXXXXX_!!2596264565.jpg_q90.jpg\"><img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i2/2596264565/TB2UgV3lVXXXXbdXpXXXXXXXXXX_!!2596264565.jpg_q90.jpg\"><img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i2/2596264565/TB2ip5XlVXXXXX2XpXXXXXXXXXX_!!2596264565.jpg_q90.jpg\"> <img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i2/2596264565/TB2sMTBdVXXXXXlXXXXXXXXXXXX_!!2596264565.jpg_q90.jpg\" style=\"line-height:1.5;\"><img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i3/2596264565/TB2d3HfdVXXXXahXpXXXXXXXXXX_!!2596264565.jpg_q90.jpg\" style=\"line-height:1.5;\"><img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i4/2596264565/TB2AVbBdVXXXXXkXXXXXXXXXXXX_!!2596264565.jpg_q90.jpg\" style=\"line-height:1.5;\"><img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i2/2596264565/TB2nf_wdVXXXXaMXXXXXXXXXXXX_!!2596264565.jpg_q90.jpg\" style=\"line-height:1.5;\"><img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i4/2596264565/TB2dLYddVXXXXbtXpXXXXXXXXXX_!!2596264565.jpg_q90.jpg\" style=\"line-height:1.5;\"><img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i2/2596264565/TB2H1_adVXXXXbWXpXXXXXXXXXX_!!2596264565.jpg_q90.jpg\" style=\"line-height:1.5;\"><img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i2/2596264565/TB2eBzsdVXXXXbuXXXXXXXXXXXX_!!2596264565.jpg_q90.jpg\" style=\"line-height:1.5;\"><img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i4/2596264565/TB2dOTndVXXXXcCXXXXXXXXXXXX_!!2596264565.jpg_q90.jpg\" style=\"line-height:1.5;\"><img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i2/2596264565/TB2fK2tdVXXXXbkXXXXXXXXXXXX_!!2596264565.jpg_q90.jpg\" style=\"line-height:1.5;\"><img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i2/2596264565/TB29zjedVXXXXaFXpXXXXXXXXXX_!!2596264565.jpg_q90.jpg\" style=\"line-height:1.5;\"><img align=\"absmiddle\" src=\"//img.alicdn.com/imgextra/i3/2596264565/TB2i7rmdVXXXXcTXXXXXXXXXXXX_!!2596264565.jpg_q90.jpg\" style=\"line-height:1.5;\" /></p>",
"item_imgs": [
{
"url": "//img.alicdn.com/imgextra/i4/2596264565/TB2p30elFXXXXXQXpXXXXXXXXXX_!!2596264565.jpg"
},
{
"url": "//img.alicdn.com/imgextra/i2/2596264565/TB2onxRlVXXXXcDXpXXXXXXXXXX_!!2596264565.jpg"
},
{
"url": "//img.alicdn.com/imgextra/i1/2596264565/TB2a.x.lVXXXXXPXpXXXXXXXXXX_!!2596264565.jpg"
},
{
"url": "//img.alicdn.com/imgextra/i2/2596264565/TB2iWE6bKZkyKJjSszbXXblwFXa_!!2596264565.jpg"
},
{
"url": "//img.alicdn.com/imgextra/i4/2596264565/TB2j2cTXib_F1JjSZFzXXc6KXXa_!!2596264565.jpg"
}
],
"item_weight": "0",
"item_size": "",
"location": "广东深圳",
"post_fee": "",
"express_fee": "0.00",
"ems_fee": "",
"shipping_to": "广东广州白云区",
"has_discount": "false",
"video": [],
"is_virtual": "",
"sample_id": "",
"is_promotion": "false",
"props_name": "1627207:1347647754:颜色分类:长方形带开瓶器+送工具刀卡+链子;1627207:1347647753:颜色分类:椭圆形带开瓶器+送工具刀卡+链子;1627207:1195392087:颜色分类:GJ018X钥匙刀+送工具刀卡+链子;1627207:1331112595:颜色分类:超凡大师套餐【送工具卡+链子】;1627207:1331112594:颜色分类:最强王者套餐【送工具卡+链子】;1627207:1331264247:颜色分类:璀璨钻石套餐【送工具卡+链子】",
"prop_imgs": {
"prop_img": [
{
"properties": "1627207:1347647754",
"url": "//img.alicdn.com/imgextra/i3/2596264565/TB2.XeblVXXXXXkXpXXXXXXXXXX_!!2596264565.jpg"
},
{
"properties": "1627207:1347647753",
"url": "//img.alicdn.com/imgextra/i4/2596264565/TB2dTrjdVXXXXXBXpXXXXXXXXXX_!!2596264565.jpg"
},
{
"properties": "1627207:1195392087",
"url": "//img.alicdn.com/imgextra/i2/2596264565/TB2j22kdVXXXXXdXpXXXXXXXXXX_!!2596264565.jpg"
},
{
"properties": "1627207:1331112595",
"url": "//img.alicdn.com/imgextra/i4/2596264565/TB2_uiXnFXXXXXBXXXXXXXXXXXX_!!2596264565.jpg"
},
{
"properties": "1627207:1331112594",
"url": "//img.alicdn.com/imgextra/i4/2596264565/TB2Gm9xnFXXXXbmXXXXXXXXXXXX_!!2596264565.jpg"
},
{
"properties": "1627207:1331264247",
"url": "//img.alicdn.com/imgextra/i3/2596264565/TB2wWohmXXXXXX8XXXXXXXXXXXX_!!2596264565.jpg"
}
]
},
"property_alias": "1627207:1347647754:长方形带开瓶器+送工具刀卡+链子;1627207:1347647753:椭圆形带开瓶器+送工具刀卡+链子;1627207:1195392087:GJ018X钥匙刀+送工具刀卡+链子;1627207:1331112595:超凡大师套餐【送工具卡+链子】;1627207:1331112594:最强王者套餐【送工具卡+链子】;1627207:1331264247:璀璨钻石套餐【送工具卡+链子】",
"props": [
{
"name": "品牌",
"value": "三刃木"
},
{
"name": "产地",
"value": "中国"
},
{
"name": "颜色分类",
"value": "长方形带开瓶器+送工具刀卡+链子,椭圆形带开瓶器+送工具刀卡+链子,GJ018X钥匙刀+送工具刀卡+链子,超凡大师套餐【送工具卡+链子】,最强王者套餐【送工具卡+链子】,璀璨钻石套餐【送工具卡+链子】"
},
{
"name": "吊牌价",
"value": "46"
},
{
"name": "功能数量",
"value": "5个及以下"
},
{
"name": "货号",
"value": "GJ019C"
},
{
"name": "附加功能",
"value": "开瓶器,刀,螺丝刀,钥匙圈,其他"
}
],
"total_sold": "1",
"skus": {
"sku": [
{
"price": "39",
"orginal_price": "39.00",
"properties": "1627207:1347647754",
"properties_name": "1627207:1347647754:颜色分类:长方形带开瓶器+送工具刀卡+链子",
"quantity": "104",
"sku_id": "3166598625985"
},
{
"price": "39",
"orginal_price": "39.00",
"properties": "1627207:1347647753",
"properties_name": "1627207:1347647753:颜色分类:椭圆形带开瓶器+送工具刀卡+链子",
"quantity": "370",
"sku_id": "3166598625984"
},
{
"price": "25.8",
"orginal_price": "25.80",
"properties": "1627207:1195392087",
"properties_name": "1627207:1195392087:颜色分类:GJ018X钥匙刀+送工具刀卡+链子",
"quantity": "34",
"sku_id": "3144644292458"
},
{
"price": "73.8",
"orginal_price": "73.80",
"properties": "1627207:1331112595",
"properties_name": "1627207:1331112595:颜色分类:超凡大师套餐【送工具卡+链子】",
"quantity": "157",
"sku_id": "3161300228970"
},
{
"price": "91.8",
"orginal_price": "91.80",
"properties": "1627207:1331112594",
"properties_name": "1627207:1331112594:颜色分类:最强王者套餐【送工具卡+链子】",
"quantity": "0",
"sku_id": "3161300228969"
},
{
"price": "63.8",
"orginal_price": "63.80",
"properties": "1627207:1331264247",
"properties_name": "1627207:1331264247:颜色分类:璀璨钻石套餐【送工具卡+链子】",
"quantity": "167",
"sku_id": "3161107666655"
}
]
},
"seller_id": "2596264565",
"sales": "1",
"shop_id": "127203758",
"props_list": {
"1627207:1347647754": "颜色分类:长方形带开瓶器+送工具刀卡+链子",
"1627207:1347647753": "颜色分类:椭圆形带开瓶器+送工具刀卡+链子",
"1627207:1195392087": "颜色分类:GJ018X钥匙刀+送工具刀卡+链子",
"1627207:1331112595": "颜色分类:超凡大师套餐【送工具卡+链子】",
"1627207:1331112594": "颜色分类:最强王者套餐【送工具卡+链子】",
"1627207:1331264247": "颜色分类:璀璨钻石套餐【送工具卡+链子】"
},
"seller_info": {
"title": "欢乐购客栈",
"shop_name": "欢乐购客栈",
"sid": "127203758",
"zhuy": "//shop127203758.taobao.com",
"level": "12",
"shop_type": "C",
"user_num_id": "2596264565",
"nick": "欢乐购客栈",
"cid": null,
"delivery_score": "4.8 ",
"item_score": "4.8 ",
"score_p": "4.8 "
},
"tmall": "false",
"error": "",
"warning": "",
"url_log": [],
"stuff_status": "",
"shopinfo": {
"shop_name": "欢乐购客栈",
"shop_id": "127203758"
},
"data_from": "mtop",
"method": "item_mtop:item_get",
"promo_type": null,
"props_img": {
"1627207:1347647754": "//img.alicdn.com/imgextra/i3/2596264565/TB2.XeblVXXXXXkXpXXXXXXXXXX_!!2596264565.jpg",
"1627207:1347647753": "//img.alicdn.com/imgextra/i4/2596264565/TB2dTrjdVXXXXXBXpXXXXXXXXXX_!!2596264565.jpg",
"1627207:1195392087": "//img.alicdn.com/imgextra/i2/2596264565/TB2j22kdVXXXXXdXpXXXXXXXXXX_!!2596264565.jpg",
"1627207:1331112595": "//img.alicdn.com/imgextra/i4/2596264565/TB2_uiXnFXXXXXBXXXXXXXXXXXX_!!2596264565.jpg",
"1627207:1331112594": "//img.alicdn.com/imgextra/i4/2596264565/TB2Gm9xnFXXXXbmXXXXXXXXXXXX_!!2596264565.jpg",
"1627207:1331264247": "//img.alicdn.com/imgextra/i3/2596264565/TB2wWohmXXXXXX8XXXXXXXXXXXX_!!2596264565.jpg"
},
"rate_grade": "",
"shop_item": [],
"relate_items": []
},
"secache": "d8bd20b8f0d9df02dd030dd374110240",
"secache_time": 1591841298,
"secache_date": "2020-06-11 10:08:18",
"translate_status": "error",
"translate_time": 0.001,
"language": {
"current_lang": "zh-CN",
"source_lang": "cn"
},
"error": "",
"reason": "",
"error_code": "0000",
"cache": 1,
"api_info": "today:7033 max:10000",
"execution_time": 0.211,
"server_time": "Beijing/2020-06-11 10:12:27",
"call_args": {
"num_iid": "520813250866",
"area_id": "440111"
},
"api_type": "taobao",
"translate_language": "zh-CN",
"translate_engine": "google_cn",
"server_memory": "8.26MB",
"request_id": "15ee1930b4e098"
}
API 工具
API SDK调用示例
APISDK下载
API测试工具
如何开通API测试,点击立即开通