ACSD-55100: GraphQL does not return products beyond 10k in the search results
GraphQL does not return products beyond 10k in the search results. Quality patch ACSD-55100 for magento/module-catalog-graph-ql applies to Magento Open Source and Adobe Commerce 2.4.6 to 2.4.7-p10.
- Categories
- GraphQL, Catalog Search, Catalog/Product
- Components
- magento/module-catalog-graph-ql, magento/module-catalog-search, magento/module-elasticsearch, magento/module-elasticsearch-7, magento/module-open-search, magento/module-elasticsearch-catalog-permissions
- Origin
- adobe-commerce-support
- Since QPT
- 1.1.46
Issue
GraphQL does not return products beyond 10k in the search results.
Steps to reproduce
1. Generate the catalog with 15k products. 1. Send the GraphQL: query { products( filter: { # category_id:{eq:""} } , pageSize: 5, currentPage: 1 ) { total_count page_info { current_page page_size total_pages } aggregations { attribute_code count label options { label value } } items { uid sku is_for_clearance categories { name breadcrumbs { category_name category_uid } display_mode description } } } }
Adobe's page lists 2.4.6 - 2.4.6-p3 as compatible; the versions below are resolved from the current QPT constraints and are the ones the tool will offer.
Adobe scheduled the permanent fix for 2.4.8.
Additional steps
Requires 2.2.0 version of opensearch-project/opensearch-php.
Install
Install the Quality Patches Tool with composer require magento/quality-patches, apply the prerequisites listed for all files applicable to your distribution and version first, then run vendor/bin/magento-patches apply ACSD-55100. On Cloud, add ACSD-55100 under stage.build.QUALITY_PATCHES in .magento.env.yaml.
For cweagans/composer-patches, choose a compatible version below and download the bundle. Copy its ACSD-55100/ folder into patches/composer/, merge composer.patches.json into composer.json, then run composer install. Bundle prerequisites the same way and list them first. Paths are relative to each package root, using the default -p1 level. Prefer local files when configuring composer-patches; a remote URL can change.
Patch files and compatible versions
magento/magento2-base >=2.4.6 <2.4.7
- Magento Open Source
- 2.4.6-p15, 2.4.6-p14, 2.4.6-p13, 2.4.6-p12, 2.4.6-p11, 2.4.6-p10, 2.4.6-p9, 2.4.6-p8, 2.4.6-p7, 2.4.6-p6, 2.4.6-p5, 2.4.6-p4, 2.4.6-p3, 2.4.6-p2, 2.4.6-p1, 2.4.6
- Adobe Commerce
- 2.4.6-p15, 2.4.6-p14, 2.4.6-p13, 2.4.6-p12, 2.4.6-p11, 2.4.6-p10, 2.4.6-p9, 2.4.6-p8, 2.4.6-p7, 2.4.6-p6, 2.4.6-p5, 2.4.6-p4, 2.4.6-p3, 2.4.6-p2, 2.4.6-p1, 2.4.6
- Replaced with
- ACSD-62332
- Patch file
- patches/os/ACSD-55100_2.4.6.patch
- vendor/magento/module-catalog-graph-ql/DataProvider/Product/SearchCriteriaBuilder.php
- vendor/magento/module-catalog-graph-ql/Model/Resolver/Products/DataProvider/ProductSearch.php
- vendor/magento/module-catalog-graph-ql/Model/Resolver/Products/DataProvider/ProductSearch/ProductCollectionSearchCriteriaBuilder.php
- vendor/magento/module-catalog-graph-ql/Model/Resolver/Products/Query/Search.php
- vendor/magento/module-catalog-graph-ql/Model/Resolver/Products/SearchCriteria/CollectionProcessor/FilterProcessor/CategoryFilter.php
- vendor/magento/module-catalog-search/Model/ResourceModel/Fulltext/Collection.php
- vendor/magento/module-catalog-search/Model/ResourceModel/Fulltext/Collection/SearchResultApplier.php
- vendor/magento/module-elasticsearch/Model/Adapter/BatchDataMapper/ProductDataMapper.php
- vendor/magento/module-elasticsearch/SearchAdapter/Query/Builder/Sort.php
- vendor/magento/module-elasticsearch/SearchAdapter/Query/Builder/Sort/DefaultExpression.php (added)
- vendor/magento/module-elasticsearch/SearchAdapter/Query/Builder/Sort/EntityId.php (added)
- vendor/magento/module-elasticsearch/SearchAdapter/Query/Builder/Sort/ExpressionBuilder.php (added)
- vendor/magento/module-elasticsearch/SearchAdapter/Query/Builder/Sort/ExpressionBuilderInterface.php (added)
- vendor/magento/module-elasticsearch/SearchAdapter/Query/Builder/Sort/Position.php (added)
- vendor/magento/module-elasticsearch/SearchAdapter/Query/Builder/Sort/Relevance.php (added)
- vendor/magento/module-elasticsearch/etc/di.xml
- vendor/magento/module-elasticsearch-7/Model/Client/Elasticsearch.php
- vendor/magento/module-elasticsearch-7/SearchAdapter/Adapter.php
- vendor/magento/module-open-search/Model/SearchClient.php
- vendor/magento/module-open-search/SearchAdapter/Adapter.php
magento/magento2-base >=2.4.7 <2.4.8
- Magento Open Source
- 2.4.7-p10, 2.4.7-p9, 2.4.7-p8, 2.4.7-p7, 2.4.7-p6, 2.4.7-p5, 2.4.7-p4, 2.4.7-p3, 2.4.7-p2, 2.4.7-p1, 2.4.7
- Adobe Commerce
- 2.4.7-p10, 2.4.7-p9, 2.4.7-p8, 2.4.7-p7, 2.4.7-p6, 2.4.7-p5, 2.4.7-p4, 2.4.7-p3, 2.4.7-p2, 2.4.7-p1, 2.4.7
- Patch file
- patches/os/ACSD-62272_2.4.7_v2.patch
- vendor/magento/module-catalog-graph-ql/DataProvider/Product/SearchCriteriaBuilder.php
- vendor/magento/module-catalog-graph-ql/Model/Resolver/Products/DataProvider/ProductSearch.php
- vendor/magento/module-catalog-graph-ql/Model/Resolver/Products/DataProvider/ProductSearch/ProductCollectionSearchCriteriaBuilder.php
- vendor/magento/module-catalog-graph-ql/Model/Resolver/Products/Query/Search.php
- vendor/magento/module-catalog-graph-ql/Model/Resolver/Products/SearchCriteria/CollectionProcessor/FilterProcessor/CategoryFilter.php
- vendor/magento/module-catalog-search/Model/ResourceModel/Fulltext/Collection.php
- vendor/magento/module-catalog-search/Model/ResourceModel/Fulltext/Collection/SearchResultApplier.php
- vendor/magento/module-elasticsearch/Model/Adapter/BatchDataMapper/ProductDataMapper.php
- vendor/magento/module-elasticsearch/SearchAdapter/Query/Builder/Sort.php
- vendor/magento/module-elasticsearch/etc/di.xml
- vendor/magento/module-elasticsearch-7/Model/Client/Elasticsearch.php
- vendor/magento/module-elasticsearch-7/SearchAdapter/Adapter.php
- vendor/magento/module-open-search/Model/SearchClient.php
- vendor/magento/module-open-search/SearchAdapter/Adapter.php
- vendor/magento/module-elasticsearch/SearchAdapter/Query/Builder/Sort/DefaultExpression.php (added)
- vendor/magento/module-elasticsearch/SearchAdapter/Query/Builder/Sort/EntityId.php (added)
- vendor/magento/module-elasticsearch/SearchAdapter/Query/Builder/Sort/ExpressionBuilder.php (added)
- vendor/magento/module-elasticsearch/SearchAdapter/Query/Builder/Sort/ExpressionBuilderInterface.php (added)
- vendor/magento/module-elasticsearch/SearchAdapter/Query/Builder/Sort/Position.php (added)
- vendor/magento/module-elasticsearch/SearchAdapter/Query/Builder/Sort/Relevance.php (added)
- vendor/magento/module-elasticsearch/Model/ResourceModel/Fulltext/Collection/SearchCriteriaResolver.php
magento/magento2-ee-base >=2.4.6 <2.4.7
- Magento Open Source
- —
- Adobe Commerce
- 2.4.6-p15, 2.4.6-p14, 2.4.6-p13, 2.4.6-p12, 2.4.6-p11, 2.4.6-p10, 2.4.6-p9, 2.4.6-p8, 2.4.6-p7, 2.4.6-p6, 2.4.6-p5, 2.4.6-p4, 2.4.6-p3, 2.4.6-p2, 2.4.6-p1, 2.4.6
- Replaced with
- ACSD-62332
- Patch file
- patches/commerce/ACSD-55100_2.4.6.patch
- vendor/magento/module-elasticsearch-catalog-permissions/Model/ResourceModel/Index.php
- vendor/magento/module-elasticsearch-catalog-permissions/etc/di.xml
magento/magento2-ee-base >=2.4.7 <2.4.8
- Magento Open Source
- —
- vendor/magento/module-elasticsearch-catalog-permissions/Model/ResourceModel/Index.php
- vendor/magento/module-elasticsearch-catalog-permissions/etc/di.xml
