xiaodian.data.querySkuData

  • 免费
  • 需要授权

API功能描述(支持get和post)

查询商品sku的T+1数据

公共参数

名称 类型 必选 描述
app_key Long 接入时申请的app_key
method String 接口名称
access_token String Oauth2.0授权获得的access_token
sign String 对 API 调用参数(除sign外)进行 md5 加密获得。参数的顺序为字母表的顺序
timestamp Long 时间戳,使用Unix时间戳格式
format String 响应格式。默认为json格式,固定
sign_method String 参数的加密方法选择,当前只支持Md5
version String API协议版本,固定值为:1.0

输入参数

名称 类型 必选 描述 示例值
skuDataQuery Object sku查询数据
skuCode String skucode
startDate String 开始时间 格式为yyyy-MM-dd
endDate String 结束时间 格式为yyyy-MM-dd
pageSize Number 分页的尺寸,每次最大为10
pageNum Number 当前页

返回参数

名称 类型 描述 默认值
result Object 返回结果
data Object 结果实体
list Object[] sku的列表数据
Object
title String 商品名称
itemId String 商品Id
skuId String skuId
itemCode String
skuCode String skcode
kind String 品牌
productStage String 阶段
payUserNumD Number 昨日成交人数(去重)
newPayUserNumD Number 昨日新客成交人数(去重)
monthPayUserNumD Number 当月成交人数(去重)
payBoxes String 成交箱数(带小数点)
payTings String 成交听数(整数)
payGmv String 成交gmv(单位元)
newPayBoxes String 新客成交箱数(带小数点)
newPayTings String 新客成交听数(整数)
newPayGmv String 新客成交gmv(单位元)
payOrderNum String 成交订单数
payItemNum String 成交商品件数
kdj String 客单价(单位元)
uv String 访客数
pv String 浏览次数
refundOrderNum String 退货退款订单数
refundAmount String 退货退款金额(单位元)
newMemberCount String 新增会员数
visitdate String 数据时间
refundUserNum String 退货退款人数
pageNum Number 页码
total Number 总数
isEnd Boolean true-是尾页 

请求参数示例

1).
{"skuCode":"","startDate":"2021-05-13","endDate":"2021-05-14","pageSize":10,"pageNum":1}

返回示例

1).
{ "status": { "code": "0000000", "msg": "调用成功" }, "result": { "data": { "total": 280, "list": [ { "payboxes": "0.0", "paygmv": "0.0", "pv": 0, "newpayusernumd": 0, "payitemnum": 0, "title": "【测试商品不发货】美素佳儿较大婴儿配方奶粉2段盒装1200克", "newpayboxes": "0.0", "itemid": "1qmmz24", "newmembercount": 1027, "paytings": 0, "refundusernum": 0, "refundamount": "0.0", "newpaytings": 0, "uv": 0, "kind": "", "monthpayusernumd": 0, "skucode": "", "visitdate": "2021-05-14", "payordernum": 0, "refundordernum": 0, "kdj": "0.0", "payusernumd": 0, "itemcode": "0747972", "newpaygmv": "0.0", "productstage": "", "skuid": "11u62g3o" }, { "payboxes": "0.0", "paygmv": "0.0", "pv": 0, "newpayusernumd": 0, "payitemnum": 0, "title": "【测试商品不发货】皇家美素佳儿3段 幼儿配方奶粉罐装800克*2罐组", "newpayboxes": "0.0", "itemid": "1qmmz7a", "newmembercount": 1027, "paytings": 0, "refundusernum": 0, "refundamount": "0.0", "newpaytings": 0, "uv": 0, "kind": "", "monthpayusernumd": 0, "skucode": "", "visitdate": "2021-05-14", "payordernum": 0, "refundordernum": 0, "kdj": "0.0", "payusernumd": 0, "itemcode": "ZTMS0203", "newpaygmv": "0.0", "productstage": "", "skuid": "11u62g3o" }, { "payboxes": "0.0", "paygmv": "0.0", "pv": 8, "newpayusernumd": 0, "payitemnum": 0, "title": "【新人专享,每个id限购一次】美素佳儿儿童配方奶粉(调制乳粉)4段罐装900克", "newpayboxes": "0.0", "itemid": "1qmn9je", "newmembercount": 1027, "paytings": 0, "refundusernum": 0, "refundamount": "0.0", "newpaytings": 0, "uv": 4, "kind": "金装", "monthpayusernumd": 0, "skucode": "9736", "visitdate": "2021-05-14", "payordernum": 0, "refundordernum": 0, "kdj": "0.0", "payusernumd": 0, "itemcode": "9736", "newpaygmv": "0.0", "productstage": "4段", "skuid": "11u62g3o" }, { "payboxes": "0.0", "paygmv": "0.0", "pv": 6, "newpayusernumd": 0, "payitemnum": 0, "title": "【新人专享,每个id限购一次】美素佳儿较大婴儿配方奶粉2段盒装1200克 (效期:2022年5月)", "newpayboxes": "0.0", "itemid": "1qmn9k2", "newmembercount": 1027, "paytings": 0, "refundusernum": 0, "refundamount": "0.0", "newpaytings": 0, "uv": 5, "kind": "金装", "monthpayusernumd": 3, "skucode": "9737", "visitdate": "2021-05-14", "payordernum": 0, "refundordernum": 0, "kdj": "0.0", "payusernumd": 0, "itemcode": "9737", "newpaygmv": "0.0", "productstage": "2段", "skuid": "11u62g3o" }, { "payboxes": "0.1111", "paygmv": "169.0", "pv": 11, "newpayusernumd": 1, "payitemnum": 1, "title": "【新人专享,每个id限购一次】美素佳儿儿童配方奶粉(调制乳粉)4段盒装1200克", "newpayboxes": "0.1111", "itemid": "1qmn9ky", "newmembercount": 1027, "paytings": 1, "refundusernum": 0, "refundamount": "0.0", "newpaytings": 1, "uv": 2, "kind": "金装", "monthpayusernumd": 1, "skucode": "9739", "visitdate": "2021-05-14", "payordernum": 1, "refundordernum": 0, "kdj": "169.0", "payusernumd": 1, "itemcode": "9739", "newpaygmv": "169.0", "productstage": "4段", "skuid": "11u62g3o" }, { "payboxes": "0.0", "paygmv": "0.0", "pv": 0, "newpayusernumd": 0, "payitemnum": 0, "title": "皇家美素佳儿2段较大婴儿配方奶粉罐装800克", "newpayboxes": "0.0", "itemid": "1qmn9mc", "newmembercount": 1027, "paytings": 0, "refundusernum": 0, "refundamount": "0.0", "newpaytings": 0, "uv": 0, "kind": "皇家", "monthpayusernumd": 0, "skucode": "", "visitdate": "2021-05-14", "payordernum": 0, "refundordernum": 0, "kdj": "0.0", "payusernumd": 0, "itemcode": "0747972", "newpaygmv": "0.0", "productstage": "2段", "skuid": "11u62g3o" }, { "payboxes": "0.0", "paygmv": "0.0", "pv": 27, "newpayusernumd": 0, "payitemnum": 0, "title": "美素力1段婴儿配方奶粉(NOVAS尊属版)罐装800g", "newpayboxes": "0.0", "itemid": "1qmn9nc", "newmembercount": 1027, "paytings": 0, "refundusernum": 0, "refundamount": "0.0", "newpaytings": 0, "uv": 16, "kind": "NOVAS", "monthpayusernumd": 3, "skucode": "408254", "visitdate": "2021-05-14", "payordernum": 0, "refundordernum": 0, "kdj": "0.0", "payusernumd": 0, "itemcode": "408254", "newpaygmv": "0.0", "productstage": "1段", "skuid": "11u62g3o" }, { "payboxes": "0.0833", "paygmv": "279.0", "pv": 27, "newpayusernumd": 0, "payitemnum": 1, "title": "美素佳儿3段幼儿配方奶粉(NOVAS尊属版)罐装800g", "newpayboxes": "0.0", "itemid": "1qmn9ne", "newmembercount": 1027, "paytings": 1, "refundusernum": 0, "refundamount": "0.0", "newpaytings": 0, "uv": 22, "kind": "NOVAS", "monthpayusernumd": 3, "skucode": "408257", "visitdate": "2021-05-14", "payordernum": 1, "refundordernum": 0, "kdj": "279.0", "payusernumd": 1, "itemcode": "408257", "newpaygmv": "0.0", "productstage": "3段", "skuid": "11u62g3o" }, { "payboxes": "0.0", "paygmv": "0.0", "pv": 4, "newpayusernumd": 0, "payitemnum": 0, "title": "美素佳儿4段儿童配方奶粉(调制乳粉)(NOVAS尊属版)罐装800g", "newpayboxes": "0.0", "itemid": "1qmn9ng", "newmembercount": 1027, "paytings": 0, "refundusernum": 0, "refundamount": "0.0", "newpaytings": 0, "uv": 4, "kind": "NOVAS", "monthpayusernumd": 0, "skucode": "408258", "visitdate": "2021-05-14", "payordernum": 0, "refundordernum": 0, "kdj": "0.0", "payusernumd": 0, "itemcode": "408258", "newpaygmv": "0.0", "productstage": "4段", "skuid": "11u62g3o" }, { "payboxes": "0.0", "paygmv": "0.0", "pv": 0, "newpayusernumd": 0, "payitemnum": 0, "title": "美素佳儿较大婴儿配方奶粉2段罐装400克*2罐组", "newpayboxes": "0.0", "itemid": "1qmn9to", "newmembercount": 1027, "paytings": 0, "refundusernum": 0, "refundamount": "0.0", "newpaytings": 0, "uv": 0, "kind": "金装", "monthpayusernumd": 0, "skucode": "", "visitdate": "2021-05-14", "payordernum": 0, "refundordernum": 0, "kdj": "0.0", "payusernumd": 0, "itemcode": "ZTMS0308", "newpaygmv": "0.0", "productstage": "2段", "skuid": "11u62g3o" } ], "pageNum": 1, "isEnd": false } }, "success": true }

异常示例