Forums / General Questions / Change status of all products to enabled quickly, how?

Change status of all products to enabled quickly, how?

Locked

Results 1 to 3 of 3

This thread is locked. New replies are disabled.

7 Mar 2009, 11:09 AM

coolglobal

New Zenner

Join Date:: Jul 2007
Posts:: 64
Plugin Contributions:: 0

Change status of all products to enabled quickly, how?

I need a way to change the status of all products to Enabled quickly including zero quantity products. I am unable to do it with the Easy Populate Module, (unresolved issue). I have over 2000 products I need to get Enabled with a minimum of fuss. Could I do this with phpMyAdmin, or is there another method?

7 Mar 2009, 4:17 PM

bunyip

Totally Zenned

Join Date:: Sep 2004
Location:: Western Massachusetts
Posts:: 2,361
Plugin Contributions:: 1

Re: Change status of all products to enabled quickly, how?

From Admin > Tools > Install SQL Patches, run this sql query:

 UPDATE products SET products_status = 1 WHERE products_id > 0;

Neville
An assumption is what you arrive at when you get tired of thinking...

7 Mar 2009, 10:30 PM

coolglobal

New Zenner

Join Date:: Jul 2007
Posts:: 64
Plugin Contributions:: 0

Re: Change status of all products to enabled quickly, how?

Bunyip, you are a true Gentleman.