[Resolved] Cannot sort products (WooCommercer) by Price with Views using URL parameter

[Author]

Posts

[SJ5362]

I am trying to:
Cannot sort the results (WooCommerce Products ) by Price with Views using URL Parameter correctly.

Link to a page where the issue can be seen:

Page (View using wpv-woo-product-price ) - hidden link

Page (View using field-views_woo_price) - hidden link

I expected to see:
Products sorted correctly from lowest to highest price.

Instead, I got:

However, this is not the case, the products are not sorted correctly in both cases.

Question :
What is the difference between wpv-woo-product-price and field-views_woo_price ? Anyway, none of these two is working when sorting products by price. wpv-woo-product-price gives the same number of results as other sorting criteria (sorting by product's title) whereas field_views_woo_price does not give the same number of results and does not sort the products correctly.

[Luo Yang]

Hello,

I assume we are talking about a normal post view, querying product posts.

Yes, it is possible to sort the results by field "views_woo_price", see it in your website:

ASC order:
hidden link

DESC order:
hidden link

You will need to use order by "as a number" option, see screenshot: sortby-price.JPG

The custom field "views_woo_price" is a feature of Woocommerce Views plugin:
https://toolset.com/documentation/user-guides/views-shortcodes/#wpv-woo-product-price

[SJ5362]

Thanks for your response but I need to sort it based on the woocommerce price field and not based on views_woo_price field. How is that possible?
The issue with views_woo_price is that I have to maintain the price at 2 places. One is woocommerce price field and another is this views_woo_price field.

[Luo Yang]

I assume we are talking about the custom field "_price" of Woocommerce plugin, it is a hidden field, you can try these:
Dashboard-> Toolset-> Settings-> Front-end Content
in section "Hidden custom fields", click button "Select custom fields", find and enable option "_price".

Then you will be able to use field "_price" to sort the Views result.

[SJ5362]

Thanks for your response,
I also need to Sort books by a custom field containing author's last name (and then sort books' titles alphabetically - using nested View) . How is that possible?
This author's last name is coming from another custom post type which is related to woo commerce product using Toolset relations. Let me know if it is clear to you?

New threads created by Luo Yang and linked to this one are listed below:

https://toolset.com/forums/topic/sort-books-by-a-custom-field-containing-authors-last-name/

[Luo Yang]

I assume the original question of this thread is resolved, for the new question, please check the new thread here:
https://toolset.com/forums/topic/sort-books-by-a-custom-field-containing-authors-last-name/