Enable products in store

[S N Menon]

I have over 30000 products in my store but all of them are disabled. Anyone have an idea to enable them all either using prestashop backend or my database?Also in the future how to set the new product status enabled by default, so that I don't have to manually enable them after each and every product import. 

Any help would be much appreicated

[musicmaster]

update ps_product set active=1

update ps_product_shop set active=1

[S N Menon]

Thanks musicmaster. Would you be able to elaborate?Sorry I am not very good at handling MysQL . Also I found something strange that I no longer have ps_ database fields. Its all ccz_ or mmq_ unless I am looking at the wrong table. 

[musicmaster]

If you are are not so good at handling MySQL you have a problem because there is no really fast way to update 30,000 articles when you don't go directly to MySQL or PHPmyadmin. 

 

During the installation Prestashop proposes a prefix for the database fields. The default is ps_ but it looks like you have chosen another one. However, your mentioning of two different prefixes leaves me puzzled.