Author Topic: Incorrect amounts in order emails for foreign currencies  (Read 680 times)

panjarek

  • Beginner
  • *
  • Posts: 19
  • A beginner
Hi,
I noticed that there is something wrong with amounts in an order email confirmations, when an order is done in a different currency than the shop main currency.
For example for standard payment method I have set email confirmations currency as user selected currency. When user makes an order he or she receives first confirmation with status Confirmed by shopper and there amounts are ok. But when I change status in next days and send another email with new status, amounts are incorrect. I think the currency rate from current date is taken, not form date of the order and that is why different amounts are sent. I think when user made an order, amounts should be constant in all email confirmations.

I tested it without email template overrides.
I attached screens from two emails.
Main shop currency is PLN orders are in EUR.

VirtueMart 3.8.2 10325 (I tested it also for 3.6.10 10211 and 3.2.15)
Joomla! 3.9.18

Regards
Jarek

Jörgen

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 2750
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: Incorrect amounts in order emails for foreign currencies
« Reply #1 on: May 22, 2020, 10:31:58 am »
You have changed the exchange rate, please use a fixed exchange rate to avoid this.

Jörgen @ Kreativ Fotografi
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9651
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: Incorrect amounts in order emails for foreign currencies
« Reply #2 on: May 22, 2020, 10:54:11 am »
But perhaps panjarek is correct ... or not..  ;)

I guess if u confirm and pay an order in zloty on a certain date ( this will be stored in VM ) where are we legally when later the euro exchange rate has shifted and notification is required in euro?

I'm sure someone knows this..  is it always ( e.g. when declaring your turn over etc ) the rate on the day it was paid ( I would have thought so)?
If that is so is the exchange rate stored in the orders table not used?

@ panjarek .. can u check in the #__virtuemart_orders table what is stored there?
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

panjarek

  • Beginner
  • *
  • Posts: 19
  • A beginner
Re: Incorrect amounts in order emails for foreign currencies
« Reply #3 on: May 22, 2020, 14:19:43 pm »
I think exchange rate is stored correctly in orders table, please check attachment, prices calculated with this exchange rate are correct.

@Jörgen, thanks for advise, with fixed exchange rate it works correctly, but then I have calculate values in PLN (main currency) manually.

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9651
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: Incorrect amounts in order emails for foreign currencies
« Reply #4 on: May 22, 2020, 14:22:03 pm »
To me then this looks like a bug - reported
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

Jörgen

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 2750
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: Incorrect amounts in order emails for foreign currencies
« Reply #5 on: May 22, 2020, 17:45:55 pm »
GJC I agree, should use the exchange rare att Time of purchase.
Jörgen @ Kreativ Fotografi
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9651
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: Incorrect amounts in order emails for foreign currencies
« Reply #6 on: May 23, 2020, 09:58:02 am »
Quote
For example for standard payment method I have set email confirmations currency as user selected currency.

where are u setting this?
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

panjarek

  • Beginner
  • *
  • Posts: 19
  • A beginner
Re: Incorrect amounts in order emails for foreign currencies
« Reply #7 on: May 25, 2020, 10:27:34 am »
Maybe I wrote it wrongly, I standard payment method I set this: Accepted Currency: Selected currency in Currency Module
I thought that it also influence email currency.