Possible to "hide" product in 1.5.x?

ronnieb wrote:Unfortunatly this doesn't work, tried hiding category and product as -1 but it put them at the top of the listing

any other solution ?

1. EDIT: catalog/model/catalog/category.php
2. FIND:

Code: Select all
public function getCategories($parent_id = 0) {
$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "category c LEFT JOIN " . DB_PREFIX . "category_description cd ON (c.category_id = cd.category_id) WHERE c.parent_id = '" . (int)$parent_id . "' AND cd.language_id = '" . (int)$this->language->getId() . "' ORDER BY c.sort_order");

return $query->rows;
}

3. REPLACE WITH:

Code: Select all
public function getCategories($parent_id = 0) {
$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "category c LEFT JOIN " . DB_PREFIX . "category_description cd ON (c.category_id = cd.category_id) WHERE c.parent_id = '" . (int)$parent_id . "' AND cd.language_id = '" . (int)$this->language->getId() . "' AND c.sort_order <> '-1' ORDER BY c.sort_order");

return $query->rows;
}

Now just set the sort order to -1 for all the ones you don't want to show.

AND c2s.store_id = '" . (int)$this->config->get('config_store_id') . "'  [b]AND c.sort_order <> '-1'[/b]  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)");