• 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: 31 | OUT OF STOCK: 2 | First In-Stock at position: 2 | Total Products: 33
Position ID SKU Name Stock Status
1 11974 286568410736 Kamado Joe JoeTisserie 24 inch Big Joe Grill Rotis OUT OF STOCK
2 3110 277091711997 Funko Pop! Pin Star Wars Max Rebo SE Target Exclus IN STOCK
3 3111 277093334750 SUPER7 RUN DMC Joseph "RUN" Simmons ReAction Figur IN STOCK
4 3112 277093398774 FUNKO POP! MOVIES: Raiders of the Lost Ark - Arnol IN STOCK
5 3113 277093424276 FUNKO POP! MOVIES: The Last Crusade - Henry Jones IN STOCK
6 3114 277093437505 Funko Pop! Pin Star Wars Max Rebo SE Target Exclus IN STOCK
7 3115 286549184208 Women's Darla Platform Mule Heels Black 6 IN STOCK
8 3117 286550852026 Funko Pop! Vinyl: Indiana Jones - Indiana Jones #1 IN STOCK
9 11956 277098598300 The Real Mccoy DVD Action Crime Kim Basinger Val K IN STOCK
10 11957 277103109122 Snake Eyes (DVD, 1999, Sensormatic) Nicolas Cage G IN STOCK
11 11958 277105767269 Sahara - Universal Mouse Pad with Wireless Chargin IN STOCK
12 11959 277108023030 Pioneer TS-A30S4 1400 Watt 12" 4 Ohm Car Audio Sub IN STOCK
13 11960 277108609311 Pioneer TS-A30S4 1400 Watt 12" 4 Ohm Car Audio Sub IN STOCK
14 11961 286566328311 Kenwood KFC 1666R 6.5 Inch Coaxial Car Speakers 30 IN STOCK
15 11962 286565954268 Pioneer A-Series TS-A653FH 6.5" 2-Way 340 W Max Po IN STOCK
16 11963 286563364559 Pioneer 2-Way Speaker TS-G650 300W Max 6 1/2 / 6 3 IN STOCK
17 11964 286553822204 Alex Men S 7/8 Chestnut Suede Cushion Faux Sherpa IN STOCK
18 11965 286556227610 The Object of Beauty DVD Movie Full Screen John Ma IN STOCK
19 11966 286556269735 Kenwood - Road Series 12" Single Voice Coil 4-Ohm IN STOCK
20 11967 286560717312 Kenwood - Road Series 12" Single Voice Coil 4-Ohm IN STOCK
... products 21 to 20 hidden ...
21 11968 286560727712 Kenwood - Road Series 12" Single Voice Coil 4-Ohm IN STOCK
22 11969 286563505562 OEM Dyson V15 Detect Laser Slim Fluffy Optic Clean OUT OF STOCK
23 11970 286563566917 Genuine Dyson Wall Mount Docking Station for V11 / IN STOCK
24 11971 286566095118 Core Innovations - Amplified Bar HDTV Indoor Anten IN STOCK
25 11972 286568323356 Baby Monitor VTech DM221 Digital Audio Talk Back I IN STOCK
26 11973 286568347758 CyberPower 650VA Battery Back-Up System 360W - Bla IN STOCK
27 13279 286571172223 Pioneer TS-WX1010A - 10" Active Sealed subwoofer w IN STOCK
28 13400 286571370525 Kenwood KSC-PSW8 8" Class-D Compact Powered Subwoo IN STOCK
29 14633 286573689044 Kenwood KSC-PSW8 8" Class-D Compact Powered Subwoo IN STOCK
30 14741 277115995062 CoComelon My First Sing-Along Boombox Music Toy Mi IN STOCK
31 19014 286581315080 Wireless Meat Thermometer Meater Plus Digital Exte IN STOCK
32 20802 286584503041 Vava EVOLVE Split View Screen Baby Monitor (2x 720 IN STOCK
33 23561 286589557366 Govee RGBIC LED Strip Lights, 16.4ft Smart LED Lig 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 33

Set Descending Direction
Page
per page
Shop By
Now Shopping by
  1. Shoe Shaft Style Low Top Remove This Item
  2. Theme Movies Remove This Item
Clear All
Shopping Options
Set Includes
  1. Kickplate / toe kick 31 items
Outsole Material
  1. Suede 33 items
Accents
  1. Glow-In-The-Dark, Hooded 33 items
Calf Width
  1. Regular 31 items
Platform Height
  1. 1.25 in 31 items
Primary Color
  1. Black 20 items
  2. Chestnut 5 items
  3. Clear 1 item
  4. Gray 1 item
  5. Multicolor 6 items
Shape
  1. Foot Print 31 items
Item Weight
  1. 5.875000 31 items
Finish
  1. Glossy 31 items
Product Line
  1. BearPaw 33 items
Room
  1. Any Room 31 items
Personalized
  1. No 31 items
Mounting
  1. Wall Mounted 31 items
Indoor Outdoor
  1. Indoor & Outdoor 31 items
Suitable For
  1. Coats, Towels, Hats 31 items
Subject
  1. Firefighting 31 items
Assembly Required
  1. No 31 items
Hook Style
  1. Traditional 31 items
Manufacturer
  1. ALEX 1 item
  2. ARTISAN 1 item
  3. Cocomelon 1 item
  4. Core Innovations 1 item
  5. CyberPower 1 item
  6. Darla 1 item
  7. Dyson 2 items
  8. Funko 7 items
  9. Govee 1 item
  10. Kamado Joe 1 item
  11. Kenwood 6 items
  12. Pioneer 5 items
  13. Sahara 1 item
  14. Super7 1 item
  15. Traeger Industries 1 item
  16. Vava 1 item
  17. VTech 1 item
Color
  1. Black 20 items
  2. Chestnut 5 items
  3. Clear 1 item
  4. Gray 1 item
  5. Multicolor 6 items
Us Shoe Size
  1. 6 11 items
  2. 7.5 5 items
  3. S 7/8 17 items
Department
  1. Kids 5 items
  2. Men 17 items
  3. Women 11 items
Occasion
  1. Easter 33 items
Lining Material
  1. Wool 33 items
Style
  1. ABIS_DVD 16 items
  2. LP 5 items
  3. Platform 11 items
  4. Slide Slippers 1 item
Heel Height
  1. High (3-3.9 in) 33 items
Upper Material
  1. Suede 17 items
  2. Synthetic 16 items
Price
  1. $0.00 - $99.99 29 items
  2. $100.00 - $199.99 3 items
  3. $200.00 and above 1 item
Toe Shape
  1. Round Toe 33 items
Closure
  1. Slip On 28 items
  2. Zip 5 items
Heel Style
  1. Stiletto 33 items
Shoe Width
  1. M 17 items
  2. Standard 16 items
Insole Material
  1. Cushioned Faux Sherpa Insole 17 items
  2. Memory Foam 16 items
Fabric Type
  1. Shearling 33 items
Season
  1. Fall, Winter 33 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.