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
                2043
                266207820000
                Welcome Stepping Stone Cast Iron Lawn Garden Decor
                
                                        IN STOCK
                
            

                2
                2063
                286391557901
                Fitbit Sense 2 Health and Fitness Smartwatch FB521
                
                                        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	2043	266207820000	Welcome Stepping Stone Cast Iron Lawn Garden Decor	IN STOCK
2	2063	286391557901	Fitbit Sense 2 Health and Fitness Smartwatch FB521	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.