Magento : Out of stock products showing last in the category page

magentomagento-1.7

I am using Magento 1.7.0.2 and I have this code line that i am using in /app/code/core/Mage/Catalog/Block/Product/list.php :

$this->_productCollection = $layer->getProductCollection()
                    ->joinField(
                        'inventory_in_stock', 
                        'cataloginventory_stock_item', 
                        'is_in_stock', 
                        'product_id=entity_id',
                        'is_in_stock>=0', 
                        'left')
                    ->setOrder('inventory_in_stock','desc');

When sorting for position and name the out of stock products are last. But when sorting for price, the out of stock products are in a normal order not last.

How can i make that the out of stock products to be last even in the sort after price ?

Best Answer

Great find Alex! A tip: If you want to avoid changing core files (and possibly make this into a module), you can add it to an event listener, like this (tested on 1.8.1.0):

/**
 * Fires before a product collection is loaded
 *
 * @param Varien_Event_Observer $observer
 */
public function catalog_product_collection_load_before($observer)
{
    $collection = $observer->getCollection();
    $collection->getSelect()->joinLeft(
        array('_inventory_table'=>$collection->getTable('cataloginventory/stock_item')),
        "_inventory_table.product_id = e.entity_id",
        array('is_in_stock', 'manage_stock')
    );
    $collection->addExpressionAttributeToSelect(
        'on_top',
        '(CASE WHEN (((_inventory_table.use_config_manage_stock = 1) AND (_inventory_table.is_in_stock = 1)) OR  ((_inventory_table.use_config_manage_stock = 0) AND (1 - _inventory_table.manage_stock + _inventory_table.is_in_stock >= 1))) THEN 1 ELSE 0 END)',
        array()
    );
    $collection->getSelect()->order('on_top DESC');
    // Make sure on_top is the first order directive
    $order = $collection->getSelect()->getPart('order');
    array_unshift($order, array_pop($order));
    $collection->getSelect()->setPart('order', $order);
}

Edit: Changed back to catalog_product_collection_load_before from catalog_product_collection_apply_limitations_before and fixed order part priority.

Related Solutions

Magento – Show out of Stock For Configurable Products in magento

Create your own module, and in the config.xml file add these 2 events inside the tag:

<events>
    <controller_action_layout_render_before_catalog_product_view>
        <observers>
            <namespace_module>
                <class>module/observer</class>
                <method>showOutOfStock</method>
            </namespace_module>
        </observers>
    </controller_action_layout_render_before_catalog_product_view>
    <controller_action_layout_render_before_checkout_cart_configure>
        <observers>
            <namespace_module>
                <class>module/observer</class>
                <method>showOutOfStock</method>
            </namespace_module>
        </observers>
    </controller_action_layout_render_before_checkout_cart_configure>
</events>

Now create an observer inside app/code/local/Namespace/Module/Model/Observer.php

class Namespace_Module_Model_Observer {
    public function showOutOfStock($observer){
        Mage::helper('catalog/product')->setSkipSaleableCheck(true);
    }
}

Php – Magento – Changing attribute sorting

This is almost impossible to achieve if you want to go with the actual color attribute. The product collection can get the text value of each color from the EAV structure and run a sorting based on it. But the attribute option table isn't joined to the collection, so there's no way it could know what position you've set for your options.

I would make an workaround for that, maybe not the best overall solution, but you'll get what you want.

Create an attribute with code smth like sorting_color and label Color, and numerical options (e.g. 1,2,3). And assign proper values to each product (so "light blue" would be 1, "blue" is 2 - and so on). Then remove the actual color attribute from sorting, and add your newly created sorting_color.

As I said not the exact solution, but you could get yourself into troubles if you choose to mess up with the product collection sorting.

Best Answer

Related Solutions

Magento – Show out of Stock For Configurable Products in magento

Php – Magento – Changing attribute sorting

Related Topic