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 = 1 ORDER BY `stock_status`.`stock_status` DESC

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

            
                #
                ID
                SKU
                Name
                Stock Status
            

                1
                1861
                144907820000
                Aluminum Sign Kitchen Rules Wall Hanging Plaque 12
                
                                        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	1861	144907820000	Aluminum Sign Kitchen Rules Wall Hanging Plaque 12	IN STOCK (1)

Aluminum Sign Kitchen Rules Wall Hanging Plaque 12" x 9"
$14.99

Add to Wish List Add to Compare

Now Shopping by

Heel Height High (3-3.9 in) Remove This Item
Theme Kitchen Remove This Item

Clear All

Shopping Options

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.