How to display different currency in product info?

[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

[lib99]

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.

[Stoned-6]

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.

[Blackguard]

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.

[Stoned-6]

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

[UVBoy]

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.

[MPEracing]

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.

[Stoned-6]

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??

[Shana]

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

[Calljj]

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 '&euro;'.$amount;

//end of euro currency