How to display different currency in product info?

Hey,

is it possible to show different currencies in product info ???

base currency is EURO but I want to show my customers the product price in
USD GBP. The standart for the order should be EURO I only want to the other currencies. Is something like that possible???

Thanks

Frank

Yes it is possible, but is not a standard feature of Zen Cart. It would require custom coding. You might check the downloads section, although I'm not aware of one for this task.

Hmm.. i´m not a php coder but i think it should be possible to take the standart price recalulate them wiht the exchange rates of each currency and put the output in product_info.tpl

I have no idear how to get the exchange rates out of the database.

I need to do the same thing. I'm looking into it right now and will post any findings here. If you come across anything, please let me know.

Hey,

If you found something I will also post it here.

It would be helpful if somebody could tell how to exchangerates from the database. The rest I could do by myself.

cheers

Frank

I have a similar but slightly differenct dilemma that I'm hoping to get some help with. I am developing a new revision to my website that will use Zen Cart. My business sells to the USA & Canada. I obviously need to show US visitors US dollars and Canadian visitors CAD dollars. My problem is that my US & Canadian prices are different.

To elaborate: I might charge somebody in Canada $100 for a product and charge somebody in the USA $75 for the same product. It has nothing to do with exchange rates it has to do with my cost for the product being different in the two different countries. I need to know if there is a way to set a different US & Canadian price for each product where the two prices are not linked in any way (such as with an exchange rate).

Thanks.

I have a similar question or concern.

Basically what I want to do is set 3 prices per region.
These will be:
Stockist
Dealer
Retail

These are prices that are dictated by the parket, not as a % discount of the retail price.

Each region (Australia, USA, UK, Europe) would show their currency as per what their IP address is. Anything out of these regions would divert to the AUD currency.

The other thing we need is each region will have a different bank account, so when the person set's up their account, it will take their country information and deposit the funds into the correct bank account in the correct currency.

Again, our pricing is similar to the above post where they are just prices we set that are determined by market forces. We might sell the one product in Australia at $400.00 AUD, and also sell it in the U.S. at $400.00 USD because the competition isn't as strong in that region for example.

Can anybody help us with this?....Is this facility already available or does it need a developer to help with this bit?...Thanks in advance.

It could not that big problem. I only need to know how to exchangerate and the productprice from the database. The rest I could do by myself.

Is there nobody how knows the structures of zencart?? :(

I also am trying to display fees with different prices and currencies based on regions.

This is not a final solution but I may have found a temporary solution.
It will require that I go in once a week and update the currency exchange rates and USD totals for each product.

I made 3 regions USA, Canada, UK.
Then I made a few fees under each of those countries.

I changed the text on the Main page to be the regions and list of fees under the regions.
On the store I made visible the currency box and categories.
Then I made links from the Main page to the individual pages for each fee.

But before doing this I would change the currency on the page displaying one fee, and then insert that link onto the Main page for that fee.

So when someone comes to the store they see their region and fees they can pay.
When they click on the fees under UK they will see all the products in GBP.
When they click on the fees under USA they will see all the products in USD.

Once this was done I took off the store the currency option and categories. Then someone cannot change the currency.

I think if I could get a real time converter installed I would be satisfied with this option.
Anyway may be this can help someone else until then.

Shana

Stoned-6:

Hey,

is it possible to show different currencies in product info ???

base currency is EURO but I want to show my customers the product price in
USD GBP. The standart for the order should be EURO I only want to the other currencies. Is something like that possible???

Thanks

Frank

Code for euro is here:

will place in downlaods section. Takes currency values from database, just change the query to make dollars e.t.c.

Add In /public_html/includes/templates/yourtemplate/templates/tpl_product_info_display.php

After line 72:

 //euro currency

$currencies_query_db = "select *
                          from " . TABLE_CURRENCIES . " where title = 'Euro'";
$rate = $db->Execute($currencies_query_db);
$rates = $rate->fields['value'];
$spacer = '<br/>';
echo $spacer;
$value = zen_get_products_display_price((int)$_GET['products_id']);
list($curency, $amount) = split(';', $value);
$amount = $amount*$rates;
$amount= number_format($amount, 2, '.', '');
echo '€'.$amount;

//end of euro currency

if you want to display in product listings also, then :

Add In /public_html/includes/modules/yourtemplate/product_listing.php

After line 111:

//euro currency

$currencies_query_db = "select *
                          from " . TABLE_CURRENCIES . " where title = 'Euro'";
$rate = $db->Execute($currencies_query_db);
$rates = $rate->fields['value'];
$value = zen_get_products_display_price($listing->fields['products_id']);
list($curency, $amount) = split(';', $value);
$amount = $amount*$rates;
$amount= number_format($amount, 2, '.', '');
$amount= 'Approx €'.$amount;
$lc_text = $lc_price . $amount;

//end of euro currency

Hi,

thanks a lot :clap:

So I could make now all changes to display the additional currency.

Cheers

Frank

Hello,

I don't know if my situation is slightly different of not.

My website is marketed in New Zealand, however I am in Australia.

My products are in Australian Dollars. I can't put them in NZ dollars because the merchant account that I have only allow the system to send payments to my Eway account in Australian dollars.

What I want to do is to be able to have the ability to show (on the product page), the price in New Zealand dollars (like the currency side box, how you can select different currencies, however I don't have my site set up with side boxes)

Is there a way to do this?

Kind regards,
Anthony

Calljj:

if you want to display in product listings also, then :

Add In /public_html/includes/modules/yourtemplate/product_listing.php

After line 111:

//euro currency

$currencies_query_db = "select *
from " . TABLE_CURRENCIES . " where title = 'Euro'";
$rate = $db->Execute($currencies_query_db);
$rates = $rate->fields['value'];
$value = zen_get_products_display_price($listing->fields['products_id']);
list($curency, $amount) = split(';', $value);
$amount = $amount*$rates;
$amount= number_format($amount, 2, '.', '');
$amount= 'Approx €'.$amount;
$lc_text = $lc_price . $amount;

//end of euro currency

Hi Calljj,

Im totally newbie, just installed ZenCart 3 days back and spent almost 48 hrs on it.

Really nice code.

I have little problem and need your guidance.

When I tried to replicate same code in other files like new_products.php, It is working but the problem is that its not reflecting Discount price.

I mean to say when its calculating the given currency by your code, its calculating the original product price for currency conversion, its not taking the new discounted price.

1st Request
So I want to know what changes should I do to the code, so it should see if the price is discounted then display that, **if possible **in same way as it shows like Strike out old price and show new price in red color.

2nd Request
I want your code to reflect on all site, so individually what all files I should put this code. When I changed new_products.php, its changed in new products section but still not on home page.... So where to see to change home page too.

3rd Request
Is it possible it to integrate to show at products total value page in shopping cart, if so then how.

My base currency is Euro, and im placing your code with GBP

Thank you in advance.

~Time

I ended up using this

http://www.zen-cart.com/forum/showthread.php?t=60112&highlight=euro&page=2

and altering css and the .php files to get what you described above

Its possible to display different currency in attributes???
please help