Looking for old forum posts and information? View the old forum archive here ยป
Welcome to Vortx Community Forum, where you can ask questions and receive answers from the staff at Vortx and other members of the community.

If you had a user account on our previous forums website, you will need to register a new account here.

A static copy of our previous forums website is available online for reference. Click here to access the forum archive.

Learn more about...


SQL query to update page size on all categories

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.

asked Sep 6, 2017 in MultiStore by gesturepoke (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.

answered Sep 6, 2017 by Vortx ScottS (13,500 points)
selected Sep 6, 2017 by gesturepoke
This worked perfectly. Thank you!