Thread: Products Unpublished

I had to mark several products and catagories as "Unpublished" due to some manufacture concerns. I now need to republish them but they do not show up in the Manage Products area, so I cannot find them. I could republish them all if there is a script to run against the database. Any help would be appreciated.

I've run into this before and managed to get the Unpublished products to reappear in the list by going into any other product that is showing and pressing the "Update" button. This seems to refresh the list of products shown in the admin area and should hopefully now show your missing products.

Not sure why its like this.. hope this helps, seems to work for me

update product
set published=1
where productid=x

replace x with your product number

or to turn them all back on in one go

update product
set published=1

And, of course,

update category
set published=1
where categoryid=y

replace y with your category number

or to turn them all back on in one go

update category
set published=1

Thanks for the SQL commands, they worked like a champ. I could not see in the admin section until ran them. I had actually unpublished some Departments (Sections) so I was able to get them back. Thanks for the help.