2021-10-20 12:47:50] main.CRITICAL: {"error":{"root_cause":[{"type":"query_shard_exception","reason":"No mapping found for [out_of_stock_at_last] in order to sort on","index_uuid":"mZx8iP_-TwqV3YZhSb0mRQ","index":"magento2_product_1_v182"}],"type":"search_phase_execution_exception","reason":"all shards failed","phase":"query","grouped":true,"failed_shards":[{"shard":0,"index":"magento2_product_1_v182","node":"QojGcWy_SN-pJQgKPP89cA","reason":{"type":"query_shard_exception","reason":"No mapping found for [out_of_stock_at_last] in order to sort on","index_uuid":"mZx8iP_-TwqV3YZhSb0mRQ","index":"magento2_product_1_v182"}}]},"status":400} {"exception":"[object] (Elasticsearch\Common\Exceptions\BadRequest400Exception(code: 400): {"error":{"root_cause":[{"type":"query_shard_exception","reason":"No mapping found for [out_of_stock_at_last] in order to sort on","index_uuid":"mZx8iP_-TwqV3YZhSb0mRQ","index":"magento2_product_1_v182"}],"type":"search_phase_execution_exception","reason":"all shards failed","phase":"query","grouped":true,"failed_shards":[{"shard":0,"index":"magento2_product_1_v182","node":"QojGcWy_SN-pJQgKPP89cA","reason":{"type":"query_shard_exception","reason":"No mapping found for [out_of_stock_at_last] in order to sort on","index_uuid":"mZx8iP_-TwqV3YZhSb0mRQ","index":"magento2_product_1_v182"}}]},"status":400} at /home/domain/public_html/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Connections/Connection.php:675)"} []

Preconditions (*)

Magento version 2.4 PHP version 7.4

Steps to reproduce (*)

Go to category and order by price

Expected result (*)

It is expected to order by price, leaving the products out of stock at the end

Actual result (*)

Sort by price without considering out of stock products

after installing the extension , sorting products by position are not working anymore on category pages. I got this once working in magento 2.2.3 in ListProduct.php using this code: $collection->addExpressionAttributeToSelect('in_stock', 'IFNULL(stock_status_index.stock_status,0)', array()); $collection->getSelect()->reset('order'); $collection->getSelect()->order('in_stock DESC');

Preconditions (*)

1. Request from issue https://github.com/tuyennn/magento2-outofstockatlast/issues/1

Steps to reproduce (*)

1. None

Expected result (*)

1. Compatibility with smile/elasticsuite

I want to display all in-Stock products at the first and backorders product in the last of the page. for example- suppose we have total 5 products. 4 products are In-Stock, so these products will be display first, 5th products will be feature at last as the 5th products is out of stock and we have enabled back-order so it must display at last,

Please help How to accomplice it? Thanks in advance. any help regrading this would be appreciated.,

Note- I am not showing out of stock products on the webshop. I need to display only In Stock prodycts and the backorders products on website. and the backorders products should display in last on categories pages.

Preconditions (*)

1. Magento 2.4.4 Installed
2. Default sorting set as Bestsellers
3. Module installed and catalog reindexed

Steps to reproduce (*)

1. Open any category and you will see out of stock product in the middle of the category page

Expected result (*)

Module working as aspected

Actual result (*)

1. Not working

Preconditions (*)

1. Magento 2.4.x
2. With smile/elasticsuite

Steps to reproduce (*)

1. Edit category
2. Manually sorting and add out of stock products

Expected result (*)

1. Manually out of stock products sorting should moved to the last

Actual result (*)

1. Manually out of stock products sorting kept position
2. Ref https://github.com/tuyennn/magento2-outofstockatlast/issues/3

Precondtion : Magento 2.4 Module - Smile ELastic and Layered Navigation (https://landofcoder.com/magento-2-layered-navigation.html )

Issue - AFter installing Layered Navigation i get below error -

Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'stock_status_idx.stock_status' in 'where clause', query was: SELECT 1 AS status, e.entity_id, e.attribute_set_id, e.type_id, e.created_at, e.updated_at, e.sku, cat_index.position AS cat_index_position FROM catalog_product_flat_1 AS e INNER JOIN catalog_category_product_index_store1 AS cat_index ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id=1039 WHERE (stock_status_idx.stock_status = '1') Exception #1 (PDOException): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'stock_status_idx.stock_status' in 'where clause'

Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'stock_status_idx.stock_status' in 'where clause', query was: SELECT 1 AS status, e.entity_id, e.attribute_set_id, e.type_id, e.created_at, e.updated_at, e.sku, cat_index.position AS cat_index_position FROM catalog_product_flat_1 AS e INNER JOIN catalog_category_product_index_store1 AS cat_index ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id=1039 WHERE (stock_status_idx.stock_status = '1')

Possible fix for https://github.com/tuyennn/magento2-outofstockatlast/issues/15

query_shard_exception. No mapping found for [out_of_stock_at_last] in order to sort on

Preconditions (*)

1. Magento 2.4.x
2. Install Amasty Shopby

Steps to reproduce (*)

2021-10-20 12:47:50] main.CRITICAL: {"error":{"root_cause":[{"type":"query_shard_exception","reason":"No mapping found for [out_of_stock_at_last] in order to sort on","index_uuid":"mZx8iP_-TwqV3YZhSb0mRQ","index":"magento2_product_1_v182"}],"type":"search_phase_execution_exception","reason":"all shards failed","phase":"query","grouped":true,"failed_shards":[{"shard":0,"index":"magento2_product_1_v182","node":"QojGcWy_SN-pJQgKPP89cA","reason":{"type":"query_shard_exception","reason":"No mapping found for [out_of_stock_at_last] in order to sort on","index_uuid":"mZx8iP_-TwqV3YZhSb0mRQ","index":"magento2_product_1_v182"}}]},"status":400} {"exception":"[object] (Elasticsearch\Common\Exceptions\BadRequest400Exception(code: 400): {"error":{"root_cause":[{"type":"query_shard_exception","reason":"No mapping found for [out_of_stock_at_last] in order to sort on","index_uuid":"mZx8iP_-TwqV3YZhSb0mRQ","index":"magento2_product_1_v182"}],"type":"search_phase_execution_exception","reason":"all shards failed","phase":"query","grouped":true,"failed_shards":[{"shard":0,"index":"magento2_product_1_v182","node":"QojGcWy_SN-pJQgKPP89cA","reason":{"type":"query_shard_exception","reason":"No mapping found for [out_of_stock_at_last] in order to sort on","index_uuid":"mZx8iP_-TwqV3YZhSb0mRQ","index":"magento2_product_1_v182"}}]},"status":400} at /home/domain/public_html/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Connections/Connection.php:675)"} []

Expected result (*)

1. No exception

Actual result (*)

1. [Screenshots, logs or description]

This seem was mentioned on https://github.com/tuyennn/magento2-outofstockatlast/issues/15

…llection

Possible fix for https://github.com/tuyennn/magento2-outofstockatlast/issues/10

Steps to reproduce

Go to category and order by price

Expected result

It is expected to order by price, leaving the products out of stock at the end

Actual result

Sort by price without considering out of stock products

Hi,

This is fantastic work. I'm just looking at integrating it with a few other areas such as Amasty ElasticSearch and Mirasvit Search Ultimate.

Neither paid plugin gives the option to move out of stock last.

Any experience with either? Just looking to update the di.xml files for both to allow for your out_of_stock flag

Preconditions (*)

1. Module Installed
2. Magento 2.4.x

Steps to reproduce (*)

Expected result (*)

1. While Display Out of Stock Products Stores > Configuration > Catalog > Inventory > Stock set Yes
2. A category attribute option allow forcing hide out of stock items on specific category but another categories still remain display the OOS products

Actual result (*)

Preconditions (*)

1. Module installed
2. Magento 2.4.x

Steps to reproduce (*)

1. An category attribute to switch to specify the sorting is allowed to work

Expected result (*)

1. An category attribute to switch to specify the sorting is allowed to work
2. When this ignore flag was set Yes on category level, the Out Of Stock At Last took no effect

Actual result (*)

Preconditions (*)

1. Current module has no configuration to enable/disable

Steps to reproduce (*)

Expected result (*)

1. Add configuration Enable/Disable
2. Could based on store view

Actual result (*)

1. Current module has no configuration to enable/disable

Preconditions (*)

1. Magento
2. Hyva theme

Steps to reproduce (*)

Expected result (*)

1. Compatibility with Hyva

Actual result (*)

1. [Screenshots, logs or description]