Hello all,
Just thought I'd pass on a 'bug fix' I found the other day when fiddling about with this great contrib. It's not really a bug, but some people may find the following useful.
If, like me, you have a shop which doesn't have Manufacturers, the corresponding Manufacturers drop down list will be blank/Null. If you're running STRICT mode on MySQL, quick_stock will report that it has updated the item(s) (i.e. the stock number), but not actually run the script.
As far as I can work out MySql in Strict Mode doesn't like running an SQL statement with a NULL or empty value for the Manufacturer field. I added the following code
if ($items['manufacturer'] == '') {$items['manufacturer']=0;}
before the $sql variable is defined (somewhere round about line 377)
Of course, the other alternative is to have a dummy manufacturer.
Cheers