I need to edit the page size (as in, the number of products displayed on each page) for every category on our site, and I have a feeling this would be really easy with SQL, but I don't know what query I would type for that. I imagine it would be something like:

UPDATE ProductCategory
PageSize = 20

Or something along those lines, but I'm having trouble figuring out where I can find that information.

in MultiStore by (210 points)

1 Answer

0 votes
Best answer

PageSize is on the Category table, not ProductCategory.  You're looking for something like this:

UPDATE Category
SET PageSize = 20

Make sure you've got a backup of the DB first of course, just in case.

by (13.5k points)
selected by
This worked perfectly. Thank you!