Disabled products still showing up [solved]

[omgzhobbs]

Usually I just delete the products, but this time I generally just need to disable a few things will prices are reworked, so ideally I want to avoid having to remove them all and then go though the painful process of individually assigning RRP prices and images to each product.

However after disabling all of the products, they are still showing up in the shop for purchase.. they show in the 'new products' module as well as any category they are assigned to.. any idea why disabling them does nothing?

It shows the red cross in the back office, but yet nothing has changed..

Here are all of the products which are disabled;

 

http://www.zappies.com/6_winning-moves

Edited January 30, 2014 by omgzhobbs (see edit history)

[omgzhobbs]

Ok I have figured it out, when disabling products in bulk via SQL you have to edit more than one database.

ps_product

 

and also

 

ps_product_shop

 

little bit odd, but ive noticed anything you do via SQL needs to be done twice, usually in another table full of similar data.  

 

[solved]

[mcian]

So, this should work:

 

    UPDATE ps_product SET active = '0' WHERE ps_product.id_product = '105'
    UPDATE ps_product_shop SET active = '0' WHERE ps_product_shop.id_product = '105'

 

..where 105 is the product id ans this query is setting it to DEactice.

Edited February 6, 2014 by mcian (see edit history)