How to remove special prices of products?

Question

I am trying to update products prices with in a specific store. But when I do that, it shows me regular and special prices against each product. I want to set just one price against each product by disabling special price. How to do that? Here is my code.

$prod = Mage::getModel('catalog/product')
                    ->setStoreId($storeId)
                    ->load($prodId); 
    $prod->setPrice($newPrice)->getResource()->saveAttribute($prod, 'price');
    $prod->setSpecialPrice('')->getResource()->saveAttribute($prod, 'special_price');
    $prod->setSpecialFromDate('')->getResource()->saveAttribute($prod, 'special_from_date');
    $prod->setSpecialToDate('')->getResource()->saveAttribute($prod, 'special_to_date');

Answer 1

How about this.

$productIds = array($id1 , $id2); // specify your product ids here
$attributes = array( 
                'price' => $newPrice,
                'special_to_date' => '',
                'special_from_date => '',
                'special_price' => null); // attribute codes and values 

$storeId = $someStoreId // change this to your store id

Mage::getSingleton("catalog/product_action')
        ->updateAttributes($productIds , $attributes , $storeId); // update the products

Answer 2

Edit

It got the issue Actually Price,Special Price,Special Price from date and scope is Website.So it was taking same for value for all stores.As you was change it value for one store then it automatically change to other store.

Solution:

1) If you three store was in different Website then you can change the those attribute

It works it store would look like:

Full image link : http://oi60.tinypic.com/2j4vt6e.jpg

2) Delete those attribute and create new attribute of same name and proprity and but need Scope label store view