• 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 ALL Products (Stock Status Check):

IN STOCK: 14 | OUT OF STOCK: 0
ID SKU Name Stock Status
1733 272907820015 Thankful Grateful Blessed Fall Leaves Garden Flag IN STOCK (1)
1732 000000410068 Disney Princess Self Stick Removable Appliques Wal IN STOCK (1)
3113 277093424276 FUNKO POP! MOVIES: The Last Crusade - Henry Jones IN STOCK (1)
3112 277093398774 FUNKO POP! MOVIES: Raiders of the Lost Ark - Arnol IN STOCK (1)
3111 277093334750 SUPER7 RUN DMC Joseph "RUN" Simmons ReAction Figur IN STOCK (1)
1877 284292040564 Baby Einstein Four Fundamentals 5 Developmental Ac IN STOCK (1)
32 254107820002 Angle Bracket Cast Iron Wall Shelf Brace Decorativ 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)
3110 277091711997 Funko Pop! Pin Star Wars Max Rebo SE Target Exclus IN STOCK (1)
3114 277093437505 Funko Pop! Pin Star Wars Max Rebo SE Target Exclus IN STOCK (1)
31 254007820001 Decorative Cast Iron Wall Shelf Bracket Brace Bird IN STOCK (1)
1879 284965973493 vintage Cracker Jack prize charm Seagrams Gin Bott IN STOCK (1)
2359 272907820016 Welcome To Our Home Garden Flag – Seasonal Outdo 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-14 of 14

Set Descending Direction
Page
per page
Shop By
Now Shopping by
  1. Primary Color Multicolor Remove This Item
  2. Insole Material Memory Foam Remove This Item
Clear All
Shopping Options
Category
  1. Garden Flags 3 items
Set Includes
  1. 1 Shelf Bracket 2 items
  2. Kickplate / toe kick 12 items
Outsole Material
  1. Leather & Rubber 2 items
  2. Suede 12 items
Accents
  1. Buckle 6 items
  2. Glow-In-The-Dark, Hooded 5 items
  3. Logo 3 items
Calf Width
  1. Regular 14 items
Platform Height
  1. 1.25 in 14 items
Shape
  1. Foot Print 12 items
  2. Triangle 2 items
Item Weight
  1. 2 lb 2 items
  2. 5.875000 12 items
Finish
  1. Glossy 5 items
  2. Matt 1 item
  3. Painted 8 items
Product Line
  1. BearPaw 12 items
  2. Junie 2 items
Room
  1. Any 2 items
  2. Any Room 12 items
Personalized
  1. No 14 items
Mounting
  1. Wall Mounted 14 items
Indoor Outdoor
  1. Indoor & Outdoor 14 items
Suitable For
  1. Coats, Towels, Hats 12 items
  2. Custom Shelves 2 items
Subject
  1. Beware Of Dog 2 items
  2. Close The Gate 2 items
  3. Dog 2 items
  4. Fall 1 item
  5. Firefighting 5 items
  6. Princess 1 item
  7. Wine 1 item
Assembly Required
  1. No 14 items
Hook Style
  1. Traditional 14 items
Shoe Shaft Style
  1. Ankle 6 items
  2. Low Top 8 items
Manufacturer
  1. Baby Einstein 1 item
  2. Flag Emotes 4 items
  3. Funko 4 items
  4. Seagram's 1 item
  5. Super7 1 item
  6. Unknown 1 item
  7. Unos 2 items
Color
  1. Multicolor 14 items
Us Shoe Size
  1. 13 2 items
  2. 6 6 items
  3. 7.5 6 items
Department
  1. Adult 4 items
  2. Adults 4 items
  3. Kids 5 items
  4. Women 1 item
Occasion
  1. Activewear, Casual 2 items
  2. Any 5 items
  3. Easter 5 items
  4. Fall 1 item
  5. Summer 1 item
Lining Material
  1. Polyester 2 items
  2. Wool 12 items
Style
  1. Antique 2 items
  2. Antique Style 1 item
  3. LP 5 items
  4. Nautical 4 items
  5. Traditional 2 items
Heel Height
  1. High (3-3.9 in) 12 items
  2. Mid (2-2.9 in) 2 items
Upper Material
  1. Beads 2 items
  2. Synthetic 12 items
Price
  1. $0.00 - $9.99 2 items
  2. $10.00 - $19.99 9 items
  3. $20.00 and above 3 items
Toe Shape
  1. Round Toe 12 items
  2. Square Toe 2 items
Closure
  1. Lace Up 3 items
  2. Slip On 6 items
  3. Zip 5 items
Heel Style
  1. Kitten 2 items
  2. Stiletto 12 items
Theme
  1. Animals 1 item
  2. Birds 2 items
  3. Developmental Activities 2 items
  4. Disney, Cartoons, Princesses/Fairies 1 item
  5. Fall 1 item
  6. Movies 5 items
  7. Racing 1 item
  8. Welcome 1 item
Shoe Width
  1. Medium 6 items
  2. Standard 8 items
Fabric Type
  1. Knit 2 items
  2. Shearling 12 items
Season
  1. Fall, Spring, Summer 3 items
  2. Fall, Winter 5 items
  3. Spring, Summer 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.