function onOpen() {
var ui = SpreadsheetApp.getUi();
ui.createMenu('Update-Order-Status')
.addItem('Update Status', 'so13343001')
.addToUi();
}
function so13343001() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheetname = "Sheet1_script";
var sheet = ss.getSheetByName(sheetname);
var LR = sheet.getLastRow();
var Columns = 4;
var range = sheet.getDataRange();
var data = range.getValues();
var refReqStatus = data[1][1];
var refSupplier = data[2][1];
for (var i=0;i<LR-1;i++){
var requests = data[i+1][3];
var supplier = data[i+1][4];
var orderstatus = data[i+1][5];
var item = data[i+1][6];
if (requests == refReqStatus && supplier == refSupplier){
data[i+1][5] = "Ordered";
}
}
range.setValues(data);
}