Page 1 of 2 12 LastLast
Results 1 to 10 of 13
  1. #1
    Join Date
    Nov 2009
    Posts
    17
    Plugin Contributions
    0

    Default Listing Sort Order by Date Added

    v1.5.7c
    It is the latest version, I have just installed.
    I have Image Handler installed and that is it.
    I used a one click install from my hosting company.
    PHP Version: 7.4.12 (Zend: 3.4.0)

    URL: https://www.aimeeharrisondesigns.com/store/

    I have looked everywhere and cannot find a thread to help me with this.

    I simply want to sort all my products by date added. Not alphabetically. I had an old version that did this and I cannot find the instructions to do this using my version.

    If anyone can point me in the right direction, that would be great. Or tell me what needs to be changed and I will change it.

    Thank you!

  2. #2
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,623
    Plugin Contributions
    123

    Default Re: Listing Sort Order by Date Added

    There's no built in way to do this. If it was me, I'd just modify includes/index_filters/default_filter.php to taste.
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  3. #3
    Join Date
    Feb 2009
    Location
    UK
    Posts
    1,221
    Plugin Contributions
    1

    Default Re: Listing Sort Order by Date Added

    Quote Originally Posted by swguy View Post
    There's no built in way to do this. If it was me, I'd just modify includes/index_filters/default_filter.php to taste.
    That's how I do it. I replaced line #82 in that file with:

    Code:
    $listing_sql .= " order by p.products_date_added desc, pd.products_name";
    Simon

  4. #4
    Join Date
    Nov 2009
    Posts
    17
    Plugin Contributions
    0

    Default Re: Listing Sort Order by Date Added

    Thank you!!

  5. #5
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,623
    Plugin Contributions
    123

    Default Re: Listing Sort Order by Date Added

    You might also need to update the SELECT to include this field depending on your database mode - not sure.
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  6. #6
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,623
    Plugin Contributions
    123

    Default Re: Listing Sort Order by Date Added

    @simon1066 if you have some free time, writing this up as a documentation article (Developer's side) would be great so people who want to do this can follow a set of steps.
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  7. #7
    Join Date
    Feb 2009
    Location
    UK
    Posts
    1,221
    Plugin Contributions
    1

    Default Re: Listing Sort Order by Date Added

    Quote Originally Posted by swguy View Post
    @simon1066 if you have some free time, writing this up as a documentation article (Developer's side) would be great so people who want to do this can follow a set of steps.
    Sure, will do.

    Edit:

    Quote Originally Posted by swguy View Post
    You might also need to update the SELECT to include this field depending on your database mode - not sure.
    Can I ask what you mean by 'database mode', is it innodb/myisam?
    Last edited by simon1066; 13 Oct 2021 at 05:08 PM.
    Simon

  8. #8
    Join Date
    Nov 2005
    Location
    los angeles
    Posts
    2,669
    Plugin Contributions
    9

    Default Re: Listing Sort Order by Date Added

    Quote Originally Posted by swguy View Post
    @simon1066 if you have some free time, writing this up as a documentation article (Developer's side) would be great so people who want to do this can follow a set of steps.
    @swguy i think it would be a good PR to be able to override the default_filter.

    can we count on you for that?
    author of square Webpay.
    mxWorks has premium plugins. donations: venmo or paypal accepted.
    premium consistent excellent support. available for hire.

  9. #9
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,623
    Plugin Contributions
    123

    Default Re: Listing Sort Order by Date Added

    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  10. #10
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,623
    Plugin Contributions
    123

    Default Re: Listing Sort Order by Date Added

    Quote Originally Posted by carlwhat View Post
    @swguy i think it would be a good PR to be able to override the default_filter.

    can we count on you for that?
    AHEM! I spend the morning documenting sort order on the store front. How 'bout you step up?
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. v151 Change sort order of products to date added to category
    By Bee01 in forum Customization from the Admin
    Replies: 2
    Last Post: 25 May 2013, 02:21 PM
  2. sort by price, date added, etc
    By RollzRoyce in forum Templates, Stylesheets, Page Layout
    Replies: 1
    Last Post: 5 Aug 2010, 05:03 PM
  3. Sort by Date Added New to Old (etc) on Product Listing Pages?
    By limelites in forum Templates, Stylesheets, Page Layout
    Replies: 1
    Last Post: 25 May 2009, 09:21 PM
  4. Sort by Date Added/Product ID
    By edadk in forum Setting Up Categories, Products, Attributes
    Replies: 0
    Last Post: 10 Nov 2008, 04:56 PM
  5. Sort By Date Added!!
    By brotherhud in forum Setting Up Categories, Products, Attributes
    Replies: 3
    Last Post: 21 Feb 2007, 01:39 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR