Magento Cloud - Cannot sorting products list by min_price DESC or ASC

Question

I'm developing a website using Magento Cloud.
I created 2 new sort-by options as attachments below:

When I select sort-by "Price Low to High" or "Price High to Low". I always get messages:

We can't find products matching the selection.

---

This's my code:

1. di.xml file

<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:ObjectManager/etc/config.xsd">
   <type name="Magento\Catalog\Block\Product\ProductList\Toolbar">
       <plugin name="custom_custom_block_toolbar" type="Vendor\Catalog\Plugin\Catalog\Block\ToolbarPlugin"/>
   </type>
   <type name="Magento\Catalog\Model\Config">
       <plugin name="custom_catalog_model_config" type="Vendor\Catalog\Plugin\Catalog\Model\ConfigPlugin"/>
   </type>
</config>

3. ConfigPlugin.php

<?php

declare(strict_types=1);

namespace Vendor\Catalog\Plugin\Catalog\Model;

use Magento\Catalog\Model\Config;

class ConfigPlugin
{
    const LOW_TO_HIGH = 'low_to_high';
    const HIGH_TO_LOW = 'high_to_low';

    /**
     * @param Config $catalogConfig
     * @param $options
     * @return mixed
     */
    public function afterGetAttributeUsedForSortByArray(Config $catalogConfig, $options)
    {
        $options[self::LOW_TO_HIGH] = __('Price Low to High');
        $options[self::HIGH_TO_LOW] = __('Price High To Low');
        return $options;
    }
}

4. ToolbarPlugin.php

<?php

declare(strict_types=1);

namespace Vendor\Catalog\Plugin\Catalog\Block;

use Closure;
use Magento\Catalog\Block\Product\ProductList\Toolbar;
use Vendor\Catalog\Plugin\Catalog\Model\ConfigPlugin;

class ToolbarPlugin
{
    /**
     * @param Toolbar $subject
     * @param Closure $proceed
     * @param $collection
     * @return mixed
     */
    public function aroundSetCollection(
        Toolbar $subject,
        Closure $proceed,
        $collection
    ) {
        $currentOrder = $subject->getCurrentOrder();
        $result = $proceed($collection);

        if (in_array($currentOrder, [ConfigPlugin::LOW_TO_HIGH, ConfigPlugin::HIGH_TO_LOW])) {
            if ($currentOrder == ConfigPlugin::LOW_TO_HIGH) {
                $subject->getCollection()->getSelect()->order(
                    new \Zend_Db_Expr("price_index.min_price = 0, price_index.min_price ASC")
                );
            }
            if ($currentOrder == ConfigPlugin::HIGH_TO_LOW) {
                $subject->getCollection()->getSelect()->order(
                    new \Zend_Db_Expr("price_index.min_price = 0, price_index.min_price DESC")
                );
            }
        }

        return $result;
    }
}

Does anyone know what's happened?
Thanks in advance!

Answer 1

i'm also facing this issue, does anyone have updates?