• 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

First 20 Products (Stock Status Check):

IN STOCK: 14 | OUT OF STOCK: 1 | First In-Stock at position: 1
# ID SKU Name Stock Status
1 31 254007820001 Decorative Cast Iron Wall Shelf Bracket Brace Bird IN STOCK (1)
2 32 254107820002 Angle Bracket Cast Iron Wall Shelf Brace Decorativ IN STOCK (1)
3 205 930907820008 Cast Iron Dinner Bell Rooster & Flowers Colorful D OUT OF STOCK (0)
4 247 274007820001 Merry Christmas Garden Flag Winter Double Sided Ya IN STOCK (1)
5 248 273607820002 Halloween Garden Flag Happy Haunting Trick Or Trea IN STOCK (1)
6 249 272907820005 Welcome Garden Flag Pink Flowers Yard Banner Decor IN STOCK (1)
7 250 273207820000 Funny Cat Garden Flag Beware Of Cat Double Sided Y IN STOCK (1)
8 251 273207820011 Funny Black Lab Puppy Garden Flag Beware Of Dog Do IN STOCK (1)
9 2359 272907820016 Welcome To Our Home Garden Flag – Seasonal Outdo IN STOCK (1)
10 3110 277091711997 Funko Pop! Pin Star Wars Max Rebo SE Target Exclus IN STOCK (1)
11 3111 277093334750 SUPER7 RUN DMC Joseph "RUN" Simmons ReAction Figur IN STOCK (1)
12 3112 277093398774 FUNKO POP! MOVIES: Raiders of the Lost Ark - Arnol IN STOCK (1)
13 3113 277093424276 FUNKO POP! MOVIES: The Last Crusade - Henry Jones IN STOCK (1)
14 3114 277093437505 Funko Pop! Pin Star Wars Max Rebo SE Target Exclus IN STOCK (1)
15 23561 286589557366 Govee RGBIC LED Strip Lights, 16.4ft Smart LED Lig 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 15

Set Descending Direction
Page
per page
Shop By
Now Shopping by
  1. Primary Color Multicolor Remove This Item
  2. Shoe Shaft Style Low Top Remove This Item
Clear All
Shopping Options
Category
  1. Garden Flags 6 items
  2. Doorbells 1 item
Set Includes
  1. 1 Shelf Bracket 8 items
  2. Kickplate / toe kick 7 items
Outsole Material
  1. Leather & Rubber 2 items
  2. Rubber 6 items
  3. Suede 7 items
Accents
  1. Glow-In-The-Dark, Hooded 6 items
  2. Logo 3 items
  3. Stripe 6 items
Calf Width
  1. Regular 15 items
Platform Height
  1. 1.25 in 15 items
Shape
  1. Foot Print 7 items
  2. Tractor 6 items
  3. Triangle 2 items
Item Weight
  1. 2 lb 3 items
  2. 5 oz 5 items
  3. 5.875000 7 items
Finish
  1. Glossy 6 items
  2. Matt 1 item
  3. Painted 8 items
Product Line
  1. BearPaw 7 items
  2. Junie 2 items
  3. Troy 6 items
Room
  1. Any 8 items
  2. Any Room 7 items
Personalized
  1. No 15 items
Mounting
  1. Wall Mounted 15 items
Indoor Outdoor
  1. Indoor & Outdoor 15 items
Suitable For
  1. Coats, Towels, Hats 7 items
  2. Custom Shelves 2 items
  3. Home 6 items
Subject
  1. Cat 1 item
  2. Christmas 3 items
  3. Close The Gate 2 items
  4. Dog 1 item
  5. Firefighting 6 items
  6. United States 1 item
  7. Wine 1 item
Assembly Required
  1. No 15 items
Hook Style
  1. Antique 6 items
  2. Traditional 9 items
Manufacturer
  1. Flag Emotes 7 items
  2. Funko 4 items
  3. Govee 1 item
  4. Super7 1 item
  5. Unos 2 items
Color
  1. Multicolor 14 items
  2. Teal 1 item
Us Shoe Size
  1. 13 8 items
  2. 7.5 6 items
  3. S 7/8 1 item
Department
  1. Adults 8 items
  2. Kids 5 items
  3. Men 1 item
  4. Women 1 item
Occasion
  1. Activewear, Casual 3 items
  2. Christmas 1 item
  3. Easter 6 items
  4. Everyday 1 item
  5. Halloween 3 items
  6. Summer 1 item
Lining Material
  1. Polyester 2 items
  2. Textile 6 items
  3. Wool 7 items
Style
  1. ABIS_DVD 1 item
  2. Antique Style 2 items
  3. LP 5 items
  4. Traditional 7 items
Heel Height
  1. 2.75 in 6 items
  2. High (3-3.9 in) 7 items
  3. Mid (2-2.9 in) 2 items
Upper Material
  1. Beads 2 items
  2. Suede 1 item
  3. Synthetic 12 items
Price
  1. $0.00 - $9.99 1 item
  2. $10.00 - $19.99 9 items
  3. $20.00 and above 5 items
Toe Shape
  1. Round Toe 13 items
  2. Square Toe 2 items
Closure
  1. Lace Up 9 items
  2. Slip On 1 item
  3. Zip 5 items
Heel Style
  1. Kitten 2 items
  2. Stiletto 13 items
Theme
  1. Birds 2 items
  2. Black Lab 1 item
  3. Cats 1 item
  4. Halloween 1 item
  5. Holiday 1 item
  6. Movies 6 items
  7. Outdoor, Sports, University, Fashion 1 item
  8. Welcome 2 items
Shoe Width
  1. M 1 item
  2. Standard 14 items
Insole Material
  1. Cushioned Faux Sherpa Insole 1 item
  2. Foam 6 items
  3. Memory Foam 8 items
Fabric Type
  1. Knit 8 items
  2. Shearling 7 items
Season
  1. Fall, Spring, Summer 3 items
  2. Fall, Spring, Summer, Winter 6 items
  3. Fall, Winter 6 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.