|
function getCatalogJSON() { |
|
var basicToken = var basicToken = Utilities.base64Encode('<username>' + ":" + '<password>'); |
|
var settings = { |
|
"async": true, |
|
"crossDomain": true, |
|
"url": "<shopify_url>", |
|
"method": "GET", |
|
"headers": { |
|
"authorization": "Basic ", |
|
"cache-control": "no-cache" |
|
} |
|
} |
|
var headers = { |
|
Authorization : "Basic" + basicToken |
|
}; |
|
var options = { |
|
method : "GET", |
|
"headers" : headers, |
|
followRedirects : true, |
|
muteHttpExceptions : true |
|
}; |
|
|
|
var result = UrlFetchApp.fetch(settings.url, options); |
|
if (result.getResponseCode() == 200) { |
|
return JSON.parse(result.getContentText()); |
|
}else{ |
|
Logger.log("error"); |
|
return |
|
} |
|
|
|
} |
|
|
|
function checkPublicationStatus(){ |
|
|
|
var catalog_json = getCatalogJSON(); |
|
var sh = SpreadsheetApp.getActiveSpreadsheet(); |
|
var ss = sh.getActiveSheet(); |
|
|
|
for (var i=0; i<catalog_json.products.length; i++){ |
|
|
|
var cell = ss.getActiveCell(); |
|
cell.setBackground('#ffff55'); |
|
var value = catalog_json.products[i].handle; |
|
var data = ss.getDataRange().getValues(); |
|
var noDate = catalog_json.products[i].published_at; |
|
var ssPublish = ''; |
|
for(var step=0;step<data.length;step++){ |
|
Logger.log(step+' -- '+value+' = '+data[step][0]); |
|
if(data[step][0]==''){ return }; |
|
if(value.toString().toLowerCase()==data[step][0].toString().toLowerCase()){ |
|
ss.getRange(step+1,2).activate().setBackground('#fffff5'); |
|
ss.getRange(step+1,3).activate().setValue(noDate); |
|
ssPublish = data[step][1]; |
|
if(ssPublish==false){ss.getRange(step+1,2).activate().setBackground('#ff0000');} |
|
if(noDate=='' && ssPublish==false){ss.getRange(step+1,2).activate().setBackground('#f10500');} |
|
} |
|
} |
|
|
|
} |
|
|
|
} |