How disable all products that have price 0

[iticleonel.len]

How I can disable all products that have price 0

 

i try some like this

 

BEGIN

UPDATE diventoc_product_shop SET active=0 WHERE diventoc_product IN (SELECT diventoc_product FROM diventoc_stock_available WHERE quantity=0);

UPDATE diventoc_product_shop SET active=1 WHERE diventoc_product IN (SELECT diventoc_product FROM diventoc_stock_available WHERE quantity>0);

END

 

​could you help me?

 

thanks a lot!!

[vekia]

you should define column names, not table names in WHERE and SELECT clauses

 

like:

UPDATE ps_product_shop SET active=0 WHERE ps_product.id_product IN (SELECT ps_product.id FROM ps_stock_available WHERE quantity=0);

[El Patron]

once you have that completed, you can use our module as it will automatically disable products when quantity reaches 0

 

http://www.prestashop.com/forums/topic/269988-module-automatically-hide-out-of-stock-products-v14-15/

[Kirillych]

UPDATE `ps_product` SET active=0 WHERE price = 0.000000
 

AND

UPDATE `ps_product_shop` SET active=0 WHERE price = 0.000000

Edited October 1, 2013 by Kirillych (see edit history)

[vekia]

UPDATE `ps_product` SET active=0 WHERE price = 0.000000

 

wrong, ps_product_shop