any way to set screen options wordpress via the database?

Question

My products woocommerce page will not load because it is set to show 100 products at the time. (server 503 error because of server overload). Is there any way to set this value of 100 back to a lower number via the mysql database of wordpress directly? Thanks for any help.

Are you referring to the admin product dashboard page? – Andrew Schultz Nov 12 '17 at 11:20 — Andrew Schultz, Nov 12 '17 at 11:20

Andrew Schultz · Accepted Answer · 2022-02-06T07:43:45.917

11

In the wp_usermeta table there is a row per user that sets this limit. Look for the meta_key ='edit_product_per_page' and set the meta_value = 20 which is the default. You can update it using phpMyAdmin and manually edit the row.

edited Feb 06 '22 at 07:43

answered Nov 12 '17 at 11:24

Andrew Schultz

4,092
2
21
44

Fantastic. That did the trick. Thank you! Marked as accepted answer. – Friso NL Nov 13 '17 at 08:39
2

Perfect! This solution is still working in the year 2021. Thank you! It helped me a lot and took away a lot of problems .... – Paulo Boaventura Feb 07 '21 at 11:13
1

Still works in 2022. The table name is 'wp_usermeta' though. – Ifti Mahmud Feb 04 '22 at 18:27

any way to set screen options wordpress via the database?

1 Answers1