[Resolved] Order archive products by price not working

[Author]

Posts

[ivanJ]

Hello,

I'm trying to order product by regular price with the field _regular_price but it's not affecting the order.
There is also a custom filter on the left side which is also not working properly. The filter is set as the custom fields of the products with all OR relationships. Because multiple laptops (in example) can have 3GB of RAM and INTEL I3 as a processor.
hidden link -> that's the archive, this is the name of that WordPress archive "Proizvodi, Kategorije, Oznake, Kategorije proizvoda, Proizvod oznake, Kategorije"

Best regards,
Ivan

[Minesh]

Hello. Thank you for contacting the Toolset support.

Well - the access details you shared with us is not working. Could you please send me working access details so I can check your issue further.

I have set the next reply to private which means only you and I have access to it.

[Minesh]

Well - The default shop page of Woocommerce plugin is archive page of post type "Products", and the query of WordPress archive page is setup by wordpress, Views cannot change it, but you can try with WordPress action hook "pre_get_posts":

So, I've added the following code at "Custom Code" section:
=> hidden link

function sort_by_regular_price($query) { 
    if ($query->is_post_type_archive('product') && $query->is_main_query()) {
    $query->set('order', 'ASC');
    $query->set('meta_key', '_regular_price');
    $query->set('orderby', 'meta_value_num');
    }
}
add_action('pre_get_posts', 'sort_by_regular_price');

More info:
http://codex.wordpress.org/Plugin_API/Action_Reference/pre_get_posts

Could you please confirm:
=> hidden link

[ivanJ]

Hello Minesh,

Yes, it works perfectly now, awesome, thanks.

But another issue is still present. Please, when you click on multiple filter choices, it doesn't show good. It only shows good when I have 1 filter checked.

When I choose more of them, it throws "No items found" (on my Croatian language of course).
hidden link

I hope you understand what I'm trying to describe, if not, I'll make a video, no problem 🙂

Best,
Ivan

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

https://toolset.com/forums/topic/split-order-archive-products-by-price-not-working-multiple-filters-applied-not-working/

[Minesh]

As your original issue is resolved. I have split the ticket for your another issue. Please feel free to resolve this ticket.

This will help us to write correct resolution summery as well as help other users searching on the forum for the specific issue.

We will continue with your new issue with the following ticket:
=> https://toolset.com/forums/topic/split-order-archive-products-by-price-not-working-multiple-filters-applied-not-working/

[ivanJ]

Hello Minesh,

I've ran into another problem. You see, I've modified you code by adding one of the categories into your custom code like this:

<?php
/**
 * New custom code snippet.
 */

function sort_by_regular_price($query) { 
    if ( $query->is_post_type_archive('product') || $query->is_product_category() ) {
    	$query->set('order', 'ASC');
    	$query->set('meta_key', '_regular_price');
    	$query->set('orderby', 'meta_value_num');
    }
}
add_action('pre_get_posts', 'sort_by_regular_price');

And now my navigation "Max Mega Menu Pro" is not working/showing up on those category pages - hidden link

Can you please check it out?

Thanks

[Minesh]

Well - could you please share few screenshots pointing out whats not working?

[ivanJ]

Hello Minesh,

Sorry it took me this long. I've made you a video showing what's wrong 🙂

Here's the link: hidden link

Best regards,
Ivan

[Minesh]

Well - the wp-admin access details you shared before is not working now at this end.

Could you please resend me working access details so I can look at it whats going wrong there.

I have set the next reply to private which means only you and I have access to it.

[Minesh]

Could you please check now. I've changed the code as given under:

function sort_by_regular_price($query) { 
    if ( $query->is_post_type_archive('product') or  $query->is_tax('product_cat') ) {
    	$query->set('order', 'ASC');
    	$query->set('meta_key', '_regular_price');
    	$query->set('orderby', 'meta_value_num');
    }
}
add_action('pre_get_posts', 'sort_by_regular_price');

I can see the order works now:
hidden link

[ivanJ]

My issue is resolved now. Thank you!