Still not working.
I plugged into the search results template the following:
list($productsRecords, $productsMetaData) = getRecords(array( 'tableName' => 'products', 'perPage' => '10', 'where' => "name != 'miele'", ));
However, Miele products keeps showing up in the results. Am I placing the code in the correct page?