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: 143 | OUT OF STOCK: 1
ID SKU Name Stock Status
204 930907820004 Cast Iron Dinner Bell Green Farm Tractor Colorful IN STOCK (1)
229 273607820003 Halloween Garden Flag Trick Or Treat Double Sided IN STOCK (1)
236 272807820001 Welcome Garden Flag Lighthouse Yard Banner Beach D IN STOCK (1)
239 273207820002 Garden Flag Wine A Bit Funny Drinking Yard Banner IN STOCK (1)
242 273707820001 Happy Easter Garden Flag Wreath Bunny Eggs Double IN STOCK (1)
243 273207820010 Funny Dog Garden Flag Beware Of Dog Black Lab Labr IN STOCK (1)
244 273207820003 Cat Garden Flag Spoiled Cats Live Here Double Side IN STOCK (1)
245 272807820000 Beach Life Garden Flag Colorful Shells Double Side IN STOCK (1)
247 274007820001 Merry Christmas Garden Flag Winter Double Sided Ya IN STOCK (1)
249 272907820005 Welcome Garden Flag Pink Flowers Yard Banner Decor IN STOCK (1)
250 273207820000 Funny Cat Garden Flag Beware Of Cat Double Sided Y IN STOCK (1)
251 273207820011 Funny Black Lab Puppy Garden Flag Beware Of Dog Do IN STOCK (1)
254 274107820003 Happy Campers Garden Flag Double Sided Camping Yar IN STOCK (1)
257 272807820002 Bereavement Garden Flag Forever Loved Heart In Sky IN STOCK (1)
258 273207820014 Funny Boxer Garden Flag Beware Of Dog Double Sided IN STOCK (1)
773 273407820003 Heart Shaped Trivet Ornate Decorative Cast Iron Fl IN STOCK (1)
775 273407820005 Square Trivet Black Cast Iron Decorative Ornate Di IN STOCK (1)
777 273407820002 Cast Iron Trivet Round Ornate Heart Scrollwork Des IN STOCK (1)
776 273407820001 Decorative Cast Iron Trivet Ornate Heart Design Ro IN STOCK (1)
5 254007820003 Fleur De Lis & Vine Shelf Bracket Cast Iron Brace IN STOCK (1)
8 254107820010 Decorative Cast Iron Wall Shelf Bracket Brace DIY IN STOCK (1)
6 254107820011 Decorative Shelf Bracket Flower Leaf Brace Distres IN STOCK (1)
10 254107820009 Cast Iron Wall Shelf Bracket Ornate Brace 10" Deep IN STOCK (1)
1130 019700410016 Cast Iron Wall Hook Rack Antique Skeleton Key 3 Ho IN STOCK (1)
328 019707820009 Horse Head Western Wall Hook Rust Brown Cast Iron IN STOCK (1)
329 019700410014 Mermaid Wall Hook Rust Cast Iron Coat Hanger Ocean IN STOCK (1)
169 254007820000 Wall Shelf Bracket Decorative Cast Iron Brace Humm IN STOCK (1)
1164 229207820005 Please Close The Gate Sign Decorative Plaque Cast IN STOCK (1)
1165 274207820001 Chicken Trivet Decorative Cast Iron Hot Pad 7.75" IN STOCK (1)
26 254107820027 Wall Shelf Bracket Distressed White Ornate Cast Ir IN STOCK (1)
29 254107820012 Decorative Shelf Bracket Ornate Leaf Brace Rust Br IN STOCK (1)
170 012600410004 Wall Shelf Bracket Leaf Vine Pattern Cast Iron Bra IN STOCK (1)
176 254107820004 Cast Iron Wall Shelf Bracket Brace Vine & Flower R IN STOCK (1)
193 019707820013 Double Wall Hook Decorative Antique Style Coat & H IN STOCK (1)
780 203707820000 Decorative Cast Iron Trivet Chilli Peppers Kitchen IN STOCK (1)
794 IWSTS0018 Cast Iron Footprint Stepping Stones - Garden Pathw IN STOCK (1)
793 269907820001 Butterfly Stepping Stone Verdigris Cast Iron 11" W IN STOCK (1)
182 254107820018 Decorative Shelf Bracket - Hexagon Lattice - Rust IN STOCK (1)
1173 275453524384 Vintage Cracker Jack Gumball prize charm Man on R IN STOCK (1)
1172 275453521123 Vintage Cracker Jack Gumball prize charm celluloid IN STOCK (1)
1193 276301204436 Baby Proofing American Electrical Outlet Safety Co IN STOCK (1)
1192 229207820003 Cast Iron Plaque Sign - Please Close The Gate - Bl IN STOCK (1)
770 276821346666 Dearfoams Women's Pumpkin Slide Slippers Jack-O-La IN STOCK (1)
215 273207820009 Golden Retriever Garden Flag Emotes Beware Of Dog IN STOCK (1)
228 272907820004 Welcome Garden Flag Yellow Tulips Double Sided Yar IN STOCK (1)
232 272907820011 Bible Verse Garden Flag Deuteronomy 31:6 Be Strong IN STOCK (1)
241 272807820003 Fleur De Lis Garden Flag Emotes Double Sided Welco IN STOCK (1)
235 272707820000 Beach Life Rocks Garden Flag Live Laugh Love Doubl IN STOCK (1)
263 273307820000 Duck Family Plant Hanger Flower Basket Hook Colorf IN STOCK (1)
238 273607820001 Happy Halloween Garden Flag Witches Trick Or Treat IN STOCK (1)
256 274007820002 Merry Christmas Garden Flag Flannel Evergreen Tree IN STOCK (1)
273 255707820014 Chickadee Bird S Style Plant Hook Cast Iron Flower IN STOCK (1)
779 203707820001 Tea Kettle Trivet Ornate Decorative Cast Iron Kitc IN STOCK (1)
186 019700410031 Cast Iron Wall Hook Verdigris Seahorse 5.5" Tall N IN STOCK (1)
166 273007820002 Seed Feeder Bird Bath Cast Iron Wall Mounted 9.75" IN STOCK (1)
30 197100410009 Wall Shelf Bracket Brace Black Cast Iron Scrolling IN STOCK (1)
205 930907820008 Cast Iron Dinner Bell Rooster & Flowers Colorful D OUT OF STOCK (0)
33 254007820008 Hummingbird Wall Shelf Bracket Cast Iron Brace Cra IN STOCK (1)
335 019707820017 Wall Hook Coat Rack Birds On Fence 3 Cast Iron Hoo IN STOCK (1)
1269 019707820007 Skeleton Key Style Wall Hook Coat Rack Victorian 4 IN STOCK (1)
183 254107820019 Shelf Bracket Brace For Custom Shelving Leaf & Vin IN STOCK (1)
846 286278494687 Allegra K Women's Lace Mesh Floral Embroidered Sti IN STOCK (1)
849 286278436738 Women's Aurora Water Shoes Black Sz 6 IN STOCK (1)
2049 286364704411 Playtex Finger Puppets Set – 5pc Jungle Animal B IN STOCK (1)
2051 286367402132 Decorative Cast Iron Snail Stepping Stone – Gard IN STOCK (1)
2057 197100410002 Cast Iron Shelf Bracket Fleur-de-Lis Wall Brace De IN STOCK (1)
2053 286367593981 New England Patriots Rawlings Cooler Tote Holds 30 IN STOCK (1)
28 254107820022 Wall Shelf Bracket Brown Cast Iron Brace Custom Sh IN STOCK (1)
222 273207820004 Yorkie Garden Flag Beware Of Dog Yard Decor Funny IN STOCK (1)
225 273207820001 Custom Dog Garden Flag Personalized Pet Photo & Na IN STOCK (1)
220 272907820008 Welcome Garden Flag Yellow Butterfly Double Sided IN STOCK (1)
227 273807820000 Fire & Rescue Garden Flag Firemans Cross Firefight IN STOCK (1)
219 272907820014 Double Sided Garden Flag Emotes Welcome To The Nut IN STOCK (1)
200 930907820001 Cast Iron Dinner Bell Moose Welcome Sign Outdoor D IN STOCK (1)
234 272907820002 WTF Where's The Fish Garden Flag Double Sided Yard IN STOCK (1)
233 272907820000 Welcome Garden Flag Monarch Butterfly Double Sided IN STOCK (1)
1129 163807820002 Firefighting Aluminum Sign Firemans St Florian Mal IN STOCK (1)
1128 198507820001 Double Sided Hanging Welcome Sign Squirrel Eating IN STOCK (1)
326 019707820000 Nautical Black & White Lighthouse Wall Hook Decora IN STOCK (1)
330 019707820004 Wall Hook Skeleton Key Coat Rack Antique Style 3 H IN STOCK (1)
333 019707820003 Seahorse Wall Hook Ocean Decor Rust Brown Decorati IN STOCK (1)
788 246407820002 LARGE Turtle Stepping Stone Paver Decorative Cast IN STOCK (1)
1166 198507820003 Double Sided Hanging Welcome Sign Ornate Cast Iron IN STOCK (1)
184 254107820026 Cast Iron Wall Shelf Bracket Brace Columns Distres IN STOCK (1)
32 254107820002 Angle Bracket Cast Iron Wall Shelf Brace Decorativ IN STOCK (1)
172 254107820029 Wall Shelf Bracket Brace Ornate Vine Brown Cast Ir IN STOCK (1)
192 019707820021 Cast Iron Wall Hook Rack Tropical Fish & Coral Dec IN STOCK (1)
1167 274811615606 Harley Quinn Costume Girl M (8-10) DC Super Hero G IN STOCK (1)
181 254107820016 Decorative Shelf Bracket - Ornate Lattice - Rust B IN STOCK (1)
1174 275453537797 Vintage Cracker Jack Gumball prize charm faded pur IN STOCK (1)
1175 275458939770 vintage Cracker Jack Gumball charm prize toy: Gree IN STOCK (1)
1176 275458944602 vintage Cracker Jack Gumball charm prize toy: Red IN STOCK (1)
1180 275459274008 vintage Cracker Jack charm prize Metallized Plasti IN STOCK (1)
1177 275458949486 vintage Cracker Jack charm prize Boy on Bicycle (m IN STOCK (1)
1179 275459221209 vintage Cracker Jack charm prize Silvery Plastic P IN STOCK (1)
764 276816918998 Dearfoams Men's Shearling Side Stitch Moc Slippers IN STOCK (1)
774 273907820001 Decorative Cast Iron Trivet Owl Hot Pad Kitchen De IN STOCK (1)
221 272907820006 Welcome Garden Flag Pink Dogwood Tree Double Sided IN STOCK (1)
223 273807820001 Firefighting Garden Flag Fire & Rescue Double Side IN STOCK (1)
252 272907820013 He Is Risen Garden Flag Easter Yard Banner Double IN STOCK (1)
237 272807820004 Custom Pet Bereavement Garden Flag Emotes Forever IN STOCK (1)
240 272907820003 Welcome Garden Flag Purple & White Tulips Double S IN STOCK (1)
246 272907820001 Bible Verse Garden Flag Psalm 62:5 My Soul Double IN STOCK (1)
255 272907820012 Inspirational Garden Flag Psalm 34:4 I Sought The IN STOCK (1)
261 273107820000 Fleur De Lis Plant Hanger Ornate Cast Iron flower IN STOCK (1)
248 273607820002 Halloween Garden Flag Happy Haunting Trick Or Trea IN STOCK (1)
268 255707820011 Butterfly Plant Hanger Bracket Flower Pot Basket H IN STOCK (1)
12 254207820000 Nautical Shelf Bracket Clamshell Beach Shell Brace IN STOCK (1)
267 255707820013 Bluejay S Style Plant Hook Cast Iron Flower Basket IN STOCK (1)
272 272607820002 Plant Hanger Hanging Pot Flower Basket Hook Grape IN STOCK (1)
778 203707820002 Decorative Cast Iron Fish Trivet Kitchen Decor Hot IN STOCK (1)
16 254007820004 Wall Shelf Bracket Brace Fleur De Lis Verdigris Ca IN STOCK (1)
17 254007820007 Fleur De Lis Wall Shelf Bracket Cast Iron Ornate B IN STOCK (1)
274 272607820006 Rose Flower Bloom S Style Plant Hook Cast Iron Flo IN STOCK (1)
188 019707820012 Decorative Coat Hook Victorian Ornate Double Wall IN STOCK (1)
191 019707820010 Decorative Triple Wall Hook Cast Iron Coat Hat Sca IN STOCK (1)
190 019707820005 Wall Hook Coat Rack Victorian Skeleton Key Style 3 IN STOCK (1)
167 273007820005 Hanging Heart Shaped Love Bird Feeder Or Bath 5.5" IN STOCK (1)
31 254007820001 Decorative Cast Iron Wall Shelf Bracket Brace Bird IN STOCK (1)
174 254107820031 Wall Shelf Bracket Ornate Vine Distressed White Ca IN STOCK (1)
178 254107820025 Decorative Wall Shelf Bracket Simple Vine Rust Bro IN STOCK (1)
334 019707820018 Horse Head Horseshoe Western Double Wall Hook Rust IN STOCK (1)
792 246407820003 Decorative Baby Turtles Stepping Stone Rust Cast I IN STOCK (1)
179 197100410004 Wall Shelf Bracket - Ornate Pattern - Black Cast I IN STOCK (1)
762 286251265340 Dearfoams Women's Pumpkin Slide Slippers Jack-O-La IN STOCK (1)
759 286251193844 Isotoner Genuine Suede Women's Moccasin Slip-On Sl IN STOCK (1)
760 286251207844 Dearfoams Women's Shearling Scuff Slippers Chestnu IN STOCK (1)
2043 266207820000 Welcome Stepping Stone Cast Iron Lawn Garden Decor IN STOCK (1)
2046 286347914467 dearfoams Kids' Dave Quilted Slide Slippers - Navy IN STOCK (1)
2065 286393541437 Women's Mel Rhinestone Mesh Ballet Flats Silver / 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)
2066 286393686543 Victrola Eastwood Signature Record Player With Blu IN STOCK (1)
217 273207820006 White Chihuahua Puppy Beware Of Dog Double Sided F IN STOCK (1)
218 273207820007 Dark Brown Chihuahua Beware Of Dog Funny Pet Doub IN STOCK (1)
224 272907820009 Welcome Garden Flag Sunflower Floral Double Sided IN STOCK (1)
230 272907820007 Welcome Friends Garden Flag Orange Flower Yard Dec IN STOCK (1)
226 273507820001 Welcome To The Lake Garden Flag Cabin Double Sided IN STOCK (1)
198 930907820006 Cast Iron Dinner Bell Love Birds Distressed Brown IN STOCK (1)
201 930907820007 Cast Iron Dinner Bell Ornate Vine Doorbell Porch D IN STOCK (1)
253 272907820018 Home Is Where The Heart Is Floral Garden Flag Emot IN STOCK (1)
231 272907820010 Welcome Garden Flag Floral Decor Orange Green Flow IN STOCK (1)
262 272607820007 Blooming Flower S Style Plant Hook Cast Iron Flowe IN STOCK (1)
260 272607820000 Oak Tree Leaf & Acorn Plant Hanger Decorative Cast 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-144 of 144

Set Descending Direction
Page
per page
Copyright © 2023-present Chillicothe Market All rights reserved.