CODEWITHSUNDEEP
magentoupdatesbulk
Eager2Learn
Eager2Learn

Reputation: 163

Magento Tier Price Bulk Change

I need a little bit a help here-down is sample og php code for price update in Magento, can someone please give me a hint how to put relation in this code.

For example, i need this: if price is >=500 then tier= 1.8 Code below increases all prices but i need only increase price for products equal or expensive then 500 USD.

<?php

$server     = "localhost";
$database   = "";
$user       = "";
$password   = "";

$myConn = mysql_connect( $server, $user, $password ); 
$select = mysql_select_db( $database, $myConn );

$query = "SELECT
            value_id, value
        FROM
            catalog_product_entity_decimal
        ORDER BY
            value_id
        ASC";

$result = mysql_query($query) or die(mysql_error()); 

// 1.04 = 4% (duh) ovdje idu postavke marze
$tier   = 1.04;
$i      = 0;

while( $row = mysql_fetch_array($result) )
{
    if( $row["value"] != NULL )
    {
        $value          = 0;
        $value          = $row["value"];

        $value          = round( $value * $tier );


        $updQuery = "UPDATE
                        catalog_product_entity_decimal
                    SET
                        value = ".$value."
                    WHERE
                        value_id = ".$row["value_id"];

        $updResult = mysql_query($updQuery) or die(mysql_error());

        $i++;

        print "value_id: ".$row["value_id"]." | ";
        print "old price: ".$row["value"]." -> ";
        print "new price: ".$value."<br/>";
    }

}

print "<br/><br/><hr><br/><b>".$i."</b> records updated.<br/><br/>Now go to system -> index management -> and reindex everything";

?>

Upvotes: 0

Views: 1476

Answers (1)

Matt
Matt

Reputation: 11

The Magento way
$tier = 1.04;
$products = Mage::getModel('catalog/product')->getCollection
    ->addAttributeToFilter('price' , array( 'gteq' => 500))
    ->load();
foreach($products as $product){
    $product->setPrice($product->getPrice() * $tier);
    $product-save();
}

sql direct query
//first get price attribute id
$sql = 'select attribute_id from eav_attribute where attribute_code= "price"';
$attribute_id = mysql_query($sql);

//get entity id  which price >=500
$sql = "select eneity_id from catalog_product_entity_decimal d where attribute_id = {$attribute_id[0]} and d.value >= 500";
while($row = mysql_fetch_array($result)){
    // do something
}

Upvotes: 1

Related Questions