Hello all, I have a custom post type which I need to order in a specific order. These custom fields are Best Seller, and New, based on these values, it shows a tag on the post. New is not related to the post date just to make that clear. I want to query all the posts for this custom post type, but order them in the following order Best Seller, New, the rest of the posts.
Here is what I have tried, but the order is wrong, I can’t figure out how to get this query to work and order the posts how I want.
Ended up getting all the posts, created arrays for best seller, new, others, looped through each post and assigned to appropriate array, merged the arrays, then looped through the merged array to display the posts, works.