{"id":6196,"date":"2017-03-28T13:51:42","date_gmt":"2017-03-28T17:51:42","guid":{"rendered":"https:\/\/themespress.ca\/?p=6196"},"modified":"2022-09-03T13:04:55","modified_gmt":"2022-09-03T17:04:55","slug":"woocommerce-products-sorted-by-sales","status":"publish","type":"post","link":"https:\/\/themespress.ca\/en\/woocommerce-products-sorted-by-sales\/","title":{"rendered":"Products Sorted by Sales WooCommerce Plugin"},"content":{"rendered":"
\n\t
\n\t\t
\n\t\t\t

This tutorial will show you how to create a function allowing you to display your best selling WooCommerce products. This query will include arguments that will check the WooCommerce “product”<\/strong> post type and use the meta query of the “total_sales”<\/strong> key.<\/p>\n

We increment $i inside the loop so the sorting number of each result starts at 1. We also need the WooCommerce variable $product in the loop so it returns the products.<\/p>\n

We want to display our WooCommerce products sorted by sales by making sure that the “total_sales”<\/strong> meta query key is superior to 0.<\/p>\n

We also need another condition that specifies if $units_sold > 1 we need to use plural. Otherwise, it’s singular.<\/p>\n

Here’s the code snippet to add into your WordPress plugin.<\/p>\n\n\t\t<\/div>\n\t<\/div>\n

<?php \n$i = 1; $args = array( \n'post_type'       => 'product',\n'meta_key'        => 'total_sales',\n'orderby'         => 'meta_value_num',\n'posts_per_page'  => 25,\n'meta_query'      => array(\n  array(\n    'key'      => 'total_sales',\n    'value'    => 0,\n    'compare'  => '>'\n    )\n  )\n);\n\n$loop = new WP_Query( $args );\nwhile ( $loop->have_posts() ) : $loop->the_post(); \n?>\n<h3>\n<a id="<?php the_id(); ?>" style="text-decoration: none;" title="<?php the_title(); ?>" href="<?php the_permalink(); ?>" target="_blank" rel="noopener">\n     <?php echo $i; ?><?php the_title(); ?>\n<\/a>\n<\/h3>\n<?php $i++; endwhile; ?>\n<?php wp_reset_query(); ?><\/pre><\/div>\n\t
\n\t\t
\n\t\t\t
This query also lets you edit your HTML and CSS.<\/p>\n\n\t\t<\/div>\n\t<\/div>\n<\/div><\/div><\/div><\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"This tutorial will show you how to create a function allowing you to display your best selling WooCommerce products. This query will include arguments that will check the WooCommerce \"product\"
Read More<\/a><\/div>","protected":false},"author":81,"featured_media":4623,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[283],"tags":[],"class_list":["post-6196","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/posts\/6196","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/users\/81"}],"replies":[{"embeddable":true,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/comments?post=6196"}],"version-history":[{"count":0,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/posts\/6196\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/media\/4623"}],"wp:attachment":[{"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/media?parent=6196"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/categories?post=6196"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/tags?post=6196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}