Update Magento Special Price
- by Farid
I'm trying to revert "special price" after the "special price to date" passed to null. So basically when I update my products special price programmatically using this code :
$todayDate = Mage::app()->getLocale()->date()->toString(Varien_Date::DATETIME_INTERNAL_FORMAT);
$collection = Mage::getModel('catalog/product')->getCollection()
->addStoreFilter()
->addAttributeToFilter('special_price', array('gt' => 0))
->addAttributeToFilter('special_to_date', array('date' => true, 'to' => $todayDate));
echo "Total products found : ".count($collection);
foreach ($collection as $product)
{
$product->setSpecialPrice(null)
->setSpecialFromDate(null)
->setSpecialToDate(null)
->save();
}
echo "<br/> Done!";
But after I update my special price to null the magento product wizard does not let me set a new special price for my product. When I save the form it does not give me any error nor affect any changes in special price and it's still null! What's wrong?!
