AbanteCart Community

Shopping Cart Operations => Support => General Support => Topic started by: Ollie on November 08, 2014, 02:46:28 PM

Title: Shipping estimator - Foreign currency mismatch
Post by: Ollie on November 08, 2014, 02:46:28 PM
Shipping estimator works perfectly when I request an estimate in English. It also works well when switching to another language and getting a quote in USD. However, when I choose a foreign currency in a foreign language (other than English), there is a mismatch in the estimated amounts. The amount in the dropdown menu does not match the amount shown on the page. See attached screenshot. I appreciate if someone could help me figure this one out.
Title: Re: Shipping estimator - Foreign currency mismatch
Post by: Basara on November 10, 2014, 06:36:05 AM
Hello

What shipping method used in screenshot?
Can you please post site URL?
Title: Re: Shipping estimator - Foreign currency mismatch
Post by: abolabo on November 10, 2014, 09:57:53 AM
shipping estimator based on shipping methods calculations. i guess use tried an usps shipping method. Be sure that your usps account allow to process requests with a different currencies.
Title: Re: Shipping estimator - Foreign currency mismatch
Post by: Ollie on November 10, 2014, 10:53:00 AM
What shipping method used in screenshot? Can you please post site URL?
USPS. Here's the URL for one of the products: http://assistech.com/store/152239
Title: Re: Shipping estimator - Foreign currency mismatch
Post by: Ollie on November 10, 2014, 10:57:59 AM
Be sure that your usps account allow to process requests with a different currencies.
The problem is happening with both UPS and USPS. I checked my USPS settings in Abantecart and there's no place to set currency.
Title: Re: Shipping estimator - Foreign currency mismatch
Post by: abolabo on November 10, 2014, 01:04:00 PM
i have a problem with replication this bug ( can't get damn usps account ).
Can you tell what is your store location settings (country,  zone, postal-code) and customer's address that you tried to? i guess cause is in address
Title: Re: Shipping estimator - Foreign currency mismatch
Post by: llegrand on November 10, 2014, 01:39:13 PM
FYI  -  I had same issue with UPS,  I found if I change the UPS setting to ALL Locations - it works,  is set to only US,  I get only the store location state.

Additionally,  since I only have enabled US for this install,  all the countries (even though turned off )  show in the country dropdown, but if one is selected that doesn't have zones enabled it shows NONE

Just hadn't posted this yet.

Lee

PS abolabo -  I think they do an IP check  - if you want me to get you a test account  let me know.

Title: Re: Shipping estimator - Foreign currency mismatch
Post by: Ollie on November 10, 2014, 08:17:22 PM
Thank you, Lee. You're right on target. I changed my UPS settings to All Zones and it's now working.  :) However, this is a fix to another post. (You might want to post your answer there too.) These two posts are somehow related, they both have to do with shipping so it's easy to get confused. :-) The above post has to do with shipping and foreign currency mismatch, and I'm still having trouble in this area. The issue is still open.
Title: Re: Shipping estimator - Foreign currency mismatch
Post by: llegrand on November 11, 2014, 12:23:09 AM
You're right Ollie,  sorry for the confusion - it was a busy and harried day today.
I will post this over there also -  thanks for the catch.

Lee
Title: Re: Shipping estimator - Foreign currency mismatch
Post by: Ollie on November 30, 2014, 03:22:01 PM
I found out what the problem was. There is no currency mismatch. What happens is that the quotes provided by the carrier are all in US dollars (my default currency), even though they display the currency symbol that the customer selected. I believe this problem can be easily solved with a javascript replace function and that's what I'm trying now.
Title: Re: Shipping estimator - Foreign currency mismatch
Post by: Basara on December 01, 2014, 08:37:26 AM
I found out what the problem was. There is no currency mismatch. What happens is that the quotes provided by the carrier are all in US dollars (my default currency), even though they display the currency symbol that the customer selected. I believe this problem can be easily solved with a javascript replace function and that's what I'm trying now.

Hello.
Issue confirmed. Thank you for reporting problem.  Fixes process https://github.com/abantecart/abantecart-src/issues/42
Title: Re: Shipping estimator - Foreign currency mismatch
Post by: Ollie on December 01, 2014, 10:32:56 AM
Issue confirmed. Thank you for reporting problem.  Fixes process https://github.com/abantecart/abantecart-src/issues/42
Hi Basara. I created an account at GitHub, but couldn't find the fixes. Is it just a post looking for fixes?
Title: Re: Shipping estimator - Foreign currency mismatch
Post by: Basara on December 01, 2014, 11:01:30 AM
Sorry for inconvenience. I mean when developer fix it this issue at github will be closed.
Title: Re: Shipping estimator - Foreign currency mismatch
Post by: Ollie on December 01, 2014, 11:12:51 AM
No problem. I believe I found out what's going on. The amounts in the dropdown menu are in the currency selected by the customer and they seem to be correct. For example, USD $49.35 = 39.62E to ship an item to France by Priority Mail. This means 1 USD = .8028368E. The line right below the Subtotal is taking the quote in Euro and multiplying by .8028368E, therefore posting an incorrect amount (31.81) instead of repeating the same quote from USPS. It looks like the totals are in a table called "totals_table". Any idea where this table is located?
Title: Re: Shipping estimator - Foreign currency mismatch
Post by: Ollie on December 01, 2014, 11:59:52 AM
With the help of a programmer in Greece I was able to solve the problem with the shipping estimator when using a foreign currency. There is a "weight code" setting in UPS that needs to match weight class. Once I entered "lb" for "pound", the problem was gone. With this change and the javascript he customized for me, my shipping estimator is now working beautifully.
Title: Re: Shipping estimator - Foreign currency mismatch
Post by: Ollie on December 05, 2014, 06:17:20 PM
UPDATE: A developer created a javascript for me that resolved the mismatch between shipping quote and amount shown in the table. However, the amounts quoted in the dropdown menu are out of wack in all currencies, except USD. The developer said it is working for one particular item in my shopping cart. This shipping estimator is acting crazy. Any suggestions for a resolution are greatly appreciated.
Title: Re: Shipping estimator - Foreign currency mismatch
Post by: Ollie on December 06, 2014, 11:17:46 AM
With the help of a programmer in Greece I was able to figure out the problem with shipping mismatch when using a foreign currency. There is a setting in UPS called "weight code". This field was blank. Once I set it to "lb" to match the weight class ("pound"), the problem was gone. With this and the javascript that he customized for me, the shipping estimator is now working beautifully in any currency.
Title: Re: Shipping estimator - Foreign currency mismatch
Post by: Ollie on December 06, 2014, 11:20:22 AM
With the help of a programmer in Greece I was able to solve the shipping estimator problem when using a foreign currency.