Help with Products deactivated

[dsimon]

I love that Zen cart tells me how many Products deactivated there are.

How can I find out which ones have been deactivated with having to go thru all my sales and checking?

Thanks for all your help

Dave

www.thecoinopshopinc.com

[RodG]

I love that Zen cart tells me how many Products deactivated there are.
How can I find out which ones have been deactivated with having to go thru all my sales and checking?

Using a tool such as 'phpmyadmin', enter the following SQL query:

SELECT * FROM `products` WHERE `products_status` = 0 ;

Cheers
Rod