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: 1 | 
            OUT OF STOCK: 0 | 
            First In-Stock at position: 1 |
            Total Products: 1
        

            
                Position
                ID
                SKU
                Name
                Stock Status
            

                1
                19
                254107820008
                Wall Shelf Bracket Large Fleur De Lis Cast Iron Br
                
                                        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	19	254107820008	Wall Shelf Bracket Large Fleur De Lis Cast Iron Br	IN STOCK

Wall Shelf Bracket Large Fleur De Lis Cast Iron Brace DIY Shelves
$19.98

Add to Wish List Add to Compare

Now Shopping by

Suitable For Wall Shelf, Mail Box Mount Remove This Item
Insole Material Memory Foam 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.