Error Message: results returned exceed the paging limit, refine the search expression to limit search result
If you have more than 5000 items (SKU) under a particular product and when you try to retrieve this huge amount of data which is greater than the paging limit of WebSphere Commerce Management Center, then system throws an error.
You will notice the following error message in WebSphere Commerce Management Center user interface when you try to view that particular product under catalog tool, "The number of results returned from the search exceeded the paging limit of 5000. Refined the search expression to limit the search result".
This is caused by the maximum paging limit (5000) set in Out of the box WebSphere Commerce System.
Resolving the problem
Problem can be resolved by increasing the paging limit. To increase this paging limit (maximumPageSize), Update the wc-component.xml file under the com.ibm.commerce.catalog-ext component directory. If the wc-component.xml configuration file does not exist then you will need create one. For example,
<?xml version="1.0" encoding="UTF-8"?>
xsi:schemaLocation="http://www.ibm.com/xmlns/prod/commerce/foundation/config ../xsd/wc-component.xsd "
Note: When you try to increase this paging limit, you also need consider the WebSphere Commerce Management Center performance as well.