[Resolved] Update Currency Rates VIA PrestaShop not working. Products prices set to '0' ZERO! :)

[El Patron]

There is a problem with the PrestaShop currency conversion. I manually updated my currienes and then notices 'later' that except for a few currencies GBP/AUD/CAD the conversion rate was set to zero.

 

so in other words all my products except for EUR and those mentioned has a displayed price of 0.00.

 

Can someone else verify that there conversion is or is not working. I saw a post earlier today 'cant find it now' where someone was having a similar problem.

 

doh!

Edited May 30, 2013 by eTiendas.co (see edit history)

[El Patron]

I found the other thread.

 

http://www.prestashop.com/forums/topic/251184-currency-convter-not-working/

[El Patron]

here is a snap shot (I have disabled the non-default currencies) after a update

http://screencast.com/t/imPGiDmPlAev

[El Patron]

NOTE this is not isolated to one or two shops...

 

this affects EVERY shop that uses the 'update currency' between their shop and PS

[benjamin utterback]

Hello, thank you for this thread. We are taking a close look at what could be the problem.

[vekia]

checked for 1.5.4.1 - how it looks with automatic update:


I FOUND THE PROBLEM!
http://api.prestasho.../currencies.xml - works well, but where are other currenies?

 

 

THIS IS WHY I DEVELOPED MODULE
update currency rates with ECB

[Xavier du Tertre]

Thanks Vekia! We're on it.

 

The problem will be fixed ASAP! Thanks for your patience you all.

[Bruno Leveque]

Good evening everyone,

 

First of all thank you for your feedback and responsiveness

 

I just fixed it, it seems that there was a temporary glitch with the bank we are relying on to retrieve the real-time currencies rates.

 

The file is now up-to-date and complete:

 

This XML file does not appear to have any style information associated with it. The document tree is shown below.
<currencies>
<source iso_code="EUR"/>
<list>
<currency iso_code="AFN" rate="71.875"/>
<currency iso_code="ALL" rate="140.88"/>
<currency iso_code="DZD" rate="103.3"/>
<currency iso_code="ADP" rate="166.38"/>
<currency iso_code="ARS" rate="6.8517"/>
<currency iso_code="AMD" rate="541.98"/>
<currency iso_code="AWG" rate="2.3248"/>
<currency iso_code="AUD" rate="1.3501"/>
<currency iso_code="BSD" rate="1.2988"/>
<currency iso_code="BHD" rate="0.4896"/>
<currency iso_code="BDT" rate="100.66"/>
<currency iso_code="BBD" rate="2.5976"/>
<currency iso_code="BYR" rate="11293"/>
<currency iso_code="BZD" rate="2.6106"/>
<currency iso_code="BMD" rate="1.2988"/>
<currency iso_code="BTN" rate="73.219"/>
<currency iso_code="BOB" rate="8.9746"/>
<currency iso_code="BWP" rate="11.2"/>
<currency iso_code="BRL" rate="2.7412"/>
<currency iso_code="GBP" rate="0.8568"/>
<currency iso_code="BND" rate="1.6449"/>
<currency iso_code="BGN" rate="1.9558"/>
<currency iso_code="BIF" rate="2020.9"/>
<currency iso_code="CAD" rate="1.3464"/>
<currency iso_code="CVE" rate="110.68"/>
<currency iso_code="KYD" rate="1.065"/>
<currency iso_code="CLP" rate="638.61"/>
<currency iso_code="CNY" rate="7.9635"/>
<currency iso_code="COP" rate="2457.8"/>
<currency iso_code="KMF" rate="493.27"/>
<currency iso_code="CRC" rate="649.62"/>
<currency iso_code="HRK" rate="7.562"/>
<currency iso_code="CUP" rate="1.2988"/>
<currency iso_code="CYP" rate="0.5869"/>
<currency iso_code="CZK" rate="25.775"/>
<currency iso_code="DKK" rate="7.4544"/>
<currency iso_code="DJF" rate="230.82"/>
<currency iso_code="DOP" rate="53.516"/>
<currency iso_code="XCD" rate="3.5067"/>
<currency iso_code="ECS" rate="32470"/>
<currency iso_code="EGP" rate="9.0707"/>
<currency iso_code="SVC" rate="11.361"/>
<currency iso_code="EEK" rate="15.646"/>
<currency iso_code="ETB" rate="24.238"/>
<currency iso_code="EUR" rate="1"/>
<currency iso_code="FJD" rate="2.391"/>
<currency iso_code="XAF" rate="657.65"/>
<currency iso_code="XPF" rate="119.65"/>
<currency iso_code="GMD" rate="44.003"/>
<currency iso_code="GEL" rate="2.1326"/>
<currency iso_code="GHS" rate="2.5917"/>
<currency iso_code="GIP" rate="0.8568"/>
<currency iso_code="XAU" rate="0.0009"/>
<currency iso_code="GTQ" rate="10.13"/>
<currency iso_code="GNF" rate="9260.3"/>
<currency iso_code="GYD" rate="276.04"/>
<currency iso_code="HTG" rate="55.196"/>
<currency iso_code="HNL" rate="26.326"/>
<currency iso_code="HKD" rate="10.084"/>
<currency iso_code="HUF" rate="293.54"/>
<currency iso_code="ISK" rate="159.62"/>
<currency iso_code="INR" rate="73.219"/>
<currency iso_code="IDR" rate="12738"/>
<currency iso_code="IRR" rate="15947"/>
<currency iso_code="IQD" rate="1509.3"/>
<currency iso_code="ILS" rate="4.7928"/>
<currency iso_code="JMD" rate="128.16"/>
<currency iso_code="JPY" rate="131.54"/>
<currency iso_code="JOD" rate="0.9204"/>
<currency iso_code="KHR" rate="5279.5"/>
<currency iso_code="KZT" rate="196.47"/>
<currency iso_code="KES" rate="110.43"/>
<currency iso_code="KWD" rate="0.3716"/>
<currency iso_code="KGS" rate="62.587"/>
<currency iso_code="LAK" rate="9986.4"/>
<currency iso_code="LVL" rate="0.7015"/>
<currency iso_code="LBP" rate="1965.1"/>
<currency iso_code="LSL" rate="12.988"/>
<currency iso_code="LRD" rate="96.123"/>
<currency iso_code="LYD" rate="1.6737"/>
<currency iso_code="LTL" rate="3.4528"/>
<currency iso_code="MOP" rate="10.386"/>
<currency iso_code="MGA" rate="2872.3"/>
<currency iso_code="MWK" rate="428.6"/>
<currency iso_code="MYR" rate="3.9899"/>
<currency iso_code="MVR" rate="20.001"/>
<currency iso_code="MTL" rate="0.4293"/>
<currency iso_code="MRO" rate="387.69"/>
<currency iso_code="MUR" rate="40.587"/>
<currency iso_code="MXN" rate="16.605"/>
<currency iso_code="MDL" rate="16.264"/>
<currency iso_code="MNT" rate="1868.9"/>
<currency iso_code="MAD" rate="11.127"/>
<currency iso_code="MMK" rate="1226"/>
<currency iso_code="NPR" rate="116.88"/>
<currency iso_code="ANG" rate="2.3248"/>
<currency iso_code="NZD" rate="1.6161"/>
<currency iso_code="NIC" rate="31.722"/>
<currency iso_code="NGN" rate="205.64"/>
<currency iso_code="NOK" rate="7.6218"/>
<currency iso_code="OMR" rate="0.5"/>
<currency iso_code="PKR" rate="127.97"/>
<currency iso_code="PAB" rate="1.2988"/>
<currency iso_code="PGK" rate="2.7982"/>
<currency iso_code="PYG" rate="5513.3"/>
<currency iso_code="PEN" rate="3.4983"/>
<currency iso_code="PHP" rate="54.919"/>
<currency iso_code="XPT" rate="0.0009"/>
<currency iso_code="PLN" rate="4.2684"/>
<currency iso_code="QAR" rate="4.7291"/>
<currency iso_code="RON" rate="4.3486"/>
<currency iso_code="RUB" rate="41.177"/>
<currency iso_code="RWF" rate="847.5"/>
<currency iso_code="STD" rate="24498"/>
<currency iso_code="SAR" rate="4.8707"/>
<currency iso_code="RSD" rate="111.91"/>
<currency iso_code="SCR" rate="15.327"/>
<currency iso_code="SLL" rate="5616.9"/>
<currency iso_code="XAG" rate="0.057"/>
<currency iso_code="SGD" rate="1.642"/>
<currency iso_code="SKK" rate="30.124"/>
<currency iso_code="SBD" rate="9.4422"/>
<currency iso_code="SOS" rate="1889.7"/>
<currency iso_code="ZAR" rate="12.987"/>
<currency iso_code="KRW" rate="1464.3"/>
<currency iso_code="LKR" rate="164.3"/>
<currency iso_code="SDD" rate="573.41"/>
<currency iso_code="SRD" rate="4.286"/>
<currency iso_code="SZL" rate="12.988"/>
<currency iso_code="SEK" rate="8.5763"/>
<currency iso_code="CHF" rate="1.2467"/>
<currency iso_code="SYP" rate="126.5"/>
<currency iso_code="TWD" rate="38.945"/>
<currency iso_code="TZS" rate="2119.6"/>
<currency iso_code="THB" rate="39.213"/>
<currency iso_code="TTD" rate="8.3382"/>
<currency iso_code="TND" rate="2.1559"/>
<currency iso_code="TRY" rate="2.4346"/>
<currency iso_code="AED" rate="4.7704"/>
<currency iso_code="USD" rate="1.2988"/>
<currency iso_code="UGX" rate="3370.5"/>
<currency iso_code="UAH" rate="10.579"/>
<currency iso_code="UYU" rate="26.054"/>
<currency iso_code="UZS" rate="2703.5"/>
<currency iso_code="VUV" rate="125.85"/>
<currency iso_code="VEF" rate="8.1721"/>
<currency iso_code="VND" rate="27285"/>
<currency iso_code="ZMW" rate="6.9225"/>
</list>
</currencies>

 

Please feel free to try again on your end.

 

In the next coming days we will add a automated check on this file to make sure it does not happen again.

 

Regards,

[jimmyc]

Just a quick question on these currency updates. If i allow currency conversion to show customer in their own currency, can i still set prestashop 1.5 so paypal will only accept the usd price on payment. Thanks in advance if anyone knows the answer.

[El Patron]

Just a quick question on these currency updates. If i allow currency conversion to show customer in their own currency, can i still set prestashop 1.5 so paypal will only accept the usd price on payment. Thanks in advance if anyone knows the answer.

 

You could do what you want if your shop's default currency is USD, then (see belows) use 'shop default currency'

 

paypal only accepts the following currencies:

https://www.paypal.c...c_intro-outside

 

for any currencies on your shop that are not supported, then exclude 'restrict' that currency in 'Payment module restrictions':

http://screencast.com/t/l1vK0kNibLm

Edited June 1, 2013 by eTiendas.co (see edit history)

[adamus007p]

no it is not fixed

 

additionally:

 

 

when I wanted cancel some order i have got an error:

Fatal error (Order -> conversion_rate = 0.845800)

it is connected to this error

 

i use several PS 1.4.10

[vekia]

but currency rates update feature works well now, and the main problem in this thread was about updating currency rates, not about cancelling orders

[vekia]

EDIT:

 

adamus007p got right!

 

currencies exchange rates xml list isn't full once again

[cocothehorse]

We have the same issue on our shop. GBP and EURO work fine, but USD have zero prices for every product in our store.

[adamus007p]

I opened reports on forge but it is closed as solved, I wrote email to PS, but no answer.....

 

currency update rates are not fixed!

 

additionally there is an error to cancel any order Fatal error (Order -> conversion_rate = 0.845800)

 

3rd bug that you can not to update (manually) rates in BO in 1.4.10

 

 

no help or advice what to do from PS in such situaction, so here is my workaround:

 

- you are not able to change currency rates from BO, use database for it

- you can disable other currencies and leave only your default one (e.g. for people who don't know how to correct it in database)

 

 

there should be a mechanism which prevent such as situaction in the future

 

 

 

//

 

in my case we loose a lot of money cause customer did not paid 100euro but paid 0$

not explain to the customer that it was a bug from prestashop and customer should pay a money

 

if you sell didital files it is difficult....

 

 

my report, please join and write here you comments:

http://forge.prestashop.com/browse/PNM-1466

Edited June 5, 2013 by adamus007p (see edit history)

[Xavier du Tertre]

Hi!

 

The bank we are relying on to retrieve the real-time currencies rates had another glitch 48hrs ago, indeed. To prevent that from impacting your PrestaShop 1.4 store, we did two things:

 

What we first did is we wrote a fix, you can either include it in your code right now, or wait for the next release to have it automaticaly included. Here's the fix : https://github.com/PrestaShop/PrestaShop-1.4/commit/018c40ff4d2878908ed6b4828df6beca764f38a8

 

Then, we created an alert system that warns us when there's a fault in the currencies update. It basically enables the system to realize when a new currency rate is wrong, and it stops the new currencies database to overwrite the previous one. This alerts system will be in place withing the next 24hrs, so you are sure not to encounter the problem again even if you don't include the fix in your code.

 

Thank you so much for your understanding and your patience.

[vekia]

Hello Xavier

 

where the fix is available? on forge or github?

[adamus007p]

please keep in mind that now when error occurred you are not able to cancel any order

Fatal error (Order -> conversion_rate = 0.845800)

 

and you are not able to edit currency rates from BO >> 2nd bug

 

where we can find this fix?

 

 

 

 

warns us when there's a fault in the currencies update.

us? who merchant or prestashop? if prestashop what when it happen on weekend or in bank holiday?

 

It basically enables the system to realize when a new currency rate is wrong, and it stops the new currencies database to overwrite the previous one.

 

so it will 1st verify the input data before will rewrite data in the database?

Edited June 5, 2013 by adamus007p (see edit history)

[adamus007p]

it seems that problem with currency is back - Cannot parse feed. when i am clicking an update.

 

forum also was not working...

 

Kind regards,

Mike

[vekia]

i suppose that this was issue related to the:

 

At this time prestashop.com and the PrestaShop forums are down. We are working hard to get them back up as soon as possible. Until then, thank you for your patience.

http://www.facebook.com/prestashop

[adamus007p]

yes it was connected when the forum back currency updates back to work

[vekia]

it's because xml file is located on the prestashop servers, hope that new version will have got features to check correctness of the xml (+connection issues support)

[ftlrs]

Hi guys

 

I know this might be a bit off topic, but I can´t find the answer elsewhere.

 

In my multistore..

 

Shop B has a different currency, and its set to conversionrate 1.22.

 

However, its not changing in frontend so all price in shop B are 1 to 1 - but in correct currency.

 

How tried to solve it for days, but no luck.

 

Is this also a known issue?

 

Thanks!

[ricky11]

Suggest start a new topic ftlrs

 

If your currency is 1-1, then you click on "update currency"?

[ftlrs]

Thanks for getting back Ricky11. 

 

I tried that too yes. But still, in front end, its just showing the same price as in shop A, with the currence of shop B.

 

Any other ideas?

[Hexacrafter]

My shop is set up with USD as default currency. I wish to also display GBP. I add the new currency as the non-default currency and all seems to be in order,BUT.... When you go to the shop and look at the GBP price it show 0.00.
This problem has been identified before and closed a resolved, but it is not resolved.
I manually set non default currency and the rate of .60. BUT when you go back into the edit currency, the currency still shows 0.0000 even though it was set to .60 and displays .60 in the main currency window. I think this is the BUG.... it is displaying on the website 0.00 as it is using the rate in the currency edit window (0.0000) as opposed to currency rate displayed in the main currency window.
For now I have had to disable the GBP currency until I can get to to display the correct pricing (Not 0.00) on my website.

[El Patron]

My shop is set up with USD as default currency. I wish to also display GBP. I add the new currency as the non-default currency and all seems to be in order,BUT.... When you go to the shop and look at the GBP price it show 0.00.

This problem has been identified before and closed a resolved, but it is not resolved.

I manually set non default currency and the rate of .60. BUT when you go back into the edit currency, the currency still shows 0.0000 even though it was set to .60 and displays .60 in the main currency window. I think this is the BUG.... it is displaying on the website 0.00 as it is using the rate in the currency edit window (0.0000) as opposed to currency rate displayed in the main currency window.

For now I have had to disable the GBP currency until I can get to to display the correct pricing (Not 0.00) on my website.

 

This is not the same issue, if it was then if you clicked 'update currencies' then the non-default currency would show '0'.  I looked at your back office, including clicking 'update currencies' and you have proper update.

 

Please open a new topic, including that you are using 1.5.2.0, you can pm  me the link if you like but having new topic will allow the community to help.  el

[El Patron]

This is not the same issue, if it was then if you clicked 'update currencies' then the non-default currency would show '0'.  I looked at your back office, including clicking 'update currencies' and you have proper update.

 

Please open a new topic, including that you are using 1.5.2.0, you can pm  me the link if you like but having new topic will allow the community to help.  el

 

weird, when I look at your currency screen, it shows conversion, but when I edit the currency, it then shows 0.00.

 

for now I would turn off gbp/euro until trouble shooting completed.

 

but it would seem there is an issue with the mysql table.

 

again, weird, but not same as auto/manual update creating 0.00 because it does show in your loc/currency...

[El Patron]

This is not the same issue, if it was then if you clicked 'update currencies' then the non-default currency would show '0'.  I looked at your back office, including clicking 'update currencies' and you have proper update.

 

Please open a new topic, including that you are using 1.5.2.0, you can pm  me the link if you like but having new topic will allow the community to help.  el

 

 

weird, when I look at your currency screen, it shows conversion, but when I edit the currency, it then shows 0.00.

 

for now I would turn off gbp/euro until trouble shooting completed.

 

but it would seem there is an issue with the mysql table.

 

again, weird, but not same as auto/manual update creating 0.00 because it does show in your loc/currency...

 

hexcrater opened the following thread.

 

any currency experts, please go there.

 

http://www.prestashop.com/forums/topic/320864-non-default-currencies-display-000-in-front-office-customer-view/

[aamirjaved83]

Hello, thank you for this thread. We are taking a close look at what could be the problem.

 

i suppose that this was issue related to the:

 

 

http://www.facebook.com/prestashop

 

but currency rates update feature works well now, and the main problem in this thread was about updating currency rates, not about cancelling orders

Hello,

 

I cannot change my product currency at my website. could you please find out the error or what i have to do . when i click on currency tab and select another currency then it goes again default currency. my website link is

http://www.thelondont.com/tlt

your reply will be very appreciated regarding to resolve this issue. thank you.

[Jayasilen]

Hello,

 

How can I identify the exchange rate of a particular order that was transacted on a specific date. I'd like to show this info at the back office in the "Orders" so that it is easier for the finance team to do their accounting. I'm not too sure which table I should refer to for the exchange rate that was used a specific order.

 

Thanks.

[[email protected]]

i suppose that this was issue related to the:

 

 

http://www.facebook.com/prestashop

Right now everything works fine with the currencies update via the currencies.xml from Prestashop. The only problem is that those rates are not even nearly up to date and as such completely useless to us. Is there any other possiblity to get realtime currency rates from Bloomberg or Yahoo which reflect the reality and not some obscure data which is weeks or even months old?

 

Thanks for looking at it.

[[email protected]]

it's because xml file is located on the prestashop servers, hope that new version will have got features to check correctness of the xml (+connection issues support)

Right now everything works fine with the currencies update via the currencies.xml from Prestashop. The only problem is that those rates are not even nearly up to date and as such completely useless to us. Is there any other possiblity to get realtime currency rates from Bloomberg or Yahoo which reflect the reality and not some obscure data which is weeks or even months old?

 

Thanks for looking at it. Sorry for my double post.

[winsuseno]

Good evening everyone,

 

First of all thank you for your feedback and responsiveness

 

I just fixed it, it seems that there was a temporary glitch with the bank we are relying on to retrieve the real-time currencies rates.

 

In the next coming days we will add a automated check on this file to make sure it does not happen again.

 

Regards,

 

 

Hi Bruno, thanks for fixing the currency update in 2013.

 

However, Currency.xml stopped updating 3 weeks ago (http://forge.prestashop.com/browse/PSCSX-8322).

 

Could you help check and fix, please? 

 

Also you might want to check why your automatic check on this file failed to detect.

 

Thank you in advance for your prompt action!

[burakpresta3]

checked for 1.5.4.1 - how it looks with automatic update:

 

I FOUND THE PROBLEM!

http://api.prestasho.../currencies.xml - works well, but where are other currenies?

 

 

THIS IS WHY I DEVELOPED MODULE

update currency rates with ECB

Hello, thank you for this thread. We are taking a close look at what could be the problem.

Thanks Vekia! We're on it.

 

The problem will be fixed ASAP! Thanks for your patience you all.

Good evening everyone,

 

First of all thank you for your feedback and responsiveness

 

I just fixed it, it seems that there was a temporary glitch with the bank we are relying on to retrieve the real-time currencies rates.

 

The file is now up-to-date and complete:

 

This XML file does not appear to have any style information associated with it. The document tree is shown below.

<currencies>

<source iso_code="EUR"/>

 

 

Please feel free to try again on your end.

 

In the next coming days we will add a automated check on this file to make sure it does not happen again.

 

Regards,

 

We have exchange rates problem again, and loosing money day by day almost %2. Please take a look these, and fix it. o it is really important for lots of people. Exchange rates are wrong, it should be simple procedure to fix it again.. But we are wating the fix almost wherefrom august.

 

http://api.prestashop.com/xml/currencies.xml

http://forge.prestashop.com/browse/PSCSX-8322

Edited October 13, 2016 by burakpresta3 (see edit history)

[vekia]

official currency rates repository is not updated all the time

here on forums someone from prestashop stuff said that this currency feed is not updated while they are on holidays etc.

sad, but true. unfortunately