[resolved] How to Change Admin Product Page Screen Options from Code (products page blank) (9 posts)

  1. jameswwolf
    Posted 2 years ago #

    I changed the screen options (at top of page) for the admin side woocommerce products page... I was trying to 'view all products' rather than pagination. So I changed the number in screen options to 500. Now the products page (back-end admin side) is blank and I cannot edit products.

    From what file in woocommerce plugin can I modify this screen option setting to fix my products page?

    Thanks for an awesome plugin!!


  2. jameswwolf
    Posted 2 years ago #


    I cannot figure out how to modify 'screen options' on woocommerce edit products page, from the code..

    I am certain that changing the screen options is what has broken my 'edit products' page...

    Please help!
    Thanks, James

  3. jameswwolf
    Posted 2 years ago #

    SOLVED. The solution was quite easy... all screen options are saved under the user's meta options. So I simply created a new user as administrator, then deleted the old administrator. Now the default screen options are back!!


  4. aliput
    Posted 2 years ago #

    Thank James!!!!!!

    You saved my sorry bacon. Glad you're resourceful as NO-ONE came to help out - I did exactly the same as you :) 500 products and now met with a blank screen.
    I shall do as you say immediately…

  5. aliput
    Posted 2 years ago #

    Well done that man!

    Thanks James :D

  6. aliput
    Posted 2 years ago #

    Are the user's meta options editable in the code somewhere James do you know?

  7. jameswwolf
    Posted 2 years ago #

    Hi there aliput!! Hope all is well and that this solution has worked for you.

    I'm not sure where the user options are editable in the code... I just simply created a new user as admin and then deleted the old admin.

    Because the products page was the only page which broke, I was still able to access the USERS page from the back-end of wordpress.

  8. StavrosKen
    Posted 1 year ago #

    No need to create new user. You can still change the value from DB without switching users. The value is stored in wp_usermeta table.

    So find the entry in the database
    SELECT * FROM wp_usermeta WHERE meta_value="500"
    and change it.

  9. lawrencepclo
    Posted 1 year ago #

    Good stuff

    saved my life

    Thanks all

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • WooCommerce
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic