Magento – magento special price still showing after expiration, reindexed, flushed, special date & price removed, still

magento-1.9products-managementspecial-price

I have major problem with my magento 1.9 website

Special prices are being shown in a front page despite it expired.
I googled the problem.
I reindexed data.
I cleared cache.
I removed special dates and prices via import.
I checked products in inventory – they do not have special dates or prices.
IT IS STILL SHOWING them in FRONT PAGE.
In result I have phone calls from pissed customers…

Please, if anyone experienced the same and have solution, kindly share.

Best Answer

If special prices are only applied via "special price", "special price from date" and "special price to date" attributes, make sure that you did not override the attributes per store view. Also, as you already know, reindexing the price index and clearing the cache is necessary to see changes immediately.

If special prices are applied via promotional catalog price rules, make sure that the cronjob is running which updates special prices from catalog price rules nightly.

Another possible source of special prices are customer group prices (configured for each product as well).

Related Solutions

Magento – How to display Special Price end date on front end

On Product detail page or Category list page, You can use following code to display special price end date.

<?php

// check if product has special
if($_product->getSpecialPrice()){
    // get special price
    echo $_product->getSpecialPrice();
    // get special end date 
    echo $_product->getSpecialToDate();

}

Magento – Special Price From Date and To Date

You may use following code

$collection=Mage::getResourceModel('catalog/product_collection')
            ->addAttributeToSelect('name')
            ->addAttributeToSelect('sku')
            ->addAttributeToSelect('special_price')
            ->addAttributeToSelect('price');
$collection->addAttributeToFilter('special_from_date',array(array('from' => Mage::getModel('core/date')->gmtDate()),
                                 array('special_from_date', 'null'=>true)));
$collection->addAttributeToFilter('special_to_date',array(array('to' => Mage::getModel('core/date')->gmtDate()),
                                 array('special_to_date', 'null'=>true)));

Best Answer

Related Solutions

Magento – How to display Special Price end date on front end

Magento – Special Price From Date and To Date

Related Topic