Direct update of database doesnt reflect in the store for prod "Active"

[harmon]

Hi

 

Direct update of database doesn't reflect in the store for prod availability.

 

For instance, when changing the value in the table: _product > active > 0 

 

The product still appears in the store as active and available. 

 

 

How can direct changes to the database be made to reflect in the store?

 

Thank you

Edited October 7, 2013 by harmon (see edit history)

[CUBE-IN]

hi,

you need to change the value in _product_shop table in addition...

 

It's better to use prestashop functions for this. For example:

 

$p = new Product($id_product);
$p->ean13 = $ean;
$p->active = 1;
$p->update();

[stottycabanas]

It's better still to use the standard back office functionality on the Product global information page, where you can change the status from enabled to disabled.

Direct database updates should be avoided as a rule.