• Sign In
Toggle Nav
My Cart
Search
Advanced Search
  • Compare Products
Menu
Account

Home & Garden

Plugin Debug - SortInStock Observer - Collection Data:

Collection loaded: NO

SQL: 

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`.`stock_status` 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` ON e.entity_id = stock.product_id AND stock.website_id = 0 ORDER BY `stock`.`stock_status` DESC

PositionIDSKUStock Status
19112862978754670
2119742865684107360
39002862951924571
49012862941302861
5119642865538222041
6119652865562276101
7119662865562697351
8119672865607173121
9119682865607277121
10119702865635669171
Its too late afterGetLoadedProductCollection

InstockProductsFirst Debug

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`.`stock_status`, `stock_status_index`.`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` ON e.entity_id = stock.product_id AND stock.website_id = 0
 LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (e.entity_id IN (911, 11974, 900, 901, 11964, 11965, 11966, 11967, 11968, 11970, 11971, 11972, 11973, 13279, 13400, 14633, 19014, 20802, 23561, 24598, 953, 764, 916, 951, 14741)) ORDER BY FIELD(e.entity_id,911,11974,900,901,11964,11965,11966,11967,11968,11970,11971,11972,11973,13279,13400,14633,19014,20802,23561,24598,953,764,916,951,14741)

ORDER BY Clauses:

Total ORDER BY clauses: 1

Order #1: FIELD(e.entity_id,911,11974,900,901,11964,11965,11966,11967,11968,11970,11971,11972,11973,13279,13400,14633,19014,20802,23561,24598,953,764,916,951,14741)

Stock Distribution (Total: 25 products):

Stock Status "0": 5 products

Stock Status "1": 20 products

Product Samples:

Pos ID SKU Name Stock
1 911 286297875467 Wireless Meat Thermometer Meater Plus Di 0 (OUT OF STOCK)
2 11974 286568410736 Kamado Joe JoeTisserie 24 inch Big Joe G 0 (OUT OF STOCK)
3 900 286295192457 Bearpaw Retro Super Shorty Size 4 Youth 1 (IN STOCK)
4 901 286294130286 Traeger Timberline Outdoor Kitchen Trim 1 (IN STOCK)
5 11964 286553822204 Alex Men S 7/8 Chestnut Suede Cushion Fa 1 (IN STOCK)
6 11965 286556227610 The Object of Beauty DVD Movie Full Scre 1 (IN STOCK)
7 11966 286556269735 Kenwood - Road Series 12" Single Voice C 1 (IN STOCK)
8 11967 286560717312 Kenwood - Road Series 12" Single Voice C 1 (IN STOCK)
9 11968 286560727712 Kenwood - Road Series 12" Single Voice C 1 (IN STOCK)
10 11970 286563566917 Genuine Dyson Wall Mount Docking Station 1 (IN STOCK)
11 11971 286566095118 Core Innovations - Amplified Bar HDTV In 1 (IN STOCK)
12 11972 286568323356 Baby Monitor VTech DM221 Digital Audio T 1 (IN STOCK)
13 11973 286568347758 CyberPower 650VA Battery Back-Up System 1 (IN STOCK)
14 13279 286571172223 Pioneer TS-WX1010A - 10" Active Sealed s 1 (IN STOCK)
15 13400 286571370525 Kenwood KSC-PSW8 8" Class-D Compact Powe 1 (IN STOCK)
16 14633 286573689044 Kenwood KSC-PSW8 8" Class-D Compact Powe 1 (IN STOCK)
17 19014 286581315080 Wireless Meat Thermometer Meater Plus Di 1 (IN STOCK)
18 20802 286584503041 Vava EVOLVE Split View Screen Baby Monit 1 (IN STOCK)
19 23561 286589557366 Govee RGBIC LED Strip Lights, 16.4ft Sma 1 (IN STOCK)
20 24598 286591620046 Metra Stereo Wiring Harness Select 2003- 1 (IN STOCK)
21 953 257407650009 Real Sand Castle Figurine 118 4" Tall Co 0 (OUT OF STOCK)
22 764 276816918998 Dearfoams Men's Shearling Side Stitch Mo 0 (OUT OF STOCK)
23 916 276841802932 Otterbox Elevation 20 Tumbler Thermal Li 0 (OUT OF STOCK)
24 951 273407820004 Decorative Trivet Square Cast Iron Hot P 1 (IN STOCK)
25 14741 277115995062 CoComelon My First Sing-Along Boombox Mu 1 (IN STOCK)
Its too late afterGetLoadedProductCollection
Its too late afterGetLoadedProductCollection
View as Grid List

Items 1-25 of 25

Set Descending Direction
Page
per page
Shop By
Now Shopping by
  1. Upper Material Suede Remove This Item
  2. Fabric Type Shearling Remove This Item
Clear All
Shopping Options
Set Includes
  1. Kickplate / toe kick 22 items
  2. Wall Mounted Hose Hanger 2 items
Outsole Material
  1. EVA 1 item
  2. Suede 24 items
Accents
  1. big girls 6 items
  2. Glow-In-The-Dark, Hooded 18 items
  3. Heel Strep 1 item
  4. wool lining 6 items
Calf Width
  1. Regular 24 items
Platform Height
  1. 1.25 in 24 items
Primary Color
  1. Black 12 items
  2. Brown 4 items
  3. Chestnut 5 items
  4. Clear 1 item
  5. Gray 1 item
  6. Multicolor 2 items
Shape
  1. Foot Print 23 items
  2. J Hook 1 item
Item Weight
  1. 1.5 lbs 1 item
  2. 5.875000 23 items
Finish
  1. Glossy 17 items
  2. Painted 7 items
Product Line
  1. BearPaw 24 items
  2. Junie 1 item
Room
  1. Any Room 24 items
Personalized
  1. No 24 items
Mounting
  1. Wall Mounted 24 items
Indoor Outdoor
  1. Indoor & Outdoor 23 items
  2. Outdoor 1 item
Suitable For
  1. Coats, Towels, Hats 24 items
Subject
  1. Boxer Dog 1 item
  2. Firefighting 17 items
  3. Foot Print 6 items
Assembly Required
  1. No 24 items
Hook Style
  1. Traditional 24 items
Shoe Shaft Style
  1. Ankle 6 items
  2. Low Top 19 items
Manufacturer
  1. ALEX 1 item
  2. ARTISAN 1 item
  3. Cocomelon 1 item
  4. Core Innovations 1 item
  5. CyberPower 1 item
  6. Dearfoams 1 item
  7. Dyson 1 item
  8. Govee 1 item
  9. Import Wholesales 1 item
  10. Kamado Joe 1 item
  11. Kenwood 5 items
  12. Maryanne 4 items
  13. Metra 1 item
  14. Mr. Sandman 1 item
  15. Pioneer 1 item
  16. Traeger Industries 1 item
  17. Vava 1 item
  18. VTech 1 item
Color
  1. Black 12 items
  2. Brown 4 items
  3. Chestnut 5 items
  4. Clear 1 item
  5. Gray 1 item
  6. Multicolor 2 items
Us Shoe Size
  1. 10 1 item
  2. 4 6 items
  3. S 7/8 18 items
Department
  1. Girls 6 items
  2. Men 19 items
Occasion
  1. Casual 7 items
  2. Easter 18 items
  3. Travel 1 item
Lining Material
  1. Shearling 1 item
  2. Wool 24 items
Style
  1. ABIS_DVD 17 items
  2. Bootie 6 items
  3. Moccasin 1 item
  4. Slide Slippers 1 item
Heel Height
  1. Flat (Under 1 in) 1 item
  2. High (3-3.9 in) 24 items
Price
  1. $0.00 - $99.99 21 items
  2. $100.00 - $199.99 3 items
  3. $200.00 and above 1 item
Toe Shape
  1. Round Toe 25 items
Closure
  1. Pull On 6 items
  2. Slip On 19 items
Heel Style
  1. Block 1 item
  2. Stiletto 24 items
Theme
  1. Classic 1 item
  2. Movies 18 items
  3. Outdoor 6 items
Shoe Width
  1. M 18 items
  2. Standard 7 items
Insole Material
  1. Cushioned Faux Sherpa Insole 18 items
  2. Shearling 1 item
  3. Wool 6 items
Season
  1. Fall 7 items
  2. Fall, Winter 18 items
  3. Spring 7 items
  4. Summer 1 item
  5. Winter 7 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.