DocumentationCommerceTools

[PaaS only]{class="badge informative" title="Applies to Adobe Commerce on Cloud projects (Adobe-managed PaaS infrastructure) and on-premises projects only."}

MDVA-40120: GraphQL product DESC/ASC sort doesn’t work

Last update: Thu Jun 19 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • Experienced
  • Admin

The MDVA-40120 patch solves the issue where GraphQL sorting by DESC/ASC doesn’t work with products having the same relevance or price. This patch is available when the Quality Patches Tool (QPT) 1.1.6 is installed. The patch ID is MDVA-40120. Please note that the issue is scheduled to be fixed in Adobe Commerce 2.4.4.

Affected products and versions

The patch is created for Adobe Commerce version:

  • Adobe Commerce (all deployment methods) 2.4.2-p1

Compatible with Adobe Commerce versions:

  • Adobe Commerce (all deployment methods) 2.4.1 - 2.4.3-p1
NOTE
The patch might become applicable to other versions with new Quality Patches Tool releases. To check if the patch is compatible with your Adobe Commerce version, update the 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

Prerequisites:

Create a few different products with the same price.

Steps to reproduce:

  1. Run the following GraphQL query:

    code language-graphql 
    {
  products(filter: {category_id: {eq: "{{cat_id}}"}}, sort: {relevance: ASC}) {
    total_count
    items {
      name
      sku
    }
  }
}

  2. Check the response.

  3. Change the sort order from ASC to DESC in the GraphQL query:

    code language-graphql 
    {
  products(filter: {category_id: {eq: "{{cat_id}}"}}, sort: {relevance: DESC}) {
    total_count
    items {
      name
      sku
    }
  }
}

  4. Check the response.

Expected results:

The product listing in the GraphQL response should be changed according to the sort order.

Actual results:

The sort order remains unchanged.

Apply the patch

To apply individual patches, use the following links depending on your deployment method:

To learn more about Quality Patches Tool, refer to:

For info about other patches available in QPT, refer to Quality Patches Tool: Search for patches in the Quality Patches Tool guide.

recommendation-more-help
c2d96e17-5179-455c-ad3a-e1697bb4e8c3