Currency Problems

[kerryanne]

My clients stores are in Australian Dollars

I have AUD set as the default currency but whenever I am adding anything to do with currency, example + attributes it does it in USD

How can I change this?

Its so annoying to try and work out the equivalent in AUD only to find that when I update the exchange rate it all changes again.

[jpf]

The LANGUAGE is defaulted to USD....

in your /catalog/includes/language/english.php file:

 // if USE_DEFAULT_LANGUAGE_CURRENCY is true, use the following currency, instead of the applications default currency (used when changing language)
define('LANGUAGE_CURRENCY', 'USD'); 
  

Change to:

 // if USE_DEFAULT_LANGUAGE_CURRENCY is true, use the following currency, instead of the applications default currency (used when changing language)
define('LANGUAGE_CURRENCY', 'AUD'); 
  

At the same time in the same file you might want to set the time/calender to AU....

en_US.ISO_8859-1
to
en_AU.ISO_8859-1

As well as change the FLAG too...

[multienterprise]

I can't seem to change the time on my site, is this because even though I am based in Australia my server is in the US?

[jpf]

I believe the reason why is because the host is using the mysql now() function to put the date into the database. Naturally, it uses the date of the host - the country it is in. To get around this problem you need to do these steps:

Change the following code below in both of english.php found in the Catalog and Admin sections.

Look for:

 @setlocale(LC_TIME, 'en_US.ISO_8859-1'); 
  

Change the setlocale en_AU to the country you are in, you are in Australia so use the the code below.

Change to:

 @setlocale(LC_TIME, 'en_AU.ISO_8859-1'); 
  

Hopefully that is all you have to do...



Now if that does not work try the following:

 putenv("TZ=Australia/Sydney"); // or whatever your area is.
@setlocale(LC_TIME, 'en_AU.ISO_8859-1');
$local_date_time = date("Y-m-d H:i:s"); 
  

Next look for the code below in checkout_process.php at line approx 106

 'date_purchased' => 'now()', 
  

change to:

 'date_purchased' => $local_date_time, 
  

and at aprox line 127

 'date_added' => 'now()', 
  

change to:

 'date_added' => $local_date_time, 
  

Next you have to go to catalog/admin/orders.php, found under the Admin directory and change this code. At around line 43. Replace now() with '".$local_date_time."'

         if ( ($check_status['orders_status'] != $status) || $comments != '' || ($status ==DOWNLOADS_ORDERS_STATUS_UPDATED_VALUE) ) {
          tep_db_query("update " . TABLE_ORDERS . " set orders_status = '" . tep_db_input($status) . "', last_modified = now() where orders_id = '" . (int)$oID . "'"); 
  

to this

         if ( ($check_status['orders_status'] != $status) || $comments != '' || ($status ==DOWNLOADS_ORDERS_STATUS_UPDATED_VALUE) ) {
          tep_db_query("update " . TABLE_ORDERS . " set orders_status = '" . tep_db_input($status) . "', last_modified = $local_date_time where orders_id = '" . (int)$oID . "'"); 
  

That should do it.

[multienterprise]

Thankyou so much, I had to do all the changes but it worked brilliantly