• 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`, `stock_status`.`stock_status` AS `is_salable` 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 = 1 ORDER BY `stock_status`.`stock_status` DESC

First 20 Products (Stock Status Check):

IN STOCK: 20 | OUT OF STOCK: 0
ID SKU Name Stock Status
329 019700410014 Mermaid Wall Hook Rust Cast Iron Coat Hanger Ocean IN STOCK (1)
330 019707820004 Wall Hook Skeleton Key Coat Rack Antique Style 3 H IN STOCK (1)
333 019707820003 Seahorse Wall Hook Ocean Decor Rust Brown Decorati IN STOCK (1)
1727 019700410046 Cast Iron Wall Hook Rack Fish Bone Skeleton Hooks IN STOCK (1)
1728 274007820000 Slow Down Garden Flag Caution Children At Play Dou IN STOCK (1)
1729 261207820000 Funny Aluminum Sign No Poop Heads Allowed Men Man IN STOCK (1)
1730 273207820013 Don't Be A Poop Head Emoji Clean Up After Dog Gard IN STOCK (1)
1731 000007830114 NASCAR Kasey Kahne Wall Appliques Decal Racing Sti IN STOCK (1)
1732 000000410068 Disney Princess Self Stick Removable Appliques Wal IN STOCK (1)
1733 272907820015 Thankful Grateful Blessed Fall Leaves Garden Flag IN STOCK (1)
1734 163807820003 Aluminum Sign Firemans Cross White Firefighting Pl IN STOCK (1)
1735 273807820002 Welcome American Garden Flag Emotes Double Sided A IN STOCK (1)
1736 322207820000 Fish Pocket Beer Bottle Opener Handheld Brown Cast IN STOCK (1)
1737 273707820003 Happy Easter Spring Flowers Birds Garden Flag Emot IN STOCK (1)
1738 273007820003 Cast Iron Pedestal Bird Feeder Bath 8" Wide Decora IN STOCK (1)
1739 930907820000 Cast Iron Horse Dinner Bell – Rustic Brown Wall IN STOCK (1)
1740 142307820000 Aluminum Sign Coffee Cappuccino Mocha Espresso Fra IN STOCK (1)
1741 277012444440 New Brielle Home Cotton Jersey Knit (T-Shirt) Shee IN STOCK (1)
1742 277015134596 CyberPower 1000VA UPS Battery Backup Surge Protect IN STOCK (1)
1743 322207820002 Wall Mounted Skull Beer Bottle Opener Cast Iron Ho 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-20 of 42

Set Descending Direction
Page
per page
Shop By
Now Shopping by
  1. Department Adult Remove This Item
  2. Heel Style Stiletto Remove This Item
Clear All
Shopping Options
Category
  1. Garden Flags 5 items
  2. Doorbells 1 item
  3. Wall Hooks 3 items
  4. Signs 7 items
Set Includes
  1. Kickplate / toe kick 39 items
  2. Wall Mounted Hose Hanger 3 items
Outsole Material
  1. Rubber 3 items
  2. Suede 39 items
Accents
  1. Buckle 39 items
  2. Stripe 3 items
Calf Width
  1. Regular 42 items
Platform Height
  1. 1.25 in 42 items
Primary Color
  1. Beige 1 item
  2. Black 1 item
  3. Brown 32 items
  4. Multicolor 4 items
  5. White 2 items
  6. Yellow 2 items
Shape
  1. Foot Print 39 items
  2. J Hook 3 items
Item Weight
  1. 1 lb 1 item
  2. 10 oz 1 item
  3. 5.875000 39 items
  4. 6 oz 1 item
Finish
  1. Glossy 3 items
  2. Matt 8 items
  3. Painted 31 items
Product Line
  1. BearPaw 39 items
  2. Troy 3 items
Room
  1. Any Room 39 items
  2. Bathroom 3 items
Personalized
  1. No 42 items
Mounting
  1. Wall Mounted 42 items
Indoor Outdoor
  1. Indoor & Outdoor 39 items
  2. Outdoor 3 items
Suitable For
  1. Coat 3 items
  2. Coats, Towels, Hats 39 items
Subject
  1. American Flag 5 items
  2. Barbies 5 items
  3. Boxer Dog 3 items
  4. Child Safety 2 items
  5. Coffee 6 items
  6. Dachshund 2 items
  7. Darts 1 item
  8. Dog 2 items
  9. Dora The Explorer 4 items
  10. Fall 2 items
  11. Fire & Rescue 8 items
  12. Princess 1 item
  13. Unicorns 1 item
Assembly Required
  1. No 42 items
Hook Style
  1. Tail 1 item
  2. Traditional 41 items
Shoe Shaft Style
  1. Ankle 39 items
  2. Low Top 3 items
Manufacturer
  1. Amazon 1 item
  2. Brewster 2 items
  3. BRIELLE 1 item
  4. CyberPower 2 items
  5. Flag Emotes 19 items
  6. Floortex 1 item
  7. Import Wholesales 6 items
  8. Intex 1 item
  9. Longaberger 1 item
  10. Sahara 1 item
  11. Sanus 1 item
  12. Simpli Home 1 item
  13. Sony Legacy 1 item
  14. Unknown 1 item
  15. Withit 2 items
  16. Yardbird 1 item
Color
  1. Beige 3 items
  2. Black 11 items
  3. Brown 16 items
  4. Clear 1 item
  5. Multicolor 4 items
  6. Teal 2 items
  7. White 3 items
  8. Yellow 2 items
Us Shoe Size
  1. 13 3 items
  2. 6 39 items
Occasion
  1. Any 5 items
  2. Bereavement 3 items
  3. Christmas 5 items
  4. Easter 24 items
  5. Fall 4 items
  6. Formal, Party/Cocktail, Travel, Wedding 1 item
Lining Material
  1. Textile 3 items
  2. Wool 39 items
Style
  1. Antique 1 item
  2. Classic Rock, Hard Rock 10 items
  3. Country 4 items
  4. Firefighting 1 item
  5. Nautical 26 items
Heel Height
  1. 2.75 in 3 items
  2. High (3-3.9 in) 39 items
Upper Material
  1. Synthetic 42 items
Price
  1. $0.00 - $99.99 41 items
  2. $100.00 and above 1 item
Toe Shape
  1. Round Toe 42 items
Closure
  1. Lace Up 3 items
  2. Slip On 39 items
Theme
  1. Animals 1 item
  2. Barbie 5 items
  3. Cartoons 4 items
  4. Children 1 item
  5. Coffee 3 items
  6. Disney, Cartoons, Princesses/Fairies 1 item
  7. Dogs 2 items
  8. Emergency Services 1 item
  9. Fall 1 item
  10. Firefighting 8 items
  11. Holiday 3 items
  12. Humor 1 item
  13. Man Cave 1 item
  14. Mermaids 1 item
  15. Racing 1 item
  16. Seahorse 1 item
  17. Skeleton Key 1 item
  18. Skull 3 items
  19. Unicorns 1 item
  20. United States 2 items
Shoe Width
  1. Medium 39 items
  2. Standard 3 items
Insole Material
  1. Foam 3 items
  2. Memory Foam 39 items
Fabric Type
  1. Knit 3 items
  2. Shearling 39 items
Season
  1. Fall, Spring, Summer, Winter 3 items
  2. Spring, Summer 39 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.