johnxl Posted June 3, 2013 Share Posted June 3, 2013 (edited) Hello ! Is it possible to change date of product ! I mean how prestashop knows when i added a new product? Edited June 4, 2013 by johnxl (see edit history) Link to comment Share on other sites More sharing options...
vekia Posted June 3, 2013 Share Posted June 3, 2013 You can change product add date (product update date also) in the database open ps_product * ps_product_shop tables you've got there: change values of these fileds. 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. 3 1 Link to comment Share on other sites More sharing options...
johnxl Posted June 4, 2013 Author Share Posted June 4, 2013 Thanks ! That is exactly I need ! Link to comment Share on other sites More sharing options...
vekia Posted June 4, 2013 Share Posted June 4, 2013 you're welcome If you've got any questions related to this case - feel free to continue discussion here regards Link to comment Share on other sites More sharing options...
blackflow Posted October 30, 2013 Share Posted October 30, 2013 I have to say it's stupid. If you're developing and adding products every single product has label "NEW" and the only way is to change through mysql? I want to keep that label for the future but imagine a check box in the product page would much easier. Is there any way of working around it? Link to comment Share on other sites More sharing options...
ps3z Posted March 21, 2014 Share Posted March 21, 2014 I have to say it's stupid. If you're developing and adding products every single product has label "NEW" and the only way is to change through mysql? I want to keep that label for the future but imagine a check box in the product page would much easier. Is there any way of working around it? yes you are right im looking for it. i have preorder sales...so i did create products earlier from release date... we need a module for that.. Link to comment Share on other sites More sharing options...
vekia Posted March 24, 2014 Share Posted March 24, 2014 idea of this module is to display everything automatically, this is why checkbox to mark product as new doesnt exist. only module can solve this problem. As i already mentioned 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. Link to comment Share on other sites More sharing options...
ps3z Posted March 25, 2014 Share Posted March 25, 2014 idea of this module is to display everything automatically, this is why checkbox to mark product as new doesnt exist. only module can solve this problem. i see,is there any module for it? or we have to write a new module? Link to comment Share on other sites More sharing options...
musicmaster Posted March 25, 2014 Share Posted March 25, 2014 In the menu under Preferences->Products you can set how long a product should be labelled as "new". If you have a new shop you could fill in "0" so that no product at all is labelled new. Link to comment Share on other sites More sharing options...
TomPuja Posted October 4, 2014 Share Posted October 4, 2014 Hey! Does this trick with MySQL work for PS1.6 also? I have tried fore few products to updte add/upd dates, clear cache, turn it on/off, force recompile... However, a tag "NEW" still sitting... any other ideas? Thanks! Link to comment Share on other sites More sharing options...
[email protected] Posted August 5, 2015 Share Posted August 5, 2015 Hi, Actually i am try to update "date_add" column of ps_product when i "enable" the product from admin panel. Plz suggest how it can be done. Regards, Rakhi Gupta Link to comment Share on other sites More sharing options...
Gomlers Posted February 15, 2016 Share Posted February 15, 2016 Hey! Does this trick with MySQL work for PS1.6 also? I have tried fore few products to updte add/upd dates, clear cache, turn it on/off, force recompile... However, a tag "NEW" still sitting... any other ideas? Thanks! I have the suddenly the same problem with ONE product.. Other products I've changed date for in the DB is ok, but this ONE product is a %#"%# - won't get rid of "New" label. Did you find a solution to this that you remember? Or anyone else know how to? Link to comment Share on other sites More sharing options...
Recommended Posts