How to Find All Zen-Cart Deactivated Products?
Is there some easy way we can find all products that have been set to deactivated? 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 number, 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;