Re: Multi currency modul
 

Hi,

I didn't get any email for this thread that's why I didn't respond earlier.
Try to manually execute the SQL code to see what kind of error do you get. Open the php MyAdmin for your database (you should've got it from your web provider) and execute the following:

UPDATE xcart_currency_rate SET active = 'Y' WHERE code = (SELECT value FROM xcart_config WHERE name = 'currency_symbol') OR code = (SELECT xcart_currencies.code FROM xcart_currencies INNER JOIN xcart_config ON xcart_currencies.symbol = xcart_config.value AND xcart_config.name = 'currency_symbol');

CREATE TABLE xcart_customer_currency (
login VARCHAR ( 32 ) NOT NULL DEFAULT '',
currency CHAR( 3 ) NOT NULL DEFAULT '',
PRIMARY KEY (login)
) TYPE=MyISAM;

Send me a post if you get any errror.

virtual

Re: Multi currency modul
 

I've begun the work on the PayPal and gess what, it doesn't support non us or non uk businesses :evil:. So it will take a time untill I find a solution for it. And after I find I will work on it.
It won't be a problem to implement the multi currency in the paypal, but you have to be aware that PayPal charges you 2,5% for conversion, so it might be lot cheaper for your customers to pay in USD than to pay in CAD and than to you pay 2,5% for conversion in USD.

Can I ask you, how were you able to open an account on the US PayPal when you are from Canada?

virtual

Re: Multi currency modul
 

Sorry for the long reply Virtual, this post must have sneaked by me.
Paypal allows you to use it if you are from Canada but only the Paypal Standard -- we cannot use the Paypal Pro.

Thanks for the heads up on the currency conversion costs. I think that I can work with that (will have to adjust prices somewhat) but I think that the optics would still be best if I can provide the items in CAD as well as USD.

I appreciate you working on this and look forward to hearing what you can do.

Thanks again!
Mario

Re: Multi currency modul
 

We are opening a branch in the UK to get the option of using the PayPal Pro. It will take a while to open it and after that I will check how to implement the module with it.

virtual

Re: Multi currency modul
 

I'm trying to install this on 4.1.10 but am getting an error:

Copying skin files ...

Copying to file skin1/modules/Multi_Currency/menu_currency.tpl - [OK]
Copying to file skin1/modules/Multi_Currency/currencies.tpl - [OK]
[OK]

Activating the module ...

Please wait ...
[OK]

Please wait ...
[FAILED] Column count doesn't match value count at row 1

Can anyone help?

Re: Multi currency modul
 

Thanks you for posting this mod - I have a question about the compatibility of this mod with One Page Checkout by Altered Cart.

I have a need for Managing currencies and showing the price based on IP location - so I really hope this works :)

PS - do we need to download another mod for the IP location stuff?

P.P.S - is there anyway to manage more than 2 currencies with the out of the box distribution of xcart 4.1.9? - so far I can only show 2. Euro and USD.

Re: Multi currency modul
 

same here... have you found a solution to this yet or at least a hint where i can search :mrgreen:

Re: Multi currency modul
 

The author is willing to work on the solution, but needs access to a site running 4.1.10 and phpMyAdmin, but I can't help on my setup.

Re: Multi currency modul
 

I'm at the vacation right now and have limited access to the internet.

Seems to me that the problem is with the version 4.1.10 and with the changed table xcart_config in it. It looks that there is a column added at the end for some other purpose which produces the error. I tried to add an empty string at the end of the query and have sent it to tqualizerman but he said that the problem still exists.

If you are willing to search for it, there is a file x-currency.sql in folder sql which has to be corrected. If you won't be able to fix it, I'll do it for you when I come home (2 weeks).

Regards,
virtual

Re: Multi currency modul
 

I don't know, never tried. I'm not at home right now so I won't be able to help you if there is a problem with it. Better try it locally first and if it works do it on line.



It does, you can check it on my web site www.smee.hr.



Yes, and YOU HAVE TO INSTALL IT FIRST! IP range module and then Multicurrency module or you will have to change a line in a file as it is explained in the first post.


No, it's not.