Select if a product is new or not when adding it

[Juandbbam]

Hello,

 

Not all products that I'm uploading to the shop now that I'm launching it are new. Is there any way of selecting which products are shown in the new products area?

 

Thank you in advance

[bellini13]

unfortunately prestashop displays new products based on the date the product was added. one idea is to use phpmyadmin to change the product add date for those products you do not want to appear as new. make the date greater than 30 days should do it.

[21846657]

@bellini13, do you manage to do it?

[martamill3]

Hi!

I want to know if there is a way to fix the value of date_add of the products.

 

Now I'm changing the date_add value with phpmyadmin but when I make a change on the product the date_add resets and changes to the real date_add. 

 

I verifited this making some examples comparing with the date_upd but the problem is that when everytime I change something on a product the date_add resets to the original value.

 

 

If it is not possible, is there a way to order the prodcucts different than: id, date_add/upd, name or price?

 

 

 

thanks a lot!!!

[vekia]

what table you change?

[martamill3]

Product table atribute date_add

[MissLili]

I'll be interested too if you find the right table to change the date_add!! Thanks

[MissLili]

Found the answer on another post

 

http://www.prestashop.com/forums/topic/285586-how-to-change-products-add-date-in-db-solved/

 

Answer by Vekia:

 

if you use prestashop 1.5.x:

table: ps_product_shop

field: date_add

 

and still works on PS v1.6.0.6

[MissLili]

*deleted*

Edited July 1, 2014 by niclap (see edit history)