What files control the 404 product not found?

[mc12345678]

This assumption isn't quite correct.

Removing the p.products_status = '1' will include the disabled product in the count(*), and that will indeed cause the '404 bit' to be skipped, assuming the product is still in the DB, but if the product with the $_GET['products_id'] has been deleted the res->fields['total'] will still be < 1 and the '404 bit' will be acted upon.

This may or may not be what you are after.

Cheers
RodG

Based on the original writeup: product disabled, still in database (not deleted), but not to be shown: products_id would still be valid, and so would everything else in the statement except a 404 would not be sent and one couldn't get to the product from the store side, could only get to the product (know that it currently exists) because it was found sometime in the past or is forwarded on now as an item of interest that has been disabled.

[Ajeh]

Just a silly idea here ...

But ... wouldn't it be easier to have Products that are 0 stock that go to products_status = 0, be changed to NOT go to products_status = 0 and just be products_quantity = 0 which then is Sold Out and adapt the Catalog to not show Products that products_quantity = 0 where you do not want to see them?

[RodG]

Yes that pretty much what I'm after. So a disabled product will:
- Not be visible in the product listings

This would be dependent on the product listings code / settings.
The proposed change to the product info page will have no effect on this.

- Accessible via external links

What happens here depends on the rest of the code for the product info page. The easiest way to determine this is to make the change and navigate to the product info page of the disabled product.

A product deleted from database will:
- Will return 404 not found

Only for the product info page.

In addition to the above I need to find out what code I need to change so that the product info page displays normally with the content and page title etc.

Unless I'm mistaken, no other changes will be needed, but again, the best thing to do is try it.

Never be afraid to experiment with these things. Just make sure you only change one thing at a time and if you don't get the expected results change things back to how they were before moving on.
What you should *not* do is leave a change in place if no effect is noted as a result of the change. Doing this has a nasty habit of biting you in unexpected ways.

Cheers
RodG

[RodG]

Just a silly idea here ...

But ... wouldn't it be easier to have Products that are 0 stock that go to products_status = 0, be changed to NOT go to products_status = 0 and just be products_quantity = 0 which then is Sold Out and adapt the Catalog to not show Products that products_quantity = 0 where you do not want to see them?

I have a feeling that this is what mc12345678 is/was trying to eke out of the OP.

I could be wrong.... or at best, a little confused other exactly what is trying to be achieved.
My aim here is to just answer the questions :)

Cheers
RodG