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

    
First 20 Products (Stock Status Check):
            IN STOCK: 2 | 
            OUT OF STOCK: 0 | 
            First In-Stock at position: 1
        

            
                #
                ID
                SKU
                Name
                Stock Status
            

                1
                239
                273207820002
                Garden Flag Wine A Bit Funny Drinking Yard Banner 
                
                                        IN STOCK (1)
                
            

                2
                2088
                273207820012
                Funny Garden Flag Roses Are Red So Is My Wine Doub
                
                                        IN STOCK (1)
                
            

        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>
    

#	ID	SKU	Name	Stock Status
1	239	273207820002	Garden Flag Wine A Bit Funny Drinking Yard Banner	IN STOCK (1)
2	2088	273207820012	Funny Garden Flag Roses Are Red So Is My Wine Doub	IN STOCK (1)

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.