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: 114 | OUT OF STOCK: 6
ID SKU Name Stock Status
3116 286550850989 Funko POP! #1352 Indiana Jones SALLAH Vinyl Figure OUT OF STOCK (0)
911 286297875467 Wireless Meat Thermometer Meater Plus Digital Exte IN STOCK (1)
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)
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)
953 257407650009 Real Sand Castle Figurine 118 4" Tall Collectible 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)
7 254007820002 Wall Shelf Bracket Fleur De Lis Cast Iron Brace Br 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)
1138 144307820002 Aluminum Sign You Need A Drink Home Bar Man Cave B 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)
285 255707820012 Hummingbird S Style Plant Hook Cast Iron Flower Ba IN STOCK (1)
29 254107820012 Decorative Shelf Bracket Ornate Leaf Brace Rust Br IN STOCK (1)
312 820107820006 Garden Water Hose Holder Rose Flower Hanger Reel IN STOCK (1)
291 255707820021 Pixie Fairy Cast Iron Plant Hanger Verdigirs 9" De IN STOCK (1)
170 012600410004 Wall Shelf Bracket Leaf Vine Pattern Cast Iron Bra IN STOCK (1)
290 272607820004 Decorative Plant Hanger Cast Iron Flower Basket Ho IN STOCK (1)
292 110102740002 Hummingbird Plant Hanger Cast Iron Flower Basket H IN STOCK (1)
318 820107820013 Wall Mount Garden Hose Holder Floral & Spade Verdi IN STOCK (1)
319 820107820000 Garden Hose Holder Cast Iron Hanger Reel Watering IN STOCK (1)
293 255707820002 Decorative Plant Hanger Ornate Victorian Cast Iron IN STOCK (1)
295 255707820003 Hummingbird Plant Hanger Flower Hook Decorative Ve 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)
322 820107820002 Garden Hose Holder Water Pail Bucket Verdigris Cas IN STOCK (1)
301 110100410001 Cast Iron Plant Hanger Basket Hook Pixie Fairy Rus 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)
410 276793574596 Women's Marsha Ankle Boots Zip Up Pointed Toe - B 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)
752 276822613745 Joybees Men's Chance Clogs Gray Sz 7 Slip On Sanda IN STOCK (1)
215 273207820009 Golden Retriever Garden Flag Emotes Beware Of Dog 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)
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)
310 820102740000 Cast Iron Garden Hose Holder Floral & Spade Patter IN STOCK (1)
263 273307820000 Duck Family Plant Hanger Flower Basket Hook Colorf 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)
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)
19191 286541448988 Portable DVD Player Insignia™ 10" NS-P10DVD20 Re OUT OF STOCK (0)
20545 277126264408 CyberPower 950VA / 510W PC Battery Backup - SX950U IN STOCK (1)
311 820107820010 Garden Hose Holder Reel Cast Iron Hanger Birds On IN STOCK (1)
2 273707820000 Ornate Heart Shelf Bracket Decorative Rust Brown C 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)
276 019707820014 Cast Iron Wall Hook Rack Ornate Victorian 4 Key Ho 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)
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)
280 273007820000 Decorative Rooster Plant Hanger Flower Hook Colorf IN STOCK (1)
284 255707820020 Plant Hanger Chickadee Bird Cast Iron Flower Baske IN STOCK (1)
30 197100410009 Wall Shelf Bracket Brace Black Cast Iron Scrolling IN STOCK (1)
313 820107820009 Cast Iron Garden Hose Holder Love Birds Garden Hos IN STOCK (1)
205 930907820008 Cast Iron Dinner Bell Rooster & Flowers Colorful D OUT OF STOCK (0)
316 820107820003 Garden Hose Holder Gnome & Bunny Rabbit Distressed IN STOCK (1)
299 255707820017 Birds In Tree Decorative Plant Hanger Cast Iron Fl IN STOCK (1)
321 256207820002 Decorative Garden Hose Guide Bird On Rose Cast Iro IN STOCK (1)
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)
325 820100410001 Hose Holder Reel Cast Iron Horse & Horseshoe Yard 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)
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)

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 271

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