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: 124 | OUT OF STOCK: 7 | First In-Stock at position: 2
# ID SKU Name Stock Status
1 3116 286550850989 Funko POP! #1352 Indiana Jones SALLAH Vinyl Figure OUT OF STOCK (0)
2 911 286297875467 Wireless Meat Thermometer Meater Plus Digital Exte IN STOCK (1)
3 760 286251207844 Dearfoams Women's Shearling Scuff Slippers Chestnu IN STOCK (1)
4 762 286251265340 Dearfoams Women's Pumpkin Slide Slippers Jack-O-La IN STOCK (1)
5 763 286256627657 Dearfoams Men's Lith Moc Toe Clog Slippers Shearli IN STOCK (1)
6 764 276816918998 Dearfoams Men's Shearling Side Stitch Moc Slippers IN STOCK (1)
7 770 276821346666 Dearfoams Women's Pumpkin Slide Slippers Jack-O-La IN STOCK (1)
8 773 273407820003 Heart Shaped Trivet Ornate Decorative Cast Iron Fl IN STOCK (1)
9 774 273907820001 Decorative Cast Iron Trivet Owl Hot Pad Kitchen De IN STOCK (1)
10 775 273407820005 Square Trivet Black Cast Iron Decorative Ornate Di IN STOCK (1)
11 776 273407820001 Decorative Cast Iron Trivet Ornate Heart Design Ro IN STOCK (1)
12 777 273407820002 Cast Iron Trivet Round Ornate Heart Scrollwork Des IN STOCK (1)
13 778 203707820002 Decorative Cast Iron Fish Trivet Kitchen Decor Hot IN STOCK (1)
14 779 203707820001 Tea Kettle Trivet Ornate Decorative Cast Iron Kitc IN STOCK (1)
15 780 203707820000 Decorative Cast Iron Trivet Chilli Peppers Kitchen IN STOCK (1)
16 781 274207820000 Cast Iron Nautical Anchor Trivet Hot Plate Rustic IN STOCK (1)
17 782 229207820000 Decorative Sitting Green Frog Stepping Stone Cast IN STOCK (1)
18 783 237107820001 Decorative Welcome Stepping Stone Plaque Footprint IN STOCK (1)
19 784 266107820000 Welcome To My Garden Hummingbird Stepping Stone Pl IN STOCK (1)
20 785 272507820003 Heart & Foot Prints Welcome Plaque Cast Iron Stepp IN STOCK (1)
21 787 229207820002 Decorative Cast Iron Yard & Garden Stepping Stone IN STOCK (1)
22 788 246407820002 LARGE Turtle Stepping Stone Paver Decorative Cast IN STOCK (1)
23 792 246407820003 Decorative Baby Turtles Stepping Stone Rust Cast I IN STOCK (1)
24 793 269907820001 Butterfly Stepping Stone Verdigris Cast Iron 11" W IN STOCK (1)
25 794 IWSTS0018 Cast Iron Footprint Stepping Stones - Garden Pathw IN STOCK (1)
26 846 286278494687 Allegra K Women's Lace Mesh Floral Embroidered Sti IN STOCK (1)
27 849 286278436738 Women's Aurora Water Shoes Black Sz 6 IN STOCK (1)
28 879 286280138492 Women's Sterling Chelsea Boots Zip Up Ankle Bootie IN STOCK (1)
29 900 286295192457 Bearpaw Retro Super Shorty Size 4 Youth Suede Wool IN STOCK (1)
30 901 286294130286 Traeger Timberline Outdoor Kitchen Trim Kit Black IN STOCK (1)
31 916 276841802932 Otterbox Elevation 20 Tumbler Thermal Lid Screw To IN STOCK (1)
32 951 273407820004 Decorative Trivet Square Cast Iron Hot Pad Kitchen IN STOCK (1)
33 953 257407650009 Real Sand Castle Figurine 118 4" Tall Collectible IN STOCK (1)
34 1128 198507820001 Double Sided Hanging Welcome Sign Squirrel Eating IN STOCK (1)
35 1129 163807820002 Firefighting Aluminum Sign Firemans St Florian Mal IN STOCK (1)
36 1130 019700410016 Cast Iron Wall Hook Rack Antique Skeleton Key 3 Ho IN STOCK (1)
37 1138 144307820002 Aluminum Sign You Need A Drink Home Bar Man Cave B IN STOCK (1)
38 1164 229207820005 Please Close The Gate Sign Decorative Plaque Cast IN STOCK (1)
39 1165 274207820001 Chicken Trivet Decorative Cast Iron Hot Pad 7.75" IN STOCK (1)
40 1166 198507820003 Double Sided Hanging Welcome Sign Ornate Cast Iron IN STOCK (1)
41 1167 274811615606 Harley Quinn Costume Girl M (8-10) DC Super Hero G IN STOCK (1)
42 1172 275453521123 Vintage Cracker Jack Gumball prize charm celluloid IN STOCK (1)
43 1173 275453524384 Vintage Cracker Jack Gumball prize charm Man on R IN STOCK (1)
44 1174 275453537797 Vintage Cracker Jack Gumball prize charm faded pur IN STOCK (1)
45 1175 275458939770 vintage Cracker Jack Gumball charm prize toy: Gree IN STOCK (1)
46 1176 275458944602 vintage Cracker Jack Gumball charm prize toy: Red IN STOCK (1)
47 1177 275458949486 vintage Cracker Jack charm prize Boy on Bicycle (m IN STOCK (1)
48 1179 275459221209 vintage Cracker Jack charm prize Silvery Plastic P IN STOCK (1)
49 1180 275459274008 vintage Cracker Jack charm prize Metallized Plasti IN STOCK (1)
50 1192 229207820003 Cast Iron Plaque Sign - Please Close The Gate - Bl IN STOCK (1)
51 1193 276301204436 Baby Proofing American Electrical Outlet Safety Co IN STOCK (1)
52 1269 019707820007 Skeleton Key Style Wall Hook Coat Rack Victorian 4 IN STOCK (1)
53 2063 286391557901 Fitbit Sense 2 Health and Fitness Smartwatch FB521 IN STOCK (1)
54 2344 286440105546 Scott Hall (Black Red) WCW Smash N Slam Wrestlers OUT OF STOCK (0)
55 2346 286442533003 Sanus In-Wall Cable Concealer for Mounted TV & Sou OUT OF STOCK (0)
56 2347 286442577481 Sanus On-Wall Cable Concealer Kit for Mounted TVs IN STOCK (1)
57 2350 286444772480 CyberPower 750VA Slim Line Battery Back-Up UPS 8 O IN STOCK (1)
58 2353 286449705459 McFarlane DC Retro Classic Batman 1966 6 Inch Figu IN STOCK (1)
59 2354 286449720137 Mcfarlane Batman DC Retro 66 Classics TV Series Ro IN STOCK (1)
60 2356 286452062505 Women's Shannon Heels with Memory Foam Insole Sz 7 IN STOCK (1)
61 2358 255707820018 Cast Iron Plant Hanger Bracket Hummingbird Vine Ho IN STOCK (1)
62 2359 272907820016 Welcome To Our Home Garden Flag – Seasonal Outdo IN STOCK (1)
63 2360 019707820020 Rustic Cast Iron Antler Wall Hook Rack Deer Lodge IN STOCK (1)
64 2361 286459777773 Peerless AV Peerless-AV ST650P Tilt TV Wall Mount OUT OF STOCK (0)
65 2363 019707820019 Decorative Double Wall Hook Love Birds Rust Brown IN STOCK (1)
66 2364 148107820000 Video Gaming Aluminum Sign Gamer Zone Characters C IN STOCK (1)
67 2365 273207820008 French Bulldog Beware Of Dog Double Sided Funny Pe IN STOCK (1)
68 2366 261207820001 Funny Aluminum Sign No Poop Heads Allowed Women Ho IN STOCK (1)
69 2367 019707820006 Cast Iron Skeleton Key Wall Hook Rack – 3 Hook R IN STOCK (1)
70 2368 286467319047 Hyde & Eek Halloween Women’s Glow-In-The-Dark Sk IN STOCK (1)
71 2370 273707820002 Happy Easter Angel & Lamb Garden Flag Emotes Doubl IN STOCK (1)
72 2371 163807820004 Aluminum Sign Firemans Cross Diamond Plate Firefig IN STOCK (1)
73 2373 286476641474 Bromic BH3130010-1 On/Off Switch for Electric and IN STOCK (1)
74 2374 286476757005 Ooni Digital Infrared Thermometer Pizza Oven Calib IN STOCK (1)
75 2377 286477126573 Cyberpower SE450G1 450 VA Battery Backup UPS 8-Out IN STOCK (1)
76 2379 286479095271 Yardbird - Harriet Fixed and Swivel Chair Cover - IN STOCK (1)
77 2380 286479184706 Yardbird Harriet Sofa Cover CVHA100 Beige Outdoor IN STOCK (1)
78 2381 286485819828 MOBICam HDX Smart HD Pan & Tilt Wi-Fi Baby Monitor IN STOCK (1)
79 2383 286491389772 MOBICam Pro 2 Pk Smart HD Pan Tilt Wi-Fi Baby Moni IN STOCK (1)
80 2386 286497320411 Matchbox Twenty Where Light Goes Vinyl LP Alternat IN STOCK (1)
81 2389 286498061560 LSU Tigers Stickers Wall Art Self-Adhesive Diecut IN STOCK (1)
82 2392 286502060821 Gamma Photon Outdoor Pickleballs High-Vis Yellow U IN STOCK (1)
83 2393 286502109409 Farberware Professional Secure Fit Funnel Removabl IN STOCK (1)
84 2394 286513849072 Funko Pop! Deluxe: Jabba's Skiff: Luke Skywalker - IN STOCK (1)
85 2396 286514205283 Absolutely Fabulous: Absolutely All of It! New DVD IN STOCK (1)
86 2397 286514279050 Horror Hall of Fame Movie 5 DVD Boxset 26 Classic IN STOCK (1)
87 2398 286514389783 The Raid: Redemption [New 4K UHD Blu-ray] Ltd Ed, IN STOCK (1)
88 2399 286514692829 Dr. Strangelove: Or How I Learned To..Love The Bom IN STOCK (1)
89 2402 286515110514 Judy Blume Welcome to the Hilarious World of Fudge IN STOCK (1)
90 2403 286515151853 THE BEST OF PENTATONIX CHRISTMAS [10/25] NEW CD Se IN STOCK (1)
91 2404 277064207987 Carrie Underwood My Gift First-Ever Christmas Albu IN STOCK (1)
92 2405 277064611176 Yogasleep Rohm Portable White Noise Machine Travel IN STOCK (1)
93 2406 277066203475 CASETiFY - Ultra Impact Bounce Case for Apple AirP IN STOCK (1)
94 2408 286523721442 Blue's Clues Wall Stickers Kids Bedroom Decor Nick IN STOCK (1)
95 2409 286524824693 Nickelodeon Rug Rats Kids Bedroom Wall Decor Stick IN STOCK (1)
96 3071 277069846799 CASETiFY - Mirror Airpods Case for Apple AirPods P OUT OF STOCK (0)
97 3072 277069870238 Kate Spade New York - Protective Case Apple Airpod IN STOCK (1)
98 3085 277074520169 Yogasleep Hushh White Noise Machine Portable Sound IN STOCK (1)
99 3093 277079003347 Blumhouse's The Craft: Legacy DVD Movie The Ritual IN STOCK (1)
100 3099 286533381922 Fitbit Charge 5 Fitness and Health Tracker Smart W IN STOCK (1)
101 3100 286533401449 Blue Beetle (DVD, 2023) Brand New Sealed DC Comics IN STOCK (1)
102 3101 286533471775 The Forgiven (DVD, 2017 Widescreen) New Factory Se IN STOCK (1)
103 3102 286533522689 Looking Glass DVD Movie, 2018 Nicolas Cage Brand N IN STOCK (1)
104 3105 286536199218 Fitbit Charge 5 Fitness and Health Tracker Smart W IN STOCK (1)
105 3106 286538461512 Splendor in the Grass [New DVD] NTSC Format Sealed IN STOCK (1)
106 3107 286538539841 My Foolish Heart DVD Movie Full Frame New Sealed IN STOCK (1)
107 3110 277091711997 Funko Pop! Pin Star Wars Max Rebo SE Target Exclus IN STOCK (1)
108 3111 277093334750 SUPER7 RUN DMC Joseph "RUN" Simmons ReAction Figur IN STOCK (1)
109 3112 277093398774 FUNKO POP! MOVIES: Raiders of the Lost Ark - Arnol IN STOCK (1)
110 3113 277093424276 FUNKO POP! MOVIES: The Last Crusade - Henry Jones IN STOCK (1)
111 3114 277093437505 Funko Pop! Pin Star Wars Max Rebo SE Target Exclus IN STOCK (1)
112 3115 286549184208 Women's Darla Platform Mule Heels Black 6 IN STOCK (1)
113 3117 286550852026 Funko Pop! Vinyl: Indiana Jones - Indiana Jones #1 IN STOCK (1)
114 11956 277098598300 The Real Mccoy DVD Action Crime Kim Basinger Val K IN STOCK (1)
115 11957 277103109122 Snake Eyes (DVD, 1999, Sensormatic) Nicolas Cage G IN STOCK (1)
116 11958 277105767269 Sahara - Universal Mouse Pad with Wireless Chargin IN STOCK (1)
117 11959 277108023030 Pioneer TS-A30S4 1400 Watt 12" 4 Ohm Car Audio Sub IN STOCK (1)
118 11960 277108609311 Pioneer TS-A30S4 1400 Watt 12" 4 Ohm Car Audio Sub IN STOCK (1)
119 11961 286566328311 Kenwood KFC 1666R 6.5 Inch Coaxial Car Speakers 30 IN STOCK (1)
120 11962 286565954268 Pioneer A-Series TS-A653FH 6.5" 2-Way 340 W Max Po IN STOCK (1)
121 11963 286563364559 Pioneer 2-Way Speaker TS-G650 300W Max 6 1/2 / 6 3 IN STOCK (1)
122 11969 286563505562 OEM Dyson V15 Detect Laser Slim Fluffy Optic Clean OUT OF STOCK (0)
123 19191 286541448988 Portable DVD Player Insignia™ 10" NS-P10DVD20 Re OUT OF STOCK (0)
124 20545 277126264408 CyberPower 950VA / 510W PC Battery Backup - SX950U IN STOCK (1)
125 21759 277128438248 Metra BY-GM11-SWC Steering Wheel Control Interface IN STOCK (1)
126 21778 277128470763 Metra Steering Wheel Control Interface Ford, Linco IN STOCK (1)
127 23598 277131919443 Funko POP! #1352 Indiana Jones SALLAH Vinyl Figure IN STOCK (1)
128 16 254007820004 Wall Shelf Bracket Brace Fleur De Lis Verdigris Ca IN STOCK (1)
129 17 254007820007 Fleur De Lis Wall Shelf Bracket Cast Iron Ornate B IN STOCK (1)
130 24 254107820001 Decorative Angle Bracket Cast Iron Shelf Brace Gol IN STOCK (1)
131 26 254107820027 Wall Shelf Bracket Distressed White Ornate Cast Ir 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 131

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