Problem:
Currently the DSC supports on one currency. This mau fit small stores or businesses. but in the time of Globalization and International businesses, many small businesses ( 20-50 employee) have overseas customers.
There is no Name and Sysmbol setting for Currency. e.g How can we denote $XXXXX are all US Dollars. yes We can do by some comments on web pages.
Solution:
Supporting this feature in DSC is pretty easy.
Just one Table for Currecny Definition : Symbol, Name and Exchange rate base on one of the rows as Reference :
Symbol Country Name Abbreviation Rate Status
$ USA US Dollar USD 1.00 Active
$ Canada Canadian Dollar CAD 1.22 Active
€ Europe Euro Dollar Euro 0.80 Active
$ Australia Australian Dollar Inactive
There should be extra columns as you know your system. but one currency is the reffrence and default that all prices are based on that.
On the Order Checkout page if user selects a currency from a list then OrderTolta will be multiplied by that factor.
It is up to the Admin to updated Currency exhnage rates.
The application have alwasys one Active Currency. Based on the marketing areas of the business they (DSC licensee) can let their user select the currency they support,
For example we have customers in US, Canada and Europe.
When User selects a currency, all prices are showed ( not saved ) by multiplying the exchange rate Factor thru all the shopping cart process.
We (Licencee) are responsible for updating the exchange rates regularly just like price lists and other stock items.
Bahram
|