• Sign In
Toggle Nav
My Cart
Search
Advanced Search
  • Compare Products
Menu
Account

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: 28 | OUT OF STOCK: 2 | First In-Stock at position: 3
# ID SKU Name Stock Status
1 3116 286550850989 Funko POP! #1352 Indiana Jones SALLAH Vinyl Figure OUT OF STOCK (0)
2 11974 286568410736 Kamado Joe JoeTisserie 24 inch Big Joe Grill Rotis OUT OF STOCK (0)
3 911 286297875467 Wireless Meat Thermometer Meater Plus Digital Exte IN STOCK (1)
4 794 IWSTS0018 Cast Iron Footprint Stepping Stones - Garden Pathw IN STOCK (1)
5 846 286278494687 Allegra K Women's Lace Mesh Floral Embroidered Sti IN STOCK (1)
6 849 286278436738 Women's Aurora Water Shoes Black Sz 6 IN STOCK (1)
7 900 286295192457 Bearpaw Retro Super Shorty Size 4 Youth Suede Wool IN STOCK (1)
8 901 286294130286 Traeger Timberline Outdoor Kitchen Trim Kit Black IN STOCK (1)
9 916 276841802932 Otterbox Elevation 20 Tumbler Thermal Lid Screw To IN STOCK (1)
10 951 273407820004 Decorative Trivet Square Cast Iron Hot Pad Kitchen IN STOCK (1)
11 1165 274207820001 Chicken Trivet Decorative Cast Iron Hot Pad 7.75" IN STOCK (1)
12 1166 198507820003 Double Sided Hanging Welcome Sign Ornate Cast Iron IN STOCK (1)
13 1167 274811615606 Harley Quinn Costume Girl M (8-10) DC Super Hero G IN STOCK (1)
14 1172 275453521123 Vintage Cracker Jack Gumball prize charm celluloid IN STOCK (1)
15 1173 275453524384 Vintage Cracker Jack Gumball prize charm Man on R IN STOCK (1)
16 1174 275453537797 Vintage Cracker Jack Gumball prize charm faded pur IN STOCK (1)
17 1175 275458939770 vintage Cracker Jack Gumball charm prize toy: Gree IN STOCK (1)
18 1176 275458944602 vintage Cracker Jack Gumball charm prize toy: Red IN STOCK (1)
19 1177 275458949486 vintage Cracker Jack charm prize Boy on Bicycle (m IN STOCK (1)
20 1179 275459221209 vintage Cracker Jack charm prize Silvery Plastic P 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 233

Set Descending Direction
Page
per page
Shop By
Now Shopping by
  1. Item Weight 5.875000 Remove This Item
  2. Fabric Type Shearling Remove This Item
Clear All
Shopping Options
Category
  1. Hose Holders 1 item
  2. Garden Flags 10 items
  3. Doorbells 2 items
  4. Wall Hooks 1 item
  5. Stepping Stones 5 items
  6. Signs 19 items
Set Includes
  1. Kickplate / toe kick 229 items
  2. Wall Mounted Hose Hanger 4 items
Outsole Material
  1. EVA 3 items
  2. Rubber 6 items
  3. Suede 224 items
Accents
  1. big girls 6 items
  2. Bow, Rhinestone 1 item
  3. Buckle 90 items
  4. Eyelet, Fur Trim 5 items
  5. Floral Pattern 2 items
  6. Flower 20 items
  7. Glow-In-The-Dark, Hooded 69 items
  8. Heel Strep 1 item
  9. Logo 16 items
  10. Studded 2 items
  11. Thick Laces 19 items
  12. Tie Strap 1 item
  13. wool lining 6 items
  14. Zipper 1 item
Calf Width
  1. Regular 233 items
Platform Height
  1. 1.25 in 233 items
Primary Color
  1. Beige 35 items
  2. Black 74 items
  3. Blue 2 items
  4. Brown 72 items
  5. Chestnut 4 items
  6. Clear 1 item
  7. Gray 4 items
  8. Light Blue 1 item
  9. Multicolor 13 items
  10. Navy Blue 2 items
  11. Silver 5 items
  12. Tan 1 item
  13. White 15 items
  14. White, Black 1 item
  15. Yellow 3 items
Shape
  1. Foot Print 233 items
Finish
  1. Glossy 83 items
  2. Matt 36 items
  3. Painted 114 items
Product Line
  1. BearPaw 230 items
  2. Junie 3 items
Room
  1. Any Room 233 items
Personalized
  1. No 233 items
Mounting
  1. Wall Mounted 233 items
Indoor Outdoor
  1. Indoor & Outdoor 233 items
Suitable For
  1. Coats, Towels, Hats 233 items
Subject
  1. American Flag 5 items
  2. Barbies 5 items
  3. Beer 2 items
  4. Beware Of Dog 3 items
  5. Child Safety 2 items
  6. Close The Gate 48 items
  7. Coffee 6 items
  8. Cows 3 items
  9. Dachshund 2 items
  10. Darts 1 item
  11. Dog 7 items
  12. Dora The Explorer 4 items
  13. Fall 2 items
  14. Fire & Rescue 10 items
  15. Firefighting 72 items
  16. Floral 1 item
  17. Foot Print 9 items
  18. Princess 1 item
  19. Snail 16 items
  20. Unicorns 2 items
  21. United States 1 item
  22. Video Games 1 item
  23. Welcome 16 items
  24. Wine 13 items
  25. You Need A Drink 1 item
Assembly Required
  1. No 233 items
Hook Style
  1. Traditional 233 items
Shoe Shaft Style
  1. Ankle 105 items
  2. Low Top 128 items
Manufacturer
  1. Allegra K 2 items
  2. Amazon 1 item
  3. Apple 2 items
  4. ARTISAN 1 item
  5. Baby Einstein 1 item
  6. BBC Warner 2 items
  7. Brewster 2 items
  8. BRIELLE 1 item
  9. Bromic 1 item
  10. CASETiFY 2 items
  11. Cocomelon 1 item
  12. Core Innovations 1 item
  13. Cracker Jack 8 items
  14. CyberPower 6 items
  15. Dearfoams 2 items
  16. Decor 1 item
  17. Devin 1 item
  18. Disney 1 item
  19. Dr. Scholl's 1 item
  20. Dyson 2 items
  21. Farberware 1 item
  22. Fitbit 9 items
  23. Flag Emotes 54 items
  24. Floortex 1 item
  25. Funko 12 items
  26. Gamma 1 item
  27. Google 1 item
  28. Govee 1 item
  29. Hasbro 1 item
  30. Heyday 2 items
  31. Holiday Home 1 item
  32. Hyde & EEK! Boutique 1 item
  33. Import Wholesales 23 items
  34. Insignia 1 item
  35. International Wallcoverings 1 item
  36. Intex 1 item
  37. Issa 2 items
  38. JBL 1 item
  39. Joshua 1 item
  40. Journee Collection 1 item
  41. Kamado Joe 1 item
  42. kate spade new york 1 item
  43. Kenwood 6 items
  44. Longaberger 1 item
  45. Maryanne 4 items
  46. McFarlane Toys 5 items
  47. Metra 4 items
  48. Misty 1 item
  49. MOBI 3 items
  50. Mr. Sandman 1 item
  51. Ooni 1 item
  52. Otterbox 2 items
  53. Peerless 1 item
  54. Pioneer 5 items
  55. Playtex Baby 1 item
  56. Rawlings 1 item
  57. Rocketfish 2 items
  58. Rubie's 1 item
  59. Sahara 2 items
  60. Sanus 5 items
  61. Seagram's 1 item
  62. Simpli Home 1 item
  63. Sony Legacy 1 item
  64. Sony Pictures 5 items
  65. Sony Pictures Home Entertainment 1 item
  66. Super7 1 item
  67. ToyBiz 1 item
  68. Traeger Industries 2 items
  69. Unknown 2 items
  70. Vava 1 item
  71. Victrola 2 items
  72. VTech 1 item
  73. Warner 1 item
  74. Warner Archives 2 items
  75. Withit 2 items
  76. WWE 1 item
  77. Yardbird 3 items
  78. Yogasleep 2 items
Color
  1. Beige 29 items
  2. Black 83 items
  3. Blue 2 items
  4. Brown 44 items
  5. Chestnut 4 items
  6. Clear 2 items
  7. Gray 8 items
  8. Green 4 items
  9. Light Blue 1 item
  10. Multicolor 14 items
  11. Navy Blue 2 items
  12. Pink 3 items
  13. Red 6 items
  14. Red, Black 1 item
  15. Silver 3 items
  16. Tan 1 item
  17. Teal 2 items
  18. Verdigris 2 items
  19. White 18 items
  20. White, Black 1 item
  21. Yellow 3 items
Us Shoe Size
  1. 10 3 items
  2. 11 1 item
  3. 13 1 item
  4. 4 24 items
  5. 5 1 item
  6. 6 75 items
  7. 7.5 70 items
  8. 8 4 items
  9. 8.5 6 items
  10. 8.5 WD 1 item
  11. 9 2 items
  12. 9 W 1 item
  13. 9.5 3 items
  14. Kids 2-3 3 items
  15. Kids 4-5 5 items
  16. L 9-10 1 item
  17. S 7/8 21 items
  18. W 9.5-10.5 11 items
Department
  1. Adult 39 items
  2. Adults 24 items
  3. Adults, Kids, Teens 2 items
  4. Girls 9 items
  5. Kids 19 items
  6. Men 22 items
  7. Unisex Adults 16 items
  8. Unisex Kids 5 items
  9. Women 97 items
Occasion
  1. Activewear 11 items
  2. Activewear, Casual 13 items
  3. All Occasions 3 items
  4. Any 15 items
  5. Business 2 items
  6. Business, Casual, Formal, Party/Cocktail, Travel, Wedding 1 item
  7. Business, Casual, Party/Cocktail, Wedding 1 item
  8. Casual 8 items
  9. Casual, Travel 1 item
  10. Casual, Workwear 27 items
  11. Christmas 12 items
  12. Easter 92 items
  13. Fall 4 items
  14. Formal 2 items
  15. Formal, Party/Cocktail, Travel, Wedding 36 items
  16. Party/Cocktail 2 items
  17. Summer 9 items
  18. Wedding 2 items
Lining Material
  1. Polyester 3 items
  2. Textile 6 items
  3. Wool 224 items
Style
  1. ABIS_DVD 16 items
  2. Antique 6 items
  3. Antique Style 6 items
  4. Beach 1 item
  5. Black & White 2 items
  6. Bootie 7 items
  7. Classic 2 items
  8. Classic Rock, Hard Rock 10 items
  9. Complete Outfit 1 item
  10. Country 10 items
  11. Decorative 28 items
  12. Firefighting 1 item
  13. Flat 3 items
  14. Flats and Slip Ons 15 items
  15. French Country 1 item
  16. Heels 1 item
  17. Kid's 1 item
  18. Long Sleeve 8 items
  19. LP 12 items
  20. Mule 3 items
  21. Nautical 35 items
  22. Not Available 1 item
  23. Novelty 1 item
  24. Onesie 2 items
  25. Platform 11 items
  26. Rustic/Primitive 7 items
  27. Slide 5 items
  28. Slingback 2 items
  29. Slip-On 5 items
  30. Sneaker 12 items
  31. Strappy 11 items
  32. T-Strap 2 items
  33. Traditional 2 items
  34. Victorian 1 item
  35. Victorian Style 2 items
Heel Height
  1. 2.75 in 1 item
  2. Flat (Under 1 in) 1 item
  3. High (3-3.9 in) 226 items
  4. Mid (2-2.9 in) 5 items
Upper Material
  1. 100% Nylon 21 items
  2. 100% Polyester 1 item
  3. Beads 6 items
  4. Faux Leather 6 items
  5. Faux Leather upper; Rubber sole 2 items
  6. Faux Suede 20 items
  7. Lace Mesh 2 items
  8. Man Made Material 2 items
  9. Not Available 17 items
  10. Polyester 1 item
  11. Suede 22 items
  12. Synthetic 133 items
Price
  1. $0.00 - $99.99 225 items
  2. $100.00 - $199.99 6 items
  3. $200.00 and above 2 items
Toe Shape
  1. Almond Toe 1 item
  2. Pointed Toe 2 items
  3. Round Toe 230 items
Closure
  1. Lace Up 22 items
  2. Pull On 25 items
  3. Slip On 142 items
  4. Tie 1 item
  5. Zip 43 items
Heel Style
  1. Block 1 item
  2. Stiletto 232 items
Theme
  1. Adventure 2 items
  2. Animals 1 item
  3. Bar & Club 1 item
  4. Bar & Club, Humor, Novelty 2 items
  5. Barbie 5 items
  6. Beach 1 item
  7. Beer, Bar & Club 1 item
  8. Beware Of Dog 1 item
  9. Butterflies 1 item
  10. Cartoons 4 items
  11. Chickens 2 items
  12. Children 1 item
  13. Close The Gate 6 items
  14. Coffee 3 items
  15. College 23 items
  16. Comics, Television 2 items
  17. DC Super Heroes 9 items
  18. Developmental Activities 2 items
  19. Disney, Cartoons, Princesses/Fairies 1 item
  20. Dogs 2 items
  21. Emergency Services 13 items
  22. Equestrian 1 item
  23. Fall 1 item
  24. Farm 3 items
  25. Firefighting 10 items
  26. Fleur De Lis 4 items
  27. Flower 2 items
  28. Flowers 1 item
  29. French Bulldog 1 item
  30. Halloween, Holiday, Bones, Glow-In-The-Dark, Matching Family Pajamas, Skeleton, Spooky 1 item
  31. Holiday 4 items
  32. Humor 1 item
  33. Kitchen 1 item
  34. Man Cave 1 item
  35. Movies 31 items
  36. Movies, Sci-Fi 23 items
  37. Nautical 15 items
  38. Outdoor 6 items
  39. Racing 1 item
  40. Rhinestones 16 items
  41. Skull 3 items
  42. Sports 8 items
  43. Squirrel 1 item
  44. Turtles 1 item
  45. Unicorns 2 items
  46. United States 2 items
  47. Video Games 1 item
  48. Welcome 4 items
  49. Wine 1 item
  50. Work 4 items
Shoe Width
  1. M 16 items
  2. Medium 91 items
  3. Standard 103 items
  4. W 22 items
  5. WD 1 item
Insole Material
  1. Cushioned Faux Sherpa Insole 16 items
  2. Memory Foam 211 items
  3. Wool 6 items
Season
  1. Fall 7 items
  2. Fall, Spring, Summer 17 items
  3. Fall, Spring, Summer, Winter 25 items
  4. Fall, Winter 69 items
  5. Spring 8 items
  6. Spring, Summer 113 items
  7. Summer 2 items
  8. Winter 7 items
Compare Products
  1. Remove This Item
Compare
Clear All
You have no items to compare.
My Wish List
Last Added Items
  1. Add to Cart
    Remove This Item
Go to Wish List
You have no items in your wish list.
Copyright © 2023-present Chillicothe Market All rights reserved.