ACSD-65750: GraphQL “route” query returns products out of order in Page Builder Products content type
The ACSD-65750 patch fixes the issue where the GraphQL “route” query returns products out of order in Page Builder Products content type. This patch is available when the Quality Patches Tool (QPT) 1.1.66 is installed. The patch ID is ACSD-65750. Please note that this issue is scheduled to be fixed in Adobe Commerce 2.4.9.
Affected products and versions
The patch is created for Adobe Commerce version:
- Adobe Commerce (all deployment methods) 2.4.7-p4
Compatible with Adobe Commerce versions:
- Adobe Commerce (all deployment methods) 2.4.7-p1 - 2.4.8
magento/quality-patches package to the latest version and check the compatibility on the Quality Patches Tool: Search for patches page. Use the patch ID as a search keyword to locate the patch.Issue
The GraphQL “route” query doesn’t return products in the correct sort order when using the Page Builder Products content type.
Steps to reproduce:
-
Create a new category and some products in Catalog, and link the products to this category.
-
Navigate to Catalog > Categories, edit the created category, and open the Products in Category tab.
-
Set custom Position for each product in this category.
-
Save the category and run reindex.
-
Navigate to Content > Elements > Pages and click Add New Page.
-
Expand the Content tab, then click Edit with Page Builder.
-
Drag a Row element into the content area, then drag a Products element inside the row.
-
Configure the Products element as follows:
- Select Products By: Category
- Category: Select the newly created category
- Sort By: Position
-
Switch to the Search Engine Optimization tab, and set the URL Key to test-widget.
-
Save the page.
-
Make the following GraphQL request:
query {
route(url: "/test-widget") {
relative_url
redirect_code
type
... on CmsPage {
identifier
content
__typename
}
... on ProductInterface {
uid
__typename
}
... on CategoryInterface {
uid
__typename
}
__typename
}
}
Expected results:
The system returns products in the order defined by their category position.
Actual results:
The system returns products in an order that does not match their category position in the GraphQL response.
Apply the patch
To apply individual patches, use the following links depending on your deployment method:
- Adobe Commerce or Magento Open Source on-premises: Quality Patches Tool > Usage in the Quality Patches Tool guide.
- Adobe Commerce on cloud infrastructure: Upgrades and Patches > Apply Patches in the Commerce on Cloud Infrastructure guide.
Related reading
To learn more about Quality Patches Tool, refer to:
- Quality Patches Tool: A self-service tool for quality patches in the Tools guide.