Post by Kaiketsu » Tue May 27, 2014 10:53 pm

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 1.5.6.4

Newbie

Posts

Joined
Tue May 27, 2014 10:41 pm

Post by Kaiketsu » Wed Jun 04, 2014 5:09 am

*Bump*

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?

Newbie

Posts

Joined
Tue May 27, 2014 10:41 pm
Who is online

Users browsing this forum: No registered users and 78 guests