• 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 20 Products (Stock Status Check):

IN STOCK: 35 | OUT OF STOCK: 0
ID SKU Name Stock Status
1706 272607820008 S-Hook Plant Hanger Flower Basket Decor Rustic Bro IN STOCK (1)
1708 276981428196 WWE Elite Collection Undertaker Figure - Best of 2 IN STOCK (1)
1716 276987506055 Women's Shannon Heels with Memory Foam Insole Sz 6 IN STOCK (1)
1720 254107820007 Ornate Cast Iron Shelf Bracket Decorative Corner S IN STOCK (1)
1721 276992410457 Mcfarlane Batman DC Retro 66 Classics TV Series W5 IN STOCK (1)
1722 276992464944 McFarlane DC Retro 66 Classic TV Series Radioactiv IN STOCK (1)
1723 276992467087 Hasbro Star Wars George Lucas Stormtrooper Action IN STOCK (1)
1741 277012444440 New Brielle Home Cotton Jersey Knit (T-Shirt) Shee IN STOCK (1)
1941 286287688602 Allegra K Women's Back to College Faux Suede Open IN STOCK (1)
2059 286382333221 Womens Paulina Kitten Heel Sling Back Pointed Toe IN STOCK (1)
2061 254107820032 White Cast Iron Shelf Bracket Ornate Scroll Wall M IN STOCK (1)
2356 286452062505 Women's Shannon Heels with Memory Foam Insole Sz 7 IN STOCK (1)
2379 286479095271 Yardbird - Harriet Fixed and Swivel Chair Cover - IN STOCK (1)
2380 286479184706 Yardbird Harriet Sofa Cover CVHA100 Beige Outdoor IN STOCK (1)
2381 286485819828 MOBICam HDX Smart HD Pan & Tilt Wi-Fi Baby Monitor IN STOCK (1)
2383 286491389772 MOBICam Pro 2 Pk Smart HD Pan Tilt Wi-Fi Baby Moni IN STOCK (1)
2386 286497320411 Matchbox Twenty Where Light Goes Vinyl LP Alternat 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)
2393 286502109409 Farberware Professional Secure Fit Funnel Removabl IN STOCK (1)
2394 286513849072 Funko Pop! Deluxe: Jabba's Skiff: Luke Skywalker - 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)
2398 286514389783 The Raid: Redemption [New 4K UHD Blu-ray] Ltd Ed, IN STOCK (1)
2399 286514692829 Dr. Strangelove: Or How I Learned To..Love The Bom 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)
2404 277064207987 Carrie Underwood My Gift First-Ever Christmas Albu IN STOCK (1)
1699 276966958927 Heyday Silicone Phone Case for iPhone 12 Mini – IN STOCK (1)
1700 276967399530 Funko Mini Moments: Marvel - Jennifer & Abominatio IN STOCK (1)
1701 276969248621 UNOS BY SZ Adult Sneakers - Gray 8-9 IN STOCK (1)
1693 276955627052 Women's Marcia Lace up Heels with Memory Foam Inso IN STOCK (1)
1703 273107820002-1 Nautical Ship Anchor Cast Iron Shelf Bracket 7.75" IN STOCK (1)
1704 273107820002 Nautical Ship Anchor Cast Iron Shelf Bracket 7.75" IN STOCK (1)
1705 254107820003-1 Wall Shelf Bracket Cast Iron Brace Vine & Leaf Ver 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-35 of 35

Set Descending Direction
Page
per page
Shop By
Now Shopping by
  1. Primary Color Beige Remove This Item
  2. Toe Shape Round Toe Remove This Item
Clear All
Shopping Options
Set Includes
  1. Kickplate / toe kick 35 items
Outsole Material
  1. Suede 35 items
Accents
  1. Buckle 15 items
  2. Flower 2 items
  3. Glow-In-The-Dark, Hooded 16 items
  4. Logo 1 item
  5. Tie Strap 1 item
Calf Width
  1. Regular 35 items
Platform Height
  1. 1.25 in 35 items
Shape
  1. Foot Print 35 items
Item Weight
  1. 5.875000 35 items
Finish
  1. Glossy 16 items
  2. Matt 1 item
  3. Painted 18 items
Product Line
  1. BearPaw 35 items
Room
  1. Any Room 35 items
Personalized
  1. No 35 items
Mounting
  1. Wall Mounted 35 items
Indoor Outdoor
  1. Indoor & Outdoor 35 items
Suitable For
  1. Coats, Towels, Hats 35 items
Subject
  1. Close The Gate 15 items
  2. Coffee 1 item
  3. Firefighting 16 items
  4. Snail 2 items
  5. Wine 1 item
Assembly Required
  1. No 35 items
Hook Style
  1. Traditional 35 items
Shoe Shaft Style
  1. Ankle 16 items
  2. Low Top 19 items
Manufacturer
  1. Allegra K 1 item
  2. BBC Warner 2 items
  3. BRIELLE 1 item
  4. Farberware 1 item
  5. Flag Emotes 8 items
  6. Funko 3 items
  7. Gamma 1 item
  8. Hasbro 1 item
  9. Heyday 1 item
  10. McFarlane Toys 3 items
  11. Metra 1 item
  12. MOBI 3 items
  13. Sony Pictures 5 items
  14. Warner 1 item
  15. WWE 1 item
  16. Yardbird 2 items
Color
  1. Beige 27 items
  2. Brown 4 items
  3. Gray 1 item
  4. Pink 2 items
  5. Verdigris 1 item
Us Shoe Size
  1. 5 1 item
  2. 6 8 items
  3. 7.5 17 items
  4. 8.5 3 items
  5. W 9.5-10.5 6 items
Department
  1. Adult 1 item
  2. Women 34 items
Occasion
  1. Activewear, Casual 1 item
  2. Business, Casual, Party/Cocktail, Wedding 1 item
  3. Casual, Workwear 2 items
  4. Easter 17 items
  5. Formal, Party/Cocktail, Travel, Wedding 14 items
Lining Material
  1. Wool 35 items
Style
  1. Country 1 item
  2. Decorative 16 items
  3. Heels 1 item
  4. Nautical 5 items
  5. Slingback 2 items
  6. Sneaker 1 item
  7. Strappy 9 items
Heel Height
  1. High (3-3.9 in) 35 items
Upper Material
  1. 100% Polyester 1 item
  2. Not Available 9 items
  3. Synthetic 25 items
Price
  1. $0.00 - $99.99 33 items
  2. $100.00 and above 2 items
Closure
  1. Lace Up 1 item
  2. Slip On 17 items
  3. Tie 1 item
  4. Zip 16 items
Heel Style
  1. Stiletto 35 items
Theme
  1. Coffee 1 item
  2. College 3 items
  3. Comics, Television 2 items
  4. Emergency Services 8 items
  5. Movies, Sci-Fi 8 items
  6. Nautical 10 items
  7. Rhinestones 2 items
  8. Sports 1 item
Shoe Width
  1. Medium 16 items
  2. Standard 17 items
  3. W 2 items
Insole Material
  1. Memory Foam 35 items
Fabric Type
  1. Shearling 35 items
Season
  1. Fall, Spring, Summer 1 item
  2. Fall, Winter 16 items
  3. Spring, Summer 18 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.