Magento 1.9 : How to Edit the price of all products؟

Question

I want to increase the price of all products
And if I want to edit each one
It's very time consuming
Is there a way to group?

Answer 1

1. Export all products from admin

2. Then copy complete sku column from this export csv.

3. Create new csv with 2 columns (sku , price ). paste all sku on that new csv and add updated price on price column and make import that csv .

4.Import from admin->system->importexport->import

Answer 2

You can alternately use this solution. A bit of programming is required .Create this file in your Magento root folder

require_once('/app/Mage.php'); //path to mage bootstrapper

Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID); 

$csvObject = new Varien_File_Csv();

$pathtoCSV = '/path/products.csv';
$data =  $csvObject->getData($pathtoCSV);

foreach ($data as $lines => $line) {
    $sku = trim($line[0]);
    $price = trim($line[1]);

    $product = Mage::getModel('catalog/product');
    $product->load($product->getIdBySku($sku));

    $product->setPrice($price);
    $product->getResource()->saveAttribute($product, 'price');

 }