Home & Garden

🔍 InstockProductsFirst Debug Info
        SQL Query:
        SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
 LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
 LEFT JOIN `cataloginventory_stock_status` AS `stock_status` ON e.entity_id = stock_status.product_id AND stock_status.website_id = 0 ORDER BY `stock_status`.`stock_status` DESC

    
ALL Products in Category (No Pagination):
            IN STOCK: 2 | 
            OUT OF STOCK: 0 | 
            First In-Stock at position: 1 |
            Total Products: 2
        

            
                Position
                ID
                SKU
                Name
                Stock Status
            

                1
                410
                276793574596
                Women's Marsha Ankle Boots Zip Up Pointed Toe  - B
                
                                        IN STOCK
                
            

                2
                879
                286280138492
                Women's Sterling Chelsea Boots Zip Up Ankle Bootie
                
                                        IN STOCK
                
            

        Quick Fix - Add this to your theme's catalog_category_view.xml:
        <referenceBlock name="category.products.list">
    <action method="setData">
        <argument name="sort_by" xsi:type="string">stock_status</argument>
    </action>
</referenceBlock>
    

Position	ID	SKU	Name	Stock Status
1	410	276793574596	Women's Marsha Ankle Boots Zip Up Pointed Toe - B	IN STOCK
2	879	286280138492	Women's Sterling Chelsea Boots Zip Up Ankle Bootie	IN STOCK

Compare Products

Remove This Item

You have no items to compare.

My Wish List

Last Added Items

You have no items in your wish list.