Create a Custom WooCommerce Product Loop (The Right Way)

- 75 comments

By

Development,Projects,WooCommerce,WordPress,WordPress Filters

If you ever needed to create a custom WooCommerce Product loop then you probably used get_posts() or even a WP_Query(). But did you know that using those could actually cause your loop to stop working unexpectedly or even break your site? If you didnā€™t know that then Iā€™m guessing you also didnā€™t know that WooCommerce actually has a native function for doing this. Itā€™s ok, I didnā€™t know any of that either until I wanted to create a custom WooCommerce Product loop complete with all its addons and paging without repeating any code.

Skip to the final snippet

On a recent WooCommerce project I was tasked with building a page to display only Featured Products. WooCommerce actually has a handy function to make getting Featured Product IDs very quick, wc_get_featured_product_ids(). Using that, itā€™s fairly trivial to plug that in to a custom WP_Query() and fire out a vanilla custom loop (or use get_posts() if youā€™re determined to do it the long way). I could even use the Featured Products shortcode, but those methods arenā€™t ideal. Unfortunately, anyone searching for the right way to accomplish this will find no shortage of stackexchange posts offering WP_Query() and get_posts() solutions. Letā€™s talk about why those arenā€™t great and what the best practices are.

The Downsides of using WP_Query & Shortcodes

The downside to a custom WooCommerce loop using any of the methods above is that Iā€™d end up losing the WooCommerce goodies that are baked into WooCommerceā€™s native loop. I wouldnā€™t get a nifty ordering dropdown to sort products by various criteria, and I wouldnā€™t get my much needed pagination. I can add those elements back into the loop myself, but itā€™s a good amount of repetitive code Iā€™d like to avoid adding to the project, especially because WooCommerce already comes with that code. In addition, if Iā€™ve used any of the WooCommerce action or filter hooks to change the main WooCommerce loop behavior or appearance then Iā€™ll need to account for those changes in my custom loop.

One more important downside is mentioned in the WooCommerce GitHub Wiki (emphasis added):

Building custom WP_Queries or database queries is likely to break your code in future versions of WooCommerce as data moves towards custom tables for better performance. This is the best-practices way for plugin and theme developers to retrieve multiple products.

After reading that and considering the other downsides of using WP_Query() and other methods to create a custom WooCommerce product loop, I decided to dig around and devise the most Woo-native way of creating a custom product loop to keep all the WooCommerce loop features while still leaving room to make the customizations I need. In my case, and the example Iā€™ll be demonstrating, that means displaying only Featured Products on a page made to closely resemble the main Shop page.

A Better Way

My quest for a better WooCommerce custom loop started where all great copies start: the original. So I took a look at archive-product.php inside my WooCommerce installation and began analyzing it. Itā€™s actually very simple, but itā€™s also very nuanced. So Iā€™m going to follow the structure of the WooCommerce Archive Template, including its action hooks and filters (along with a few other important bits Iā€™ll need to add), but instead of using the WordPress Archive loop (which isnā€™t available in a standard page template) Iā€™ll use wc_get_products() to follow best practices mentioned in the Wiki above.

Hereā€™s what weā€™re starting with:

<?php
if ( have_posts() ) {
do_action( 'woocommerce_before_shop_loop' );
woocommerce_product_loop_start();
if ( wc_get_loop_prop( 'total' ) ) {
while ( have_posts() ) {
the_post();
do_action( 'woocommerce_shop_loop' );
wc_get_template_part( 'content', 'product' );
}
}
woocommerce_product_loop_end();
do_action( 'woocommerce_after_shop_loop' );
} else {
do_action( 'woocommerce_no_products_found' );
}
view raw woocommerce_loop-unmodified.php hosted with ā¤ by GitHub

This is the simple base weā€™re starting with. Itā€™s a very basic WordPress loop with a few action hooks and WooCommerce functions. Letā€™s dig in to how we can replicate this with our custom loop.

Getting Started

The first thing I did was make a Page Template. If you found this post then I assume you already know how to do that or you can use that link to figure it out. Next, Iā€™ll copy the entire loop from the WooCommerce Product Archive template. However, I need to make some adjustments because that loop relies on the WordPress main Post Type Archive query. That query wonā€™t be available on a Page (hence the need for a custom query/loop).

The Custom WooCommerce Product Loop

Iā€™ll be using wc_get_products() as recommended on the WooCommerce Wiki so I need to adjust my code because that function (and even the WC_Product_Query Class) doesnā€™t give me the methods weā€™re all used to when creating custom loops, namely have_posts(). Instead of relying on have_posts() and the_post(), Iā€™ll create a foreach loop. My projectā€™s main Shop Page makes use of the WooCommerce ordering dropdown and pagination, so Iā€™ll need to get some of the relevant variables to ensure those functions work here, and I also need to set some properties in the WooCommerce loop variable ($GLOBAL['woocommerce_loop']). Hereā€™s what I came up with:

<?php
if(!function_exists('wc_get_products')) {
return;
}
$paged = (get_query_var('paged')) ? absint(get_query_var('paged')) : 1;
$ordering = WC()->query->get_catalog_ordering_args();
$ordering['orderby'] = array_shift(explode(' ', $ordering['orderby']));
$ordering['orderby'] = stristr($ordering['orderby'], 'price') ? 'meta_value_num' : $ordering['orderby'];
$products_per_page = apply_filters('loop_shop_per_page', wc_get_default_products_per_row() * wc_get_default_product_rows_per_page());
$featured_products = wc_get_products(array(
'meta_key' => '_price',
'status' => 'publish',
'limit' => $products_per_page,
'page' => $paged,
'featured' => true,
'paginate' => true,
'return' => 'ids',
'orderby' => $ordering['orderby'],
'order' => $ordering['order'],
));
wc_set_loop_prop('current_page', $paged);
wc_set_loop_prop('is_paginated', wc_string_to_bool(true));
wc_set_loop_prop('page_template', get_page_template_slug());
wc_set_loop_prop('per_page', $products_per_page);
wc_set_loop_prop('total', $featured_products->total);
wc_set_loop_prop('total_pages', $featured_products->max_num_pages);
if($featured_products) {
do_action('woocommerce_before_shop_loop');
woocommerce_product_loop_start();
foreach($featured_products->products as $featured_product) {
$post_object = get_post($featured_product);
setup_postdata($GLOBALS['post'] =& $post_object);
wc_get_template_part('content', 'product');
}
wp_reset_postdata();
woocommerce_product_loop_end();
do_action('woocommerce_after_shop_loop');
} else {
do_action('woocommerce_no_products_found');
}
view raw woocommerce_loop-custom.php hosted with ā¤ by GitHub

Itā€™s actually fairly straightforward. First I get and set the variables for paging and order display in lines 7-11, then I get my Products, then I hack the WooCommerce loop variable with some parameters it needs in lines 25-30, then I finally loop through them using a foreach loop instead of the usual while loop because I donā€™t have the Loop methods to rely on as mentioned above. Lines 36-38 use the same form and function to temporarily set the global Post object as WooCommerce uses in its shortcodes, but hit the comments if thereā€™s a better way.

Conclusion

Creating a custom WooCommerce Product loop on a Page in WordPress is often mentioned in tutorials and almost always calls for using a new WP_Query() or get_posts(). Both of those methods are certainly viable, but ultimately they may not keep pace with WooCommerce updates and so the right way to create a custom product loop is to use wc_get_products() and a foreach loop or WC_Product_Query(). Itā€™s also possible through a few quick tricks to persuade WooCommerce into outputting its goodies like ordering dropdowns and pagination to save you some time and save your project from repetitive code. This method can be used just about anywhere in your templates and does a thorough job of outputting a WooCommerce Product loop that matches up with the default Product loop on your Shop and Product Category pages. Any changes youā€™ve made to the WooCommerce loopā€™s action hooks or filters will be output when using this snippet so you wonā€™t need to repeat yourself.

I hope this helps more WordPress and WooCommerce developers implement custom Product loops the right way. If you have questions or comments or noticed something I may have overlooked please leave a comment below!

Comments

  1. The global $product is not being set. Iā€™m running this code on my home page and it doesnā€™t output any products.

    Reply

  2. Hi Michael,
    Thanks for this tutorial, I just tested it with my woocommerce site (staging environment): made a copy of archive-product.php in my storefront child-theme template folder and added the code above. I want to filter the archive page based on a specific attribute ā€œwinkelā€, so I added this to the $featured_products variable:

    'tax_query' => array(
    array(
    'taxonomy' => 'pa_winkel',
    'field' => 'name',
    'terms' => array('De Hooiberg'),
    'operator' => 'IN',
    )
    ),

    I see this partially works: It still shows all categories with the number of products of the unfiltered loop. Below that it shows the 2 products that indeed have ā€œDe Hooibergā€ in the winkel-attribute. Iā€™d like to make this fully function on the product archive page. So that it only shows the categories which contain products with this attribute value. Is this possible too?

    Reply

  4. Hi Michael,
    Thank you very much for this tutorial. Iā€™ve been able to get this php code more or less working but with two caveatsā€¦
    1) the array result never shows all articles, must of the time just 10% of all articles concerned.
    2) a meta_query with an ACF-field is not taken into account:
    ā€˜meta_queryā€™ => array(
    ā€˜keyā€™ => ā€˜release_dateā€™,
    ā€˜valueā€™ => $today,
    ā€˜compareā€™ => ā€˜>ā€™,
    ),
    I do not understand why in both cases.
    Thanks in advance for having a look.

    Reply

    1. You can see the Woo wiki has some details on custom parameter support @ https://github.com/woocommerce/woocommerce/wiki/wc_get_products-and-WC_Product_Query#adding-custom-parameter-support. Not sure if that will get you where you want. If that doesnā€™t work then you may want to run a WP_Query() first to obtain a list of product IDs based on the meta_query and then use that list of IDs in your wc_get_products() call by putting it in the include parameter. It would be two queries which could be resource intensive, but it would get you there most likely.

      Reply

  5. all working fine however I get this error notice ā€œNotice: Only variables should be passed by reference in E:\Programs\XAMPP\htdocs\mttwood_www\wp-content\themes\mttwood\woocommerce\archive-product.php on line 23ā€

    the code on line 23 is ā€œ$ordering[ā€˜orderbyā€™] = array_shift(explode(ā€˜ ā€˜, $ordering[ā€˜orderbyā€™]));ā€

    Reply

  6. Hi, is there any way to make a sorting for Trending products ā€” products that are bestsellers for last 30 days? And woocommerce everyday checks for number of sales of all products and make a dynamic sorting among all shop products as Trending products?

    Reply

  7. Hi Michael.
    Thank You for great tutorial. Iā€™m using this method to build custom loops in my blocks, and it works great. But on my main shop page Iā€™m using ajax to load more products. Iā€™m using the WP_Query for this, but You are right ā€“ if there is a built in woocommerce method, we should use it. But how can I filter products bu price or by attributes? In WP_Query Iā€™m using the meta_query and tax_query parameters? Is there a way to set this with wc_set_loop_prop function? Thanks

    Reply

  8. The Custom WooCommerce Product Loop is great to display on a page BUT I want to add featured products in the woocommerce order email, how i will customize its html/css

    Reply

  10. My biggest beef with this neat tutorial and code snippet is the amount of queries youā€™re ultimately making. The wc_get_products() function calls a query but youā€™re only returning IDs. At that point you loop through the ID and thing ping the database each time for get_post() When instead you should be returning post objects or Products ( as WooCommerce will also load the associated post and cache it ).

    In any case, itā€™s neat and thank you for putting it together.

    Reply

    2. Hey Alex,

      sound very reasonable ā€“ how would the improved code look like? How did you tackle it in the end? I am eager to improve šŸ™‚

      Thanks & regards!

      Reply

  11. Hey,

    Iā€™ve been struggling adding meta query to WP site.

    Iā€™ve checked WP_Query, and the code works there, but as soon as I put this into WC_Product_Query, the meta_query doesnā€™t work anymore.


    $query_args = array(
    // 'page' => $custom_page,
    // 'limit' => $limit,
    'limit' => 50,
    'paginate' => true,
    'post_type' => 'product',
    // 'price' => 9.99,
    // 'orderby' => 'date',
    // 'order' => 'DESC',
    // 'orderby' => ['meta_value_num' => 'DESC', 'title' => 'ASC'],
    // 'orderby' => '_price',

            'meta_query' =&gt; array(
        'relation' =&gt; 'OR',
        array(
            'key'     =&gt; '_price',
            'value'   =&gt; array( 5, 10 ),
            'type'    =&gt; 'NUMERIC',
            'compare' =&gt; 'BETWEEN',
        ),       
    ),
    'tax_query' =&gt; array( 
        array(
            'taxonomy'      =&gt; 'pa_color',
            'field'         =&gt; 'slug',
            'terms'         =&gt; $custom_colors,//$custom_colors,
            'operator'      =&gt; $custom_operator
        ),
    ),
    'return'   =&gt; 'ids'
);

$query = new WC_Product_Query( $query_args );

    If this was wp_query, it would filter by price. I have no idea how to fix this. Searched the entire internet. WooCommmerce is up to date, but this just doesnā€™t work.

    Reply

  12. What if the page is for infinite scroll and not for pagination? Iā€™ll get duplicate products on the scroll.

    Reply

  13. how can we do this ā€œ$featured_products->max_num_pagesā€ when ā€œwc_get_productsā€ returns an array?

    Reply

  14. Iā€™m trying to get the ordering working with an AJAX call. According to the wiki/docs the orderby parameter does not accept the standard list of ā€œvaluesā€ like: ā€œmenu_orderā€. How do you get the native ordering to work?

    Reply

    1. Howdy! That would be in the theme customizer in Appearance -> Customize -> WooCommerce -> Product Catalog -> Products per row & Rows per page. Hope that helps!

      Reply

  17. Hi Michael,

    Thanks for writing such a detailed instruction. This has really helped me understand WooCommerce loops. Iā€™m new to this but Iā€™m fairly sure I get it all, but Iā€™m hoping you can help me with one thing.

    ā€œOut of the boxā€™ I just get a blank

    <

    ul>. When I var_dump the array I can see it is populated with the IDā€™s, which confused me, as I would have expected the rest of the code to work. I wondered if removing the -> product from the foreach loop might work, and voila, all of the ā€˜s were output.

    Iā€™m just wondering if that is an error above, or if you had another explanation as to why that might have made it work in my case? Not super important so no sweat, just thought it might help another user facing a similar situation, and Iā€™m interested as to whether this points to a different error in my case.

    Thanks!!!

    Reply

  18. This is exactly what I was after, but Iā€™m having an issue with the Pagination. Pagination is displayed and works as expected, until loading the new page, which returns a 404. Any ideas on how I can solve this?!

    Reply

  19. Great tutorial thanks. If I change the number of posts per page to 8, the count still says ā€œshowing all 10 productsā€ rather than showing ā€œshowing products 1-8 of 10ā€ ā€“ any idea how to fix this?

    Reply

    1. Hi Catherine, where are you changing the number of posts per page?

      Unless youā€™re changing the number of products per page in the WooCommerce loop using the variables in my code snippetā€”either by directly setting $products_per_page or by using the loop_shop_per_page somewhere else in your theme, then you might not be changing that setting even though you think you are.

      The correct place to set that number of products per page in the WooCommerce loop is in Appearance -> Customize -> WooCommerce -> Product Catalog -> Products per row & Rows per page.

      I hope that helps!

      Reply

  20. Hello and thank you for the post!
    The pagination while it is displayed, it doesnā€™t work.
    It redirects to page/2/, but it shows 404 error

    Reply

    1. Apologies for the late reply George. Please visit Settings -> Permalinks and click ā€œSaveā€ to flush your siteā€™s permalinks.

      Reply

  21. Hi Michael,
    really great tutorial thank you sho much to share it!

    Iā€™ve read the previous comments and I understand that youā€™re not able to debug any kind of WordPress page and If you have time to look at my code hereā€™s a Gist

    I do not understand why but my templates shows only three product instead of the 8 Iā€™ve limited the loop to. In the Gist Iā€™ve added the content-product.php custom template file where I add some action hook to inject some code but thatā€™s it for my concern about query customization.

    I think the problem relies on the setup_postdata() calls because if I vdump() (thanks to this plugin ) I can see that the actual WP_Post Object is created but somewhat the template file does not load it.

    How can I check the value of setup_postdata() in the template file?

    Reply

    1. Happy to solve my own problem. The issue where in the if $product->is_visible() was hiding some hidden product I have in my store.

      Once I added 'visibility' => 'catalog', in the wc_get_products() call Iā€™ve started to see my 8 visible products.

      Thank you again for this amazing article!

      Reply

      1. Thanks for your comments Andrea. Iā€™m sorry I didnā€™t reply until now but Iā€™m glad you figured it out!

        Reply

  22. Hi Want to create a Shortcode in WooCommerce which exclude featured products once shortcode exclude-featured=true/false. As well want to filter using the same shortcode in between publish date. If I added start-date=04/04/2019 end-date=05/04/2019 as a shortcode parameter then it will filter products in between these 2 dates.

    So please kindly guide me and provide me the solution of it,

    Thanks

    Reply

  23. wc_set_loop_prop('total', $featured_products->total); produces an error: Trying to get property 'total' of non-object

    Reply

    1. If you changed the name of the variable where you stored the results of wc_get_products() then youā€™ll need to change $featured_products on that line, too. It should be $your_variable_name->total.

      Reply

  24. Thanks for this. But for some reason original query mixed with the new one(Im changing a tempate for one specific category and custom loop shows all subcatgories first and then displays custom query results) Plus pagintaion doesnā€™t work on page one. But when i add ā€˜page/2/ā€™ to url ā€“ paginatin works.

    Reply

  27. Hey Michael, great post thanks! it came up top on the search results.

    I am using latest woocommerce and storefront. When I select the ā€˜sort by average ratingā€™ the code breaks, because what is returned is an array and not a string.

    print_r( $ordering ):
<em>Array ( [orderby] => Array ( [meta_value_num] => DESC [ID] => ASC ) [order] => ASC [meta_key] => _wc_average_rating )</em>

    Warning: explode() expects parameter 2 to be string, array given in /home/pall/public_html/wp-content/themes/storefront-child/template-custom.php on line 46

Warning: array_shift() expects parameter 1 to be array, null given in /home/pall/public_html/wp-content/themes/storefront-child/template-custom.php on line 46
    Reply

  28. Hey Michael,

    Unfortunately, your code snippet crashed when I ran it verbatim, but after looking into what I could do with WP_Product_Query (thanks for pointing me to that Wiki btw!), hereā€™s what I came up with:

    $args = array( 
    'status' => 'publish',
    'limit' => -1,
    'return' => 'ids',
); // Basically, get all product IDs.

$wc_query = new WC_Product_Query($args); // Run the $arg through WC_Product_Query (just like WP_Query)

$wc_products = $wc_query->get_products();

    Grab all the product data. If you print it out,
    youā€™ll see an ugly behemoth of protected data arrays.

    What to do about those?

    Use the get_data() method (courtesy of the WC_Data class) to grab whatever you need.

    Hereā€™s how:

    Since we already told the WooCommerce API that we
    just wanted product IDs in the first set of arguments that we
    passed to the WC_Product_Query object, now we can run those product
    IDs through the wc_get_product() function and call the get_data() method
    on the resulting $product_data variable like so:

    $product_data_array = array();

foreach ($wc_products as $product_id) {

  $product = wc_get_product($product_id);

  $product_data = $product->get_data(); // This will "unlock" the protected data arrays so you can grab the data you need.

  // Grab all the properties you want / need.

  $product_data_array[] = $product_data['id'];
  $product_data_array[] = $product_data['name'];
  $product_data_array[] = $product_data['price'];
  $product_data_array[] = $product_data['short_description'];
}

    Finally, just so you donā€™t have to stare at an ugly block of PHP-garbled text,
    print your freshly minted product data array between a set of pre tags to see your results. The end! =)

    echo '

';

print_r($product_data_array);

echo '

';

    Good luck everyone! =)

    Reply

  29. Thanks for this great content. But I do have one question about using AJAX with this method to handle my own custom page pagination and filters for the products. I would usually do something like creating a wp_query to get the post data store it in a variable then covert it into JSON and pass it to my AJAX function to output to the page. But how would I be able to pass all the product data to my ajax function using this method or would it be best to use wp_query in this situation? I can provide an example on how I would do this with wp_query if I wasnā€™t clear enough. Thanks

    Reply

    1. The function and class in the post are basically wrappers for get_posts() and WP_Query, so you should be able to use the Woo function/class just fine. Have you tried it? Specifically what ā€œproduct dataā€ do you think youā€™ll need that you canā€™t fetch with these Woo functions?

      Reply

  30. Thanks a lot for this post. Please help, how can I use this solution with orderby form on custom page(no category, taxonomy)?

    Reply

  31. Great article, very very helpful.
    However, Iā€™m trying to use this to only show products of certain categories. Would that be possible ? Do I have to change the $featured_products array to only call the category I need? Thanks for any help you might give me.

    Reply

    1. Hi Antonin, glad you found this helpful. For a category, you can omit the featured argument and instead use the category argument, which accepts an array of categories by slug. So something like category => array('category-slug-1', 'another-category-slug') should work.

      Reply

          1. Never came across the wiki before! Thanks for that!
            I wanted to ask another question, you might have a quick answer, if not no worries. But Iā€™ve been trying to add a dropdown filter menu for attributes to appear in the woocommerce_before_shop_loop ( so that it sits next to the catalog ordering dropdown).
            By creating a custom widget region and using the native product attribute filter widget I was able to get it to work. The issue is that the widget only works on the archive and shop page, and I want it to work on any page. Thereā€™s a link that I canā€™t seem to find.
            Tried looking for ressources on how to create a custom attri filter dropdown from scratch but no luck there either.
            Just wondering if you have a quick tip to give me.
            Again thanks so much for your time and your help.

            Reply

            1. Hi, I have the same problem. Did you find the solution how to show attributes filter on your custom page/custom product loop?

              Reply

  32. I hope you can help me. Iā€™m trying to get a shortcode to expand on the Shop page within the product short description text.

    The shortcode is added to the product short description text box. It expands as expected on the single product page and using the quick view but not on the Shop page.

    I think I need to edit the archive-product.php file in my child theme but Iā€™m not sure how/what to edit to get it to work.

    Any help would be greatly appreciated.

    Reply

  33. Hey Michael, excellent tutorial.

    Do you have any other article where explains how exactly does the WC loop works? Iā€™m having a trouble with that.

    Thanks in advance.

    Reply

    1. Hi Edinaldo, thank you for the kind words. The WC loop is just a basic WordPress loop which you can read more about here: https://codex.wordpress.org/The_Loop. WC adds a few action hooks and has some variables of its own that it uses to setup the loop, but apart from that itā€™s a standard WordPress loop. If you let me know what youā€™re stuck on I can try to shed some light where the Codex might be unclear.

      Reply

      1. Thanks for replying. Alright, iā€™ll try to be clear as possible.

        In my home page i need to display only the featured products on the top and, below this all the products are displayed with a excerpt of itā€™s description limited to 50 chars and the button to add to the cart. Then, in another page i need to create a filter for all products categories, displaying only the products that matches with the filter.

        Iā€™m using the Outlet child theme for Storefront.
        Thanks already

        Reply

        1. What have you tried so far and what issues are you having? If you link to a Gist of your template files and let me know specifically where youā€™re having difficulty then I can try to help more.

          Reply

  34. Hi, thank you for the tutorial, it was great, but I have a problem. I want to show products with custom fields ( like 5 of them ) in products archives or product category
    Is it possible?
    Like brand and color or everything important about my products
    Thank you for your time.

    Reply

    1. Thanks Dave. Not sure what you mean, but the function is actually wp_reset_postdata(), so make sure youā€™re calling it correctly. In order to troubleshoot more, Iā€™d need to see your code. Also, you can try commenting out any other custom functions in your functions.php that may be customizing/affecting your Page Template or the WooCommerce loop.

      Reply

  37. Very good read! Thank you. However when I use above code some pages contain 11 products, some 12 and some 13. How could I force the number to be 12 at all times?

    Reply

    1. Great tutorial. but as Robbert is saying, the first pages is showing 1 product less than the following pages. how can we solve this?

      Reply

      1. Dave, glad itā€™s helpful, but as Iā€™ve replied to everyone else who reported problems in the comments, Iā€™d need to see the entire template youā€™re using this code in to be able to pinpoint any possible issues. Even then, there may be hooks in use in your functions.php, plugins, or elsewhere that are affecting the loop. Your best bet is to post the complete template code in a Gist, or debug some of the loop variables youā€™re using, including running print_r() on the custom query variable itself to ensure itā€™s returning the correct number of posts.

        Reply

  38. Love the tutorial, really helped! I have a further query. I am using the above code in a site where I need to make a custom loop on several pages. So far I have this working thanks to your great tutorial. What I need to do now is filter one of them for products that are on sale. I was looking at another example of this that uses WP_Query and they use a meta query with an OR operator to test for sales price > 0 for both simple and variable products. Could you suggest how I would achieve this using the loop above?

    Reply

    1. Ryan, thanks for the kind words, Iā€™m glad this helped you. What you want to do should actually be quite easy. Fortunately, the function I alluded to in the introā€”wc_get_featured_product_ids()ā€”has a cousin called wc_get_product_ids_on_sale() (see here), so youā€™re in luck šŸ™‚ For future reference, thatā€™s a great file full of useful functions. So you can try something like this for your loop arguments:

        $sale_products           = wc_get_products(array(
    'meta_key'             => '_price',
    'status'               => 'publish',
    'limit'                => $products_per_page,
    'page'                 => $paged,
    'include'              => wc_get_product_ids_on_sale(),
    'paginate'             => true,
    'return'               => 'ids',
    'orderby'              => $ordering['orderby'],
    'order'                => $ordering['order'],
  ));

      Notice that all I did was remove the 'featured' => true and replaced it with 'include' => wc_get_product_ids_on_sale(). I hope that helps.

      Reply

  39. I tried to follow his steps, but it does not pass the condition if ( wc_get_loop_prop( 'total' ) ). Can you help?

    Reply

    1. Sure Lucas, can you please post your full template source code into a GitHub Gist or a StackExchange question? Iā€™ll be happy to take a look.

      Reply

  40. This is a great piece of code! I am having trouble with pagination though. I get a 404 error when moving past page 1.

    Any thoughts? Thanks!

    Reply

    1. Thanks John. You can try flushing your permalinks (just visiting Settings -> Permalinks in your admin will do that). If that doesnā€™t work, post your entire templateā€™s code here or in a Gist and Iā€™ll have a look.

      Reply

Leave a Reply to Dave

Click here to cancel reply.