Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › PowerStore › Powerstore General / Announcements › order of products

order of products

Thread began 4/20/2010 11:04 pm by dave276887 | Last modified 5/09/2010 5:55 pm by dave276887 | 1005 views | 2 replies |

4/20/2010 11:04 pm | #1 dave276887

order of products

Hi
is it possible to change the order of products each store category?
Products_Results.php?Search=1&ProductCategoryID[]=58 would like them to be based on weight.

PS still building site as you can see.
Played with templates a bit.
:)
Dave

4/22/2010 8:40 am | #2 Jason ByrnesWebAssist

you can change the recordset code on the Products Results page from:

php:

$query_WADAProducts = "SELECT * , coalesce((select ps3_productoptions.GroupingID from ps3_productoptions WHERE ps3_productoptions.ProductID = ps3_products.ProductID limit 1),ps3_products.ProductID) AS GroupingID FROM ps3_products WHERE ProductLive = 1 GROUP BY GroupingID ORDER BY ProductName";

to:

php:

$query_WADAProducts = "SELECT * , coalesce((select ps3_productoptions.GroupingID from ps3_productoptions WHERE ps3_productoptions.ProductID = ps3_products.ProductID limit 1),ps3_products.ProductID) AS GroupingID FROM ps3_products WHERE ProductLive = 1 GROUP BY GroupingID ORDER BY ProductWeight";

5/09/2010 5:55 pm | #3 dave276887

thanks

great and thankyou

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.