WebsiteBaker Community Forum

WebsiteBaker Support (2.8.x) => Bakery Shop => Topic started by: nene on July 29, 2010, 12:54:19 PM

Title: Automatic Product Arrangement in Bakery is not working
Post by: nene 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

Title: Re: Automatic Product Arrangement in Bakery is not working
Post by: freeSbee on July 31, 2010, 02:47:42 PM

Hi Nene

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

Regards Christoph

Title: Re: Automatic Product Arrangement in Bakery is not working
Post by: nene 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

Title: Re: Automatic Product Arrangement in Bakery is not working
Post by: freeSbee on August 13, 2010, 10:04:34 PM

Hi Nene

Please provide as much information as possible regarding your problem.

Regards Christoph

Title: Re: Automatic Product Arrangement in Bakery is not working
Post by: nene 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

Title: Re: Items in Alphabetic Order
Post by: freeSbee 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

Title: Re: Automatic Product Arrangement in Bakery is not working
Post by: nene on August 13, 2010, 11:00:06 PM

Thank you Christoph,
It is working fine now

Regards
Nene

Title: Re: Automatic Product Arrangement in Bakery is not working
Post by: delta44 on December 24, 2010, 09:37:08 AM

is it also possible to arrange the articles by declining article-numbers?

Title: Re: Automatic Product Arrangement in Bakery is not working
Post by: freeSbee 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