Price showing as 0 on product grid but correct price when you click into it [closed]

Question

I have imported some products into Magento and I am faced with this problem.

I don't really know where to start debugging this. This is how I am setting the price at the moment (removed some data for clarity):

$productData = array(
        'price'                             => $sellPrice          
    );
$mc = new Mage_Catalog_Model_Product_Api();
$mc->update($productId, $productData);

Should I be updating another attribute somewhere?

Edit When debugging the SQL that runs, I can see in Grid.php _prepareCollection that $collection->addAttributeToSelect('price'); is called but when I do (string)$this->getCollection()->getSelect() the price column isn't selected in the SQL which I assume is why they all default to zero.

Answer 1

I don't know how the Mage_Catalog_Model_Product_Api works so I'm writing this alternative.

$productId = 10; //replace with your product id
$sellPrice = 9.90; //replace with own price
$productData = array(
    'price' => $sellPrice          
);

Mage::getSingleton('catalog/product_action')->updateAttributes(
    array($productId), //list of product ids to be updated
    $productData, //array with attributes to be updated
    0 //store id - 0 means "default values"
);

This always worked for me.

[EDIT]
For websites use this to add products to websites:

Mage::getModel('catalog/product_website')->addProducts($websiteIds, $productIds)

and this to remove products from websites:

Mage::getModel('catalog/product_website')->removeProducts($websiteIds, $productIds);

Answer 2

I actually ran into the same problem importing a large amount of products. After importing prices were showing an incorrect value when browsing but the correct price when viewing the product on the product page.

The solution: If you have a store with multiple views, you need to assign the problem products to those views and re-index.