How to Find All Zen-Cart Deactivated Products? – Study PHP Skills, Share PHP Code

Is there some easy way we can find all products that have been set to deactivate? Without going through all of them one by one in admin?

We can use the powerful MySQL command to achieve this. Go to phpMyAdmin, if you only use the following SQL command, you will only get all deactivated products id numbers, it is still useless.

SELECT products_id FROM products where products_status = 0;

We can use MySQL Join search to meet our demands, we search 2 mysql tables:

select products_description.products_name, products.products_status from products_description, pres_products where products.products_status = 0 and products_description.products_id = products.products_id;