Impossible! Sort by SKU???

  • Resolved Big Frank

    (@big-frank)


    6 years, 6 months ago

    Hello,

    Thank you for this plugin. I see it is open source, thank you!

    I installed and activated the plugin and I can see it in my plugins list but I couldn’t find a Help File or Instructions Page anywhere which is why I have to ask here, I’m sorry if my question is stupid, I simply do not understand how this works.

    All I Want Is This: to go into my WordPress Woocommerce back end and to have my product list sorted by SKU instead of the default sort order. I don’t care about the store front, that’s OK, it’s the back end where I just want it sorted by SKU alphanumerically. But NOWHERE can I understand how you can do this!

    PLEASE HELP!

    Thank you ??

Viewing 5 replies - 1 through 5 (of 5 total)

  • Hello,

    You’re welcome ??

    You can do as following:

    1. Go to Plugin’s Settings on WooCommerce > Settings > More Sorting section
    2. Go to Plugin’s Custom Meta Sorting section
    3. Check Enable Section and enable Custom Meta Sorting #1
    4. Meta Key:_sku
    5. Parameter:_sku
    6. Order:Ascending
    7. Title:SKU

    Now you have to setup WooCommerce to display SKU as default sorting order:

    1. Go to Appearance > Customize > WooCommerce > Product Catalog
    2. On Default product sorting set SKU

    Tell me if it suits you ??

    Thread Starter Big Frank

    (@big-frank)

    Hello Pablo and thank you for the quick response.

    Your plugin and the method you illustrated works perfectly for setting the default sort order for the public-facing website. The problem is that inside the Woocommerce back-end, the product sorting default is still the product ID (1) and not the SKU (2):

    https://footcred.com/wp-content/uploads/2018/05/footcred.jpg

    I have searched everywhere for a solution to this without having to edit the code manually and I find it incredible that Woocommerce make it so difficult to sort your products. There is no doubt that it’s a great online shop solution, but this sorting business is something I find very badly thought out. If you manage your store based on SKU it is completely normal that you would want your back end products to be sorted by SKU by default when you click on “Products”.

    I will have to admit defeat, give up and live with this annoying limitation.

    This is of course not your fault nor your issue and I want to thank you for your help anyway and good luck with your plugins!

    • This reply was modified 6 years, 6 months ago by Big Frank.

    Hum, I got it now.

    I don’t know if you already know that but if you click on the arrow, inside SKU column, it will sort by SKU, like you want.

    But considering you want SKU sorting as default, it won’t suit you so well, because you will have to click on the arrow.

    After reading your case, I decided to create a little plugin to setup the default sorting on admin as SKU sorting. Here it is: https://ufile.io/j30xe

    Please give it a try and tell me if it suits you ??
    See you

    Thread Starter Big Frank

    (@big-frank)

    Hello Pablo
    That is EXACTLY what I wanted!!
    This makes all the difference when updating all products.
    I don’t understand that nobody asked this from WooCommerce before.
    Thank you SO much ??

    Any time!
    Glad to hear it! Take care ??

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Impossible! Sort by SKU???’ is closed to new replies.