• 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 = 0 ORDER BY `stock_status`.`stock_status` DESC

ALL Products in Category (No Pagination):

IN STOCK: 21 | OUT OF STOCK: 0 | First In-Stock at position: 1 | Total Products: 21
Position ID SKU Name Stock Status
1 273 255707820014 Chickadee Bird S Style Plant Hook Cast Iron Flower IN STOCK
2 276 019707820014 Cast Iron Wall Hook Rack Ornate Victorian 4 Key Ho IN STOCK
3 279 255700410004 Hummingbird Plant Hanger Cast Iron Flower Basket H IN STOCK
4 280 273007820000 Decorative Rooster Plant Hanger Flower Hook Colorf IN STOCK
5 281 273107820003 Cast Iron Plant Hanger Basket Hook Ornate Fleur De IN STOCK
6 292 110102740002 Hummingbird Plant Hanger Cast Iron Flower Basket H IN STOCK
7 335 019707820017 Wall Hook Coat Rack Birds On Fence 3 Cast Iron Hoo IN STOCK
8 759 286251193844 Isotoner Genuine Suede Women's Moccasin Slip-On Sl IN STOCK
9 760 286251207844 Dearfoams Women's Shearling Scuff Slippers Chestnu IN STOCK
10 762 286251265340 Dearfoams Women's Pumpkin Slide Slippers Jack-O-La IN STOCK
11 764 276816918998 Dearfoams Men's Shearling Side Stitch Moc Slippers IN STOCK
12 770 276821346666 Dearfoams Women's Pumpkin Slide Slippers Jack-O-La IN STOCK
13 773 273407820003 Heart Shaped Trivet Ornate Decorative Cast Iron Fl IN STOCK
14 774 273907820001 Decorative Cast Iron Trivet Owl Hot Pad Kitchen De IN STOCK
15 775 273407820005 Square Trivet Black Cast Iron Decorative Ornate Di IN STOCK
16 776 273407820001 Decorative Cast Iron Trivet Ornate Heart Design Ro IN STOCK
17 777 273407820002 Cast Iron Trivet Round Ornate Heart Scrollwork Des IN STOCK
18 778 203707820002 Decorative Cast Iron Fish Trivet Kitchen Decor Hot IN STOCK
19 779 203707820001 Tea Kettle Trivet Ornate Decorative Cast Iron Kitc IN STOCK
20 780 203707820000 Decorative Cast Iron Trivet Chilli Peppers Kitchen IN STOCK
... products 21 to 20 hidden ...
21 781 274207820000 Cast Iron Nautical Anchor Trivet Hot Plate Rustic IN STOCK

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 21

Set Descending Direction
Page
per page
Shop By
Now Shopping by
  1. Item Weight 1.5 lbs Remove This Item
  2. Shoe Shaft Style Low Top Remove This Item
Clear All
Shopping Options
Category
  1. Plant Hangers 6 items
  2. Wall Hooks 1 item
  3. Trivets 9 items
Set Includes
  1. 1 Shelf Bracket 6 items
  2. Wall Mounted Hose Hanger 15 items
Outsole Material
  1. EVA 11 items
  2. Rubber 10 items
Accents
  1. Heel Strep 14 items
  2. Stripe 7 items
Calf Width
  1. Regular 21 items
Platform Height
  1. 1.25 in 21 items
Primary Color
  1. Black 7 items
  2. Brown 9 items
  3. Cream 1 item
  4. Gray 1 item
  5. Multi Colored 2 items
  6. Rust Brown 1 item
Shape
  1. J Hook 16 items
  2. S Hook 5 items
Finish
  1. Matte 6 items
  2. Painted 15 items
Product Line
  1. Junie 14 items
  2. Troy 7 items
Room
  1. Any 6 items
  2. Any Room 15 items
Personalized
  1. No 21 items
Mounting
  1. Wall Mounted 21 items
Indoor Outdoor
  1. Indoor & Outdoor 6 items
  2. Outdoor 15 items
Suitable For
  1. Coats, Towels, Hats 15 items
  2. Plants 5 items
  3. Plants, Bird Feeders, Windchimes 1 item
Subject
  1. Boxer Dog 21 items
Assembly Required
  1. No 21 items
Hook Style
  1. Antique 1 item
  2. Traditional 20 items
Manufacturer
  1. Dearfoams 2 items
  2. Flag Emotes 16 items
  3. Kev 3 items
Color
  1. Black 2 items
  2. Brown 14 items
  3. Cream 2 items
  4. Gray 1 item
  5. Light Green 1 item
  6. Multi-Color 1 item
Us Shoe Size
  1. 10 1 item
  2. 13 7 items
  3. 6 1 item
  4. L 9-10 10 items
  5. MD 7.5-8 1 item
  6. XL 11-12 1 item
Department
  1. Adults 7 items
  2. Men 1 item
  3. Women 13 items
Occasion
  1. All Occasions 7 items
  2. Any 1 item
  3. Bereavement 7 items
  4. Casual 6 items
  5. Travel 6 items
Lining Material
  1. Faux Fur 1 item
  2. Polyester 11 items
  3. Shearling 2 items
  4. Textile 7 items
Style
  1. Antique 5 items
  2. Antique Style 3 items
  3. Butterflies 1 item
  4. Farm 1 item
  5. Moccasin 2 items
  6. Nautical 1 item
  7. Slide 2 items
  8. Slip-On 1 item
  9. Traditional 1 item
  10. Victorian 1 item
  11. Vintage/Retro 2 items
  12. Western 1 item
Heel Height
  1. 2.75 in 7 items
  2. Flat (Under 1 in) 14 items
Upper Material
  1. Leather 1 item
  2. Polyester 11 items
  3. Suede 2 items
  4. Synthetic 7 items
Price
  1. $0.00 - $9.99 10 items
  2. $10.00 - $19.99 10 items
  3. $20.00 and above 1 item
Toe Shape
  1. Round Toe 21 items
Closure
  1. Lace Up 7 items
  2. Slip On 14 items
Heel Style
  1. Block 14 items
  2. Stiletto 7 items
Theme
  1. Boxer Dog 1 item
  2. Classic 1 item
  3. Compfort 2 items
  4. Cooking 1 item
  5. Farmhouse 5 items
  6. Fish 1 item
  7. Halloween 2 items
  8. Horses Horses 1 item
  9. Love & Hearts 1 item
  10. Nautical 1 item
  11. Owl 4 items
  12. Teapot 1 item
Shoe Width
  1. Standard 21 items
Insole Material
  1. Foam 7 items
  2. Memory Foam 12 items
  3. Shearling 2 items
Fabric Type
  1. Knit 8 items
  2. Shearling 13 items
Season
  1. Fall 14 items
  2. Fall, Spring, Summer, Winter 7 items
  3. Spring 3 items
  4. Summer 1 item
  5. Winter 14 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.