Page 1 of 1

Latest Module Ordered by Date Available and <=Now() ?

Posted: Tue May 27, 2014 10:53 pm
by Kaiketsu
Hi, i have done some searches and can't find a solution to my problem, i have found a few promising ones but not for my exact issue.

The problem is i am attempting to use the Latest module to show the latest releases (logical right?), ordered by the date available, the trouble is i have many pre-order items and only want to show what is currently released and not the pre-orders.

i have changed date_added to date_available in catalog/model/catalog/product.php this orders them how i wish but includes all the pre orders and with a limit of 1 currently shows the product being released in december 2015

i have attempted to change the getLatestProducts function aswell but any changes result in no physical change.

i was thinking of something like ORDER BY p.date_available <= NOW() (not sure if correct syntax) but i am unsure how exactly to implement this

Thank you :)

i am running OC

Re: Latest Module Ordered by Date Available and <=Now() ?

Posted: Wed Jun 04, 2014 5:09 am
by Kaiketsu

Is this not a thing people want? Or is there a module that does this already? Or more to the point is this be possible?