You would need to customize the file:
/includes/modules/pages/products_all/header_php.php
Code:
$products_all_query_raw = "SELECT p.products_type, p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id,
p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
p.product_is_always_free_shipping, p.products_qty_box_status,
p.master_categories_id
FROM " . TABLE_PRODUCTS . " p
LEFT JOIN " . TABLE_MANUFACTURERS . " m ON (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd
WHERE p.products_status = 1
AND p.master_categories_id != 70
AND p.products_id = pd.products_id
AND pd.language_id = :languageID " . $order_by;
again, change the 70 to your categories_id ...
NOTE: there is no override for this file ...
Bookmarks