• 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: 30 | OUT OF STOCK: 0 | First In-Stock at position: 1
# ID SKU Name Stock Status
1 204 930907820004 Cast Iron Dinner Bell Green Farm Tractor Colorful IN STOCK (1)
2 229 273607820003 Halloween Garden Flag Trick Or Treat Double Sided IN STOCK (1)
3 236 272807820001 Welcome Garden Flag Lighthouse Yard Banner Beach D IN STOCK (1)
4 239 273207820002 Garden Flag Wine A Bit Funny Drinking Yard Banner IN STOCK (1)
5 242 273707820001 Happy Easter Garden Flag Wreath Bunny Eggs Double IN STOCK (1)
6 243 273207820010 Funny Dog Garden Flag Beware Of Dog Black Lab Labr IN STOCK (1)
7 244 273207820003 Cat Garden Flag Spoiled Cats Live Here Double Side IN STOCK (1)
8 245 272807820000 Beach Life Garden Flag Colorful Shells Double Side IN STOCK (1)
9 247 274007820001 Merry Christmas Garden Flag Winter Double Sided Ya IN STOCK (1)
10 249 272907820005 Welcome Garden Flag Pink Flowers Yard Banner Decor IN STOCK (1)
11 250 273207820000 Funny Cat Garden Flag Beware Of Cat Double Sided Y IN STOCK (1)
12 251 273207820011 Funny Black Lab Puppy Garden Flag Beware Of Dog Do IN STOCK (1)
13 254 274107820003 Happy Campers Garden Flag Double Sided Camping Yar IN STOCK (1)
14 257 272807820002 Bereavement Garden Flag Forever Loved Heart In Sky IN STOCK (1)
15 258 273207820014 Funny Boxer Garden Flag Beware Of Dog Double Sided IN STOCK (1)
16 5 254007820003 Fleur De Lis & Vine Shelf Bracket Cast Iron Brace IN STOCK (1)
17 8 254107820010 Decorative Cast Iron Wall Shelf Bracket Brace DIY IN STOCK (1)
18 6 254107820011 Decorative Shelf Bracket Flower Leaf Brace Distres IN STOCK (1)
19 7 254007820002 Wall Shelf Bracket Fleur De Lis Cast Iron Brace Br IN STOCK (1)
20 10 254107820009 Cast Iron Wall Shelf Bracket Ornate Brace 10" Deep 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 121

Set Descending Direction
Page
per page
Shop By
Now Shopping by
  1. Mounting Wall Mounted Remove This Item
  2. Heel Height 2.75 in Remove This Item
Clear All
Shopping Options
Category
  1. Plant Hangers 35 items
  2. Hose Holders 14 items
  3. Garden Flags 43 items
  4. Doorbells 6 items
  5. Wall Hooks 12 items
Set Includes
  1. 1 Shelf Bracket 97 items
  2. Kickplate / toe kick 1 item
  3. Wall Mounted Hose Hanger 23 items
Outsole Material
  1. Rubber 121 items
Accents
  1. Bow, Rhinestone 1 item
  2. Heel 2 items
  3. Stripe 118 items
  4. Zipper 2 items
Calf Width
  1. Regular 121 items
Platform Height
  1. 1.25 in 121 items
Primary Color
  1. Black 3 items
  2. Blue 6 items
  3. Bronze 1 item
  4. Brown 54 items
  5. Distressed White 3 items
  6. Green 6 items
  7. Multi Colored 2 items
  8. Multi-Color 2 items
  9. Multicolor 6 items
  10. Rust Brown 4 items
  11. Teal 32 items
  12. Verdigris 2 items
Shape
  1. C Hook 2 items
  2. Foot Print 1 item
  3. J Hook 40 items
  4. S Hook 17 items
  5. Tractor 45 items
  6. Triangle 16 items
Item Weight
  1. 0.937500 1 item
  2. 1 lb 14 items
  3. 1 lbs 1 item
  4. 1.5 1 item
  5. 1.5 lb 3 items
  6. 1.5 lbs 9 items
  7. 10 oz 1 item
  8. 14 Oz 1 item
  9. 2 lb 7 items
  10. 2 lbs 4 items
  11. 2.5 lb 6 items
  12. 2.5 lbs 1 item
  13. 2.937500 1 item
  14. 3 lb 5 items
  15. 3 lbs 4 items
  16. 3 Oz 11 items
  17. 3.062500 1 item
  18. 3.312500 1 item
  19. 3.812500 1 item
  20. 3lbs. 1 item
  21. 4 lb 2 items
  22. 4 lbs 2 items
  23. 4 Oz 13 items
  24. 5 lb 4 items
  25. 5 lbs 1 item
  26. 5 oz 20 items
  27. 5.875000 1 item
  28. 6 oz 2 items
  29. 9 Oz 9 Oz 1 item
  30. 9 oz 1 item
Finish
  1. Distressed 3 items
  2. Distressed Brown 1 item
  3. Glossy 1 item
  4. Matte 40 items
  5. Painted 76 items
Product Line
  1. BearPaw 1 item
  2. Junie 2 items
  3. Troy 118 items
Room
  1. Any 110 items
  2. Any Room 7 items
  3. Bathroom 3 items
  4. Kitchen 1 item
Personalized
  1. No 116 items
  2. Yes 5 items
Indoor Outdoor
  1. Indoor & Outdoor 87 items
  2. Outdoor 34 items
Suitable For
  1. Birds 6 items
  2. Coat 4 items
  3. Coats, Towels, Hats 5 items
  4. Hanging Flower Baskets 3 items
  5. Hanging Planters 1 item
  6. Hanging Plants 1 item
  7. Home 48 items
  8. Keys 1 item
  9. Plants 29 items
  10. Plants, Bird Feeder, Windchime 1 item
  11. Plants, Bird Feeders, Windchimes 8 items
  12. Plants, Windchimes, Bird Feeders 5 items
  13. Shelf 1 item
  14. Shelves 6 items
  15. Wind Chimes 2 items
Subject
  1. Beach 1 item
  2. Bee 1 item
  3. Bereavement 3 items
  4. Bible Verse 2 items
  5. Black Lab 1 item
  6. Boxer Dog 66 items
  7. Butterfly 1 item
  8. Camping 1 item
  9. Cat 1 item
  10. Cats 1 item
  11. Christmas 3 items
  12. Dog 6 items
  13. Easter 1 item
  14. Fishing 1 item
  15. Fleur De Lis 2 items
  16. Home 1 item
  17. Inspiration 1 item
  18. Lake 5 items
  19. Lighthouses 1 item
  20. Sunflower 1 item
  21. United States 12 items
  22. Welcome 4 items
  23. Wine 2 items
  24. Yorkie 2 items
  25. You Need A Drink 1 item
Assembly Required
  1. No 121 items
Hook Style
  1. Antique 60 items
  2. Horseshoe 1 item
  3. Monkey Tails 16 items
  4. Nautical 1 item
  5. Tail 1 item
  6. Traditional 41 items
  7. Western 1 item
Shoe Shaft Style
  1. Ankle 2 items
  2. Low Top 119 items
Manufacturer
  1. Fitbit 1 item
  2. Flag Emotes 108 items
  3. Import Wholesales 5 items
  4. Kendra 1 item
  5. Maddison 5 items
  6. Shaun 1 item
Color
  1. Black 3 items
  2. Black, White, Red 1 item
  3. Blue 7 items
  4. Bronze 1 item
  5. Brown 58 items
  6. Gray 1 item
  7. Green 9 items
  8. Green, Yellow 10 items
  9. Multi-Color 2 items
  10. Multicolor 12 items
  11. Taupe 1 item
  12. Teal 13 items
  13. Verdigris 3 items
Us Shoe Size
  1. 13 118 items
  2. 7 1 item
  3. 7.5 1 item
  4. 8 1 item
Department
  1. Adult 3 items
  2. Adults 113 items
  3. Kids 1 item
  4. Men 1 item
  5. Unisex Adults 1 item
  6. Women 2 items
Occasion
  1. Activewear, Casual 16 items
  2. Any 8 items
  3. Bereavement 67 items
  4. Business 1 item
  5. Casual 2 items
  6. Christmas 2 items
  7. Easter 5 items
  8. Everyday 1 item
  9. Formal, Party/Cocktail, Travel, Wedding 1 item
  10. Halloween 14 items
  11. Inspirational 1 item
  12. Party/Cocktail 1 item
  13. Summer 4 items
  14. Travel 2 items
Lining Material
  1. Textile 121 items
Style
  1. Antique 3 items
  2. Antique Style 37 items
  3. Bootie 1 item
  4. Butterflies 4 items
  5. Clog 1 item
  6. Country 1 item
  7. Farm 1 item
  8. Flat 1 item
  9. French 2 items
  10. French Country 1 item
  11. Hummingbird 2 items
  12. Nautical 7 items
  13. Traditional 48 items
  14. Victorian 5 items
  15. Victorian Style 3 items
  16. Vintage/Retro 1 item
  17. Western 3 items
Upper Material
  1. Faux Suede 1 item
  2. Synthetic 120 items
Price
  1. $0.00 - $9.99 18 items
  2. $10.00 - $19.99 84 items
  3. $20.00 - $29.99 18 items
  4. $70.00 and above 1 item
Toe Shape
  1. Almond Toe 1 item
  2. Round Toe 119 items
  3. Square Toe 1 item
Closure
  1. Lace Up 118 items
  2. Slip On 2 items
  3. Zip 1 item
Heel Style
  1. Block 2 items
  2. Stiletto 119 items
Theme
  1. 80s, 90s, City 1 item
  2. Animal & Birds 1 item
  3. Beach 2 items
  4. Bereavement 2 items
  5. Black Lab 2 items
  6. Boxer Dog 10 items
  7. Camping 1 item
  8. Cats 2 items
  9. Chihuahua 2 items
  10. Christmas 1 item
  11. Dogs 1 item
  12. Easter 1 item
  13. Emergency Services 1 item
  14. Farmhouse 42 items
  15. Fire & Rescue 1 item
  16. Fishing 1 item
  17. Fleur De Lis 2 items
  18. Floral 4 items
  19. Flowers 1 item
  20. Golden Retriever 1 item
  21. Halloween 1 item
  22. Heart 1 item
  23. Holiday 4 items
  24. Home 1 item
  25. Horses Horses 2 items
  26. Inspirational 1 item
  27. Lighthouses 1 item
  28. Mermaids 1 item
  29. Nautical 1 item
  30. Outdoor 1 item
  31. Outdoor, Sports, University, Fashion 11 items
  32. Rhinestones 1 item
  33. Scripture 1 item
  34. Seahorse 1 item
  35. Skeleton Key 1 item
  36. Vintage 1 item
  37. Welcome 10 items
  38. Wine 1 item
  39. Yorkshire Terrier 1 item
Shoe Width
  1. Standard 121 items
Insole Material
  1. Foam 118 items
  2. Memory Foam 3 items
Fabric Type
  1. Knit 120 items
  2. Shearling 1 item
Season
  1. Fall 2 items
  2. Fall, Spring, Summer 1 item
  3. Fall, Spring, Summer, Winter 118 items
  4. Spring 2 items
  5. Summer 2 items
  6. Winter 1 item
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.