I tried to make a custom inventory 1:1 for retail setup but i get erros on this jscript can someone look in to it to offer some kind of guidence or advice I added a column in MenuItems called Inventario = " Stock in English ", [a2] [a3] I’m triying to update the value from that column using this …

sql.Query() only works for SELECT statements. To do an INSERT or UPDATE etc. you need sql.Exec() or sql.ExecSql()

I tried to make a custom inventory 1:1 for retail setup but i get erros on this jscript can someone look in to it to offer some kind of guidence or advice

QMcKay October 12, 2017, 11:59am 10

Have you seen this? It was originally designed for Retail 1:1 Product/Inventory …

1 Like