X-Cart: shopping cart software

X-Cart forums (https://forum.x-cart.com/index.php)
-   Dev Questions (https://forum.x-cart.com/forumdisplay.php?f=20)
-   -   Multi currency modul (https://forum.x-cart.com/showthread.php?t=38421)

virtual@croatia 05-18-2008 08:25 AM

Re: Multi currency modul
 
Quote:

Originally Posted by konadnailart
Hi
I got the following error when trying to install, any pointers. Am using 4.1.9.
Thanks


Copying skin files ...

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

Activating the module ...

Please wait ...
[OK]

Please wait ...
Creating table: [xcart_currency_rate] ... [OK]
[FAILED] You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT value FROM xcart_config WHERE name = 'currency_symbol')


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

virtual@croatia 05-18-2008 08:33 AM

Re: Multi currency modul
 
Quote:

Originally Posted by Italian Glassman
Just a quick question:
I deal with two main currencies (USD & CAD).

If my Canadian clients click on CAD, will their account be credited in CAD by PayPal?
Conversely, if my US clients click on USD, will their account be credited in USD by PayPal?

My site is currently only in USD and although I show the CAD conversion on the site, my Canadian clients still get charged in USD and some of them are annoyed by this (and some others have written to tell me that they won't buy from me until they can purchase in CAD).

Thanks for letting me know if your mod does this. If not, perhaps you can point me to something that could do the job. Thanks!!!

Mario


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

Italian Glassman 06-02-2008 04:57 AM

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

virtual@croatia 06-03-2008 01:01 AM

Re: Multi currency modul
 
Quote:

Originally Posted by Italian Glassman
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


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

tqualizerman 07-23-2008 07:10 PM

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?

pairodimes 07-24-2008 09:49 AM

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.

AquaClic 08-05-2008 12:08 AM

Re: Multi currency modul
 
Quote:

Originally Posted by tqualizerman
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?


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

tqualizerman 08-05-2008 01:31 AM

Re: Multi currency modul
 
Quote:

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


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.

virtual@croatia 08-07-2008 01:03 AM

Re: Multi currency modul
 
Quote:

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


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

virtual@croatia 08-07-2008 01:09 AM

Re: Multi currency modul
 
Quote:

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



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.

Quote:

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



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

Quote:

Originally Posted by pairodimes
PS - do we need to download another mod for the IP location stuff?



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.

Quote:

Originally Posted by pairodimes
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.


No, it's not.


All times are GMT -8. The time now is 06:36 PM.

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.