Update all currencies by CSV

osCommerce comes with a built in currencies updater which is operated manually and gets rates from “oanda” and “xe” – both of which are well known currency converter sites. In addition, it is possible to manually update the currency rates one by one.

For some sites, it is desirable to update prices 10 times or more each day, and to do this manually is a chore, especially if the shopowner has multiple currencies. For example a site selling gold. The price of gold fluctuates wildly day by day, even hour by hour!

I was approached by a client who wanted a CSV input box which would allow them to update all their currencies in one go. So, they would input something like:

USD:1,EUR:0.8,GBP:0.9

Then press “update”, and all of the currencies are updated in one go. This saves a massive amount of time daily.

The end result:

And Video:

One Reply to “Update all currencies by CSV”

  1. Also the connection to oanda or xe currency converter site doesn’t seem to always work (at least not from my country). There are far more reliable sources where we can grab the exchange rates and dump them into osC shop using this convenient little tool.

Leave a Reply

Your email address will not be published. Required fields are marked *