Forums / General Questions / Help with Products deactivated

Help with Products deactivated

Results 1 to 2 of 2

20 Jul 2012, 1:10 PM

dsimon

New Zenner

Join Date:: Mar 2012
Posts:: 82
Plugin Contributions:: 0

Help with Products deactivated

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

https://www.thecoinopshopinc.com

21 Jul 2012, 2:20 AM

rodg

Deceased

Join Date:: Jan 2007
Location:: Australia
Posts:: 6,263
Plugin Contributions:: 4

Re: 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?

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

SELECT * FROM products WHERE products_status = 0 ;

Cheers
Rod