Product sorting issue in WP Admin

Hello John-Pierre Cornelissen,

Thank you for contacting Woo support.

To make sure I fully understand your issue let me rephrase the problem.

You initially sorted your products in a specific order, and after adding a new product, that item appeared at the top of the product list in both the WP Admin and on the front end. When you attempted to adjust the order by clicking the “Sorting” option in WP Admin, the list was unexpectedly reordered alphabetically, causing the custom order you set earlier to be lost.

A couple of clarifying questions to help pinpoint the issue:
– Before adding the new products, how did you initially sort your products?
– After adding a new product, have you tried reordering just a few items manually? Does that order persist, or does it reset again when you attempt to adjust it?

Let me know so I can assist you better!

Best regards.

• This reply was modified 2 months ago by Zubair Zahid (woo-hc). Reason: typo

Thanks @doublezed2,

You initially sorted your products in a specific order, and after adding a new product, that item appeared at the top of the product list in both the WP Admin and on the front end. When you attempted to adjust the order by clicking the “Sorting” option in WP Admin, the list was unexpectedly reordered alphabetically, causing the custom order you set earlier to be lost.

Yes, that is correct

Before adding the new products, how did you initially sort your products?

The original product list was created. Then the customer wanted to show a few products at the top of the list, so I clicked the ‘sorting’ option in the backend and dragged the products in the order the customer had requested.

After adding a new product, have you tried reordering just a few items manually? Does that order persist, or does it reset again when you attempt to adjust it?

No not yet. These the customer wants to have these two new product at the bottom of the list. If I now click ‘sorting’, it shows everything alphabetically, and I am afraid that if I move these two new product to the bottom, the entire list will be saved in alphabetical order. If that happens, I will have to reorder the entire list all over again.

Hi @jpnl

I have an issue with product sorting in WP Admin. In the past, I have sorted the products in a specific order.

In WooCommerce, the newest product typically shows at the top in the backend by default. Could you tell me how you’ve managed to arrange this so that the oldest product appears on top instead? Using the “Sortng” option or custom code?

I am afraid that if I move these two new product to the bottom, the entire list will be saved in alphabetical order.

Yes, it is possible since you are using “Default Sorting.” I suggest trying it on the staging site. Or you can try using a custom code snippet like these:

• https://stackoverflow.com/questions/55011566/change-default-sorting-order-for-specific-woocommerce-category-archive
• https://stackoverflow.com/questions/49884114/change-default-sorting-for-specific-woocommerce-product-category-archive-pages
• https://stackoverflow.com/questions/55681423/how-do-i-manually-set-woocommerce-product-sorting-to-popularity

Let us know how that goes. Looking forward to helping you.

It’s fixed. I don’t know what it was, but I had to re-order everything all over again and now it’s back on how it should.

Hello @jpnl,

Glad to know that the issue has been resolved and thank you for letting us know the outcome.

Should you have further inquiries, kindly?create a new topic here.

Meanwhile, if it isn’t too much to ask for – would you mind leaving us a review here? It only takes a couple of minutes but helps us tremendously. It would mean so much to us and would go a long way.

Thanks!