QUALITY PATCH

MDVA-43232: Sorting products in visual merchandiser by Special Price to Top (or Bottom) causes…

Sorting products in visual merchandiser by Special Price to Top (or Bottom) causes an error while saving category. Quality patch MDVA-43232 for magento/module-visual-merchandiser applies to Magento Open Source and Adobe Commerce 2.3.4 to 2.4.4-p18.

Categories
Catalog/Product, Admin
Components
magento/module-visual-merchandiser
Origin
adobe-commerce-support
Since QPT
1.1.12

Issue

Sorting products in visual merchandiser by Special Price to Top (or Bottom) causes an error while saving category.

Steps to reproduce

1. Make sure there are two websites. 1. Navigate to Stores > Configuration > Catalog > Price and set Catalog Price Scope = Website. 1. Again, navigate to Stores > Configuration > Catalog > Visual Merchandiser > Visible Attributes for Category Rules > and add Special Price. 1. Create a simple product and assign the products to both websites. 1. Add a special price to the default scope of the product. 1. Switch to the other store's scope and override both the Price and Special Price of that product. 1. Do a catalog_product_price reindex. 1. Go to Catalog > Categories and create a new category. 1. Add a category rule to filter products that have a special price. 1. Save the category. 1. Under the Products in Category section, set Sort Order = Special Price to Top (or Bottom). 1. Save the category again.

Adobe's page lists 2.3.4 - 2.4.3 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.5.

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 MDVA-43232. On Cloud, add MDVA-43232 under stage.build.QUALITY_PATCHES in .magento.env.yaml.

For cweagans/composer-patches, choose a compatible version below and download the bundle. Copy its MDVA-43232/ 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

Packages across compatible versions (1): magento/module-visual-merchandiser

magento/magento2-ee-base >=2.3.4 <2.4.5

Magento Open Source
—
Adobe Commerce
2.4.4-p18, 2.4.4-p17, 2.4.4-p16, 2.4.4-p15, 2.4.4-p14, 2.4.4-p13, 2.4.4-p12, 2.4.4-p11, 2.4.4-p10, 2.4.4-p9, 2.4.4-p8, 2.4.4-p7, 2.4.4-p6, 2.4.4-p5, 2.4.4-p4, 2.4.4-p3, 2.4.4-p2, 2.4.4-p1, 2.4.4, 2.4.3-p3, 2.4.3-p2, 2.4.3-p1, 2.4.3, 2.4.2-p2, 2.4.2-p1, 2.4.2, 2.4.1-p1, 2.4.1, 2.4.0-p1, 2.4.0, 2.3.7-p4, 2.3.7-p3, 2.3.7-p2, 2.3.7-p1, 2.3.7, 2.3.6-p1, 2.3.6, 2.3.5-p2, 2.3.5-p1, 2.3.5, 2.3.4-p2, 2.3.4-p1, 2.3.4
Patch file
patches/commerce/MDVA-43232_2.4.2-p1.patch
  • vendor/magento/module-visual-merchandiser/Model/Sorting/SortAbstract.php

Sources

Łukasz Bajsarowicz
Built by

Łukasz Bajsarowicz, e-commerce architect

Magento and Adobe Commerce architecture, upgrades, performance and audits for merchants and agencies since 2015; magento.watch is the tooling I use on those projects.

Open source, maintained on weekends.