With some help of this answer and this post I managed to get your desired sorting hooking into the posts_orderby
filter.
You would need to add some additional check so this only affects your post type and on your page of choice but this snippet gives you the required statement to get the
Apple store
Zebra store
7-11
posts sorting, provided their slug is
apple-store
zebra-store
7-11
since I order by post_name
which is the post’s slug
add_filter( 'posts_orderby' , 'wpse_custom_orderby_statement' );
function wpse_custom_orderby_statement( $orderby ) {
$orderby = " post_name+0<>0 ASC, post_name+0, post_name";
return $orderby;
}
Related Posts:
- Sort on meta value but include posts that don’t have one
- Using Orderby and meta_value_num to order numbers first then strings
- multiple orderby in pre_get_posts action
- get_the_terms in descending alphabetical order
- next and previous post link ordered alphabetically
- Order posts by meta_value even if meta_key is not filled
- Order by first name
- How to alter query order direction using $query->set(‘order’, ‘ASC’); inside a pre_get_posts filter?
- the_tags() : display the tags by the order they are typed in in the backend, not alphabetically
- Sorting Attributes order when using get_the_terms
- How to order posts by meta value?
- How Do I Order Posts by Modified Date? [duplicate]
- Orderby Post Views
- How to order posts (woocommerce products) alphabetically but ignore certain words, eg ‘The’ and ‘An’
- Best Plugin to Reorder Post Types
- Ordering system through WordPress
- Issue with multiple orderby values
- get_query_var returns wrong default value
- Use pre_get_posts to sort meta_key by an array of values
- Show first the posts from 1 specific tag
- Order posts by price
- All, published and pending order
- get_adjacent_post() returning weird results
- Get_Users Orderby Page
- Sort order of next/prev sibling page
- Order char by post title
- Why does pre_get_posts() return “date” as the orderby parameter for every sortable column?
- next_post_link and previous_post_link order not working properly
- query pages by a childs publish date
- List most recently added posts (with a twist)
- Check post_date in pre_get_posts
- pre_get_posts shows posts in random order sometimes
- Featured-Content/Featured Posts With Random Order
- Orderby in Query Posts affected by operating system?
- Ordering posts by title containing numbers
- Stylesheet Enqueue Order and Best Practices
- wp_list_pages sort order by top nav menu order and child of
- How to display taxonomy terms the way they are hierarchical
- wp_list_categories() by alphabet? (ex. only category titles that start with “A”) [closed]
- Order by ASC, DESC, Title, Date from URL on custom page template post
- Offset posts with random order
- view subcategories order by id
- Sort query output on taxonomy term archive by post type using pre_get_posts
- ASC and DESC separately from orderby
- Order WP_Query by The Order of an Array in Tax_Query
- struggling to order by title
- Order by two meta values – one is a number and the other is text
- Last post sorting get_categories
- Sort by DESC works, ASC doesn’t?
- Shop sends Mail with order cancellation
- List of terms in alphabetical order under the respective initial letter and within columns
- update_post_meta saves data but does not show in Order backend
- Changing cache update rate
- how to complete order status automatically after paypal payment received
- Order management including recurring orders on woocommerce
- Orderby Title not working
- Sort loop by title doesn’t sort single digits like human would
- Sort posts by meta value with get method
- How to order custom user list columns by datetime?
- Creating a post that contains a list of other posts like a table of contents
- Want to order by Meta Values (tweaking Post Order Widget)
- Changing posts order on a page
- Ordering Subcategories
- How to order posts by parents?
- single post navigation order (NOT chronological)
- Problem with meta_value order after update
- Random order of posts on each request
- How can I make have_posts() return posts ordered DESC by id?
- Add post order like page order
- Woocommerce Pre Orders view order link wrong [closed]
- How to make WordPress orderby work with post_excerpt column?
- Orderby with menu_order and title
- Sort wordpress posts by facebook likes [closed]
- Sorting by date not working?
- WooCommerce ‘all’ orders no longer being displayed – how may I debug/fix [closed]
- WP REST API: Order posts by meta value (acf)?
- Compare 3 custom fields and sort by oldest
- Order Custom post type loop by custom field (datepicker)
- Show all parents and children in custom post type in right order
- orderby:date not working
- Make Images appear in the same order as in media browser using get children?
- Order posts by custom field DATE value
- How to do WP_Query with two meta fields with orderby clause
- WP Query – Is this correct?
- How to manage a particular “order by” for get_search_query()?
- Ascending order has strange effects on wordpress loop
- Order posts by date
- WP_Query orderby
- Display Parent-Child Posts in specific order by comparing IDs in array
- sort title descending with title with number
- How to save one API response to WooCommerce order meta data
- SEARCH QUERIES – REVERSE OUTPUT
- How to sort (orderby) a query done by a template function before the ‘foreach’ loop?
- Display three sequential posts on each page load, without repeating previous
- Find by post_meta, then sort by post_meta, then sort by date (wp_posts)
- $args Orderby The number
- WP_Query with several meta_query-statements and order by meta_value
- How to search for articles containing two words?
- Query order by meta value force specific tag first
- How can I display all these movies in DESC order by modified?