[solved] Don't show certain products in new-products

[ossy]

Hello,

 

I need that products of the "outlet" category, don't appear on the section "new-products".

I don't know how to get this.

 

I have changed the aad_date of a product in the database, but the product is still listed as new-product.

 

 

Any idea?

Thank you very much.

[vekia]

add_date? you mean date_add field, am I right?

 

ps. you changes ps_product or ps_product_shop? try to change second one

[ossy]

Ok perfect, changing the date in ps_product_shop the product disappears of news,

 

There isn't an easier way to this, am I right?

 

I'll do one sql consult to be faster.

 

UPDATE `ps_product_shop`
SET `date_add`='20130515'
WHERE `id_category_default`=18

 

 

 

 

Thank you very much Vekia

Edited May 31, 2013 by ossy (see edit history)

[vekia]

thanks for your sql query :-)

 

i marked this thread as [solved]

 

regards

[ossy]

Thanks Vekia.