WebsiteBaker Community Forum

WebsiteBaker Support (2.8.x) => Bakery Shop => Topic started by: svsanchez on June 23, 2018, 12:03:58 AM

Title: Sorting products in Bakery shop
Post by: svsanchez on June 23, 2018, 12:03:58 AM

Hello. I need to sort the products displayed on a Bakery catalog by Title in ascending order. How can I do this?

Thank you!

Title: Re: Sorting products in Bakery shop
Post by: dbs on June 23, 2018, 07:27:33 AM

Hi, view_overview.php line 63
Original is ORDER BY position, change it to title

Code: [Select]

// Query items (for this page)
$query_items = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_bakery_items WHERE section_id = '$section_id' AND active = '1' AND title IS NOT NULL ORDER BY title ASC".$limit_sql);


Title: Re: Sorting products in Bakery shop
Post by: svsanchez on June 25, 2018, 06:33:23 AM

Hello dbs, thanks a lot for your help. Your suggestion worked :)