How to Display the Products in Ascending Order

[amin007]

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.

[esopose]

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?

[amin007]

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

[Craig]

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

[Ivy]

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.

[blogmeistress]

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!

[amin007]

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

Please request for an update and you will get it.

[wpCommerce]

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