Reply To: Order Posts by Custom Fields When Meta Key Already In Use

• kwdit

• June 5, 2020 at 12:11 am

Thanks again for your help…

I can’t say I had a good understanding of the information on that page, but I’ve managed to solve my problem.

$args = array(
    'numberposts'   => -1,
	'post_type'     => 'cars',
	'meta_query' => array(
        'state_clause' => array(
            'key' => 'sold',
            'value' => '0'
		)
	),
    'meta_key'      => 'price',
	'orderby'       => 'meta_value',
	'order'         => 'ASC',
    'posts_per_page' => 12,
    'paged' => $paged
);

As you can see, I’ve used the meta_query to filter out the sold vehicles, allowing me to use the meta_key to order the results.

I’ve got a bit of a glitch going on though…
Any prices starting with 1 are at the beginning and any starting with 9 are at the end etc.
This has resulted in £30,000 cars being next to £300,000 cars.
I’ve checked the type for the Price field and it’s “number”.
Am I missing something simple or should I have done the ordering via meta_query as well?