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: 139 | OUT OF STOCK: 6
ID SKU Name Stock Status
3116 286550850989 Funko POP! #1352 Indiana Jones SALLAH Vinyl Figure OUT OF STOCK (0)
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)
1998 286320126330 Courtney Sneakers Memory Foam Insole Shoes Light B IN STOCK (1)
3115 286549184208 Women's Darla Platform Mule Heels Black 6 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)
11969 286563505562 OEM Dyson V15 Detect Laser Slim Fluffy Optic Clean OUT OF STOCK (0)
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)
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)
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)
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)
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)
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)
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)
779 203707820001 Tea Kettle Trivet Ornate Decorative Cast Iron Kitc IN STOCK (1)
784 266107820000 Welcome To My Garden Hummingbird Stepping Stone Pl IN STOCK (1)
781 274207820000 Cast Iron Nautical Anchor Trivet Hot Plate Rustic IN STOCK (1)
30 197100410009 Wall Shelf Bracket Brace Black Cast Iron Scrolling IN STOCK (1)
33 254007820008 Hummingbird Wall Shelf Bracket Cast Iron Brace Cra 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)
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)
753 286264953134 Women's Spencer Fashion Sneakers Cheetah Print Sho 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)
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)
28 254107820022 Wall Shelf Bracket Brown Cast Iron Brace Custom Sh 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)
2396 286514205283 Absolutely Fabulous: Absolutely All of It! New DVD IN STOCK (1)
2397 286514279050 Horror Hall of Fame Movie 5 DVD Boxset 26 Classic IN STOCK (1)
2408 286523721442 Blue's Clues Wall Stickers Kids Bedroom Decor Nick IN STOCK (1)
2409 286524824693 Nickelodeon Rug Rats Kids Bedroom Wall Decor Stick IN STOCK (1)
3105 286536199218 Fitbit Charge 5 Fitness and Health Tracker Smart W IN STOCK (1)
3102 286533522689 Looking Glass DVD Movie, 2018 Nicolas Cage Brand N 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)
785 272507820003 Heart & Foot Prints Welcome Plaque Cast Iron Stepp IN STOCK (1)
24 254107820001 Decorative Angle Bracket Cast Iron Shelf Brace Gol 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)
32 254107820002 Angle Bracket Cast Iron Wall Shelf Brace Decorativ IN STOCK (1)
1167 274811615606 Harley Quinn Costume Girl M (8-10) DC Super Hero G 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)
774 273907820001 Decorative Cast Iron Trivet Owl Hot Pad Kitchen De IN STOCK (1)
3093 277079003347 Blumhouse's The Craft: Legacy DVD Movie The Ritual IN STOCK (1)
2063 286391557901 Fitbit Sense 2 Health and Fitness Smartwatch FB521 IN STOCK (1)
3110 277091711997 Funko Pop! Pin Star Wars Max Rebo SE Target Exclus IN STOCK (1)
2076 286416196718 Fitbit Inspire 3 | Heart Rate Monitor | Health + F IN STOCK (1)
3114 277093437505 Funko Pop! Pin Star Wars Max Rebo SE Target Exclus IN STOCK (1)
11958 277105767269 Sahara - Universal Mouse Pad with Wireless Chargin IN STOCK (1)
11957 277103109122 Snake Eyes (DVD, 1999, Sensormatic) Nicolas Cage G IN STOCK (1)
11959 277108023030 Pioneer TS-A30S4 1400 Watt 12" 4 Ohm Car Audio Sub IN STOCK (1)
11960 277108609311 Pioneer TS-A30S4 1400 Watt 12" 4 Ohm Car Audio Sub IN STOCK (1)
778 203707820002 Decorative Cast Iron Fish Trivet Kitchen Decor Hot IN STOCK (1)
783 237107820001 Decorative Welcome Stepping Stone Plaque Footprint 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)
782 229207820000 Decorative Sitting Green Frog Stepping Stone Cast IN STOCK (1)
787 229207820002 Decorative Cast Iron Yard & Garden Stepping Stone IN STOCK (1)
31 254007820001 Decorative Cast Iron Wall Shelf Bracket Brace Bird IN STOCK (1)
792 246407820003 Decorative Baby Turtles Stepping Stone Rust 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)
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)
2074 254007820011 Cast Iron Shelf Bracket Fleur De Lis Distressed Wh IN STOCK (1)
2066 286393686543 Victrola Eastwood Signature Record Player With Blu IN STOCK (1)
2073 286401640996 Folding Front Shelf Traeger Pro Series 34 Pellet G IN STOCK (1)
2081 272607820003 13.75" Cast Iron Plant Hanger Bracket – Decorati IN STOCK (1)
2082 286427434485 HEYDAY Phone Case for iPhone 12 Mini 5.4” screen IN STOCK (1)
2084 254107820003 Wall Shelf Bracket Decorative Cast Iron Brace Vine IN STOCK (1)
2347 286442577481 Sanus On-Wall Cable Concealer Kit for Mounted TVs IN STOCK (1)
2346 286442533003 Sanus In-Wall Cable Concealer for Mounted TV & Sou OUT OF STOCK (0)
2344 286440105546 Scott Hall (Black Red) WCW Smash N Slam Wrestlers OUT OF STOCK (0)
2359 272907820016 Welcome To Our Home Garden Flag – Seasonal Outdo IN STOCK (1)
2358 255707820018 Cast Iron Plant Hanger Bracket Hummingbird Vine Ho IN STOCK (1)
2356 286452062505 Women's Shannon Heels with Memory Foam Insole Sz 7 IN STOCK (1)
2364 148107820000 Video Gaming Aluminum Sign Gamer Zone Characters C IN STOCK (1)
2366 261207820001 Funny Aluminum Sign No Poop Heads Allowed Women Ho IN STOCK (1)
2365 273207820008 French Bulldog Beware Of Dog Double Sided Funny Pe IN STOCK (1)
2371 163807820004 Aluminum Sign Firemans Cross Diamond Plate Firefig IN STOCK (1)
2386 286497320411 Matchbox Twenty Where Light Goes Vinyl LP Alternat IN STOCK (1)
2383 286491389772 MOBICam Pro 2 Pk Smart HD Pan Tilt Wi-Fi Baby Moni IN STOCK (1)
2389 286498061560 LSU Tigers Stickers Wall Art Self-Adhesive Diecut IN STOCK (1)
2392 286502060821 Gamma Photon Outdoor Pickleballs High-Vis Yellow U IN STOCK (1)
2394 286513849072 Funko Pop! Deluxe: Jabba's Skiff: Luke Skywalker - IN STOCK (1)
2393 286502109409 Farberware Professional Secure Fit Funnel Removabl IN STOCK (1)
2402 286515110514 Judy Blume Welcome to the Hilarious World of Fudge IN STOCK (1)
2403 286515151853 THE BEST OF PENTATONIX CHRISTMAS [10/25] NEW CD Se IN STOCK (1)
2399 286514692829 Dr. Strangelove: Or How I Learned To..Love The Bom IN STOCK (1)
3099 286533381922 Fitbit Charge 5 Fitness and Health Tracker Smart W IN STOCK (1)
3100 286533401449 Blue Beetle (DVD, 2023) Brand New Sealed DC Comics IN STOCK (1)
3101 286533471775 The Forgiven (DVD, 2017 Widescreen) New Factory Se IN STOCK (1)
3106 286538461512 Splendor in the Grass [New DVD] NTSC Format Sealed IN STOCK (1)
3107 286538539841 My Foolish Heart DVD Movie Full Frame New Sealed 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-145 of 145

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