scott_see on "[Plugin: WooCommerce] Set "Number of items per page" in Screen Options too high, crashing server."

I needed to do a bulk edit, so I bumped up the "Number of items per page" for Products in Screen Options so I could show my whole list of products. I set the number too high, and now I can't open the Products page. Does anyone know what table this value is stored in so I can change it back to 20? I've searched for the number in phpMyAdmin, but I can't find it.

Thanks,

Scott

https://wordpress.org/plugins/woocommerce/

WordPress Dashboard --> Settings --> Reading --> Blog pages show at most --> [ 20 ]

Oddly enough this is what changes the amount of products viewable per page. I tried it out on mine just to be sure.

I've got Settings > Reading > Blog pages show at most > 10

Unfortunately, when you're at Products (woocommerce) and change the number of items per page in Screen Options, that overrides the 10. So I'm seriously still stuck. : (

The value is stored in the usermeta table under the edit_product_per_page meta key: http://cld.wthms.co/M18n/2pbpri4a

Excellent, thanks! I got it fixed, with a little help from phpMyAdmin