Exclude category from also purchased?

[Ajeh]

There are several aspects to the Also Purchased ...

That code blocks the Also Purchased from showing on the product _info when in the products of those categories ...

To block Products from those categories from showing on other categories in the Also Purchased but still let the Also Purchased to show, you need to customize the code in:
/includes/classes/db/mysql/define_queries.php

and change the code to include the code in RED:

DEFINE('SQL_ALSO_PURCHASED', "select p.products_id, p.products_image
                     from " . TABLE_ORDERS_PRODUCTS . " opa, " . TABLE_ORDERS_PRODUCTS . " opb, "
                            . TABLE_ORDERS . " o, " . TABLE_PRODUCTS . " p
                     where opa.products_id = '%s'
                     and opa.orders_id = opb.orders_id
                     and opb.products_id != '%s'
                     and opb.products_id = p.products_id
                     and opb.orders_id = o.orders_id
                     and p.products_status = 1
and master_categories_id NOT IN (71, 72, 75, 76)
                     group by p.products_id
                     order by o.date_purchased desc
                     limit " . MAX_DISPLAY_ALSO_PURCHASED);

[swamyg1]

Just wanted to give big thanks to you Linda. The code worked flawlessly, thank you so much for your persistence in helping me and understanding my needs. It's exactly what I was looking for.

This is the reason I love Zen Cart so much, this forum is unbelievably helpful and gives me everything I'm looking in an e-commerce platform. Thanks again.

[Ajeh]

You are most welcome ... glad that this is now working for you as you needed ... remember the Zen Cart Team when you are rich and famous ...

[mcpisik]

Thanks for answering this post also. I've just used your answer to instantly do the same thing. Cheers.

[Ajeh]

Thank you for the update that you were also able to use this solution ...

[gjh42]

Hi Gautama,

I tried messaging you but your inbox is full. Sorry for the bandwidth, but I had no other way to reach you:)