72 Responses

  1. Anto
    Anto December 13, 2012 at 10:54 am Reply

    it’s possible to search by product tag? thank you !

  2. Jeff
    Jeff December 21, 2012 at 12:32 am Reply

    Hey thanks for the plugin.

    It seems to work well when the complete, correct sku is searched. But if searching for a partial sku, it only shows the first result that matches, instead of all products that have sku’s starting with the partial search. For example:

    Search for “PHA01″

    Results show: PHA012
    Results SHOULD show: PHA012, PHA015

    Is this possible? Thanks,


  3. Katharina
    Katharina December 23, 2012 at 8:03 pm Reply

    Hi, great plugin.
    Will this as well display the items in the catalogue sorted by SKU (which is something I’m trying to achieve)

    Thanks & best regards

  4. Freddy
    Freddy January 8, 2013 at 2:35 am Reply

    LOVE IT MATT !!!
    Simple, clean, & does exactly as it claims!

    Thank you so much for sharing the fruits of your labor!


    P.S.: Bookmarking your site and will definitely spread the word!

  5. Mike
    Mike February 12, 2013 at 5:57 pm Reply

    Hi Matt,
    Yur pluginis good but you don’t have need plugin.
    In the search bar admin product tipping SKU: +your sku.

    Recherche de “PHA01″

    Les résultats montrent: PHA012
    Les résultats doivent montrer: PHA012, PHA015

    Est-ce possible? Merci,


    Matthew Lawson
    Matthew Lawson 21 décembre 2012 à 11:48 | Lien permanent | Répondre

    Salut Jeff, heureux vous l’avez trouvé utile.

    Je vais jeter un oeil à ce que devrait être assez rapide pour le changer.


    Have you found for more result ?

  6. Terry
    Terry February 15, 2013 at 6:45 pm Reply

    Though I see you still intend to work on the ‘partial sku’ portion, just wanted to let you know when I used the plug-in and tried a ‘partial’ sku search I always received back php garbage on the screen. When I deactivated the plug-in, woocommerce went back to displaying the usual “No products found which match your selection” screen.

    I look forward to seeing this up on WordPress.org. I’ll definitely give it a positive vote with the partial sku search working. Thanks for your time coding this!

  7. Jen
    Jen March 11, 2013 at 9:49 am Reply

    Hi Matt – after I updated to WooCommerce 2+ this no longer works on front end. I keep getting a white screen when I search. Works in product admin end ok.

  8. Jen
    Jen March 11, 2013 at 10:33 am Reply

    RE: my last comment – it seems I was searching for out of stock skus (hidden from catalogue). works ok for in stock items.

  9. felix
    felix March 13, 2013 at 8:24 pm Reply

    where can i download the latest version? I have a sku maybe call SKU011 and SKU012, when i perform a search SKU01, which product will showed?

  10. Maxim
    Maxim March 29, 2013 at 12:18 pm Reply


    Thank you for the pluign but i have little problem.

    I have prodcut: name – “Laserhiiri – UNITY U-318″ sku “U-318″

    I have plugin on and try search – “U-318″ and i will get two result of the same product, because in name it the SKU name. I thinked how it can by fixed, but nothing goes to mean. Could you fix it?

    For thanks after i can give little gift for paypal :)

  11. Maxim
    Maxim March 29, 2013 at 12:22 pm Reply

    I cant change the skus names – i have update stock and price from suppliers

  12. aclase
    aclase March 31, 2013 at 9:02 pm Reply


    when i search sku, and if it contain in product name, i will get two search result. Howit can be fixed? Sku renameing is impossible..

    1. Joff
      Joff May 2, 2013 at 12:37 am Reply

      Hey Aclase,

      I had a product inventory (750+ lines) with SKU’s in the title, so also had duplicate results but I resolved it by stripping them out of the titles and used a filter on the WooCommerce product title to add the SKU back in dynamically.
      Now the store admin doesn’t need to worry about adding the SKU to the title manually and no more duplicate results (although Matthew’s fixed that now anyway).

      Let me know if this might be of interest to you too.

  13. Mimi
    Mimi May 3, 2013 at 11:50 pm Reply

    Thank you I been looking for a search plugin that will search for SKU, I gave up I actually placed the sku number on the title of the product, which I hated but it actually worked on the search.

    Thanks for doing this!!!!! Now I can remove the SKU from the title name :D

    1. Jeff
      Jeff August 31, 2013 at 10:15 pm Reply

      Mimi, have you considered the SEO impact of not having the SKU in the title? Just asking as I often start a Google search with a product #.

  14. Jonathan
    Jonathan May 31, 2013 at 3:07 am Reply

    Hi Matthew,
    First, thanks for the great plugin!
    I’ve encountered a weird behavior. On the orders page, when I search by sku it pulls up the right number of rows but they are blank. For example, I search for sku 00123 and the results shown are 1 empty row. There is only 1 order with this sku – so the number of rows is correct. However, is it possible to show these results?


  15. Rich Senior
    Rich Senior May 31, 2013 at 2:26 pm Reply

    Does exactly what it says on the tin! Nice one, Sir!

    Thanks very much for sharing this. I really don’t know why this functionality is not enabled by default in the Woocommerce product search. So thanks again for sharing your great plugin.

    Are you going to share this on WordPress.org?

  16. Dveloper
    Dveloper May 31, 2013 at 3:16 pm Reply

    Thank You very much. Nice Plugin

  17. How we built the Propex Leisure Accessories website

    [...] to be able to search for products by SKU. Which is sadly lacking in Woocommerce. So we installed Matthew Lawson’s excellent plugin, which does exactly what it says on the [...]

  18. Gonza
    Gonza June 7, 2013 at 3:44 pm Reply

    Thank you very much for the SKU search!! Works great!!

  19. Scott
    Scott June 18, 2013 at 5:08 pm Reply


    Thanks for the pluggin! I’m developing a Woo-com store and migrating our Drupal store over to WP.

    After the initial setup I’m seeing we have a lot of custom features not offered in WP. The main one being an admin option of sorting ONLY ordered products by SKU, this is to create lists of products to order from our various suppliers.

    My question is, is there already a way to do this? If not how do other stores process orders when they have multiple suppliers? And finally is there a way to modify your pluggin to sort only “ordered” products by SKU?


  20. Rachel
    Rachel June 23, 2013 at 2:46 pm Reply

    Hey Matthew! I am looking for a plugin that will show the SKU # on my sales log. Would this cover me?


  21. Grace
    Grace July 10, 2013 at 7:38 pm Reply

    This is a great plugin! Any plans to create one to search products by attributes?

  22. Michiyo
    Michiyo August 5, 2013 at 8:43 pm Reply

    Hi Matthew,

    Thank you for the plugin.
    It was working properly before, but I’m facing a problem.
    Each product has three variations based on sizes and has its own SKU. One product, for example, has three variations, and SKUs are CL 001, CL 002, and CL 003. When I searched by CL 003, it shows the product, but does not show the specific size.
    I’m using woo commerce version 2.0.13. I reinstalled your plugin.

    I need to provide a custom agent a searchable SKU number. When they enter a SKU number, they are expecting to see the particular product, size and price.

    I’m wondering I’m missing something.
    Thank you for your help.


  23. mark jones
    mark jones August 6, 2013 at 1:19 pm Reply

    Great job.

    I seem to be getting double results shown. as here


    I read above that this was fixed, Am I ding something wrong?

    Thanks again, extremely useful.


  24. mark jones
    mark jones August 6, 2013 at 5:29 pm Reply


    Yes 0.4

    Version 0.4 | By Matthew Lawson | Visit plugin site

    Tried with both WP search and Woo product




  25. Niels
    Niels August 12, 2013 at 5:29 pm Reply

    Hi Matthew,

    Thanks for the plugin, it works just fine. But when searching by SKU on a multilangual shop it displays all translated versions of the product and not the one of the current language

    I’ve already added the Relevanssi plugin to limit the search results on the current language but that doesn’t help either when only searching for the SKU.

    Is there a way to display only the results bases on the current language?


  26. MTRISS
    MTRISS September 24, 2013 at 12:02 pm Reply

    Thank you for the plugin.
    Works perfect (woocommerce 2.0.14, wordpress 3.6.1, Search by Sku Version 0.4 ).
    The only thing that could need to upgrade if possible is in cases of multilingual sites, using wpml, to return the results in the correct language.
    Using wpml you have double products with the same sku so it results in showing two products with the same sku but they are two products in two different languages. How can this be filtered somehow?

    Thank you again!

  27. Luke
    Luke October 8, 2013 at 3:25 am Reply

    Thank you for this plugin!!! Really like the fact that the user does not have to know the exact SKU.

    The search result page after activating plugin does not appear to activate or integrate with the WooCommerce Layered Nav widget (filtering / narrowing results). After digging into the widget code and your code I think I know why. You use the global variable $posts. WooCommerce Layered Nav widget uses the variable $woocommerce->query to check if the resulting products has any of the terms in the selected attribute of the widget. If the resulting products do not have any of the terms, it does not show the widget. So, for debugging purposes, I manipulated $woocommerce->query at the beginning of their loop like so:
    foreach ($posts as $post)
    if ($post->post_type == ‘product’)
    $woocommerce->query->unfiltered_product_ids[] = $post->ID;
    Basically adding the product ids in your $posts into their $woocommerce->query. Now the widget appears.

    Not sure what is the right way to enhance your plugin so that it can be use in conjunction or integrated with WooCommerce Layered Nav widget. Could you recommend how to fix this?



  28. Giovanni
    Giovanni October 8, 2013 at 4:21 am Reply

    Hi Matthew
    Congratulations for this plugin, it works well.
    there is a way to search by category products?

    i tried searc_everything plugin
    but there is a problem…
    the shopbar sidebar doesnt appears…
    if i write in the search box a name of a category, the producs on this category appears correctly but the shop side bare on the left side no…
    maybe you know a little “trick” to fix this problem?

  29. Olly
    Olly October 10, 2013 at 1:19 pm Reply

    I had the same issue regarding wpml, so I threw together a very crude hack.
    It’s not that elegant, but seems to work in my scenario. Maybe it helps someone


    function get_parent_post_by_sku($sku, $ignoreIds) {

    right after

    global $wpdb, $wp_query;

    i added

    /**create additional wpml query if it’s defined**/
    $wpmlQuery=” join “.$wpdb->prefix.”icl_translations wpml on p.ID = wpml.element_id and wpml.language_code=’”.ICL_LANGUAGE_CODE.”‘ “;

    then , after both
    visibility.meta_value ‘hidden’

    i just added


    so it reads

    and visibility.meta_value ‘hidden’
    where 1

    No guarantees, but maybe it works for someone

  30. Olly
    Olly October 10, 2013 at 3:11 pm Reply

    actually, it appears to be something along these lines

    /**create additional wmpl query if defined**/
    $wpmlQueryVariations=” join “.$wpdb->prefix.”icl_translations wpml on p.post_parent = wpml.element_id and wpml.language_code=’”.ICL_LANGUAGE_CODE.”‘ “;
    $wpmlQuery=” join “.$wpdb->prefix.”icl_translations wpml on p.ID = wpml.element_id and wpml.language_code=’”.ICL_LANGUAGE_CODE.”‘ “;

    and then use the relevant var in the relevant query

  31. mark
    mark October 25, 2013 at 4:58 pm Reply


    Been using this for a while with great success, how does it play with the latest WP update 3.7, as i understand that the search fuctions in wordpress have had a big overhaul.


  32. Shaina
    Shaina December 2, 2013 at 1:11 am Reply

    Hi there,
    Your plugin has been a lifesaver! Unfortunately I’m having a little trouble with duplicate results. I’m using WooCommerce in two separate instances for the same website (on separate WP installations). The two instances are configured almost identically, except one is a members-only exclusive area for placing orders and one is a catalogue where anyone can see (but not buy) our products.

    The search works perfectly in the catalogue, but I get duplicate results in the ordering part of the website. I see products A, B, C and D once, then again in the same order: A, B, C, D. I’m using both Search by SKU and Search by Tag. When I deactivate both at the same time, the problem is fixed, but when I have either of them individually or both of them simultaneously active, I get duplicates.

    Any idea what is going on?

  33. Panos
    Panos December 4, 2013 at 12:10 am Reply

    Thank you for this excellent plugin. How can I show pending review and draft product to search result?
    Thank you

  34. Miguel Ángel
    Miguel Ángel April 1, 2014 at 5:24 pm Reply


    Really nice and usefull plugin.

    I have an issue with it. When I make a search the Items with the SKU are added to t2he main menu of the site as part of the menu. For example: If I search “AAA-BB and I have this two items AAA-BB and AAA-BBC the search result page shows both results and both are included on the main menu this way –> HOME ABOUT US CONTACT AAA-BB AAA-BBC breaking the layout of the header.

    I hope you know what I mean.

    How can I fix it?

    Thank you

  35. Celso Bessa
    Celso Bessa April 8, 2014 at 2:21 pm Reply

    It just worked out of box to me. Already gave a 5 stars on WP repository.


  36. Celso Bessa
    Celso Bessa April 8, 2014 at 2:24 pm Reply

    If, by any chance, you are curious to see it in action, i am using in both http://www.fotografiasaereas.com.br and will be using on http://www.fotospot.com.br as well.


Leave a Reply