Get Item page info ( 取得商品頁詳細資訊 ) - ec-yahoo/ntu-hackathon GitHub Wiki
Usage
To get the related info of the product
Table Name
ecstore.app.get_itempage_product
Parameter
| Key | Description | Required | Example |
|---|---|---|---|
productId |
Product ID | true | p0414136736440 |
Sample Query
select * from ecstore.app.get_itempage_product where productId="p0414136736440"
Sample Response
{
"query": {
"count": 1,
"created": "2017-07-13T09:17:35Z",
"lang": "en-US",
"results": {
"Response": {
"Status": "ok",
"Result": {
"product": {
"qnaQuestionCount": 0,
"qnaReplyCount": 0,
"productId": "p0414136736440",
"productStatus": "Online",
"productName": "打摺大口袋單寧六分寬褲(黑)-F【Gentle wind】",
"shortDescription": "日系田園森女風 精緻細節藏在每一個角落",
"longDescription": "<img alt=\"\" src=\"https://ec-supplier.books.com.tw/scmimg/N00/083/11/N000831177_t_30.jpg\" style=\"cursor:default;color:rgb(51, 51, 51);font-family:sans-serif, Arial, Verdana,;font-size:13px;width:750px;height:1314px;\"><br style=\"color:rgb(51, 51, 51);font-family:sans-serif, Arial, Verdana,;font-size:13px;\"><img alt=\"\" src=\"https://ec-supplier.books.com.tw/scmimg/N00/083/11/N000831177_t_31.jpg\" style=\"cursor:default;color:rgb(51, 51, 51);font-family:sans-serif, Arial, Verdana,;font-size:13px;width:750px;height:1325px;\"><br style=\"color:rgb(51, 51, 51);font-family:sans-serif, Arial, Verdana,;font-size:13px;\"><img alt=\"\" src=\"https://ec-supplier.books.com.tw/scmimg/N00/083/11/N000831177_t_32.jpg\" style=\"cursor:default;color:rgb(51, 51, 51);font-family:sans-serif, Arial, Verdana,;font-size:13px;width:750px;height:1345px;\"><br style=\"color:rgb(51, 51, 51);font-family:sans-serif, Arial, Verdana,;font-size:13px;\"><img alt=\"\" src=\"https://ec-supplier.books.com.tw/scmimg/N00/083/11/N000831177_t_33.jpg\" style=\"cursor:default;color:rgb(51, 51, 51);font-family:sans-serif, Arial, Verdana,;font-size:13px;width:750px;height:1615px;\"><br style=\"color:rgb(51, 51, 51);font-family:sans-serif, Arial, Verdana,;font-size:13px;\"><img alt=\"\" src=\"https://ec-supplier.books.com.tw/scmimg/N00/083/11/N000831177_t_34.jpg\" style=\"cursor:default;color:rgb(51, 51, 51);font-family:sans-serif, Arial, Verdana,;font-size:13px;width:750px;height:1386px;\">",
"extraDescription": null,
"productType": "Main",
"marketPrice": 1150,
"price": 1050,
"costPrice": 0,
"reserveOnlineTime": null,
"reserveOfflineTime": null,
"storeCategoryIds": {
"storeCategoryId": [
58,
243,
330
]
},
"rating": 0,
"ratingCount": 0,
"collectionCount": 0,
"ratingHistograms": {
"count": 0,
"sum": 0,
"bins": [
{
"rating": 1,
"count": 0
},
{
"rating": 2,
"count": 0
},
{
"rating": 3,
"count": 0
},
{
"rating": 4,
"count": 0
},
{
"rating": 5,
"count": 0
}
]
},
"specs": {
"spec": [
{
"specId": 1,
"specDescription": "-",
"customizedProductId": null,
"currentStock": 5,
"saftyStock": 1,
"dimensions": {
"dimension": [
{
"specDimensionId": 1,
"description": {
"descriptionId": 1
}
}
]
}
}
]
},
"specDimensions": [],
"images": {
"image": [
{
"name": "p0414136736440-item-2173xf3x1000x1000-m.jpg",
"isMainImage": 1,
"smallImageUrl": "https://s.yimg.com/ut/api/res/1.2/bOG.hvXxBuDhP_f6W5zDeQ--/YXBwaWQ9eXR3bWFsbDtoPTEzNTtxPTc4O3c9MTM1/http://imgcld.zenfs.com:80/ps_image_prod/item/p0414136736440-item-2173xf3x1000x1000-m.jpg",
"largeImageUrl": "https://s.yimg.com/ut/api/res/1.2/EWMStlAvyyp5jtKTY2KIQQ--/YXBwaWQ9eXR3bWFsbDtoPTYwMDtxPTgxO3c9NjAw/http://imgcld.zenfs.com:80/ps_image_prod/item/p0414136736440-item-2173xf3x1000x1000-m.jpg"
}
]
},
"isAdult": 0,
"isNoInvoice": 0,
"isTaxFree": 0,
"attributes": null,
"saleType": "Normal",
"saleTypeInfo": null,
"categoryId": 152981920,
"productClass": null,
"zipCodes": [],
"cityCodes": [],
"customizedMainProductId": "MFK636",
"specTypeDimension": 0,
"addons": null,
"freebies": null,
"maxBuyNum": 20,
"videoPath": null,
"shippings": {
"shipping": [
{
"shippingId": 80,
"name": "7-11取貨付款",
"description": "免運費",
"feeType": "Free",
"fee": {
"condition": null,
"amount": 0
},
"cheapnessOrder": 1
},
{
"shippingId": 86,
"name": "萊爾富純取貨",
"description": "購物滿99元免運費",
"feeType": "PriceLine",
"fee": {
"condition": 99,
"amount": 50
},
"cheapnessOrder": 2
},
{
"shippingId": 2,
"name": "貨運 / 宅配",
"description": "購物滿599元免運費",
"feeType": "PriceLine",
"fee": {
"condition": 599,
"amount": 65
},
"cheapnessOrder": 3
},
{
"shippingId": 83,
"name": "全家取貨付款",
"description": "購物滿699元免運費",
"feeType": "PriceLine",
"fee": {
"condition": 699,
"amount": 65
},
"cheapnessOrder": 4
}
]
},
"payTypes": {
"payType": [
{
"payTypeId": 1,
"name": "ATM轉帳"
},
{
"payTypeId": 2,
"name": "信用卡一次付清"
},
{
"payTypeId": 4,
"name": "信用卡3期零利率"
},
{
"payTypeId": 11,
"name": "7-11付款取貨"
},
{
"payTypeId": 12,
"name": "全家繳費不取貨"
},
{
"payTypeId": 14,
"name": "全家付款取貨"
}
]
},
"saleInfo": {
"buyerCount": 0,
"soldCount": 0
},
"limitCount": 0,
"isLimit": 0,
"storeId": "katieq",
"productAttributes": null,
"promo": {
"title": "輕輕吹新品上市專區75折",
"price": 788,
"url": "https://tw.user.mall.yahoo.com/store_admin/view/amountPromo?promotion_id=2185921&sid=katieq",
"shortDescription": "滿1件75折"
},
"store": {
"storeId": "katieq",
"storeName": "katie Q",
"shortcutName": "katieQ",
"isOpen": 1,
"shortDescription": "無拘無束，就是聰明的風格，並且喜歡慢慢生活。\n【獨家文藝質感棉麻夏裝上市】",
"largeImageUrl": "https://s.yimg.com/ut/api/res/1.2/82LtQtg0iV2y5JwdssPKfw--/YXBwaWQ9eXR3bWFsbDtoPTYwO3E9ODE7dz0zMDA-/http://imgcld.zenfs.com:80/ps_image_prod/psBanner/katieq-psBanner-5235xf3x0300x0060-m.jpg",
"smallImageUrl": "https://s.yimg.com/ut/api/res/1.2/6Tt52wRHUUmx337rOBOA4w--/YXBwaWQ9eXR3bWFsbDtoPTM3O3E9Nzg7dz0xODU-/http://imgcld.zenfs.com:80/ps_image_prod/psBanner/katieq-psBanner-5235xf3x0300x0060-m.jpg",
"iconUrl": "https://s.yimg.com/ut/api/res/1.2/6FFDHGyLyC0wBCgZND4hRw--/YXBwaWQ9eXR3bWFsbDtoPTE0NDtxPTkwO3c9MTQ0/http://imgcld.zenfs.com:80/ps_image_prod/mthumb/katieq-mthumb-0890xf3x0144x0144_m.jpg",
"announcement": null,
"openDate": 1379125849,
"isSuperior": 0,
"collectionCount": 4496,
"storeDisplayInfo": {
"showAnnouncement": 0,
"showStoreFAQ": 1,
"showProductQandA": 1,
"homeBrowseMode": "image",
"homeBrowseSortOrder": "desc",
"homeBrowseSortBy": "createtime",
"searchBrowseMode": "image",
"searchBrowseSortOrder": "desc",
"searchBrowseSortBy": "createtime"
},
"storeEvaluation": {
"shippingVelocity": "2.2",
"replyVelocity": "2.2",
"shortRate": "2.3"
},
"ratingScore": {
"ratingAverage": 8.9,
"quality": 8.8,
"service": 9,
"deliver": 9
},
"pageView": 20128
}
},
"promotions": {
"promotion": [
{
"storeId": "katieq",
"title": "輕輕吹新品上市專區75折",
"description": "輕輕吹新品上市專區75折",
"startTime": "1499054400",
"endTime": "1500433199",
"createdTime": "1499054002",
"updatedTime": "1499737567",
"promotionPrice": 788,
"discountInfos": {
"discountInfo": [
{
"condition": 1,
"discount": 25
}
]
},
"productIds": {
"productId": [
"p0414136736440"
]
},
"promotionId": 2185921,
"promotionType": "AmountUnitConstrain",
"status": "UnderProcess",
"aggregateType": "NotAccumulated",
"presentType": "Percentage",
"groupType": "PartialProduct",
"productLinkType": "Apply",
"audienceType": "BasicPromo",
"promotionPic": "https://s.yimg.com/f/i/tw/mall/yps/p_event150x150.jpg",
"promotionActPic": "https://s.yimg.com/qs/mall/yps/common/promo_act_banner_940x360.jpg",
"promotionDetailString": "滿件折扣活動，購物滿1件打75折。",
"promotionShortString": "滿1件75折"
},
{
"storeId": "katieq",
"title": "全館購物滿899現折100",
"description": "全館購物滿899現折100",
"startTime": "1499742000",
"endTime": "1500865199",
"createdTime": "1498723121",
"updatedTime": "1499742011",
"promotionPrice": "950",
"discountInfos": {
"discountInfo": [
{
"condition": 899,
"discount": 100
}
]
},
"promotionId": 2183072,
"isWithPreviousConstrain": 0,
"promotionType": "PriceConstrain",
"status": "UnderProcess",
"aggregateType": "Accumulated",
"presentType": "Money",
"groupType": "AllProduct",
"productLinkType": "None",
"audienceType": "BasicPromo",
"promotionPic": "https://s.yimg.com/f/i/tw/mall/yps/p_event150x150.jpg",
"promotionActPic": "https://s.yimg.com/qs/mall/yps/common/promo_act_banner_940x360.jpg",
"promotionDetailString": "滿額折扣活動，購物滿899元現折100元、滿1,798元現折200元，依此類推。",
"promotionShortString": "滿899元折$100"
}
]
},
"reviews": {
"total": 0,
"count": 0,
"review": []
},
"activities": {
"total": 1,
"activity": [
{
"title": "全館加碼滿千現贈100折價劵",
"activityId": 87547,
"storeId": "katieq",
"description": "全館加碼滿千現贈100折價劵",
"activityStartTime": 1499356800,
"activityEndTime": 1500911999,
"validityStartTime": 1503936000,
"validityEndTime": 1504972799,
"money": 100,
"shoppingPrice": 1000,
"subType": "PriceConstrain",
"link": "https://tw.user.mall.yahoo.com/store_admin/view/ecouponPromo?promotion_id=87547&sid=katieq",
"imageUrl": "https://s.yimg.com/f/i/tw/mall/yps/coupon_default.png",
"status": "OnGoing"
}
],
"hiddenCount": 0
},
"pointActivities": {
"pointActivity": []
},
"storeCategories": {
"storeCategory": [
{
"storeCategoryId": "243",
"level": 2,
"parentStoreCategoryId": 0,
"isLeaf": 1,
"name": "褲子",
"parentStoreCategories": [],
"subStoreCategories": []
},
{
"storeCategoryId": "330",
"level": 2,
"parentStoreCategoryId": 0,
"isLeaf": 1,
"name": "07/10",
"parentStoreCategories": [],
"subStoreCategories": []
}
]
},
"predictionPoint": 10
}
}
}
}
}