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: 115 | OUT OF STOCK: 5
ID SKU Name Stock Status
3116 286550850989 Funko POP! #1352 Indiana Jones SALLAH Vinyl Figure OUT OF STOCK (0)
11974 286568410736 Kamado Joe JoeTisserie 24 inch Big Joe Grill Rotis OUT OF STOCK (0)
911 286297875467 Wireless Meat Thermometer Meater Plus Digital Exte IN STOCK (1)
3117 286550852026 Funko Pop! Vinyl: Indiana Jones - Indiana Jones #1 IN STOCK (1)
11961 286566328311 Kenwood KFC 1666R 6.5 Inch Coaxial Car Speakers 30 IN STOCK (1)
11962 286565954268 Pioneer A-Series TS-A653FH 6.5" 2-Way 340 W Max Po IN STOCK (1)
11963 286563364559 Pioneer 2-Way Speaker TS-G650 300W Max 6 1/2 / 6 3 IN STOCK (1)
11965 286556227610 The Object of Beauty DVD Movie Full Screen John Ma IN STOCK (1)
11966 286556269735 Kenwood - Road Series 12" Single Voice Coil 4-Ohm IN STOCK (1)
11967 286560717312 Kenwood - Road Series 12" Single Voice Coil 4-Ohm IN STOCK (1)
11968 286560727712 Kenwood - Road Series 12" Single Voice Coil 4-Ohm IN STOCK (1)
11969 286563505562 OEM Dyson V15 Detect Laser Slim Fluffy Optic Clean OUT OF STOCK (0)
11970 286563566917 Genuine Dyson Wall Mount Docking Station for V11 / IN STOCK (1)
11971 286566095118 Core Innovations - Amplified Bar HDTV Indoor Anten IN STOCK (1)
11972 286568323356 Baby Monitor VTech DM221 Digital Audio Talk Back I IN STOCK (1)
11973 286568347758 CyberPower 650VA Battery Back-Up System 360W - Bla IN STOCK (1)
13279 286571172223 Pioneer TS-WX1010A - 10" Active Sealed subwoofer w IN STOCK (1)
13400 286571370525 Kenwood KSC-PSW8 8" Class-D Compact Powered Subwoo IN STOCK (1)
14633 286573689044 Kenwood KSC-PSW8 8" Class-D Compact Powered Subwoo IN STOCK (1)
19014 286581315080 Wireless Meat Thermometer Meater Plus Digital Exte IN STOCK (1)
20802 286584503041 Vava EVOLVE Split View Screen Baby Monitor (2x 720 IN STOCK (1)
23561 286589557366 Govee RGBIC LED Strip Lights, 16.4ft Smart LED Lig IN STOCK (1)
953 257407650009 Real Sand Castle Figurine 118 4" Tall Collectible IN STOCK (1)
1130 019700410016 Cast Iron Wall Hook Rack Antique Skeleton Key 3 Ho IN STOCK (1)
1138 144307820002 Aluminum Sign You Need A Drink Home Bar Man Cave B 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)
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)
1573 276833228749 Journee Collection Womens Livvy Back Heel Zip Stac IN STOCK (1)
1654 276889348003 dearfoams Kids' Good Vibes Slide Slippers - Hot Pi IN STOCK (1)
1657 276912425839 Apple EarPods with 3.5mm Plug – Wired In-Ear Hea IN STOCK (1)
1682 276931109905 Women's Mel Rhinestone Mesh Ballet Flats Silver / IN STOCK (1)
1678 930907820002 Rustic Cast Iron Welcome Bell Vintage Wall Mount D IN STOCK (1)
1679 276928818201 Allegra K Women's T Strap Open Toe Platform Stilet 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)
1706 272607820008 S-Hook Plant Hanger Flower Basket Decor Rustic Bro IN STOCK (1)
1709 276983831741 Rocketfish 8k Ultra High Speed 15ft HDMI Cable 48 IN STOCK (1)
1708 276981428196 WWE Elite Collection Undertaker Figure - Best of 2 IN STOCK (1)
1714 276987123754 Helios In-Wall Power Outlet Relocation Kit Cable P IN STOCK (1)
1720 254107820007 Ornate Cast Iron Shelf Bracket Decorative Corner S IN STOCK (1)
1716 276987506055 Women's Shannon Heels with Memory Foam Insole Sz 6 IN STOCK (1)
1726 272907820017 Unicorn Garden Flag Rainbow Yard Banner – "Unico IN STOCK (1)
1727 019700410046 Cast Iron Wall Hook Rack Fish Bone Skeleton Hooks IN STOCK (1)
1724 246407820001 13" Brown Cast Iron Turtle Stepping Stone Decorati IN STOCK (1)
1733 272907820015 Thankful Grateful Blessed Fall Leaves Garden Flag IN STOCK (1)
1732 000000410068 Disney Princess Self Stick Removable Appliques Wal IN STOCK (1)
1734 163807820003 Aluminum Sign Firemans Cross White Firefighting Pl IN STOCK (1)
1740 142307820000 Aluminum Sign Coffee Cappuccino Mocha Espresso Fra IN STOCK (1)
1738 273007820003 Cast Iron Pedestal Bird Feeder Bath 8" Wide Decora IN STOCK (1)
1739 930907820000 Cast Iron Horse Dinner Bell – Rustic Brown Wall IN STOCK (1)
1744 261207820002 Funny Aluminum Sign No Poop Heads Allowed Man & Wo IN STOCK (1)
1750 277025938599 Yardbird Fire Table Cover CVFTRERB Rectangular Bei IN STOCK (1)
1756 277037812053 Genuine Amazon Alexa Voice Remote (3rd Gen) with T IN STOCK (1)
1758 277039604836 Nick JR Dora The Explorer Wall Sticker Decal Nicke IN STOCK (1)
1755 277037180702 SaharaCase - Office Mouse Pad with Wireless Chargi IN STOCK (1)
1768 277056810230 The Jimi Hendrix Experience Electric Ladyland Dbl IN STOCK (1)
1767 277056763782 The Jimi Hendrix Experience Electric Ladyland Dbl IN STOCK (1)
1766 163807820000 Firefighting Firemans Cross Hanging Wall Plaque Ru IN STOCK (1)
1775 277061995342 MICHAEL BUBLE' - "Michael Buble' Christmas" Christ IN STOCK (1)
2404 277064207987 Carrie Underwood My Gift First-Ever Christmas Albu IN STOCK (1)
2405 277064611176 Yogasleep Rohm Portable White Noise Machine Travel IN STOCK (1)
2406 277066203475 CASETiFY - Ultra Impact Bounce Case for Apple AirP IN STOCK (1)
3071 277069846799 CASETiFY - Mirror Airpods Case for Apple AirPods P OUT OF STOCK (0)
3072 277069870238 Kate Spade New York - Protective Case Apple Airpod IN STOCK (1)
3085 277074520169 Yogasleep Hushh White Noise Machine Portable Sound IN STOCK (1)
1822 266107820001 Funny Dachshund Sign Don't Trip Over My Wiener Dog IN STOCK (1)
1819 144307820001 Personalized Man Cave Aluminum Sign Custom Dartboa IN STOCK (1)
1681 276928972258 Fitbit Versa 4 Fitness Smartwatch FB523BKBK NO Cha IN STOCK (1)
3113 277093424276 FUNKO POP! MOVIES: The Last Crusade - Henry Jones IN STOCK (1)
3112 277093398774 FUNKO POP! MOVIES: Raiders of the Lost Ark - Arnol IN STOCK (1)
3111 277093334750 SUPER7 RUN DMC Joseph "RUN" Simmons ReAction Figur IN STOCK (1)
11956 277098598300 The Real Mccoy DVD Action Crime Kim Basinger Val K IN STOCK (1)
14741 277115995062 CoComelon My First Sing-Along Boombox Music Toy Mi IN STOCK (1)
1823 829800250004 Longaberger Traditions Handle Tie Collectible Acce IN STOCK (1)
1833 218107280003 Holiday Home Snowman Pattern Mug China Tableware C IN STOCK (1)
1834 268507820000 Lady Bug Hide A Key Box Distressed Brown Cast Iron IN STOCK (1)
1835 198507820000 Welcome Garden Sign Pink Flowers Black Cast Iron Y IN STOCK (1)
1842 137607820000 Aluminum Sign You Need A Beer Home Bar Man Cave Wa IN STOCK (1)
1872 272207820000 Large Rolling Plant Caddy Fleur De Lis IN STOCK (1)
1873 273607820000 Decorative Cast Iron Rooster Trivet Kitchen Decor IN STOCK (1)
1874 197107820000 Turtle Hide A Key Box Distressed Brown Cast Iron G IN STOCK (1)
1876 229207820004 Cast Iron Plaque Sign - Beware Of The Dog - Black IN STOCK (1)
1875 284109859464 Disney’s Baby Mickey Mouse Wall Border ABC Nurse IN STOCK (1)
1877 284292040564 Baby Einstein Four Fundamentals 5 Developmental Ac IN STOCK (1)
1269 019707820007 Skeleton Key Style Wall Hook Coat Rack Victorian 4 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)
901 286294130286 Traeger Timberline Outdoor Kitchen Trim Kit Black IN STOCK (1)
1989 286292297452 Men's Joshua Slide Sandals Tan 8 Unworn Condition IN STOCK (1)
1969 286290556641 Dr. Scholl's Women's Janette Slip Resistant Shoes, 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)
2080 237107820000 Human Footprint Stepping Stone Pair Feet Cast Iron IN STOCK (1)
2078 286416733183 Genuine Apple - EarPods with Lightning Connector - IN STOCK (1)
1693 276955627052 Women's Marcia Lace up Heels with Memory Foam Inso IN STOCK (1)
2088 273207820012 Funny Garden Flag Roses Are Red So Is My Wine Doub IN STOCK (1)
2085 286430295408 Google Pixel Watch 41mm Matte Black Stainless Stee IN STOCK (1)
2350 286444772480 CyberPower 750VA Slim Line Battery Back-Up UPS 8 O IN STOCK (1)
2354 286449720137 Mcfarlane Batman DC Retro 66 Classics TV Series Ro IN STOCK (1)
2353 286449705459 McFarlane DC Retro Classic Batman 1966 6 Inch Figu IN STOCK (1)
2363 019707820019 Decorative Double Wall Hook Love Birds Rust Brown IN STOCK (1)
2360 019707820020 Rustic Cast Iron Antler Wall Hook Rack Deer Lodge IN STOCK (1)
2361 286459777773 Peerless AV Peerless-AV ST650P Tilt TV Wall Mount OUT OF STOCK (0)
2370 273707820002 Happy Easter Angel & Lamb Garden Flag Emotes Doubl IN STOCK (1)
2368 286467319047 Hyde & Eek Halloween Women’s Glow-In-The-Dark Sk IN STOCK (1)
2367 019707820006 Cast Iron Skeleton Key Wall Hook Rack – 3 Hook R IN STOCK (1)
2374 286476757005 Ooni Digital Infrared Thermometer Pizza Oven Calib IN STOCK (1)
2377 286477126573 Cyberpower SE450G1 450 VA Battery Backup UPS 8-Out IN STOCK (1)
2373 286476641474 Bromic BH3130010-1 On/Off Switch for Electric and IN STOCK (1)
2381 286485819828 MOBICam HDX Smart HD Pan & Tilt Wi-Fi Baby Monitor IN STOCK (1)
2380 286479184706 Yardbird Harriet Sofa Cover CVHA100 Beige Outdoor IN STOCK (1)
2379 286479095271 Yardbird - Harriet Fixed and Swivel Chair Cover - IN STOCK (1)
2398 286514389783 The Raid: Redemption [New 4K UHD Blu-ray] Ltd Ed, 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-120 of 226

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