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 display Yoast SEO meta description in archive template for each post instead of the_excerpt()? [closed]
- How to get Author ID outside the loop
- remove tags from the_content
- the_title() shows title of the first post instead of the page title?
- Why do themes rely on “The Loop”?
- Endless loop with wp_insert_post and wp_update_post
- Hook into the loop via a plugin, and output something after every X post?
- Two custom loops, pagination, offset
- What exactly defines a Main Loop and a Secondary Loop?
- Loop code is displaying pages but not actual posts
- Access to Media Library
- Remove action from woocommerce barcode plugin [closed]
- wordpress loop and template files
- Creating nested forum loops in bbPress [closed]
- Adding active/current class to get_terms list
- Redirect Loop to Page, Can’t Find Origin, Can’t Remove [closed]
- WP_Query ordering numbers as letters
- Display posts from multiple user roles
- Display content of page template (get_page)
- Meta Query with spaces in value?
- Display the_content on click jquery
- Missing image in gallery shortcode in custom feed
- Including post thumbnail url in loop’s post object to reduce number of queries
- Make blog page show 10 on first page, 9 on every other page
- Duplicate posts in paginated results
- Output loop leveraged shortcode twice on one page
- Two loops on different pages do the same thing, but only one page works
- Posts active and expired in different loops
- Added if statement to loop
- Getting a custom field in the middle of a loop
- Pagination on Single Post
- Display Posts Only with Specific Tag
- How to get my loop to paginate?
- Group posts by date with a list
- Add class to last 3 posts in loop
- Get author Meta for particular user inside the loop
- WP Query – order posts by meta field first and then order the rest
- Foreach displays from last to first
- value of metadata is null wrong use of if statement
- Count post views in loop
- displaying recent comments outside loop without plugin
- Separate First Post Loop
- add offset to archive page
- loop inside the foreach
- Category ID returns as ‘0’?
- make get_post work in the loop
- How to display 3 post per slide
- How to put a block of code between [shortcode][/shortcode] in do_shortcode()?
- For Each +1 WordPress Loop
- Plugin is creating posts twice
- How can I access a post’s feature image outside the loop?
- Loops for cat links not looping for wordpress site
- Skip 5 latest post while paging?
- WordPress: query pages except remove one page
- get_post_meta printing empty fields, but it shouldn’t be
- Is it possible to set archive.php instead of index.php to display blog?
- How to read taxonomy in loop?
- get the value for ALT is we check to see if an actual ALT value is set, if not we use the caption and if no caption is set we use the title
- Undefined index: page in loop load ajax content
- how to add 4 post in one carousel slide
- Only Show Excerpt After First 3 Posts
- Exclude Posts Using Meta Query and User Meta
- Is “the loop” a template tag?
- Show a list of user posts in the user admin page
- Deeply Nested Menu Loop with Twig using Timber [closed]
- WordPress with woocommerce custom query
- Get featured image outside the loop using foreach
- Page gets displayed in post field
- Active class for my flexslider in WordPress
- setup_postdata in “loop-handling” php file called via $.ajax
- get_template_part() to render single page Theme
- Can’t see custom field after the Loop [closed]
- Showing related posts (custom post type) outside of the loop
- Same Loop on Multiple Pages
- single.php fires more than once after clicking on any post to view with different post id each time
- get all page templates
- WordPress loop: Display if posts exist
- strange parse error when including a loop template within another template
- Previous Posts Link and Next Posts Link Show All The Same Articles?
- Posts Loops To Display Specific Posts Inside Page Template?
- Showing ads after posts in home page
- Auto Stock Update after Order cancel from Admin of Woocommerce?
- Undefined variable: woocommerce_loop [closed]
- title not being printed within html tag [closed]
- wp_mail sending only once inside foreach loop