Catalog root node limit of 1000?

Questions around the TYPO3 integration and plugins
Forum rules
Always add your TYPO3, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
boettner
Advanced
Posts: 136
Joined: 09 Feb 2015, 17:49

Catalog root node limit of 1000?

Post by boettner » 29 Jan 2020, 15:38

Hi,

our root catalog node displays all available products. I saw there is a slice limit of 1000 in the DB request. Is there a possibility to expand that limit so that all available products could be browsed by pagination only if one wishes to do so?

Best
Robert.

User avatar
aimeos
Administrator
Posts: 7836
Joined: 01 Jan 1970, 00:00

Re: Catalog root node limit of 1000?

Post by aimeos » 29 Jan 2020, 17:42

You can use these two configuration options to tweak the number of pages and the number of products per page:
- https://aimeos.org/docs/Configuration/C ... ists/pages
- https://aimeos.org/docs/Configuration/C ... lists/size
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

boettner
Advanced
Posts: 136
Joined: 09 Feb 2015, 17:49

Re: Catalog root node limit of 1000?

Post by boettner » 30 Jan 2020, 07:05

We are still using the defaults which would mean a maximum of 4800 products. Why do we get 1000 for listProductTotal in client/html/templates/catalog/lists/body-standard.php?

Maybe because we are on 18.10 and client/html/catalog/lists/pages is available as of 19.04 only?

User avatar
aimeos
Administrator
Posts: 7836
Joined: 01 Jan 1970, 00:00

Re: Catalog root node limit of 1000?

Post by aimeos » 30 Jan 2020, 09:40

The count SQL statements limits to 1000 rows:
https://github.com/aimeos/aimeos-core/b ... #L369-L380

Maybe we should increase it to 10000. Can you make a pull request?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Post Reply