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]

sql.Query() only works for SELECT statements.

To do an INSERT or UPDATE etc. you need sql.Exec() or sql.ExecSql()