WebsiteBaker Support (2.8.x) > Bakery Shop

Automatic Product Arrangement in Bakery is not working

<< < (2/2)

freeSbee:
Hi Nene

Search the file view_overview.php for the code line

--- Code: ---$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);
--- End code ---
and replace it by

--- Code: ---$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);
--- End code ---

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: ---$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);
--- End code ---

--- Code: ---$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);
--- End code ---

Regards Christoph

Navigation

[0] Message Index

[*] Previous page