Automatic Product Arrangement in Bakery is not working

[nene]

Hello,
Automatic product arrangement in Bakery is not working anymore when I upgraded with Bakery v1.5.6.

Any ideas?

Regards
Nene

[freeSbee]

Hi Nene

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

Regards Christoph

[nene]

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]

Hi Nene

Please provide as much information as possible regarding your problem.

Regards Christoph

[nene]

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]

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

[nene]

Thank you Christoph,
It is working fine now

Regards
Nene

[delta44]

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

[freeSbee]

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