Hi All, please can someone tell me is there is a way in admin to set products to be listed in and ascending manner instead of descending? Any time I add a product, it shows up first when products are listed. I want to reverse this so products are listed by oldest first instead on the last.
I have the product listing addon but I believe this does not have anything to do with the default sorting in phoenix which shows the latest product first.
Thanks in advance for any assistance.
Sorting Products Ascending
-
- VIP Member
- Posts: 252
- Joined: Mon Mar 01, 2021 5:55 pm
- Has thanked: 27 times
- Been thanked: 8 times
Re: Sorting Products Ascending
@bestmatebestmate wrote: ↑Mon May 08, 2023 1:34 pm Hi All, please can someone tell me is there is a way in admin to set products to be listed in and ascending manner instead of descending? Any time I add a product, it shows up first when products are listed. I want to reverse this so products are listed by oldest first instead on the last.
I have the product listing addon but I believe this does not have anything to do with the default sorting in phoenix which shows the latest product first.
Thanks in advance for any assistance.
Have you changed this in the product listing settings
Sort Option: Latest Added (0=disable; 1=enable)
edit, sorry ignore that it is not what you asked
Re: Sorting Products Ascending
@tessthepup No worries, thanks.
@burt Please can you help with this? If you could kindly point me to where I can amend the way the results for new products are ordered, I could try change the ordering format for the database query from DESC to ASC which I believe will sort out my issue.
Many thanks.
@burt Please can you help with this? If you could kindly point me to where I can amend the way the results for new products are ordered, I could try change the ordering format for the database query from DESC to ASC which I believe will sort out my issue.
Many thanks.
-
- VIP Member
- Posts: 252
- Joined: Mon Mar 01, 2021 5:55 pm
- Has thanked: 27 times
- Been thanked: 8 times
Re: Sorting Products Ascending
@bestmate
I think you need to look in
includes/modules/content/index_products/cm_ip_product_listing.php
at '// We show them all'
I would copy the file and location into your override template first so you do not mess with the core.
I think you need to look in
includes/modules/content/index_products/cm_ip_product_listing.php
at '// We show them all'
I would copy the file and location into your override template first so you do not mess with the core.
Re: Sorting Products Ascending
tessthepup wrote: ↑Mon May 08, 2023 5:22 pm
includes/modules/content/index_products/cm_ip_product_listing.php
at '// We show them all'
I would copy the file and location into your override template first so you do not mess with the core.
@tessthepup
Thanks for your suggestion. I'm not quite sure what I expected to do as I don't see anything relating to sorting products in that file. Also, not sure what I should be copying to the ovveride template and where to copy to.
The file you mentioned above seems to relate to categories and manufacturers and I see only two instances of "ORDER BY" and they do not relate to new products. I'd thought I could just make a change somewhere from DESC to ASC but it seems that's not the case?
Re: Sorting Products Ascending
I got this resolves after tinkering around in three files. Everything sorts ascending now with the ?sort=1a appended to the three links in the three files. May not be pretty but I got my solution.