Display produt per page in version 4.2

hi there
im using version 4.2
some of my categories have in exccess of 30 products and i would like all the products to be diaplyed on the one category page. currently products are displayed sometimes on 2 or 3 pages !

How do i select the category settings and change it to increase the amount of products displayed to customers?


Thanks!

You can specify page siges per category. Go to category edit page and set Page size or Page Size options (comma separated) (when Allow customers to select page size is checked).

hi there
Thanks for the reply.
the problem is i have thousands of categories ! is there a setting in admin that can change it enmasse?

Hi,
You can run this command in database directly:

update category set PageSize = 100,  PageSizeOptions = '100, 200, 300'

After successfully running this just go to nop admin panel and clear the cache it will update the page size overall.

Thank you that worked perfectly!