How can i display the products by date

I really have to display the product by date.
Question is how can I do it???

thanks for reading again ...advice PLEASE

in the webassist/plugins/catalog/results.php and results_grid.php you would need to edit the products recodsets to order by the ProductStartDate column

Thanks
But as you might know already I don't know how to edit....
Can you give the code so I could paste it?
If it is possible...

thanks again

This is not a supported modification to power store, so I really cant give to much help on this.

the code for the recordset on the results page is:

$query_WADAProducts = "SELECT ps4_products.*, coalesce(GroupingID,ps4_products.ProductID) AS GroupingID FROM ps4_products LEFT OUTER JOIN ps4_productoptions ON ps4_productoptions.ProductID = ps4_products.ProductID " .((isset($_SESSION["WADbSearch1_Products_Category_Results"]) && $_SESSION["WADbSearch1_Products_Category_Results"] != "")?"LEFT OUTER JOIN ps4_productcategories ON ps4_products.ProductID = ps4_productcategories.ProductID":""). " WHERE ProductLive = 1 AND (ProductStartDate IS NULL OR ProductStartDate <= CURDATE()) AND (ProductEndDate IS NULL OR ProductEndDate >= CURDATE()) " . ((isset($_SESSION["WADbSearch1_Products_Category_Results"]) && $_SESSION["WADbSearch1_Products_Category_Results"] != "")?$_SESSION["WADbSearch1_Products_Category_Results"]:"") . " GROUP BY coalesce(GroupingID,ps4_products.ProductID) ORDER BY".$_SESSION["orderAdd"]." ProductName";

the last part:
ORDER BY".$_SESSION["orderAdd"]." ProductName"


sets the ordering, you could change that to the start date using:
ORDER BY ProductStartDate"

I changed the code on RESULTS.PHP but doesn't sort by START DATE...
I'm not sure which page I need to changed.... RESULTS.PHP OR RESULTS_GRID.PHP...???

Thank you

are you using the regular results or the grid results?

if you are using grid style results, make the change in the results_grid.php page. if not make the change in the results.php page.


as stated before, this is not a supported modification, if you need additional help with this, you should sign up for a premiere support appointment.

thank you very much for your help