Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Revise menu_order system #5468

Closed
bekarice opened this issue May 12, 2014 · 6 comments
Closed

Revise menu_order system #5468

bekarice opened this issue May 12, 2014 · 6 comments

Comments

@bekarice
Copy link
Contributor

@bekarice bekarice commented May 12, 2014

When using the Default sorting (custom + name) for shop display, you can drag and drop to change menu order for products rather than using the alphabetical display. However, once this is used, there's no easy way to change the menu_order values for products. Maybe creating a tool under System Status to reset product menu_order would be appropriate for users that want to revert to alphabetical displays would be helpful.

@mikejolley
Copy link
Member

@mikejolley mikejolley commented May 13, 2014

I think options like this would be useful on the actual sort screen, when sorting is enabled. I'll move to this to future for review after 2.2

@mikejolley mikejolley added this to the Future Releases milestone May 13, 2014
@robcain
Copy link

@robcain robcain commented Jul 10, 2014

i would like to second this request please.

i recently 'tried out the 'sort products link' on product listing whilst viewing only a single category - i thought it would restrict ordering to there alone - nope! - it reordered the complete catalogue & set it in stone!

i spent hours trawling the web for a solution (to reset it at the very least), but found none.

the only way to revert being to go through each product one by one/else drag & drop ALL products again into required order! (even then of course it does not save order per category and 1 cat order can end up overriding another.

ultimately, i had to go into phpmyadmin and run:

[code]
update wp_posts set menu_order=0 where post_type='product'
[/code]

which reset them all ok.

two really easy solutions i can think of:

either

a) add a button to do precisely the above from the woocommerce settings menu

or, better:

b) enable the product menu_order field within the standard bulk_action, edit feature within admin list products - it's the only field that's missing from there, and precisely the one that's needed!

also:

if a single click on an admin link is likely to irrevocably change shit - please, oh please in the name of basic usability add a 'confirm action' alert to it!

thanks.

@bekarice
Copy link
Contributor Author

@bekarice bekarice commented Jul 29, 2014

@robcain thanks for the solution. If you or anyone else runs into this in the meantime, I wrote a small plugin that can add a separate alphabetical sorting option in case custom sorting is used rather than resetting the menu_order: http://wordpress.org/plugins/woocommerce-extra-product-sorting-options/

@mikejolley mikejolley closed this Nov 13, 2014
@mikejolley mikejolley reopened this Dec 5, 2016
@mikejolley mikejolley changed the title Add product menu_order reset Revise menu_order system Dec 5, 2016
@mikejolley
Copy link
Member

@mikejolley mikejolley commented Dec 5, 2016

Sorting is clunky. Let's look at ways to revise how this works, or replace it with something more automatic (a better default) and move this out of core. Sorting thousands of products via drag and drop is silly.

@mikejolley
Copy link
Member

@mikejolley mikejolley commented Feb 6, 2017

Closed in favour of #13072

@mikejolley mikejolley closed this Feb 6, 2017
@kaldari
Copy link

@kaldari kaldari commented Jun 13, 2019

Closed in favour of #13072

@mikejolley - Since #13072 has been closed as well, can we reopen this bug? It would be really, really handy if there were a way to reset all the product menu order values to 0. Currently the only way to do this is in the MySQL itself (https://geofffranklin.com/reset-menu_order-woocommerce-products-phpmyadmin), which is inaccessible to most admins (and rather dangerous). This should be a very simple feature to add (until the full UI redesign happens). For people with hundreds of products, it's a nightmare to have to reset them all manually.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
4 participants