Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

Multi currency modul

 
Reply
   X-Cart forums > X-Cart 4 > Dev Questions
 
Thread Tools Search this Thread
  #21  
Old 05-18-2008, 08:25 AM
 
virtual@croatia virtual@croatia is offline
 

Advanced Member
  
Join Date: May 2007
Posts: 92
 

Default 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
__________________
Check what you can do with x-cart 4.1.9:
www.smee.com

Modules I made:
IP_Ranges
Multy_Currency
Order_Dates

Modules I use:
Fancycategory
Magnifier
Survey
AOM
Reply With Quote
  #22  
Old 05-18-2008, 08:33 AM
 
virtual@croatia virtual@croatia is offline
 

Advanced Member
  
Join Date: May 2007
Posts: 92
 

Default 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 . 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
__________________
Check what you can do with x-cart 4.1.9:
www.smee.com

Modules I made:
IP_Ranges
Multy_Currency
Order_Dates

Modules I use:
Fancycategory
Magnifier
Survey
AOM
Reply With Quote
  #23  
Old 06-02-2008, 04:57 AM
 
Italian Glassman Italian Glassman is offline
 

Advanced Member
  
Join Date: Sep 2007
Posts: 92
 

Default 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
__________________
X-Cart version 4.1.8
(given up, for now, on 4.1.9 upgrade)
Reply With Quote
  #24  
Old 06-03-2008, 01:01 AM
 
virtual@croatia virtual@croatia is offline
 

Advanced Member
  
Join Date: May 2007
Posts: 92
 

Default 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
__________________
Check what you can do with x-cart 4.1.9:
www.smee.com

Modules I made:
IP_Ranges
Multy_Currency
Order_Dates

Modules I use:
Fancycategory
Magnifier
Survey
AOM
Reply With Quote
  #25  
Old 07-23-2008, 07:10 PM
  tqualizerman's Avatar 
tqualizerman tqualizerman is offline
 

X-Adept
  
Join Date: Jun 2008
Posts: 392
 

Default 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?
__________________
- www.nerdseven.com - Gadgets & Gizmos from Out of This World
- Sound Sensitive T-Shirts That Flash to the Beat of Music (http://www.tqualizer.com)


X-Cart Version 4.1.10
Reply With Quote
  #26  
Old 07-24-2008, 09:49 AM
  pairodimes's Avatar 
pairodimes pairodimes is offline
 

Advanced Member
  
Join Date: Dec 2007
Posts: 50
 

Default 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.
__________________
------
Brian

Portland web design / development
X-Cart 4.1.9 (a few carts)
X-Cart 4.2.0 (1 cart so far)
Reply With Quote
  #27  
Old 08-05-2008, 12:08 AM
  AquaClic's Avatar 
AquaClic AquaClic is offline
 

Advanced Member
  
Join Date: Aug 2007
Posts: 37
 

Default 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
__________________
Xcart version 4.1.10
Reply With Quote
  #28  
Old 08-05-2008, 01:31 AM
  tqualizerman's Avatar 
tqualizerman tqualizerman is offline
 

X-Adept
  
Join Date: Jun 2008
Posts: 392
 

Default 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

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.
__________________
- www.nerdseven.com - Gadgets & Gizmos from Out of This World
- Sound Sensitive T-Shirts That Flash to the Beat of Music (http://www.tqualizer.com)


X-Cart Version 4.1.10
Reply With Quote
  #29  
Old 08-07-2008, 01:03 AM
 
virtual@croatia virtual@croatia is offline
 

Advanced Member
  
Join Date: May 2007
Posts: 92
 

Default 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

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
__________________
Check what you can do with x-cart 4.1.9:
www.smee.com

Modules I made:
IP_Ranges
Multy_Currency
Order_Dates

Modules I use:
Fancycategory
Magnifier
Survey
AOM
Reply With Quote
  #30  
Old 08-07-2008, 01:09 AM
 
virtual@croatia virtual@croatia is offline
 

Advanced Member
  
Join Date: May 2007
Posts: 92
 

Default 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.
__________________
Check what you can do with x-cart 4.1.9:
www.smee.com

Modules I made:
IP_Ranges
Multy_Currency
Order_Dates

Modules I use:
Fancycategory
Magnifier
Survey
AOM
Reply With Quote
Reply
   X-Cart forums > X-Cart 4 > Dev Questions


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 12:05 AM.

   

 
X-Cart forums © 2001-2020