Magento 1.9 – How to Delete Product Without 404 Error

catalogdeletemagento-1.9

I have some products I want to delete from my website. It means I don't want them in catalog nor in search results.

In the same time I don't want 404 error page for these url products. Best solution for me would be: set stock availability to "No longer available" and set visibility "show only individually".

Is possible to achieve similar result?

Best Answer

If you set the product to "catalog only", but remove all of it's categorisations, then the product will still be available (i.e. /product-one/) - and then just set it's stock options/layout to have a discontinued message.

Related Solutions

Magento – Stock Status Not Displayed in Product Grid When Not Set

That happens because, by default joinTable performs an INNER JOIN. You can pass an additional parameter to make a LEFT JOIN.

$collection->joinTable(
        'cataloginventory/stock_status',
        'product_id=entity_id', 
        array("stock_status" => "stock_status"),
        null ,
        'left'
    )
    ->addAttributeToSelect('stock_status');

Magento 1.9 – Search Does Not Return Results

Open your file Mage_CatalogSearch_Model_Layer and in method

public function prepareProductCollection($collection)

before return $this;

Add following rows:

Mage::log($collection->getSelectSQL(1), false, 'search.log', true);
Mage::log((array)Mage::getConfig()->getNode()->global->models->catalogsearch, false, 'search.log', true)

(it's for debug purpose to understand your problem).

Then open your var/log/search.log and put result to your first post (there should be long sql query and array where we can see rewrites).

Best Answer

Related Solutions

Magento – Stock Status Not Displayed in Product Grid When Not Set

Magento 1.9 – Search Does Not Return Results

Related Topic