Cron to disable/enable products of a manufacturer

[neymarinho]

Hello everyone,

I would like to have a cron that would enable and disable certain products at certain time. 

I would like to disable all the products from a certain manufacturer and enable them at another time. 

How can I do this??

Thank you very much,

 

[CartExpert.net]

Hi.

 

You need to write a script that handles the enable and another one that handles the disable. You set them up as cronjobs from your hosting control panel.

 

Regards.

Robin.

The CartExpert Team

[neymarinho]

Yeah but what is the mysql command to disable/ enable products?

[vekia]

UPDATE ps_productshop_shop set active=0 WHERE id_product = 123

where 123 is an id of product you want to disable.

[neymarinho]

I manage to develop this:

 

$retval = Db::getInstance()->execute('

  UPDATE 'ps_product'

SET  'available_for_order'= 0 

WHERE 'id_manufacturer' = 3

 

');

 

echo 'Done with return: '.print_r($retval,1).PHP_EOL;

 

Not working, any idea why?

[vekia]

by "not working" you mean, that you have some parse errors ? or that products are still "available for order" ?

[neymarinho]

The cron is not giving me any error message and the page doesn't print any success message or error message.

Edited January 1, 2014 by neymarinho (see edit history)

[neymarinho]

   Still not working with the code:

$retval = Db::getInstance()->execute('

  UPDATE 'ps_product'

SET  'available_for_order'= 0 

WHERE 'id_manufacturer' = 3

 

');

 

echo 'Done with return: '.print_r($retval,1).PHP_EOL;

?>

 

Any idea???