Prijzen updaten in tekstadvertenties

// Copyright 2019. Increase BV. All Rights Reserved.
//
// Created By: Tibbe van Asten
// for Increase B.V.
//
// Created 28-05-2019
// Last update: 10-02-2019
//
// ABOUT THE SCRIPT
// With this script the adcopy will be checked for current pricing
//
////////////////////////////////////////////////////////////////////

var config = {
  
  LOG : true,
  
  // Connect Merchant Center. Add user to MC that runs this script.
  // Also enable Advanced API 'Shopping content'.
  MERCHANT_ID : "127116107",
  
  CURRENCY : "€",
  DECIMAL_SEPERATOR : ",",
  AD_LABEL_HEADLINE : "Price - Headline",
  AD_LABEL_DESCRIPTION : "Price - Description",
  
}

////////////////////////////////////////////////////////////////////

function main() {

  checkLabel(config.AD_LABEL_HEADLINE);
  checkLabel(config.AD_LABEL_DESCRIPTION);
  var products = connectMerchant();

  // We will look at all ads with the label stated in the config
  var adIterator = AdsApp
    .ads()
    .withCondition("LabelNames CONTAINS_ANY ['" + config.AD_LABEL_HEADLINE + "','" + config.AD_LABEL_DESCRIPTION + "']")
    .withCondition("Status = ENABLED")
    .withCondition("AdGroupStatus = ENABLED")
    .withCondition("CampaignStatus = ENABLED")
    .get();
  
    if(config.LOG === true){
      Logger.log(adIterator.totalNumEntities() + " ads");
    }
  
  while (adIterator.hasNext()) {
    var ad = adIterator.next();
    var adUrl = ad.urls().getFinalUrl();
    
    var price = checkPrice(products, adUrl);
    
    // When no price is found in the feed, the ad with price is paused
    if(price == null){      
      	if(config.LOG == true){
          Logger.log("Ad paused");
          Logger.log(" ");
        }
      
      ad.pause();
      continue;
    }
    
    var headline = [];
    var description = [];
    
    var regex = new RegExp("[0-9]+(\\" + config.DECIMAL_SEPERATOR + "[0-9]{1,2})");
    
    // Find the price and replace it    
    for(var i = 1;i < 4;i++){
      headline[i] = eval("ad.getHeadlinePart" + i + "()");
      
      if(headline[i].indexOf(config.CURRENCY) > -1 && headline[i].indexOf(price) < 0){     
        headline[i] = headline[i].replace(regex, price);        
        var label = config.AD_LABEL_HEADLINE;
      }
      
    } // headlineIterator
    
    for(var n = 1;n < 3;n++){
      description[n] = eval("ad.getDescription" + n + "()");
      
      if(description[n].indexOf(config.CURRENCY) > -1 && description[n].indexOf(price) < 0){        
        description[n] = description[n].replace(regex, price);
        var label = config.AD_LABEL_DESCRIPTION;
      }
      
    } // descriptionIterator
    
    // If a headline or description differs, we'll create a new ad
    if(ad.getHeadlinePart1() != headline[1] || ad.getHeadlinePart2() != headline[2] || ad.getHeadlinePart3() != headline[3] || ad.getDescription1() != description[1] || ad.getDescription2() != description[2]){      
      var adGroup = ad.getAdGroup();
      var adOperation = adGroup.newAd().expandedTextAdBuilder()
        .withHeadlinePart1(headline[1])
      	.withHeadlinePart2(headline[2])
        .withHeadlinePart3(headline[3] || "")
        .withDescription1(description[1])    
        .withDescription2(description[2] || "")    
        .withPath1(ad.getPath1() || "")
      	.withPath2(ad.getPath2() || "")
        .withFinalUrl(adUrl)
        .build();
      
      if(adOperation.getErrors() == ""){
        var newAd = adOperation.getResult().applyLabel(label);
        ad.pause();
      } else {
        Logger.log("Failed to create ad in " + adGroup);
      }
      
      if(config.LOG === true){
        Logger.log("Ad replaced in " + ad.getAdGroup().getName());
      }
      
    } // Check for changes lines
    
  } // ad iterator

} // function main()

////////////////////////////////////////////////////////////////////

function checkLabel(label){
  
  if(label !== "" && !AdsApp.labels().withCondition("Name = '"+label+"'").get().hasNext()) {
    AdsApp.createLabel(label);

    	Logger.log("Label " + label + " created");
  }
  
} // function checkLabel()

////////////////////////////////////////////////////////////////////

function connectMerchant(){
  
  	if(config.MERCHANT == "123456789"){
      throw Error("Change the Merchant ID in the settings");
    }  
    
  var pageToken;
  var pageNum = 1;
  var maxResults = 250;
  var products = [];
  
  do {
    var productList = ShoppingContent.Products.list(config.MERCHANT_ID, {
      pageToken: pageToken,
      maxResults: maxResults
    });
    
    if (productList.resources) {
      for (var i = 0; i < productList.resources.length; i++) {
        products.push(productList.resources[i]);
      }
    }

    pageToken = productList.nextPageToken;
    pageNum++;
  } while (pageToken);
  
  return products;
  
} // function connectMerchant

////////////////////////////////////////////////////////////////////

function checkPrice(products, adUrl){
  
  for (var i = 1; i < products.length; i++) { 
    
    // When the link in the feed is the same as the ad url, the price is retrieved
    if(products[i]["link"] == adUrl) { 
    
      // When the saleprice is in the feed, this will be used. If not, the regular price is used.
      if(products[i]["salePrice"]) {
        var price = products[i]["salePrice"]["value"];
      } else {
        var price = products[i]["price"]["value"];
      }
      
      if(config.DECIMAL_SEPERATOR != "."){
        price = price.replace(".", config.DECIMAL_SEPERATOR);
      }
      
      return price;
      
    } // if statement url
    
  } // for statement
  
} // function checkPrice()