[SOLVED] update product price change value

[cyberdoc]

Hi, i need to change the price of a product at runtime according to a complex calculation..now i update it successfully in the Ps_product table. but after the addition to cart it still shows 0(old price). Any idea why? is there another place i need to update this??

PS : ive checked in the db the changes are occuring

[PascalVG]

Maybe you need to re-load the object, to 'synchronize' with the database values? It all depends on when/where/how you make the changes... Please elaborate.

[cyberdoc]

basically i change the product price as per the other items in the cart.. so ive added a hook at displayshopping cart and get the products list from there, calculate the price as per that then update the price of my product via sql query. finally i add this product to cart using updateqty.. below is the code..

 $cookie = $this->context->cookie;
        $sub_total=0;
        $products = $params['cart']->getProducts(true);
 //       print_r($products);
    //    print_r($cookie);
  
		foreach ($products as $product) {
		   $result = Db::getInstance()->getRow('SELECT textarea FROM `'._DB_PREFIX_.'belvg_samplemodule` sample WHERE sample.`id_product` = '.$product['id_product']);
//		   print_r($product['id_product']);
$sub_total = $sub_total + $result['textarea'];
			    }
$result =DB::getInstance()->Execute('UPDATE `'. _DB_PREFIX_ .'product` SET `price` = ' .$sub_total. ' WHERE `id_product` = 9');
          $params['cart']->updateQty(1, 9);
$params['cart']->update();

9 is the product id of my product..

[cyberdoc]

any help guys? i've checked that when the previous value in the db is 10 and the code updates it to 15, then also in the cart its shown as 0....

[cyberdoc]

Ok for anyone curious, i solved it. basically to update in the cart you need to update values both in the Ps_prduct and ps_product_shop table... Silly mistake but yeah someone may also miss it like i did!

[PascalVG]

Hi Cyberdoc, thanks for the update.

 

Good you solved it and shared the solution.This may help others!

 

 

I'll mark the topic as solved.

 

Happy selling,

pascal