数据结构

列明 别名 描述(*线上使用) 类型 注解
goodsid goodsid 商品id keyword
title title 标题 text
d_title d_title 短标题 text
cid cid 分类id short
miaoshu desc 描述 text
pic main_pic 主图 keyword
yuanjia original_price 原价 float
jiage price 券后价 float
quan_jine coupon_amount 券金额 float
quan_link coupon_link 券链接 keyword
quan_start_time coupon_start_time 券开始时间 date
quan_time coupon_end_time 券结束时间 date
yongjin_type commission_type 佣金类型 short
yongjin commission_rate 佣金比例 float
addtime add_time 添加时间 date
quan_over coupon_over 已领券 int
quan_num coupon_num 券数量 int
xiaoliang sales 淘宝销量 int
istmall is_tmall 0淘宝,1天猫 short
jinpaimaijia is_goldseller 是否金牌买家 short
seller_id seller_id 商户id keyword
is_chaoshi is_chaoshi 是否天猫超市0否，1是 short ①
shop_name shop_name 店铺名称 keyword ②
dsr_score dsr_score 描述评分 float ②
ship_score ship_score 物流评分 float ②
service_score service_score 服务评分 float ②
dsr_percent dsr_percent 描述百分比 float ②
ship_percent ship_percent 物流百分比 float ②
service_percent service_percent 服务百分比 float ②
shop_level shop_level 店铺等级 short ②
huodong_type activity_type 活动类型 short
renqi sentiment 人气 float
dsr dsr dsr float
sellnum sales_2h 2小时销量 int
today_sellnum sales_daily 全天销量 int
quan_id coupon_id 券id keyword
tk_zs_id tk_zs_id 放单id long
is_delete is_delete 是否删除 short
is_online is_online 是否上架 short
yunfeixian yunfeixian 运费险 short
hz_quan_over cut 立减 int
is_video is_video 是否视频商品 short
quan_tiaojian coupon_condition 券条件 keyword
shoufa ddq 是否咚咚抢 short
quan_m_link deposit 定金 keyword
jihua_link plan_link 计划链接 keyword
is_haitao is_haitao 是否海淘 short
neirong team_link 团长链接 keyword
category_id category_id 淘宝分类id keyword
brand_id brand_id 品牌id keyword
hot_push hot_push 热推值 float
freeship_remote_district freeship_remote_district 1.偏远地区包邮0.不是 short
is_flagship is_flagship 是否旗舰店 short
activity activity 是否活动 short
activity_type activity_type 活动类型 short
comment comment 评论 int
circle_text circle_text 朋友圈文案 keyword
special special 特色标签 keyword
fresh fresh 0.不是1.是新品 short
lowest lowest 0.不是1.史低 short
rank_num rank_num 上榜次数 int
sales_30day sales_30day 最近30天销量 long
discount_full discount_full 活动满减的满值 int
discount_cut discount_cut 活动满减的减值 int
discount_type discount_type 1.购物津贴2.跨店满减 short
sales_24h_cms sales_24h_cms cms的24小时销量 int
red_packet red_packet 红包 float
batch_quan_jine batch_coupon_amount 券金额 float
batch_link batch_link 券链接 keyword
batch_price batch_price 券后价 float
batch_status batch_status 券状态1正常2隐藏中3失效 short
batch_quan_time batch_coupon_time 券结束时间 date
batch_num batch_num 拍几件 short
batch_quan_id batch_coupon_id 券id keyword
batch_quan_over batch_coupon_over 领券量 int
batch_quan_num batch_coupon_num 剩余券数量 int
qq_pic qq_pic 淘客主图(添加商品时候上传的) keyword
super_pic super_pic keyword
copy_pic copy_pic 网站主图复制(本地地址) keyword
video_url video_url 视频地址 keyword
activity_start_time activity_start_time 活动开始时间 date
activity_end_time activity_end_time 活动结束时间 date
is_high_com is_high_com 是否最高佣金（0.不是1.是） short
com_rate_add com_rate_add 佣金比例增幅 float
is_subdivision is_subdivision 是否细分排行榜商品：0不是，1是 short
subdivision_id subdivision_id 细分排行分类id int
subdivision_name subdivision_name 细分排行分类名称 keyword
subdivision_rank subdivision_rank 分排行名次 short
com_add com_add 佣金增幅 float
pure_push_switch pure_push_switch 精推开关是否开启,1为开启,0为关闭 short
special_content special_content 商品特色标签文案 keyword
divisor divisor 商品拍多件去重：1默认倍数，其他除数>1 short
market_group market_group 活动id列表 keyword ③
topic_group topic_group 专题id列表 keyword ④
team_name team_name 团队名称 keyword ⑤
userid zs_uid 放单淘客id int ⑤
pic zs_pic 淘客主库 keyword ⑤
addtime zs_add_time 添加时间 date ⑤
qq zs_qq QQ号码 keyword ⑤
special_text special_text 特色文案列表 keyword ⑥
special_groupid special_groupid 分组id列表 keyword ⑥
name category_name 淘宝分类名称 keyword ⑦
total_score brand_total_score 品牌评分 float ⑧
brand_name brand_name 品牌名称 keyword ⑨
is_black is_black 是否榜单黑名单 short ⑩
is_gray is_gray 是否榜单灰名单 short ⑪

数据格式

  1. {
  2. "activity":"0",
  3. "activity_end_time":"",
  4. "activity_start_time":"",
  5. "activity_type":"1",
  6. "add_time":"2020-05-2717:14:45",
  7. "brand_id":"153599590",
  8. "brand_name":"惠特克",
  9. "brand_total_score":"",
  10. "category_id":"124312003",
  11. "category_name":"牛奶巧克力",
  12. "cid":"6",
  13. "circle_text":"",
  14. "com_add":"",
  15. "com_rate_add":"",
  16. "comment":"587",
  17. "commission_rate":"30.0",
  18. "commission_type":"3",
  19. "copy_pic":"",
  20. "coupon_amount":"70.0",
  21. "coupon_condition":"109",
  22. "coupon_end_time":"2020-05-3023:59:59",
  23. "coupon_id":"9ccd3126d318448c87daa5fca379760f",
  24. "coupon_link":"https://uland.taobao.com/quan/detail?sellerId=3012507952&activityId=9ccd3126d318448c87daa5fca379760f",
  25. "coupon_num":"50000",
  26. "coupon_over":"0",
  27. "coupon_start_time":"2020-05-2800:00:00",
  28. "cut":"0",
  29. "d_title":"新西兰【惠特克】黑巧克力散装1斤",
  30. "ddq":"0",
  31. "deposit":"0",
  32. "desc":"新西兰原装进口，纯正黑巧克力，香浓牛奶口感丝滑，醇香浓郁，入口即化，纯正可可给你丝滑好时光！",
  33. "discount_cut":"0",
  34. "discount_full":"0",
  35. "discount_type":"0",
  36. "divisor":"1",
  37. "dsr":"4.9",
  38. "dsr_percent":"69.97",
  39. "dsr_score":"4.90",
  40. "freeship_remote_district":"0",
  41. "fresh":"0",
  42. "goodsid":"558539624847",
  43. "hot_push":"0",
  44. "id":"26627920",
  45. "is_black":"0",
  46. "is_chaoshi":"0",
  47. "is_delete":"0",
  48. "is_flagship":"1",
  49. "is_goldseller":"0",
  50. "is_gray":"0",
  51. "is_haitao":"0",
  52. "is_high_com":"0",
  53. "is_online":"1",
  54. "is_subdivision":"0",
  55. "is_tmall":"1",
  56. "is_video":"0",
  57. "lowest":"0",
  58. "main_pic":"https://img.alicdn.com/bao/uploaded/TB1vf7YFoz1gK0jSZLeXXb9kVXa.png",
  59. "market_group":[1,2,3],
  60. "original_price":"109.0",
  61. "plan_link":"",
  62. "price":"39.0",
  63. "pure_push_switch":"0",
  64. "qq_pic":"",
  65. "rank_num":"0",
  66. "red_packet":"0",
  67. "sales":"269",
  68. "sales_24h_cms":"10",
  69. "sales_2h":"0",
  70. "sales_30day":"180",
  71. "sales_daily":"7",
  72. "seller_id":"3012507952",
  73. "sentiment":"-28.106",
  74. "service_percent":"67.38",
  75. "service_score":"4.90",
  76. "ship_percent":"66.26",
  77. "ship_score":"4.90",
  78. "shop_level":"13",
  79. "shop_name":"whittakers旗舰店",
  80. "special":"",
  81. "special_content":"",
  82. "special_groupid":[1,2,3],
  83. "special_text":["买二送一","满减","红包"],
  84. "start_time":"2020-05-2800:00:00",
  85. "subdivision_id":"0",
  86. "subdivision_name":"",
  87. "subdivision_rank":"0",
  88. "super_pic":"https://sr.ffquan.cn/dtk_user_fd/20200522/br3jk9cq57bo2hokm0900.jpg",
  89. "team_link":"",
  90. "team_name":"橙易推",
  91. "title":"新西兰原装进口Whittaker's惠特克50%黑巧克力婚庆喜糖散装1斤",
  92. "tk_zs_id":"29786547",
  93. "topic_group":[1,2,3],
  94. "user_level":"1",
  95. "video_url":"",
  96. "yunfeixian":"1",
  97. "zs_add_time":"2016-12-1616:52:58",
  98. "zs_pic":"https://img.alicdn.com/imgextra/i2/3008484522/TB2Q3HubTTI8KJjSsphXXcFppXa_!!3008484522.png",
  99. "zs_qq":"6625083",
  100. "zs_uid":"14878"
  101. }