将Woocommerce订单推送到Google Sheets

Question

我建立了一个woocommerce网站，用于从我所在地区的不同餐馆送餐。我试图设置一个自动传输订单数据从json文件直接到我们的驱动程序使用的谷歌表，但我发现自己遇到错误的谷歌脚本每次woo的webhook火灾，并不能检测到这个问题。

这是我的谷歌脚本代码

//this is a function that fires when the webapp receives a GET request
function doGet(e) {
return HtmlService.createHtmlOutput("request received");
}
//this is a function that fires when the webapp receives a POST request
function doPost(e) {
var myData = JSON.parse([e.postData.contents]);
var order_number = myData.number;
var order_address = myData.billing.address_1;
var item = ""
var url = "https://fivestars-delivery.com/mon-compte//driver-dashboard/?orderid=" + order_number;
for (var i = 0; i < myData.line_items.length(); ++i) {
item += myData.line_items[i].product_id + "n"
total += parseInt(myData.line_items[i].total)
}
var fees = ""
// var feesTotal = 0
for (var i = 0; i < myData.fee_lines.length(); ++i) {
// convertir en entier
// feesTotal += parseInt(myData.fee_lines[i].total)
fees += myData.fee_lines[i].amount + " " + myData.fee_lines[i].name + " - " + myData.fee_lines[i].total + "n"
}
var discount = myData.discount_total
// nom client
var nomClient = myData.first_name + " " + myData.last_name
var order_total = myData.total;
var payment_method = myData.payment_method_title;
var phone = myData.billing.phone
var note = myData.billing.address_2 + "n" + myData.customer_note
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
sheet.appendRow([order_number, " ", " ", " ",order_address, " ", "Attente d'envoi",url, order_total, payment_method, nomClient, phone, note, item + fees + discount, ]);
}

-I set aWooCommerce API和webhook使用api的秘钥

-在webhook

中输入我的web应用程序的URL作为交付URL

我不知道是什么问题，我在网上找到的情况都没有找到任何帮助。

Answer 1

变量total从未被创建，但它在for循环中使用。