You’ll either have to sort/order your products manually or create a custom sort order within WooCommerce. For that take a look at the WooCommerce docs and this snippet for doing just that.
In this case you’re also going to have to do a bit of MySQL manipulation as well so that you’re sorting the numbers numerically. See this post on stackoverflow for an example.
NOTE: You may have some performance issues with the MySQl as a result.
Related Posts:
- How can I custom order the results from wp_list_categories?
- WooCommerce Product Page Loop – Output All Product Thumbnails
- wordpress change the loop order by dynamic value
- Customize WooCommerce Product Images (Placement and size) [closed]
- How to order posts by meta_value created inside loop?
- How to get_posts where ‘menu_order’ is more than 0/zero?
- woocommerce stored variable
- How to check if a product is purchased within the last 365 days before displaying something
- Ascending order has strange effects on wordpress loop
- Loop order issue with Ajax filter
- Loop random posts and display odd and even based on two alternating meta values?
- WordPress redundant posts based on meta field
- Get gallery and product gallery images full size
- WordPress Not Sorting By Custom Field
- How to use orderby on meta_value when using Pods custom database table storage
- How to make FSE’s query loop to order by comments number?
- Listing subpages title and content and styling the first iteration differently
- Infinite Scroll on a loop?
- Shortcode in posts called by ajax is not working
- How to fix pagination for custom loops?
- Modify the main loop to display current month / year
- Show all posts using the template page and the loop?
- Showing sticky posts with get_posts()
- Pagination – works on local but not live dev!
- On single.php, fetch 2 posts created after and 2 posts created before in relation to the actual post (using menu_order)
- query_posts() vs get_posts() multiple loops [duplicate]
- Page-loop is looping content from custom loops on the same site. How to avoid that?
- need help looping add_action in wp
- Problem getting current post tags to show in a widget
- Modified loop-single-forum.php to work inside of a sidebar Widget, not working on some site pages
- How to order posts by meta_value and title
- How to get the role id from the role name?
- Does WordPress Loop have a function like Shopify’s cycle?
- bbPress plugin: forum lists not showing in correct order? [closed]
- How do I paginate a get_posts() request inside another page loop (Paginating childpages)
- Basic multiple loops only displaying first loop
- Using Javascript for Looped Content
- Latest Post Styled Different Than other Posts
- Display post list with different styles
- ‘Auto Draft’ Post showing in wordpress loop
- How do I display an image before the first post of the loop when I’m using get_template_part?
- ACF custom field in [closed]
- Split wordpress loop to multiple layouts
- Post classes in the loop are being changed in certain themes
- single.php – how to mark current page in the loop
- Problem with displaying HTML content after in_array [closed]
- How do I make a variable available inside partials?
- How to hook into container
- Why does `inclusive` not work in this wordpress loop?
- Combine the results of two loops [closed]
- How do I automate multiple category loops?
- Added if statement to loop
- Both a page loop and posts loop on the same page
- WordPress: Loop Help
- How to get The Loop working with $wpdb->get_results()
- Making a query to the DB using same parameters of loop
- Woocommerce: How to display product price [closed]
- How to show more random posts if Tag has less than 3 posts
- Variable not being passed into WordPress loop
- Is wp_reset_postdata() redundant after the main loop?
- Cannot retieve the_content() and the_author() – both returning empty strings
- Exclude duplicated $sticky post from combined loop content
- Exclude first post (sticky or not) from the loop using query_posts()
- WordPress Plugin manipulate have_posts()
- How to order by multiple fields using standard query_posts?
- Multiple get_posts() queries on one page
- Loop for sticky posts
- Update status of all posts in a category
- Getting a custom field in the middle of a loop
- Pagination on Single Post
- is_active-sidebar loop
- How to add a specific div element to the first post in a row?
- Are plugins instantiated on every request to WordPress?
- Get author_id in wordpress
- 4 column-loop ordered alphabetically with entries grouped (and labeled) by their first letter
- Single.php different behaviour from admin to non-admin
- Get 1 more post in loop
- Unable to change the “Read more” text inside the_excerpt
- Exclude page name from loop
- How to display pending posts on the homepage only for editors
- PHP if post is already displayed, then
- Get User_id outside wordpress,
- How to style first post differently with ‘get_template_part’?
- Display Posts Only with Specific Tag
- I want to Add My Product Image to Admin Order Email in Woocommerece [closed]
- How to get my loop to paginate?
- Pagination not working in category listing [duplicate]
- Display Post Author Link above the loop
- How can I improve the performance of this query_posts loop?
- WordPress Blog has an infinite redirect loop
- Enabling users to control custom loop’s query
- Group posts by date with a list
- Add class to last 3 posts in loop
- Stepping through a foreach loop – adding +1 to the end of it so next time it loops it starts on item 2
- Calling the_excerpt from inside a plugin template file
- Recent posts per category loop?
- Include multiple page ids in loop
- Add leading zero to current post display [closed]
- Change date format
- “Call to a member function have_posts() on array” error on have_posts();