X-Cart forums

[wertzwerth]

Hi All,

Anyone know of a way to exclude the products of 1 specified main category (and its subcategories) from ever displaying in randomly generated Recommended Products results?


I appreciate any input on how to go about this --thanks.

[wertzwerth]

Someone outside of these forums was gracious enough to point me in the right direction, so here's the answer:

Open up recommends.php, then find the line that starts:

$products_id = func_query("SELECT $sql_tbl[products].productid FROM....

Then, further on that same line, I added the following (in bold text):

...AND $sql_tbl[categories].categoryid = $sql_tbl[products_categories].categoryid AND $sql_tbl[categories].avail = 'Y' AND $sql_tbl[categories].categoryid != xxx AND $sql_tbl[categories].membership IN...

^xxx being the category id you want to exclude from the recommended products results.

Cheers