Disabling / Re-enabling Categories Issue

[jmberman]

I did figure out how to disable categories, the problem is it also disables EVERY product within them, and when you re-enable the category, the products are still disabled and have to be re-enabled one at a time... now imagine how long it took me to re-enable every single product listing... it sucked...

How can I re-enable all products at once?

[lat9]

What version of Zen Cart? Using 156c, when I click the enable/disable category I'm presented with a sidebar query asking whether the products' status should be unchanged or enabled/disabled, respectively.

To 'mass-enable' products in a category, navigate to that category so you can see its categories_id (it'll show as the cPath variable in the browser's address bar).

Then navigate to Tools->Install SQL Patches and, using that cPath value (just the last portion if it's in the form mmm_nnn):

UPDATE products SET products_status = 1 WHERE master_categories_id = nnn;

[jmberman]

What version of Zen Cart? Using 156c, when I click the enable/disable category I'm presented with a sidebar query asking whether the products' status should be unchanged or enabled/disabled, respectively.

To 'mass-enable' products in a category, navigate to that category so you can see its categories_id (it'll show as the cPath variable in the browser's address bar).

Then navigate to Tools->Install SQL Patches and, using that cPath value (just the last portion if it's in the form mmm_nnn):

UPDATE products SET products_status = 1 WHERE master_categories_id = nnn;

thank you!!!!

[mc12345678]

thank you!!!!

Note that that query won't address linked product in that category if they were also made to be disabled. That requires a different query to accomplish if needed. I thought I posted it in the previous thread about disabling categories, but maybe didn't finish that.