Random New Products Home Page

[stronyw123]

hello

Could someone tell me how to make random New products on home page? I'm using Block new products and i would like to have something like refresh every day. There is about 200 products on my shop.

 

blocknewproducts.php

[Gerardo Martinez G]

Do you want the date of when you entered it to be updated every day so that it always appears as a new product?

[stronyw123]

 

10 hours ago, Gerardo Martinez G said:

Do you want the date of when you entered it to be updated every day so that it always appears as a new product?

Yes this will be good!

So how to make it?  

[Gerardo Martinez G]

in database tables

ps_product
ps_product_shop

column `date_add`

You can make a script and run the days you want ... (crontab)
Inside the scrip the MySQL query.
This query will update all the records. You have to look for more options or products you don't want to update ....

UPDATE `ps_product` SET `date_add` = curdate();
UPDATE `ps_product_shop` SET `date_add` = curdate();