How to change products "add date" in DB. [SOLVED]

[blackflow]

Hi, I am developing a new shop and while adding multiple products I get the "new product" label. I' ve set  "14 days product as new" in  the admin panel and changed dates in mysql but still I get the "NEW" label. Any ideas? ( I've changed add and upadate dates)

http://lolo2.blackflow.pl/index.php?id_category=3&controller=category ["NOWOSCI tag]

Running presta 1.5.6

Edited October 31, 2013 by blackflow (see edit history)

[vekia]

where you changed dates in DB? everything depends on it

[blackflow]

products? is there any other place?

[vekia]

if you use prestashop 1.5.x:

table: ps_product_shop

field: date_add 

 

Optionally you can use my commercial module product date change it allows to change the date_add and date_Upd of product in a handy way, directly from shop back office.

[blackflow]

thank you! 
For learning purpose - why there is an entry "product" and "product_shop", what's the difference?

[vekia]

second table ps_product_shop is related to multistore feature, you can run several shops based on one prestashop installation, in this table you've got definition of products for each shops, You can enable / disable products for shops, and definition of this is stored in this table.

 

this tabe is used even if you don't use multistore feature.

[pette]

Hi, in prestashop 1.6

If I change the date_add of a product , there are problems with the previous sales , with comments and the whole system of prestashop ?

Thanks

[David Eschmeyer]

in bo - prod information tab

 

works in 1.6.1.x

 

Add it to line 132 (1.6.1.3) (after hard return) of: admin folder\themes\default\template\controllers\products\informations.tlp

{if $product->date_add}<div class="form-group"><label class="control-label col-lg-3"></td><span class="label-tooltip" data-toggle="tooltip"                title="{l s='Change date for "product new from".'}">{$bullet_common_field} {l s='New from'}</span></label><div class="col-lg-3"><input type="text" id="date_add" name="date_add" value="{$product->date_add|escape:html:'UTF-8'}" /></div></div>{/if}

edit - added the smarty if statement to hide the field if new product is really being added