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: 137 | OUT OF STOCK: 0 | First In-Stock at position: 1
# ID SKU Name Stock Status
1 911 286297875467 Wireless Meat Thermometer Meater Plus Digital Exte IN STOCK (1)
2 760 286251207844 Dearfoams Women's Shearling Scuff Slippers Chestnu IN STOCK (1)
3 762 286251265340 Dearfoams Women's Pumpkin Slide Slippers Jack-O-La IN STOCK (1)
4 764 276816918998 Dearfoams Men's Shearling Side Stitch Moc Slippers IN STOCK (1)
5 770 276821346666 Dearfoams Women's Pumpkin Slide Slippers Jack-O-La IN STOCK (1)
6 773 273407820003 Heart Shaped Trivet Ornate Decorative Cast Iron Fl IN STOCK (1)
7 774 273907820001 Decorative Cast Iron Trivet Owl Hot Pad Kitchen De IN STOCK (1)
8 775 273407820005 Square Trivet Black Cast Iron Decorative Ornate Di IN STOCK (1)
9 776 273407820001 Decorative Cast Iron Trivet Ornate Heart Design Ro IN STOCK (1)
10 777 273407820002 Cast Iron Trivet Round Ornate Heart Scrollwork Des IN STOCK (1)
11 778 203707820002 Decorative Cast Iron Fish Trivet Kitchen Decor Hot IN STOCK (1)
12 779 203707820001 Tea Kettle Trivet Ornate Decorative Cast Iron Kitc IN STOCK (1)
13 780 203707820000 Decorative Cast Iron Trivet Chilli Peppers Kitchen IN STOCK (1)
14 788 246407820002 LARGE Turtle Stepping Stone Paver Decorative Cast IN STOCK (1)
15 792 246407820003 Decorative Baby Turtles Stepping Stone Rust Cast I IN STOCK (1)
16 793 269907820001 Butterfly Stepping Stone Verdigris Cast Iron 11" W IN STOCK (1)
17 794 IWSTS0018 Cast Iron Footprint Stepping Stones - Garden Pathw IN STOCK (1)
18 846 286278494687 Allegra K Women's Lace Mesh Floral Embroidered Sti IN STOCK (1)
19 849 286278436738 Women's Aurora Water Shoes Black Sz 6 IN STOCK (1)
20 900 286295192457 Bearpaw Retro Super Shorty Size 4 Youth Suede Wool IN STOCK (1)
21 901 286294130286 Traeger Timberline Outdoor Kitchen Trim Kit Black IN STOCK (1)
22 916 276841802932 Otterbox Elevation 20 Tumbler Thermal Lid Screw To IN STOCK (1)
23 951 273407820004 Decorative Trivet Square Cast Iron Hot Pad Kitchen IN STOCK (1)
24 953 257407650009 Real Sand Castle Figurine 118 4" Tall Collectible IN STOCK (1)
25 1128 198507820001 Double Sided Hanging Welcome Sign Squirrel Eating IN STOCK (1)
26 1129 163807820002 Firefighting Aluminum Sign Firemans St Florian Mal IN STOCK (1)
27 1130 019700410016 Cast Iron Wall Hook Rack Antique Skeleton Key 3 Ho IN STOCK (1)
28 1164 229207820005 Please Close The Gate Sign Decorative Plaque Cast IN STOCK (1)
29 1165 274207820001 Chicken Trivet Decorative Cast Iron Hot Pad 7.75" IN STOCK (1)
30 1166 198507820003 Double Sided Hanging Welcome Sign Ornate Cast Iron IN STOCK (1)
31 1167 274811615606 Harley Quinn Costume Girl M (8-10) DC Super Hero G IN STOCK (1)
32 1172 275453521123 Vintage Cracker Jack Gumball prize charm celluloid IN STOCK (1)
33 1173 275453524384 Vintage Cracker Jack Gumball prize charm Man on R IN STOCK (1)
34 1174 275453537797 Vintage Cracker Jack Gumball prize charm faded pur IN STOCK (1)
35 1175 275458939770 vintage Cracker Jack Gumball charm prize toy: Gree IN STOCK (1)
36 1176 275458944602 vintage Cracker Jack Gumball charm prize toy: Red IN STOCK (1)
37 1177 275458949486 vintage Cracker Jack charm prize Boy on Bicycle (m IN STOCK (1)
38 1179 275459221209 vintage Cracker Jack charm prize Silvery Plastic P IN STOCK (1)
39 1180 275459274008 vintage Cracker Jack charm prize Metallized Plasti IN STOCK (1)
40 1192 229207820003 Cast Iron Plaque Sign - Please Close The Gate - Bl IN STOCK (1)
41 1193 276301204436 Baby Proofing American Electrical Outlet Safety Co IN STOCK (1)
42 1269 019707820007 Skeleton Key Style Wall Hook Coat Rack Victorian 4 IN STOCK (1)
43 1573 276833228749 Journee Collection Womens Livvy Back Heel Zip Stac IN STOCK (1)
44 1634 276860115393 Women's Diana Buckle Mule Heels Black SZ 9.5 Slip IN STOCK (1)
45 1653 276884002210 JBL Tune 230NC TWS Earbuds Blue Bluetooth Active N IN STOCK (1)
46 1654 276889348003 dearfoams Kids' Good Vibes Slide Slippers - Hot Pi IN STOCK (1)
47 1657 276912425839 Apple EarPods with 3.5mm Plug – Wired In-Ear Hea IN STOCK (1)
48 1661 276912562408 OtterBox Shaker Lid For Elevation 20 1.5 OZ Shot G IN STOCK (1)
49 1676 276920455864 Women's Alexa Flare Heel Pumps Black SZ 10 IN STOCK (1)
50 1677 820107820015 Ornate Garden Hose Holder - Heavy Duty Metal Wall IN STOCK (1)
51 1678 930907820002 Rustic Cast Iron Welcome Bell Vintage Wall Mount D IN STOCK (1)
52 1679 276928818201 Allegra K Women's T Strap Open Toe Platform Stilet IN STOCK (1)
53 1681 276928972258 Fitbit Versa 4 Fitness Smartwatch FB523BKBK NO Cha IN STOCK (1)
54 1682 276931109905 Women's Mel Rhinestone Mesh Ballet Flats Silver / IN STOCK (1)
55 1686 276939078249 Victrola Re-Spin Suitcase Vinyl Record Player Blue IN STOCK (1)
56 1690 254107820030 Wall Shelf Bracket Ornate Scroll White Cast Iron R IN STOCK (1)
57 1693 276955627052 Women's Marcia Lace up Heels with Memory Foam Inso IN STOCK (1)
58 1699 276966958927 Heyday Silicone Phone Case for iPhone 12 Mini – IN STOCK (1)
59 1700 276967399530 Funko Mini Moments: Marvel - Jennifer & Abominatio IN STOCK (1)
60 1701 276969248621 UNOS BY SZ Adult Sneakers - Gray 8-9 IN STOCK (1)
61 1703 273107820002-1 Nautical Ship Anchor Cast Iron Shelf Bracket 7.75" IN STOCK (1)
62 1704 273107820002 Nautical Ship Anchor Cast Iron Shelf Bracket 7.75" IN STOCK (1)
63 1705 254107820003-1 Wall Shelf Bracket Cast Iron Brace Vine & Leaf Ver IN STOCK (1)
64 1706 272607820008 S-Hook Plant Hanger Flower Basket Decor Rustic Bro IN STOCK (1)
65 1708 276981428196 WWE Elite Collection Undertaker Figure - Best of 2 IN STOCK (1)
66 1709 276983831741 Rocketfish 8k Ultra High Speed 15ft HDMI Cable 48 IN STOCK (1)
67 1710 276983911682 Rocketfish - 12' 4K UltraHD/HDR In-Wall Rated HDMI IN STOCK (1)
68 1711 276983927536 Sanus BSA-IWP1-W1 In-Wall Cable Concealer Recessed IN STOCK (1)
69 1712 276983994123 Sanus - On-Wall Cable Concealer High Capacity Cord IN STOCK (1)
70 1714 276987123754 Helios In-Wall Power Outlet Relocation Kit Cable P IN STOCK (1)
71 1716 276987506055 Women's Shannon Heels with Memory Foam Insole Sz 6 IN STOCK (1)
72 1720 254107820007 Ornate Cast Iron Shelf Bracket Decorative Corner S IN STOCK (1)
73 1721 276992410457 Mcfarlane Batman DC Retro 66 Classics TV Series W5 IN STOCK (1)
74 1722 276992464944 McFarlane DC Retro 66 Classic TV Series Radioactiv IN STOCK (1)
75 1723 276992467087 Hasbro Star Wars George Lucas Stormtrooper Action IN STOCK (1)
76 1724 246407820001 13" Brown Cast Iron Turtle Stepping Stone Decorati IN STOCK (1)
77 1726 272907820017 Unicorn Garden Flag Rainbow Yard Banner – "Unico IN STOCK (1)
78 1727 019700410046 Cast Iron Wall Hook Rack Fish Bone Skeleton Hooks IN STOCK (1)
79 1728 274007820000 Slow Down Garden Flag Caution Children At Play Dou IN STOCK (1)
80 1729 261207820000 Funny Aluminum Sign No Poop Heads Allowed Men Man IN STOCK (1)
81 1730 273207820013 Don't Be A Poop Head Emoji Clean Up After Dog Gard IN STOCK (1)
82 1731 000007830114 NASCAR Kasey Kahne Wall Appliques Decal Racing Sti IN STOCK (1)
83 1732 000000410068 Disney Princess Self Stick Removable Appliques Wal IN STOCK (1)
84 1733 272907820015 Thankful Grateful Blessed Fall Leaves Garden Flag IN STOCK (1)
85 1734 163807820003 Aluminum Sign Firemans Cross White Firefighting Pl IN STOCK (1)
86 1735 273807820002 Welcome American Garden Flag Emotes Double Sided A IN STOCK (1)
87 1736 322207820000 Fish Pocket Beer Bottle Opener Handheld Brown Cast IN STOCK (1)
88 1737 273707820003 Happy Easter Spring Flowers Birds Garden Flag Emot IN STOCK (1)
89 1738 273007820003 Cast Iron Pedestal Bird Feeder Bath 8" Wide Decora IN STOCK (1)
90 1739 930907820000 Cast Iron Horse Dinner Bell – Rustic Brown Wall IN STOCK (1)
91 1740 142307820000 Aluminum Sign Coffee Cappuccino Mocha Espresso Fra IN STOCK (1)
92 1741 277012444440 New Brielle Home Cotton Jersey Knit (T-Shirt) Shee IN STOCK (1)
93 1742 277015134596 CyberPower 1000VA UPS Battery Backup Surge Protect IN STOCK (1)
94 1743 322207820002 Wall Mounted Skull Beer Bottle Opener Cast Iron Ho IN STOCK (1)
95 1744 261207820002 Funny Aluminum Sign No Poop Heads Allowed Man & Wo IN STOCK (1)
96 1750 277025938599 Yardbird Fire Table Cover CVFTRERB Rectangular Bei IN STOCK (1)
97 1751 277029661358 Barbie Toy Wall Stickers Girls Bedroom Decals Deco IN STOCK (1)
98 1752 277032581994 CyberPower 1500VA Battery Back-Up System UPS 10 Ou IN STOCK (1)
99 1754 277036995257 Sanus BSA-IWP701-W1 In-Wall Power Kit AV Cable Man IN STOCK (1)
100 1755 277037180702 SaharaCase - Office Mouse Pad with Wireless Chargi IN STOCK (1)
101 1756 277037812053 Genuine Amazon Alexa Voice Remote (3rd Gen) with T IN STOCK (1)
102 1758 277039604836 Nick JR Dora The Explorer Wall Sticker Decal Nicke IN STOCK (1)
103 1760 277040873020 Computer Chair Floor Mat 30 x 48 inches Clear Floo IN STOCK (1)
104 1763 277046740996 Simpli Home Grafton Round Pouf 20" x 20" x 14" Tea IN STOCK (1)
105 1764 277047254859 10" Twin Intex Standard Dura-Beam Airbed Mattress IN STOCK (1)
106 1868 198507820002 Flamingo Welcome Plaque Brown Cast Iron Beach Them IN STOCK (1)
107 1872 272207820000 Large Rolling Plant Caddy Fleur De Lis IN STOCK (1)
108 1873 273607820000 Decorative Cast Iron Rooster Trivet Kitchen Decor IN STOCK (1)
109 1874 197107820000 Turtle Hide A Key Box Distressed Brown Cast Iron G IN STOCK (1)
110 1875 284109859464 Disney’s Baby Mickey Mouse Wall Border ABC Nurse IN STOCK (1)
111 1876 229207820004 Cast Iron Plaque Sign - Beware Of The Dog - Black IN STOCK (1)
112 1877 284292040564 Baby Einstein Four Fundamentals 5 Developmental Ac IN STOCK (1)
113 1879 284965973493 vintage Cracker Jack prize charm Seagrams Gin Bott IN STOCK (1)
114 1880 285024495455 Please Close The Gate Cast Iron Plaque Sign Black IN STOCK (1)
115 1882 TGLSPG0001 Electric Salt & Pepper Grinder Set - Adjustable Co IN STOCK (1)
116 1941 286287688602 Allegra K Women's Back to College Faux Suede Open IN STOCK (1)
117 1942 286287784729 Women's Devin Two Band Footbed Sandals Black SZ 11 IN STOCK (1)
118 1969 286290556641 Dr. Scholl's Women's Janette Slip Resistant Shoes, IN STOCK (1)
119 1989 286292297452 Men's Joshua Slide Sandals Tan 8 Unworn Condition IN STOCK (1)
120 2043 266207820000 Welcome Stepping Stone Cast Iron Lawn Garden Decor IN STOCK (1)
121 2046 286347914467 dearfoams Kids' Dave Quilted Slide Slippers - Navy IN STOCK (1)
122 2049 286364704411 Playtex Finger Puppets Set – 5pc Jungle Animal B IN STOCK (1)
123 2051 286367402132 Decorative Cast Iron Snail Stepping Stone – Gard IN STOCK (1)
124 2053 286367593981 New England Patriots Rawlings Cooler Tote Holds 30 IN STOCK (1)
125 2057 197100410002 Cast Iron Shelf Bracket Fleur-de-Lis Wall Brace De IN STOCK (1)
126 2059 286382333221 Womens Paulina Kitten Heel Sling Back Pointed Toe IN STOCK (1)
127 2061 254107820032 White Cast Iron Shelf Bracket Ornate Scroll Wall M IN STOCK (1)
128 2065 286393541437 Women's Mel Rhinestone Mesh Ballet Flats Silver / IN STOCK (1)
129 2066 286393686543 Victrola Eastwood Signature Record Player With Blu IN STOCK (1)
130 14 254107820000 Wall Shelf Bracket Decorative Cast Iron Brace Orna IN STOCK (1)
131 15 254107820020 Wall Shelf Bracket Brace With Plant Hanger Flower IN STOCK (1)
132 16 254007820004 Wall Shelf Bracket Brace Fleur De Lis Verdigris Ca IN STOCK (1)
133 17 254007820007 Fleur De Lis Wall Shelf Bracket Cast Iron Ornate B IN STOCK (1)
134 18 254107820017 Decorative Cast Iron Wall Shelf Bracket Ornate Vin IN STOCK (1)
135 25 254007820010 Wall Shelf Bracket Cast Iron Brace Fleur De Lis Di IN STOCK (1)
136 26 254107820027 Wall Shelf Bracket Distressed White Ornate Cast Ir IN STOCK (1)
137 27 254107820028 Wall Shelf Bracket Distressed Brown Ornate Brace 1 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 137

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