"NEW" Badge on new items -- Where is the date stored?

[dynambee]

In the back office it is possible to choose how many days the "NEW" badge is displayed on newly added items. The default is 20 days.

However, where is the date stored that this 20 days is calculated from? I thought it would be in `tb_products`, specifically the `date_add` column but setting that date to an older date does not make the NEW badges disappear.

I ask because when building a new site I only want the NEW badge to appear on actually NEW items, not on items that previously existed in our product catalog that just happen to be recently uploaded to a new site.

[wakabayashi]

It is the date_add. But products are a bit messy IMO. I believe you neee to change it in product_shop table too.

[piet]

Hi,

 

Just remembered tha I saw a tutorial once about changing the new creation date. Below the link, maybe this will help you.

http://nemops.com/eidt-product-creation-date-thirtybees-prestashop/#.XZ1uk0YzZPY

Regards,

Piet

[musicmaster]

You can update it with Prestools too. 

[dynambee]

1 hour ago, musicmaster said:

You can update it with Prestools too. 

I should check out Prestools one of these days, I'm sure I would learn a good chunk about how PS and TB internals work.

What I was trying to do though was update the value in the db directly to match our actual product creation date for a given item. I do this with direct db writes through an SSH tunnel just after the API call creates a new product. Now that I'm doing the update to both the `product` and `product_shop` table it is working fine.