Documents vs. Products

[LeoSixtySix]

I have been studying Zen Cart 1.3.5 for some time now and have read that there was a way to exclude Documents (Document-General) from Products (Product-General) via the following link.

http://www.zen-cart.com/forum/showpost.php?p=125980

In short, I have started to add documents to my store (i.e. press releases, specification sheets, etc.) which are purely informational and not intended to be sold.

I would like to be able to exclude these documents from appearing in the "New Products for [month]" box and "New Products [more]" sidebox.

I'm guessing that a .PHP file would have to be modified somehow but was wondering if this can be controlled somewhere in the Administrator console.

In the event that it cannot, I was hoping to find out which .PHP file needs to be modified and also what needs to be modified to exclude "documents" for informational purposes only from being listed along with the "products" that are already for sale.

This is what I've found so far in the threads but could use a little more guidance.

product_listing.php
tpl_modules_product_listing.php
tpl_product_listing.php

Any help would be appreciated.

Thanks,
Arnold

[Ajeh]

You would have to change all select statements where you do not want to see the Documents or products_type 3 ...

So if you located all of the select statements and surrounded the WHERE clause in parens and added and products_type != 3

example:
Change from:

WHERE something something something order by ...

to read instead:

WHERE (something something something) and products_type !=3 order by ...

You would be blocking the Document products_type 3

NOTE: some WHERE clauses are built in 1 location some are built from several peices and parts etc. Some WHERE statements need products_type and others might need p.products_type ...

[LeoSixtySix]

Thanks... much appreciated. I'll let you know how it works out.