Tips and Tricks HQ Support

Support site for Tips and Tricks HQ premium products

  • Home
  • Contact Us
  • Documentation
  • Forum Home
    • Forum
    • Forum Search
    • Forum Login
    • Forum Registration

How to Display the Products in Ascending Order

by

Tips and Tricks HQ Support Portal › Forums › WP eStore Forum › WP eStore Tweaks › How to Display the Products in Ascending Order

Tagged: product order, sort product display, sort users

  • This topic has 7 replies, 6 voices, and was last updated 12 years, 8 months ago by wpCommerce.
Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • January 9, 2010 at 11:09 pm #641
    amin007
    Participant

    If you want to sort and display the products in ascending order rather than descending order when using the “All Products Display” option then do the following:

    1. Open the “eStore_misc_function.php” file and search for the following line:

    $wp_eStore_db = $wpdb->get_results(“SELECT * FROM $products_table_name ORDER BY id DESC LIMIT $start, $limit”, OBJECT);

    2. Once you find the above line change the “DESC” TO “ASC” then save and upload the file and it should do the job.

    June 3, 2010 at 8:39 am #17122
    esopose
    Member

    I can’t find the “eStore_misc_function.php”. Has that file name been changed?

    Also, is there any way to change the sorting only for a given category?

    June 4, 2010 at 1:09 am #17123
    amin007
    Participant

    What version of the plugin do you have? Are you looking inside the “wp-cart-for-digital-products” directory?

    “Also, is there any way to change the sorting only for a given category?” – Nope

    June 10, 2010 at 7:02 pm #17124
    Craig
    Member

    Am I understanding correctly that it is not possible to sort in ascending order when using the tag [wp_eStore_category_products:category_id:1:end] ?

    I am only displaying products by category and it would be very helpful to be able to display recently added products at the top of the page.

    Thanks – Craig

    June 11, 2010 at 1:19 am #17125
    Ivy
    Member

    Yes you can display them in ascending order you need to make a minor code change as mentioned above.

    1. Open the “eStore_misc_function.php” file and search for the following line:

    $wp_eStore_db = $wpdb->get_results(“SELECT * FROM $products_table_name ORDER BY id DESC LIMIT $start, $limit”, OBJECT);

    2. Once you find the above line change the “DESC” TO “ASC” then save and upload the file and it should do the job.

    July 20, 2010 at 2:53 pm #17126
    blogmeistress
    Member

    Hi there.

    I tried the above – editing the “eStore_misc_function.php” file and changing DESC to ASC, but the products on my client’s site are not shown all in one go, only in categories… so I’m not seeing any change.

    Is there a way to make the default order within all categories do the same (ie become ASC rather than DESC)?

    Example:

    http://jevondangeli.com/hypnotherapy-mp3s/

    To me, it doesn’t make sense for new products to show at the bottom – would be much better to have them showing at the top!

    Please let me know if it’s possible.

    Thanks!

    July 21, 2010 at 1:46 am #17127
    amin007
    Participant

    I have made it so product in a category are displayed new to old.

    Please request for an update and you will get it.

    July 21, 2010 at 4:57 am #17128
    wpCommerce
    Moderator

    Please have a look on this post on how to get update – https://support.tipsandtricks-hq.com/forums/topic/how-and-when-do-you-get-an-update

  • Author
    Posts
Viewing 8 posts - 1 through 8 (of 8 total)
  • You must be logged in to reply to this topic.
Log In

Forum Related

  • Forum Home
  • Forum Search
  • Forum Login

Support Related Forms

  • Contact Us
  • Customer Support
  • Request a Plugin Update
  • Request Fresh Download Links

Useful Links

  • Plugin Upgrade Instructions
  • WP eStore Documentation
  • WP eMember Documentation
  • WP Affiliate Platform Documentation
  • WP PDF Stamper Documentation
  • WP Photo Seller Documentation
  • Tips and Tricks HQ Home Page
  • Our Projects

Quick Setup Video Tutorials

  • WP eStore Video Tutorial
  • WP eMember Video Tutorial
  • WP Affiliate Platform Video Tutorial
  • Lightbox Ultimate Video Tutorial
  • WP Photo Seller Video Tutorial

Our Other Plugins

  • WP Express Checkout
  • Stripe Payments Plugin
  • Simple Download Monitor

Copyright © 2023 | Tips and Tricks HQ