Magento – Magento 2 : How do conver price from any currency to base currency

currencycurrency-ratesmagento2multicurrency

I am converting price from any other currency using currency code to base currency and for this I am using this method :

$oldCurrency = 'AUD';
$newCurrency = 'USD';
$priceHelper = $objectManager->create('Magento\Directory\Helper\Data');
$priceHelper->currencyConvert($item->getCustomPrice(), $oldCurrency, $newCurrency);

My base currency is USD and USD to AUD conversion rate is defined in admin.

When I am converting price from USD to AUD then its working, but when I am trying to convert price from AUD to USD then it gives me error that conversion rate is not defined.

How do I convert price from any currency to any other currency ?

Best Answer

NOTE: In the example the amount in current store currency is converting to amount in base store currency.

You can use this code to convert one currency to another:

/**
 * @var \Magento\Store\Model\StoreManagerInterface
 */
protected $storeManager;

/**
 * @var \Magento\Directory\Model\CurrencyFactory
 */
protected $currencyFactory;

/**
 * @param \Magento\Store\Model\StoreManagerInterface $storeManager
 * @param \Magento\Directory\Model\CurrencyFactory $currencyFactory
 */
public function __construct(
    \Magento\Store\Model\StoreManagerInterface $storeManager,
    \Magento\Directory\Model\CurrencyFactory $currencyFactory
) {
    $this->storeManager = $storeManager;
    $this->currencyFactory = $currencyFactory;
}

/**
 * Convert base price value to store price value
 *
 * @param $amountValue
 * @return float
 */
public function convertPrice($amountValue)
{
    $currentCurrency = $this->storeManager->getStore()->getCurrentCurrency()->getCode();
    $baseCurrency = $this->storeManager->getStore()->getBaseCurrency()->getCode();
    if ($currentCurrency != $baseCurrency) {
        $rate = $this->currencyFactory->create()->load($currentCurrency)->getAnyRate($baseCurrency);
        $amountValue = $amountValue * $rate;
    }

    return $amountValue;
}

The $currentCurrency and $baseCurrency variables can be replaced by any valid currency codes from the currency collection.

Related Solutions

Change Magento Base and Display Currency and Auto-Update Prices (EUR to RON)

Here is something that should convert the prices.
I know it's not the best way of doing it by touching the db directly, but it's fast and it works.
Please back-up your db before trying any of this.

So all price related values are kept in the table catalog_product_entity_decimal and catalog_product_entity_tier_price in case you have tier prices.
For tier prices is simple.
Just update the value of the column value with the converted value.
So today the conversion rate for 1E is 4.4193 RON.
Run this query:

UPDATE `catalog_product_entity_tier_price` set `value ` = 4.4193 * `value`;

This should solve it.
For the rest of the prices is not that easy.
First you need to identify the attribute ids for price and special_price.
For that run this query.

SELECT 
    * 
FROM 
    `eav_attribute` e 
    LEFT JOIN `eav_entity_type` et ON `e`.`entity_type_id` = `et`.`entity_type_id`
WHERE 
    `e`.`attribute_code` IN ('price', 'special_price') AND
    `et`.`entity_type_code` = 'catalog_product'

This should produce 2 rows. Take the column attribute_id values and use them in the query below. For me these values were 75 and 76.
Now run this query for updating the prices.

UPDATE 
    `catalog_product_entity_decimal` 
SET 
    `value` = 4.4193 * `value`
WHERE
    `attribute_id` IN (75, 76)

Again 4.4193 is the exchange rate.

Now you can set your base currency to RON. Clear the cache and reindex everything.

Magento – Magento 2: Round up foreign currency. How to do it

vendor/magento/framework/pricing/amount/AmountFactory.php

public function create($amount, array $adjustmentAmounts = [])
{
    $amountModel = $this->objectManager->create(
        self::DEFAULT_PRICE_AMOUNT_CLASS,
        [
            'amount' => **round($amount)**,
            'adjustmentAmounts' => $adjustmentAmounts
        ]
    );

    if (!$amountModel instanceof \Magento\Framework\Pricing\Amount\AmountInterface) {
        throw new \InvalidArgumentException(
            get_class($amountModel) . ' doesn\'t implement \Magento\Framework\Pricing\Amount\AmountInterface'
        );
    }

    return $amountModel;
}

Best Answer

Related Solutions

Change Magento Base and Display Currency and Auto-Update Prices (EUR to RON)

Magento – Magento 2: Round up foreign currency. How to do it

Related Topic