Author Topic: Sorting products in Bakery shop  (Read 425 times)

Offline svsanchez

  • Posts: 448
Sorting products in Bakery shop
« 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!

Offline dbs

  • Betatester
  • **
  • Posts: 7526
  • Gender: Male
  • tioz4ever
    • WebsiteBaker - jQuery-Plugins - Module - Droplets - Tests
Re: Sorting products in Bakery shop
« Reply #1 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);

Offline svsanchez

  • Posts: 448
Re: Sorting products in Bakery shop
« Reply #2 on: June 25, 2018, 06:33:23 AM »
Hello dbs, thanks a lot for your help. Your suggestion worked :)

 

postern-length