Looper Provider - Order By Price

[refreshingdigital]

Hi,

I’m using a looper to list products on my client’s e-commerce website - which generally works very well - and looks much nicer than the default WooCommerce shortcodes.

One client request I’m struggling with is to order the products by PRICE, specifically on the ‘Sale’ page.

Is there a way for me to sort products by the price metadata?

Many thanks!

Tyler

[tristup]

Hi Tyler,

Thanks for reaching out.
In that case, you need to use the Query String instead of Query Builder. I would suggest you go through the following thread which will help you on Query String.

WP_Query | Class | WordPress Developer Resources

Looper Query String: Featured Products

@bobbybosler, no problem…happy to help. For a little more context on how I got that result, you might find this helpful if you need to create additional complex queries in the future… First, you’ll need a PHP environment to work in. If you’re developing locally, you can just throw any of this in your child theme’s functions.php file to ultimately get some output to work with. Start by writing out a query using the standard WP_Query syntax like so: $tax_query[] = array( 'taxo…

MEC Looper Order

Hello Jen, Your WP Query is not entirely correct. If you follow the detailed explanation of @Kory on this thread (Looper Query String: Featured Products), you should be having something like this: $meta_query[] = array( 'key' => 'mec_start_date', 'value' => date('Ymd'), 'compare' => '>=', ); $tax_query[] = array( 'taxonomy' => 'mec_category', 'terms' => 'take-action', ); $query = array( 'post_type' => 'mec-events', 'tax_query' => $tax_query, 'meta_ke…

Thanks

[refreshingdigital]

Hi,

Thanks for the reply. Is there any plan to add in more WooCommerce integration with loopers etc?

Would be nice to have this sort of thing baked into Cornerstone.

Cheers

Tyler

[bill_hodgson]

The next release providers sorting on custom fields

[tristup]

Hi Tyler,

Our development team is working on the custom fields to be added to the sorting. Hopefully, it will be added to any of the upcoming releases.

Thanks