Showcase: Automatically convert an online price list in multiple currencies


Automatically convert your pricelist to multiple currenciesIn tourism  normally multiple currencies are accepted (hotels, restaurants, diving centers). Many times an online pricelist with a different version for each currency is desired. Untill recently the office staff had to review  price lists weekly and update them based on the current exchange rates.

We wanted to avoid this tedious and error prone job for our customers and developed a self converting online pricelist in Euro, US dollar, Pound Sterling and the local currency (in our case the Egyptian Pound).

SEE A LIVE VERSION

Some guidelines:

  • Choose a base currency price list (e.g. in Euro) that only gets modified manually if items change price.
  • Mention the actual exchange rate , when it was updated and its source (we use Yahoo! Finance).
  • Although cash payments by foreigners in Egyptian Pound are rare, you should have a price list in the local currency for the creditcard payments. Mention that for creditcard payments the local currency is used.
  • If you offer a printable price list make sure it shows the print date and source (url). To avoid pernickety discussions, mention that at the moment of payment the latest online price list is used.

Used Drupal modules:

  • Money CCK field and its dependencies CCK, Currency API, Format Number API, Formatted Number CCK.
  • Some custom  PHP programming :)
Next step could be to display a certain valuta based on the visitors IP address. A visitor from the UK would by default see the Pound Sterling (GBP).