How to Change Admin Product Page Screen Options from Code (products page blank)

  • Resolved jameswwolf

    (@jameswwolf)


    11 years, 3 months 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!!
    James

    https://www.ads-software.com/plugins/woocommerce/

Viewing 8 replies - 1 through 8 (of 8 total)
  • Thread Starter jameswwolf

    (@jameswwolf)

    Anyone?

    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

    Thread Starter jameswwolf

    (@jameswwolf)

    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!!

    Phew..

    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…

    Well done that man!

    Thanks James ??

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

    Thread Starter jameswwolf

    (@jameswwolf)

    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.

    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.

    Good stuff

    saved my life

    Thanks all

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘How to Change Admin Product Page Screen Options from Code (products page blank)’ is closed to new replies.