In inventory some items have a negative stock (an import error). Fix ONLY the broken rows: set stock = 0 where it is below zero, without touching the correct items. A blanket update of the whole table holds needless locks — change only the rows that need it.