How to Seperate New General Documents from New Products ?

[HeyIts007]

Is it possible to Separate New Documents from New Products in the New Products listing option ? When I list new products, it's also listing new Document General items, that I don't want listed along with new products, as they clutter up the actual new products list.

[HeyIts007]

V 1.39h

I gather it might be a limitation of the ZenCart search function, unless it can be switched off to ignore Document General.

[Ajeh]

You could customize the SELECT statements to exclude the products_type that you do not want included on New Products ...

For example, in the:
/includes/modules/pages/products_new/header_php.php

  $products_new_query_raw = "SELECT p.products_id, p.products_type, 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.products_type != 3
                             AND p.products_id = pd.products_id
                             AND pd.language_id = :languageID " . $display_limit . $order_by;

Add the code in RED to exclude the General Document Products from the New Products page ...

Then, work you way through the code for the New Products Centerbox and Sidebox ...

[HeyIts007]

Ahh ok thanks. I will give it a try. Can I apply this as an override ? rather than editing the original code ?

[Ajeh]

Not on that particular file ... but you could on the New Products module and New Products sidebox ...