Your one place to browse brand catalogues and build wholesale orders for the garden center. Pick a brand to begin.
1. Create a Google Sheet. 2. Extensions → Apps Script, paste this, Deploy → New deployment → Web app → access “Anyone”, copy the URL into the box above.
function doPost(e){
var d = JSON.parse(e.postData.contents);
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sh = ss.getSheetByName('Orders') || ss.insertSheet('Orders');
if(sh.getLastRow()===0){
sh.appendRow(['Order ID','Date','Shop','Plant Olive Code','Code','Product','Size','Qty','Unit €','Line €','Notes']);
}
d.items.forEach(function(it){
sh.appendRow([d.orderId,d.date,d.shop,it.plantCode,it.code,it.name,it.size,it.qty,it.unitPrice,it.lineTotal,d.notes]);
});
return ContentService.createTextOutput('ok');
}