Toggle Nav
My Cart
Search
Advanced Search

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: 93 | OUT OF STOCK: 0 | First In-Stock at position: 1
# ID SKU Name Stock Status
1 773 273407820003 Heart Shaped Trivet Ornate Decorative Cast Iron Fl IN STOCK (1)
2 774 273907820001 Decorative Cast Iron Trivet Owl Hot Pad Kitchen De IN STOCK (1)
3 792 246407820003 Decorative Baby Turtles Stepping Stone Rust Cast I IN STOCK (1)
4 793 269907820001 Butterfly Stepping Stone Verdigris Cast Iron 11" W IN STOCK (1)
5 794 IWSTS0018 Cast Iron Footprint Stepping Stones - Garden Pathw IN STOCK (1)
6 1164 229207820005 Please Close The Gate Sign Decorative Plaque Cast IN STOCK (1)
7 1678 930907820002 Rustic Cast Iron Welcome Bell Vintage Wall Mount D IN STOCK (1)
8 1724 246407820001 13" Brown Cast Iron Turtle Stepping Stone Decorati IN STOCK (1)
9 1727 019700410046 Cast Iron Wall Hook Rack Fish Bone Skeleton Hooks IN STOCK (1)
10 1736 322207820000 Fish Pocket Beer Bottle Opener Handheld Brown Cast IN STOCK (1)
11 1737 273707820003 Happy Easter Spring Flowers Birds Garden Flag Emot IN STOCK (1)
12 1738 273007820003 Cast Iron Pedestal Bird Feeder Bath 8" Wide Decora IN STOCK (1)
13 1739 930907820000 Cast Iron Horse Dinner Bell – Rustic Brown Wall IN STOCK (1)
14 1740 142307820000 Aluminum Sign Coffee Cappuccino Mocha Espresso Fra IN STOCK (1)
15 1791 273907820002 Frog Hide A Key Box Distressed Brown Cast Iron Gar IN STOCK (1)
16 1819 144307820001 Personalized Man Cave Aluminum Sign Custom Dartboa IN STOCK (1)
17 1822 266107820001 Funny Dachshund Sign Don't Trip Over My Wiener Dog IN STOCK (1)
18 1874 197107820000 Turtle Hide A Key Box Distressed Brown Cast Iron G IN STOCK (1)
19 2051 286367402132 Decorative Cast Iron Snail Stepping Stone – Gard IN STOCK (1)
20 2057 197100410002 Cast Iron Shelf Bracket Fleur-de-Lis Wall Brace De IN STOCK (1)
21 2080 237107820000 Human Footprint Stepping Stone Pair Feet Cast Iron IN STOCK (1)
22 2081 272607820003 13.75" Cast Iron Plant Hanger Bracket – Decorati IN STOCK (1)
23 2358 255707820018 Cast Iron Plant Hanger Bracket Hummingbird Vine Ho IN STOCK (1)
24 2360 019707820020 Rustic Cast Iron Antler Wall Hook Rack Deer Lodge IN STOCK (1)
25 2363 019707820019 Decorative Double Wall Hook Love Birds Rust Brown IN STOCK (1)
26 2364 148107820000 Video Gaming Aluminum Sign Gamer Zone Characters C IN STOCK (1)
27 2365 273207820008 French Bulldog Beware Of Dog Double Sided Funny Pe IN STOCK (1)
28 2366 261207820001 Funny Aluminum Sign No Poop Heads Allowed Women Ho IN STOCK (1)
29 2367 019707820006 Cast Iron Skeleton Key Wall Hook Rack – 3 Hook R IN STOCK (1)
30 2 273707820000 Ornate Heart Shelf Bracket Decorative Rust Brown C IN STOCK (1)
31 5 254007820003 Fleur De Lis & Vine Shelf Bracket Cast Iron Brace IN STOCK (1)
32 6 254107820011 Decorative Shelf Bracket Flower Leaf Brace Distres IN STOCK (1)
33 7 254007820002 Wall Shelf Bracket Fleur De Lis Cast Iron Brace Br IN STOCK (1)
34 8 254107820010 Decorative Cast Iron Wall Shelf Bracket Brace DIY IN STOCK (1)
35 10 254107820009 Cast Iron Wall Shelf Bracket Ornate Brace 10" Deep IN STOCK (1)
36 12 254207820000 Nautical Shelf Bracket Clamshell Beach Shell Brace IN STOCK (1)
37 16 254007820004 Wall Shelf Bracket Brace Fleur De Lis Verdigris Ca IN STOCK (1)
38 17 254007820007 Fleur De Lis Wall Shelf Bracket Cast Iron Ornate B IN STOCK (1)
39 22 254107820005 Wall Shelf Bracket Cast Iron Shelves Brace Ornate IN STOCK (1)
40 198 930907820006 Cast Iron Dinner Bell Love Birds Distressed Brown IN STOCK (1)
41 200 930907820001 Cast Iron Dinner Bell Moose Welcome Sign Outdoor D IN STOCK (1)
42 201 930907820007 Cast Iron Dinner Bell Ornate Vine Doorbell Porch D IN STOCK (1)
43 203 930907820005 Cast Iron Dinner Bell Butterfly Floral Vine Doorbe IN STOCK (1)
44 261 273107820000 Fleur De Lis Plant Hanger Ornate Cast Iron flower IN STOCK (1)
45 262 272607820007 Blooming Flower S Style Plant Hook Cast Iron Flowe IN STOCK (1)
46 263 273307820000 Duck Family Plant Hanger Flower Basket Hook Colorf IN STOCK (1)
47 264 255707820015 Decorative Plant Hanger Chickadee Bird Brown Cast IN STOCK (1)
48 265 255707820010 Large Plant Hanger Basket Hook Hummingbird & Flowe IN STOCK (1)
49 266 110102740003 Green Hummingbird Large Plant Hanger Cast Iron Flo IN STOCK (1)
50 267 255707820013 Bluejay S Style Plant Hook Cast Iron Flower Basket IN STOCK (1)
51 268 255707820011 Butterfly Plant Hanger Bracket Flower Pot Basket H IN STOCK (1)
52 269 255707820009 Cast Iron S Style Plant Hook Colorful Bird Flower IN STOCK (1)
53 270 255707820019 Cast Iron Plant Hanger Hook Butterflies & Sunflowe IN STOCK (1)
54 271 272607820009 Decorative Plant Hanger Curly Vine Brown Cast Iron IN STOCK (1)
55 272 272607820002 Plant Hanger Hanging Pot Flower Basket Hook Grape IN STOCK (1)
56 273 255707820014 Chickadee Bird S Style Plant Hook Cast Iron Flower IN STOCK (1)
57 274 272607820006 Rose Flower Bloom S Style Plant Hook Cast Iron Flo IN STOCK (1)
58 275 019707820011 Triple Wall Hook For Coat Hat & Scarf Or Bath Towe IN STOCK (1)
59 276 019707820014 Cast Iron Wall Hook Rack Ornate Victorian 4 Key Ho IN STOCK (1)
60 277 255707820001 Decorative Horse Head Plant Hanger Cast Iron flowe IN STOCK (1)
61 279 255700410004 Hummingbird Plant Hanger Cast Iron Flower Basket H IN STOCK (1)
62 282 255700410002 Cast Iron Plant Hanger Ornate Pattern 10" Long Yar IN STOCK (1)
63 284 255707820020 Plant Hanger Chickadee Bird Cast Iron Flower Baske IN STOCK (1)
64 285 255707820012 Hummingbird S Style Plant Hook Cast Iron Flower Ba IN STOCK (1)
65 286 273007820001 Crowing Rooster Cast Iron Plant Hanger Farm Flower IN STOCK (1)
66 287 255707820007 Cast Iron S Style Plant Hook Hummingbird flower ba IN STOCK (1)
67 297 272607820010 Plant Hanger Vine Brown Flower Basket Pot Hook Hol IN STOCK (1)
68 298 255707820016 Love Birds Cast Iron Decorative Plant Hanger Flowe IN STOCK (1)
69 299 255707820017 Birds In Tree Decorative Plant Hanger Cast Iron Fl IN STOCK (1)
70 300 272607820001 Rustic Cast Iron Plant Hanger Bracket Floral Desig IN STOCK (1)
71 301 110100410001 Cast Iron Plant Hanger Basket Hook Pixie Fairy Rus IN STOCK (1)
72 303 110100410004 Decorative Chickadee Bird Design Cast Iron Plant H IN STOCK (1)
73 304 255707820006 Decorative Watering Can Cast Iron Plant Hanger Hoo IN STOCK (1)
74 305 019707820016 Monkey Wall Hook Rack With 4 Cast Iron Hooks 10.25 IN STOCK (1)
75 310 820102740000 Cast Iron Garden Hose Holder Floral & Spade Patter IN STOCK (1)
76 311 820107820010 Garden Hose Holder Reel Cast Iron Hanger Birds On IN STOCK (1)
77 313 820107820009 Cast Iron Garden Hose Holder Love Birds Garden Hos IN STOCK (1)
78 314 820107820014 Garden Hose Holder Hanger - Black Cast Iron Floral IN STOCK (1)
79 315 820107820012 Garden Water Hose Holder Birds In Tree Cast Iron H IN STOCK (1)
80 316 820107820003 Garden Hose Holder Gnome & Bunny Rabbit Distressed IN STOCK (1)
81 318 820107820013 Wall Mount Garden Hose Holder Floral & Spade Verdi IN STOCK (1)
82 319 820107820000 Garden Hose Holder Cast Iron Hanger Reel Watering IN STOCK (1)
83 320 256207820001 Garden Hose Guide Bird On Daisy Cast Iron Decorati IN STOCK (1)
84 321 256207820002 Decorative Garden Hose Guide Bird On Rose Cast Iro IN STOCK (1)
85 322 820107820002 Garden Hose Holder Water Pail Bucket Verdigris Cas IN STOCK (1)
86 325 820100410001 Hose Holder Reel Cast Iron Horse & Horseshoe Yard IN STOCK (1)
87 326 019707820000 Nautical Black & White Lighthouse Wall Hook Decora IN STOCK (1)
88 328 019707820009 Horse Head Western Wall Hook Rust Brown Cast Iron IN STOCK (1)
89 329 019700410014 Mermaid Wall Hook Rust Cast Iron Coat Hanger Ocean IN STOCK (1)
90 330 019707820004 Wall Hook Skeleton Key Coat Rack Antique Style 3 H IN STOCK (1)
91 333 019707820003 Seahorse Wall Hook Ocean Decor Rust Brown Decorati IN STOCK (1)
92 334 019707820018 Horse Head Horseshoe Western Double Wall Hook Rust IN STOCK (1)
93 335 019707820017 Wall Hook Coat Rack Birds On Fence 3 Cast Iron Hoo 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 93

Set Descending Direction
Page
per page
  1. Primary Color Brown Remove This Item
  2. Manufacturer Flag Emotes Remove This Item
Clear All
Shopping Options
Compare Products
You have no items to compare.
My Wish List
Last Added Items
You have no items in your wish list.
Copyright © 2023-present Chillicothe Market All rights reserved.