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
                554
                286254844708
                Dr. Scholl's Laurel Womens Ankle Bootie Honey Brow
                
                                        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	554	286254844708	Dr. Scholl's Laurel Womens Ankle Bootie Honey Brow	IN STOCK

Dr. Scholl's Laurel Womens Ankle Bootie Honey Brown Odor Control 7.5 M
$15.30

Add to Wish List Add to Compare

Now Shopping by

Product Line Troy Remove This Item
Heel Height 2 in 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.