• Sign In
Toggle Nav
My Cart
Search
Advanced Search
  • Compare Products
Menu
Account

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` 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
 LEFT JOIN (SELECT `cpsl`.`parent_id`, MAX(stock_child.stock_status) AS `max_stock` FROM `catalog_product_super_link` AS `cpsl`
 LEFT JOIN `cataloginventory_stock_status` AS `stock_child` ON cpsl.product_id = stock_child.product_id AND stock_child.website_id = 0 GROUP BY `cpsl`.`parent_id`) AS `config_stock` ON e.entity_id = config_stock.parent_id ORDER BY CASE 
                WHEN e.type_id = "configurable" THEN IFNULL(config_stock.max_stock, 0)
                ELSE IFNULL(stock_status.stock_status, 0)
            END DESC

First ALL Products (Stock Status Check):

IN STOCK: 19 | OUT OF STOCK: 0
ID SKU Name Stock Status
2404 277064207987 Carrie Underwood My Gift First-Ever Christmas Albu IN STOCK (1)
2381 286485819828 MOBICam HDX Smart HD Pan & Tilt Wi-Fi Baby Monitor IN STOCK (1)
2380 286479184706 Yardbird Harriet Sofa Cover CVHA100 Beige Outdoor IN STOCK (1)
2379 286479095271 Yardbird - Harriet Fixed and Swivel Chair Cover - IN STOCK (1)
2398 286514389783 The Raid: Redemption [New 4K UHD Blu-ray] Ltd Ed, IN STOCK (1)
2396 286514205283 Absolutely Fabulous: Absolutely All of It! New DVD IN STOCK (1)
2397 286514279050 Horror Hall of Fame Movie 5 DVD Boxset 26 Classic IN STOCK (1)
2061 254107820032 White Cast Iron Shelf Bracket Ornate Scroll Wall M IN STOCK (1)
2059 286382333221 Womens Paulina Kitten Heel Sling Back Pointed Toe IN STOCK (1)
2356 286452062505 Women's Shannon Heels with Memory Foam Insole Sz 7 IN STOCK (1)
2386 286497320411 Matchbox Twenty Where Light Goes Vinyl LP Alternat IN STOCK (1)
2383 286491389772 MOBICam Pro 2 Pk Smart HD Pan Tilt Wi-Fi Baby Moni IN STOCK (1)
2389 286498061560 LSU Tigers Stickers Wall Art Self-Adhesive Diecut IN STOCK (1)
2392 286502060821 Gamma Photon Outdoor Pickleballs High-Vis Yellow U IN STOCK (1)
2394 286513849072 Funko Pop! Deluxe: Jabba's Skiff: Luke Skywalker - IN STOCK (1)
2393 286502109409 Farberware Professional Secure Fit Funnel Removabl IN STOCK (1)
2402 286515110514 Judy Blume Welcome to the Hilarious World of Fudge IN STOCK (1)
2403 286515151853 THE BEST OF PENTATONIX CHRISTMAS [10/25] NEW CD Se IN STOCK (1)
2399 286514692829 Dr. Strangelove: Or How I Learned To..Love The Bom 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>
View as Grid List

Items 1-19 of 19

Set Descending Direction
Page
per page
Shop By
Now Shopping by
  1. Primary Color Beige Remove This Item
  2. Shoe Shaft Style Low Top Remove This Item
Clear All
Shopping Options
Set Includes
  1. Kickplate / toe kick 19 items
Outsole Material
  1. Suede 19 items
Accents
  1. Flower 2 items
  2. Glow-In-The-Dark, Hooded 16 items
  3. Logo 1 item
Calf Width
  1. Regular 19 items
Platform Height
  1. 1.25 in 19 items
Shape
  1. Foot Print 19 items
Item Weight
  1. 5.875000 19 items
Finish
  1. Glossy 16 items
  2. Matt 1 item
  3. Painted 2 items
Product Line
  1. BearPaw 19 items
Room
  1. Any Room 19 items
Personalized
  1. No 19 items
Mounting
  1. Wall Mounted 19 items
Indoor Outdoor
  1. Indoor & Outdoor 19 items
Suitable For
  1. Coats, Towels, Hats 19 items
Subject
  1. Firefighting 16 items
  2. Snail 2 items
  3. Wine 1 item
Assembly Required
  1. No 19 items
Hook Style
  1. Traditional 19 items
Manufacturer
  1. BBC Warner 2 items
  2. Farberware 1 item
  3. Flag Emotes 2 items
  4. Funko 1 item
  5. Gamma 1 item
  6. McFarlane Toys 1 item
  7. MOBI 3 items
  8. Sony Pictures 5 items
  9. Warner 1 item
  10. Yardbird 2 items
Color
  1. Beige 19 items
Us Shoe Size
  1. 6 2 items
  2. 7.5 17 items
Department
  1. Women 19 items
Occasion
  1. Activewear, Casual 1 item
  2. Casual, Workwear 2 items
  3. Easter 16 items
Lining Material
  1. Wool 19 items
Style
  1. Decorative 16 items
  2. Slingback 2 items
  3. Strappy 1 item
Heel Height
  1. High (3-3.9 in) 19 items
Upper Material
  1. Synthetic 19 items
Price
  1. $0.00 - $99.99 17 items
  2. $100.00 and above 2 items
Toe Shape
  1. Round Toe 19 items
Closure
  1. Lace Up 1 item
  2. Slip On 2 items
  3. Zip 16 items
Heel Style
  1. Stiletto 19 items
Theme
  1. College 2 items
  2. Emergency Services 8 items
  3. Movies, Sci-Fi 8 items
  4. Sports 1 item
Shoe Width
  1. Standard 17 items
  2. W 2 items
Insole Material
  1. Memory Foam 19 items
Fabric Type
  1. Shearling 19 items
Season
  1. Fall, Spring, Summer 1 item
  2. Fall, Winter 16 items
  3. Spring, Summer 2 items
Compare Products
  1. Remove This Item
Compare
Clear All
You have no items to compare.
My Wish List
Last Added Items
  1. Add to Cart
    Remove This Item
Go to Wish List
You have no items in your wish list.
Copyright © 2023-present Chillicothe Market All rights reserved.