Hello wix community. I am trying to copy an entry from my “tempCart” database into a “2020_Registrants” database using insert() from the event.js after a new order is created.
here is my code that is in the event.js. I have test messages to insert into the collection, but nothing is showing up in the database.
import wixData from ‘wix-data’;
import wixStoresBackend from ‘wix-stores-backend’;
wixData.insert(“2020_Registrants”, {“errorTest”:“1”});
export function wixStores_onNewOrder(event) {
wixData.insert(“2020_Registrants”, {“errorTest”:“2”});
let newOrderId = event.orderId;
wixData.query(“Stores/Orders”)
.eq(“_id”, newOrderId)
.find()
.then((results) => {
if (results.items.length > 0) {
wixData.insert(“2020_Registrants”, {“errorTest”:“3”});
let item = results.items[0];
let reg = item.lineItems;
console.log(item);
console.log(item.lineItems);
for (var i = 0; i < reg.length; i++) {
wixData.insert(“2020_Registrants”, {“errorTest”:“4”});
let regID = reg[i].customTextFields[4].value;
wixData.query("tempCart")
.eq("participantID", regID)
.find()
.then((regResult) => {
if (results.items.length > 0) {
wixData.insert("2020_Registrants", {"errorTest":"5"});
let regPart = results.items[0];
let registrantID = regPart.participantID;
if (registrantID === regID) {
wixData.insert("2020_Registrants", {"errorTest":"6"});
wixData.insert("2020_Registrants", regPart);
}
} else {
wixData.insert("2020_Registrants", {"errorTest":"7"});
console.log("Failed to Retrieve");
// handle case where no matching items found
}
})
.catch((err) => {
wixData.insert("2020_Registrants", {"errorTest":"8"});
let errorMsg = err;
});
}
} else {
wixData.insert("2020_Registrants", {"errorTest":"9"});
console.log("Failed to Retrieve");
// handle case where no matching items found
}
})
.catch((err) => {
wixData.insert("2020_Registrants", {"errorTest":"10"});
let errorMsg = err;
});
}