How to get total products for pagination

[kdim95]

Laravel framework version: 9.52.4
Aimeos Laravel version: ~2022.10
PHP Version: 8.2.4
Environment: Linux

Hello,

What is the proper way to get the total count of products for the catalog listing?

I need the total product count for pagination.

$cntl->search( $total ) inside Aimeos\Client\Html\Catalog\Lists sets the $total to a maximum of 10,000.

[aimeos]

This is done for good reasons because counting records in a database is an expensive task if they exceed 10k rows. Therefore, Aimeos (and e.g. ElasticSearch too) limits the maximum number of counted records to 10k. That's no problem because no user will usually visit more than the first 3-10 pages and use the filter instead to limit the products to the ones he is looking for.

[kdim95]

For the ElasticSearch index, does this code get the total number of products in every category?

$aggregate = $cntl->aggregate('index.catalog.id');

inside Aimeos\Client\Html\Catalog\Lists::data()

[aimeos]

Yes, that should be the case, up to 10k documents. If you have more, the numbers for some categories will be less than the real number or even zero.