The problem is that the UPS module that comes with the cart always assumes USD prices, even when you are in another currency, it always forces "From" USD conversion. So you are actually seeing $1.878,16 MXN which is the same as 151.51 USD.
The fix is not exactly simple, as the currency code actually has to be pulled from the response message from UPS. My private UPS XML module from my store does this already, but the core one will take some work as they are coded differently.
No worries, I'm fine with purchasing your private UPS XML module if this is the faster fix to this problem? Would you suggest this at this point? I really need to have my UPS shipping active and functioning correctly to make sales, customers are asking nearly every day about this issue.
Thank you,
Falofal
Thank you,
Falofal
Excellent!!! Your help has been most appreciated. I'll be sure follow-up once I have your private UPS XML shipping module installed. And if I still have the same issue.
Again, your help and work here with OpenCart is most appreciated. I'm off to spend some money in your store now.
Thank you,
Falofal
Again, your help and work here with OpenCart is most appreciated. I'm off to spend some money in your store now.
Thank you,
Falofal
I have the same problem, but at that time, Q said it is my cart problem. So I have paid someone to develop my express cost, currently I'm satisfy with my shipping now.
shipping cost in product.jpg (36.08 KiB) Viewed 3647 times
shipping cost in checkout.jpg (29.04 KiB) Viewed 3647 times
I know nothing about PHP and SQL, but I still try my best to understand it.
Q, I've purchased, installed and configured your UPS XML Shipping module and since my UPS account is based out of Mexico, it is quoting correct in MXN pesos as compared to my UPS account. But, now if my customers were to change the currency, for example to USD dollars, it under quotes.
I suppose I can disable the other exchange rates for the time being, but I have many clients that order from both Canada, the USA and want to know the exchange cost in their currency.
Suggestion? I'll include two screen shots so you can see the difference in USD and MXN.
Small note: I'm receiving the following error message when "Debug Mode" is selected in the "Yes" position.
Warning: file_put_contents(upsxml_debug.txt) [function.file-put-contents]: failed to open stream: Permission denied in /home/johfrej/public_html/catalog/model/shipping/upsxml.php on line 404
Hey, but I made progress this is good!!
Thank you,
Falofal
P.S.
Allenshea - Thank you for your post.
I suppose I can disable the other exchange rates for the time being, but I have many clients that order from both Canada, the USA and want to know the exchange cost in their currency.
Suggestion? I'll include two screen shots so you can see the difference in USD and MXN.
Small note: I'm receiving the following error message when "Debug Mode" is selected in the "Yes" position.
Warning: file_put_contents(upsxml_debug.txt) [function.file-put-contents]: failed to open stream: Permission denied in /home/johfrej/public_html/catalog/model/shipping/upsxml.php on line 404
Hey, but I made progress this is good!!
Thank you,
Falofal
P.S.
Allenshea - Thank you for your post.
Attachments
USD Dollars - UPS_XML_by_Q_2.jpg (189.3 KiB) Viewed 3621 times
MXN Pesos - UPS_XML_by_Q_1.jpg (193.27 KiB) Viewed 3621 times
Be sure your exchange values in the currency area of opencart are up to date and use "Auto-update" to ensure correct conversion.falofal wrote:Q, I've purchased, installed and configured your UPS XML Shipping module and since my UPS account is based out of Mexico, it is quoting correct in MXN pesos as compared to my UPS account. But, now if my customers were to change the currency, for example to USD dollars, it under quotes.
This is because your store's root folder is not writable. Change it to chmod 777Small note: I'm receiving the following error message when "Debug Mode" is selected in the "Yes" position.
Warning: file_put_contents(upsxml_debug.txt) [function.file-put-contents]: failed to open stream: Permission denied in /home/johfrej/public_html/catalog/model/shipping/upsxml.php on line 404
Q, after confirming my currency exchange rates are up to date, I made sure my System/Settings are set to "Yes" under the "Auto Update Currency:" setting. But still the problem remains.
Here is what I noticed, when I change the System/Settings "Weight Class:" to kilograms and my default currency to USD (and of course adjusting all the other currency exchanges correctly) the UPS amount quotes correct in USD dollars, but not in MXN pesos. And just the reverse is true, when "Weight Class:" is set to grams and my default currency to MXN pesos the UPS shipping amount quotes correct in MXN pesos, but not in USD dollars.
Just check my error logs and found this error:
2011-01-11 15:25:19 - PHP Notice: Undefined index: weight_class in /home/johfrej/public_html/admin/controller/localisation/weight_class.php on line 342
Not sure what else I should check?
Currently, all is set as grams with a default currency of MXN.
As for the writable error - SOLVED.
Thank you,
Falofal
Here is what I noticed, when I change the System/Settings "Weight Class:" to kilograms and my default currency to USD (and of course adjusting all the other currency exchanges correctly) the UPS amount quotes correct in USD dollars, but not in MXN pesos. And just the reverse is true, when "Weight Class:" is set to grams and my default currency to MXN pesos the UPS shipping amount quotes correct in MXN pesos, but not in USD dollars.
Just check my error logs and found this error:
2011-01-11 15:25:19 - PHP Notice: Undefined index: weight_class in /home/johfrej/public_html/admin/controller/localisation/weight_class.php on line 342
Not sure what else I should check?
Currently, all is set as grams with a default currency of MXN.
As for the writable error - SOLVED.
Thank you,
Falofal
Q,
Sure, sending via email and listing here with account info deleted.
After taking a quick peek at the upsxml_debug.txt file, I see it lists my shipping state of Guanajuato with the abbreviation of "GA". Where as in a "UPS Ports of Export for Mexico Air Services Only" Excel file that I download directly from the UPS.com website, shows the state abbreviation as "GT". Not sure that would make any difference?
Thank you,
Falofal
Sure, sending via email and listing here with account info deleted.
After taking a quick peek at the upsxml_debug.txt file, I see it lists my shipping state of Guanajuato with the abbreviation of "GA". Where as in a "UPS Ports of Export for Mexico Air Services Only" Excel file that I download directly from the UPS.com website, shows the state abbreviation as "GT". Not sure that would make any difference?
Thank you,
Falofal
Q,
Until someone emailed me today to make me aware, an error still remains with the currency conversion between MXN pesos and Dollars (and all the other currencies) regarding the shipping quote from UPS with your UPS XML shipping module. I apologize for not continuing through the purchasing process to catch this sooner.
I have attached two screen shots so you can see where the problem is occurring. It seems to be happening inside the shopping cart itself and when you arrive at the Checkout Confirmation section, yet before adding the total to the cart the UPS XML shipping amount converts correctly to and from USD, CAD, EURO, POUNDS and MXN just fine. Which can be seen in the attached photos.
Thank you,
Falofal
Until someone emailed me today to make me aware, an error still remains with the currency conversion between MXN pesos and Dollars (and all the other currencies) regarding the shipping quote from UPS with your UPS XML shipping module. I apologize for not continuing through the purchasing process to catch this sooner.
I have attached two screen shots so you can see where the problem is occurring. It seems to be happening inside the shopping cart itself and when you arrive at the Checkout Confirmation section, yet before adding the total to the cart the UPS XML shipping amount converts correctly to and from USD, CAD, EURO, POUNDS and MXN just fine. Which can be seen in the attached photos.
Thank you,
Falofal
Attachments
johfrej.com1.jpg (180.09 KiB) Viewed 3544 times
johfrej.com2.jpg (187.24 KiB) Viewed 3544 times
Once again a new problem has been discovered.
Now, UPS quotes are NOT correct until they are added to the Shopping Cart when shipping from Mexico to an international destination such as; USA, Canada, UK or Italy. But, once in the Shopping cart the UPS quote is correct in all the currencies I use on my site (USD, CAD, MXN, EUR & GBP).
I have reviewed and updated my currency exchange rates just to be sure and it has no effect on this issue.
When I select UPS shipping from Mexico to another domestic location inside Mexico ALL is correct in ALL currencies.
See the attached screen shots for more detail.
Thank you,
Falofal
Now, UPS quotes are NOT correct until they are added to the Shopping Cart when shipping from Mexico to an international destination such as; USA, Canada, UK or Italy. But, once in the Shopping cart the UPS quote is correct in all the currencies I use on my site (USD, CAD, MXN, EUR & GBP).
I have reviewed and updated my currency exchange rates just to be sure and it has no effect on this issue.
When I select UPS shipping from Mexico to another domestic location inside Mexico ALL is correct in ALL currencies.
See the attached screen shots for more detail.
Thank you,
Falofal
Attachments
USD Dollars currency set - johfrej_5.jpg (177.76 KiB) Viewed 3513 times
UPS Website quotes to compare to OpenCart UPS XML Shipping Module - johfrej_6.jpg (98.95 KiB) Viewed 3513 times
MXN Pesos currency set - johfrej_4.jpg (184.48 KiB) Viewed 3513 times
I'm with you on that one!!
Hey, but excellent progress has been made in making your UPS XML shipping module that much more of a functioning master piece!
Cheers mate!
Falofal
Hey, but excellent progress has been made in making your UPS XML shipping module that much more of a functioning master piece!
Cheers mate!
Falofal
Last edited by falofal on Fri Jan 21, 2011 6:48 am, edited 1 time in total.
Who is online
Users browsing this forum: No registered users and 3 guests
