Magento – How to update all prices in quote item table in magento2

magento2quoteitem

I have quote id I want to update price , base_row_total & other prices related field in quote should i want to set price only rest field should automatically update is this possible or i am thinking wrong .
please help thanks in advance

I am using the below Code but its shores only sku,name,store_id,i checked default magento cart Api its storing all vales in quote Table i want to do the same but its not working for me:

 $product = $this->product->get($this->sku);

        $quoteItem = $this->quoteItemFactory->create();

        $quoteItem->setProduct($product);

Best Answer

Yes. You can changes price of all items of a quote.

Use

$QuoteObjectitem->setCustomPrice($YourPrice);
$QuoteObjectitem->setOriginalCustomPrice($YourPrice);

Related Solutions

Magento – Update prices of all simple products via their configurable product in Magento 2

I was getting same issue when Migrated data from Magento to Magento 2.As Magento 2 change scenario to set the Special price for configurable product and we need to require set special price for every associated product of configurable product.

    <?php
error_reporting(E_ALL);
ini_set('display_errors', 1);

use Magento\Framework\App\Bootstrap;

try{

    require __DIR__ . '/app/bootstrap.php';

    $params = $_SERVER;
    $bootstrap = Bootstrap::create(BP, $params);
    $obj = $bootstrap->getObjectManager();
    $obj->get('Magento\Framework\Registry')->register('isSecureArea', true);
    $appState = $obj->get('\Magento\Framework\App\State');
    $appState->setAreaCode('frontend');

    $products = $obj->create('\Magento\Catalog\Model\Product')->getCollection();
    $products->addAttributeToSelect(array('special_price','price'))
        ->addFieldTofilter('type_id','configurable')
        ->addFieldToFilter('visibility', \Magento\Catalog\Model\Product\Visibility::VISIBILITY_BOTH)
        ->addFieldToFilter('status', \Magento\Catalog\Model\Product\Attribute\Source\Status::STATUS_ENABLED)
        ->load();



    echo "Total products count: " . $products->count() . "<hr>";
    echo "<pre>";
    if ($products->getSize() > 0) {
        foreach ($products as $product) {


            $configSpecial = $product->getSpecialPrice();

            if($configSpecial > 0)
            {
                echo 'product id<br/>'.$product_id = $product->getId();
                $configProduct = $obj->create('Magento\Catalog\Model\Product')->load($product_id);
                $_children = $configProduct->getTypeInstance()->getUsedProducts($configProduct);



                 foreach ($_children as $child){



                     $childProductId = $child->getID();

                     $childproduct = $obj->create('Magento\Catalog\Model\Product')->load($childProductId);


                     $childproduct->setStoreId(9);
                     //$childproduct->getName(); 
                     $childproduct->setSpecialPrice($configSpecial); 
                     $childproduct->save();
                     //echo $childproduct->getSpecialPrice(); 
                }

                //echo "count: ".count($_children);



           }



            //print_r($product->getData());
        }
    }

} catch (Exception $e) {
    echo $e->getMessage();
}

I hope this script will help you.

Magento – Update quote item price without using custom price

Since the quote item price is retrieved by calling the getFinalPrice, we are overriding the getFinalPrice method.

It's not a clean/final solution, but we managed partially solve our problem so far by overriding the getFinalPrice from Mage_Catalog_Model_Product_Type_Price class. The custom code would be called only on quotes created by admin panel. The frontend quote (checkout) will continue using the quote item custom price.

<?php
class Wdarking_CPDiscount_Model_Catalog_Product_Type_Price extends Mage_Catalog_Model_Product_Type_Price
{
    /**
     * Retrieve product final price
     *
     * @param float|null $qty
     * @param Mage_Catalog_Model_Product $product
     * @return float
     */
    public function getFinalPrice($qty = null, $product)
    {
        $finalPrice = parent::getFinalPrice($qty, $product);

        // custom code
        $adminQuote = Mage::getSingleton('adminhtml/session_quote')->getQuote();

        if (!$adminQuote->getId()) {
            return $finalPrice;
        }

        $observerFlag = "wdk_cpd_product_flag:{$adminQuote->getId()}:{$product->getId()}";

        if (Mage::registry($observerFlag)) {
            return $finalPrice;
        }

        Mage::register($observerFlag, 1);

        $customFinalPrice = Mage::helper('cpdiscount')->productCpdFinalPrice($adminQuote, $product);

        if ($customFinalPrice) {
            return $customFinalPrice;
        }

        return $finalPrice;
    }
}

This solution have some problems, since we are overriding a method that is called multiple times during the quote proccess. To define the custom price we use the custom helper method productCpdFinalPrice, that iterates the quote items to define a custom price, and calling it from inside getFinalPrice would recursively call getFinalPrice again, leading to a infinite loop. Thats why I'm using the registry to avoid this behavior. The quote iteration in every getFinalPrice also leads to a slow performance of the quote processing. Also the getFinalPrice is defined in another classes like bundled producs, configurable, etc. We should override the method on those classes as well.

And might exist other problems I didn't catch.

This is not the intended solution, but we're using this solution. It partially solved our problem.

Feedback is appreciated.

Best Answer

Related Solutions

Magento – Update prices of all simple products via their configurable product in Magento 2

Magento – Update quote item price without using custom price

Related Topic