Author Topic: Automatic Product Arrangement in Bakery is not working  (Read 3386 times)

Offline nene

  • Posts: 59
Automatic Product Arrangement in Bakery is not working
« on: July 29, 2010, 12:54:19 PM »
Hello,
Automatic product arrangement in Bakery is not working anymore when I upgraded with Bakery v1.5.6.

Any ideas?

Regards
Nene
« Last Edit: July 29, 2010, 10:14:46 PM by nene »

freeSbee

  • Guest
Re: Automatic Product Arrangement in Bakery is not working
« Reply #1 on: July 31, 2010, 02:47:42 PM »
Hi Nene

Please read the upgrade notes:
http://www.bakery-shop.ch/#upgrade_notes

Regards Christoph

Offline nene

  • Posts: 59
Re: Automatic Product Arrangement in Bakery is not working
« Reply #2 on: August 11, 2010, 06:26:58 PM »
Thanks Christoph,
I have tried all in the upgrade notes but I still have to arrange the products in bakery manually. Can I get some help?

Best Regards
Nene

freeSbee

  • Guest
Re: Automatic Product Arrangement in Bakery is not working
« Reply #3 on: August 13, 2010, 10:04:34 PM »
Hi Nene

Please provide as much information as possible regarding your problem.

Regards Christoph

Offline nene

  • Posts: 59
Re: Automatic Product Arrangement in Bakery is not working
« Reply #4 on: August 13, 2010, 10:14:17 PM »
Thanks Christoph,
I want the products that show up on the frontend of my bakery pages to be arranged alphabetically by it self (automatic). I try to arrange them manually and its becoming difficult.

Regards
Nene

freeSbee

  • Guest
Re: Items in Alphabetic Order
« Reply #5 on: August 13, 2010, 10:26:34 PM »
Hi Nene

Search the file view_overview.php for the code line
Code: [Select]
$query_items = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_bakery_items WHERE section_id = '$section_id' AND active = '1' AND title != '' ORDER BY position ASC".$limit_sql);and replace it by
Code: [Select]
$query_items = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_bakery_items WHERE section_id = '$section_id' AND active = '1' AND title != '' ORDER BY title ASC".$limit_sql);
You're done - no more sorting manually!

Regards Christoph

Offline nene

  • Posts: 59
Re: Automatic Product Arrangement in Bakery is not working
« Reply #6 on: August 13, 2010, 11:00:06 PM »
Thank you Christoph,
It is working fine now

Regards
Nene

Offline delta44

  • Posts: 8
Re: Automatic Product Arrangement in Bakery is not working
« Reply #7 on: December 24, 2010, 09:37:08 AM »
is it also possible to arrange the articles by declining article-numbers?

freeSbee

  • Guest
Re: Automatic Product Arrangement in Bakery is not working
« Reply #8 on: December 24, 2010, 11:44:40 AM »
Hi delta44

Choose your code depending of what fits best:
Code: [Select]
$query_items = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_bakery_items WHERE section_id = '$section_id' AND active = '1' AND title != '' ORDER BY sku DESC".$limit_sql);
Code: [Select]
$query_items = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_bakery_items WHERE section_id = '$section_id' AND active = '1' AND title != '' ORDER BY item_id DESC".$limit_sql);
Regards Christoph