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.

Answer 1

In the wp_usermeta table, there is a row per user that sets this limit for each post type.

You can find them all with a query like:

SELECT * FROM `wp_usermeta` where meta_key like '%per_page%';

Afterwards, you can set the appropriate meta_value to your desired number of results per page.

For example, to change the number of WooCommerce products loaded in wp-admin, you would look for the meta_key ='edit_product_per_page' and set the meta_value = 20 which is the default.