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

Position	ID	SKU	Stock Status
1	846	286278494687	1
2	849	286278436738	1
3	879	286280138492	1

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 (846, 849, 879)) ORDER BY FIELD(e.entity_id,846,849,879)

    

        ORDER BY Clauses:
        Total ORDER BY clauses: 1

Order #1: FIELD(e.entity_id,846,849,879)

    
Stock Distribution (Total: 3 products):Stock Status "1": 3 products

        Product Samples:
        
            
                Pos
                ID
                SKU
                Name
                Stock
            

                1
                846
                286278494687
                Allegra K Women's Lace Mesh Floral Embro
                
                    1 (IN STOCK)                
            

                2
                849
                286278436738
                Women's Aurora Water Shoes Black Sz 6
                
                    1 (IN STOCK)                
            

                3
                879
                286280138492
                Women's Sterling Chelsea Boots Zip Up An
                
                    1 (IN STOCK)                
            

    

Pos	ID	SKU	Name	Stock
1	846	286278494687	Allegra K Women's Lace Mesh Floral Embro	1 (IN STOCK)
2	849	286278436738	Women's Aurora Water Shoes Black Sz 6	1 (IN STOCK)
3	879	286280138492	Women's Sterling Chelsea Boots Zip Up An	1 (IN STOCK)

Its too late afterGetLoadedProductCollection
Its too late afterGetLoadedProductCollection

Compare Products

Remove This Item

You have no items to compare.

My Wish List

Last Added Items

You have no items in your wish list.