• 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: 41 | OUT OF STOCK: 3 | First In-Stock at position: 1
# ID SKU Name Stock Status
1 1128 198507820001 Double Sided Hanging Welcome Sign Squirrel Eating IN STOCK (1)
2 1129 163807820002 Firefighting Aluminum Sign Firemans St Florian Mal IN STOCK (1)
3 1130 019700410016 Cast Iron Wall Hook Rack Antique Skeleton Key 3 Ho IN STOCK (1)
4 1138 144307820002 Aluminum Sign You Need A Drink Home Bar Man Cave B IN STOCK (1)
5 1164 229207820005 Please Close The Gate Sign Decorative Plaque Cast IN STOCK (1)
6 2344 286440105546 Scott Hall (Black Red) WCW Smash N Slam Wrestlers OUT OF STOCK (0)
7 2346 286442533003 Sanus In-Wall Cable Concealer for Mounted TV & Sou OUT OF STOCK (0)
8 2347 286442577481 Sanus On-Wall Cable Concealer Kit for Mounted TVs IN STOCK (1)
9 2350 286444772480 CyberPower 750VA Slim Line Battery Back-Up UPS 8 O IN STOCK (1)
10 2353 286449705459 McFarlane DC Retro Classic Batman 1966 6 Inch Figu IN STOCK (1)
11 2354 286449720137 Mcfarlane Batman DC Retro 66 Classics TV Series Ro IN STOCK (1)
12 2356 286452062505 Women's Shannon Heels with Memory Foam Insole Sz 7 IN STOCK (1)
13 2358 255707820018 Cast Iron Plant Hanger Bracket Hummingbird Vine Ho IN STOCK (1)
14 26 254107820027 Wall Shelf Bracket Distressed White Ornate Cast Ir IN STOCK (1)
15 166 273007820002 Seed Feeder Bird Bath Cast Iron Wall Mounted 9.75" IN STOCK (1)
16 167 273007820005 Hanging Heart Shaped Love Bird Feeder Or Bath 5.5" IN STOCK (1)
17 169 254007820000 Wall Shelf Bracket Decorative Cast Iron Brace Humm IN STOCK (1)
18 170 012600410004 Wall Shelf Bracket Leaf Vine Pattern Cast Iron Bra IN STOCK (1)
19 172 254107820029 Wall Shelf Bracket Brace Ornate Vine Brown Cast Ir IN STOCK (1)
20 174 254107820031 Wall Shelf Bracket Ornate Vine Distressed White Ca IN STOCK (1)
21 176 254107820004 Cast Iron Wall Shelf Bracket Brace Vine & Flower R IN STOCK (1)
22 178 254107820025 Decorative Wall Shelf Bracket Simple Vine Rust Bro IN STOCK (1)
23 179 197100410004 Wall Shelf Bracket - Ornate Pattern - Black Cast I IN STOCK (1)
24 181 254107820016 Decorative Shelf Bracket - Ornate Lattice - Rust B IN STOCK (1)
25 182 254107820018 Decorative Shelf Bracket - Hexagon Lattice - Rust IN STOCK (1)
26 183 254107820019 Shelf Bracket Brace For Custom Shelving Leaf & Vin IN STOCK (1)
27 184 254107820026 Cast Iron Wall Shelf Bracket Brace Columns Distres IN STOCK (1)
28 186 019700410031 Cast Iron Wall Hook Verdigris Seahorse 5.5" Tall N IN STOCK (1)
29 188 019707820012 Decorative Coat Hook Victorian Ornate Double Wall IN STOCK (1)
30 190 019707820005 Wall Hook Coat Rack Victorian Skeleton Key Style 3 IN STOCK (1)
31 191 019707820010 Decorative Triple Wall Hook Cast Iron Coat Hat Sca IN STOCK (1)
32 192 019707820021 Cast Iron Wall Hook Rack Tropical Fish & Coral Dec IN STOCK (1)
33 193 019707820013 Double Wall Hook Decorative Antique Style Coat & H IN STOCK (1)
34 198 930907820006 Cast Iron Dinner Bell Love Birds Distressed Brown IN STOCK (1)
35 200 930907820001 Cast Iron Dinner Bell Moose Welcome Sign Outdoor D IN STOCK (1)
36 201 930907820007 Cast Iron Dinner Bell Ornate Vine Doorbell Porch D IN STOCK (1)
37 203 930907820005 Cast Iron Dinner Bell Butterfly Floral Vine Doorbe IN STOCK (1)
38 204 930907820004 Cast Iron Dinner Bell Green Farm Tractor Colorful IN STOCK (1)
39 205 930907820008 Cast Iron Dinner Bell Rooster & Flowers Colorful D OUT OF STOCK (0)
40 215 273207820009 Golden Retriever Garden Flag Emotes Beware Of Dog IN STOCK (1)
41 217 273207820006 White Chihuahua Puppy Beware Of Dog Double Sided F IN STOCK (1)
42 218 273207820007 Dark Brown Chihuahua Beware Of Dog Funny Pet Doub IN STOCK (1)
43 219 272907820014 Double Sided Garden Flag Emotes Welcome To The Nut IN STOCK (1)
44 220 272907820008 Welcome Garden Flag Yellow Butterfly Double Sided 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-12 of 44

Set Descending Direction
Page
per page
Shop By
Now Shopping by
  1. Occasion Activewear, Casual Remove This Item
  2. Heel Style Stiletto Remove This Item
Clear All
Shopping Options
Category
  1. Garden Flags 5 items
  2. Doorbells 6 items
  3. Bird Feeders 2 items
  4. Wall Hooks 6 items
  5. Signs 1 item
Set Includes
  1. 1 Shelf Bracket 31 items
  2. Kickplate / toe kick 13 items
Outsole Material
  1. Rubber 30 items
  2. Suede 14 items
Accents
  1. Logo 8 items
  2. Stripe 30 items
  3. Thick Laces 6 items
Calf Width
  1. Regular 44 items
Platform Height
  1. 1.25 in 44 items
Primary Color
  1. Beige 1 item
  2. Black 4 items
  3. Brown 17 items
  4. Distressed White 5 items
  5. Green 1 item
  6. Multi-Color 1 item
  7. Multicolor 1 item
  8. Rust 5 items
  9. Rust Brown 1 item
  10. Teal 5 items
  11. White 3 items
Shape
  1. Foot Print 13 items
  2. Tractor 7 items
  3. Triangle 24 items
Item Weight
  1. 1 lb 4 items
  2. 2 lb 6 items
  3. 2.5 lb 13 items
  4. 3 lb 2 items
  5. 5 oz 5 items
  6. 5.875000 13 items
  7. 6 oz 1 item
Finish
  1. Distressed 1 item
  2. Glossy 1 item
  3. Matt 8 items
  4. Painted 34 items
Product Line
  1. BearPaw 14 items
  2. Troy 30 items
Room
  1. Any 31 items
  2. Any Room 13 items
Personalized
  1. No 44 items
Mounting
  1. Hanging 13 items
  2. Wall Mount 1 item
  3. Wall Mounted 30 items
Indoor Outdoor
  1. Indoor & Outdoor 44 items
Suitable For
  1. Birds 19 items
  2. Coats, Towels, Hats 13 items
  3. Custom Shelves 1 item
  4. Home 10 items
  5. Shelves 1 item
Subject
  1. Butterfly 1 item
  2. Close The Gate 2 items
  3. Dog 4 items
  4. Fire & Rescue 2 items
  5. United States 25 items
  6. Welcome 1 item
  7. Wine 8 items
  8. You Need A Drink 1 item
Assembly Required
  1. No 44 items
Hook Style
  1. Antique 12 items
  2. Traditional 32 items
Shoe Shaft Style
  1. Low Top 44 items
Manufacturer
  1. CyberPower 1 item
  2. Flag Emotes 9 items
  3. Import Wholesales 8 items
  4. Maddison 19 items
  5. McFarlane Toys 3 items
  6. Sanus 2 items
  7. ToyBiz 1 item
  8. Unknown 1 item
Color
  1. Beige 1 item
  2. Black 5 items
  3. Brown 23 items
  4. Green 4 items
  5. Multi-Color 1 item
  6. Multicolor 2 items
  7. Teal 5 items
  8. White 3 items
Us Shoe Size
  1. 13 30 items
  2. 4 6 items
  3. 7.5 8 items
Department
  1. Adults 18 items
  2. Adults, Kids, Teens 2 items
  3. Kids 1 item
  4. Unisex Adults 6 items
  5. Women 17 items
Lining Material
  1. Textile 30 items
  2. Wool 14 items
Style
  1. Antique Style 21 items
  2. Country 2 items
  3. Decorative 2 items
  4. French Country 1 item
  5. Kid's 1 item
  6. Nautical 1 item
  7. Novelty 1 item
  8. Sneaker 6 items
  9. Strappy 1 item
  10. Traditional 5 items
  11. Victorian 3 items
Heel Height
  1. 2.75 in 30 items
  2. High (3-3.9 in) 14 items
Upper Material
  1. 100% Nylon 6 items
  2. Faux Suede 6 items
  3. Synthetic 32 items
Price
  1. $0.00 - $9.99 7 items
  2. $10.00 - $19.99 31 items
  3. $20.00 - $29.99 4 items
  4. $30.00 - $39.99 1 item
  5. $40.00 and above 1 item
Toe Shape
  1. Round Toe 44 items
Closure
  1. Lace Up 38 items
  2. Pull On 6 items
Theme
  1. Animal & Birds 1 item
  2. Bar & Club 1 item
  3. Chihuahua 2 items
  4. Close The Gate 1 item
  5. Firefighting 2 items
  6. Fleur De Lis 1 item
  7. Golden Retriever 1 item
  8. Outdoor, Sports, University, Fashion 25 items
  9. Sports 8 items
  10. Squirrel 1 item
  11. Welcome 1 item
Shoe Width
  1. Standard 44 items
Insole Material
  1. Foam 30 items
  2. Memory Foam 14 items
Fabric Type
  1. Knit 30 items
  2. Shearling 14 items
Season
  1. Fall, Spring, Summer 8 items
  2. Fall, Spring, Summer, Winter 36 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.