pamelasplayroom Posted July 3, 2007 Share Posted July 3, 2007 hi all. i was looking for a way to automatically update the exchange rates. i have 3, GBP, EUR, USD. i believe that at the time of checkout and processing by paypal, it will look at the default currency (GBP) and perform a conversion based on the actual exchange rate for the day, and this is what the customer is charged in their local currency. but i want to update the rates on a daily basis so that the customer gets price info that is the same, or at least real close to the amount they will actually pay. with the way that rates can change, if i am away for a week the rate could change enough to make a huge difference when converting GBP to USD and back, and that may put someone off buying from me. confirmation and clarification of how osc handles multiple currency's and exchange rates between the shop and paypal would be good, as i am worried that people may be over or under charged due to me not having the latest exchange rates, and information on how you deal with exchange rates on your own shops would be great. its always useful to know how others deal with problems that may have multiple solutions. many thanks. Link to comment Share on other sites More sharing options...
Guest Posted July 3, 2007 Share Posted July 3, 2007 hi all. i was looking for a way to automatically update the exchange rates. i have 3, GBP, EUR, USD. i believe that at the time of checkout and processing by paypal, it will look at the default currency (GBP) and perform a conversion based on the actual exchange rate for the day, and this is what the customer is charged in their local currency. but i want to update the rates on a daily basis so that the customer gets price info that is the same, or at least real close to the amount they will actually pay. with the way that rates can change, if i am away for a week the rate could change enough to make a huge difference when converting GBP to USD and back, and that may put someone off buying from me. confirmation and clarification of how osc handles multiple currency's and exchange rates between the shop and paypal would be good, as i am worried that people may be over or under charged due to me not having the latest exchange rates, and information on how you deal with exchange rates on your own shops would be great. its always useful to know how others deal with problems that may have multiple solutions. many thanks. The is a contrib that you can install (too complex for me with its cron job). Link to comment Share on other sites More sharing options...
pamelasplayroom Posted July 3, 2007 Author Share Posted July 3, 2007 The is a contrib that you can install (too complex for me with its cron job). wow, that was a fast reply, any idea where i find the mod, when i searched earlier it didnt show up. if you dont use it how do you deal with exchange rates, or do you just have prices in one currency? thanks for the help. Link to comment Share on other sites More sharing options...
Guest Posted July 3, 2007 Share Posted July 3, 2007 wow, that was a fast reply, any idea where i find the mod, when i searched earlier it didnt show up. if you dont use it how do you deal with exchange rates, or do you just have prices in one currency? thanks for the help. http://www.oscommerce.com/community/contri...search,currency I do mine manually about once a week via admin. Link to comment Share on other sites More sharing options...
pamelasplayroom Posted July 3, 2007 Author Share Posted July 3, 2007 thanks, thats exactly what im looking for. i will give it a go and let you know how i get on, and see how difficult it is to set up a cron job do do it. i assume that you dont have any problems with over/under charging by only updating the rates once a week, and that my understanding of how osc deals with different currencies is correct and i shouldnt worry about it. many thanks for the help. P.S. you dont know anything about my css/color problem in another post by any chance. thanks for sorting this one for me. Link to comment Share on other sites More sharing options...
dynamoeffects Posted July 3, 2007 Share Posted July 3, 2007 Another suggestion is this one: http://www.oscommerce.com/community/contributions,4006 It will send you email reports after the update so that you know if it failed or not. Please use the forums for support! I am happy to help you here, but I am unable to offer free technical support over instant messenger or e-mail. Link to comment Share on other sites More sharing options...
Guest Posted July 3, 2007 Share Posted July 3, 2007 Another suggestion is this one: http://www.oscommerce.com/community/contributions,4006 It will send you email reports after the update so that you know if it failed or not. Thanks Brian. The last time I looked at that one, you need the USD as the default, but you fixed that. Still neeeds a cronjob though. Link to comment Share on other sites More sharing options...
dynamoeffects Posted July 3, 2007 Share Posted July 3, 2007 Still neeeds a cronjob though. Not sure what you mean. Cron is a service that runs on the server and a cronjob is nothing more than a scheduled event. There's no way to include a "cronjob" in the package, if that's what you mean. The script in that contribution is designed to run completely autonomously to where you can schedule it to run at regular intervals with no human interaction. Please use the forums for support! I am happy to help you here, but I am unable to offer free technical support over instant messenger or e-mail. Link to comment Share on other sites More sharing options...
Guest Posted July 3, 2007 Share Posted July 3, 2007 Not sure what you mean. Cron is a service that runs on the server and a cronjob is nothing more than a scheduled event. There's no way to include a "cronjob" in the package, if that's what you mean. The script in that contribution is designed to run completely autonomously to where you can schedule it to run at regular intervals with no human interaction. Cron is a service that runs on the server and a cronjob is nothing more than a scheduled event is understood. There's no way to include a "cronjob" in the package is understood. The script in that contribution is designed to run completely autonomously to where you can schedule it to run at regular intervals with no human interaction is understood. I just do not want to have to set it up. Link to comment Share on other sites More sharing options...
Jack_mcs Posted July 3, 2007 Share Posted July 3, 2007 http://www.oscommerce.com/community/contri...search,currency I do mine manually about once a week via admin. You can add a line of code to your admin/index.php file to run the script from that contribution. It will be ran each time you log into admin (or go to the index page). That will provide an easier way that what you are doing, since it is automatic, although not as good as using cron, since you may not visit the index page regularly. Jack Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Guest Posted July 3, 2007 Share Posted July 3, 2007 You can add a line of code to your admin/index.php file to run the script from that contribution. It will be ran each time you log into admin (or go to the index page). That will provide an easier way that what you are doing, since it is automatic, although not as good as using cron, since you may not visit the index page regularly. Jack Thanks Jack, will give it a burl. Link to comment Share on other sites More sharing options...
pamelasplayroom Posted July 5, 2007 Author Share Posted July 5, 2007 hi all. well i gave it a try and all was good, got everything updated and the results output to the screen. went to change the output to email, edited the mod code ok (good comments in the code) ran it and got a error Fatal error: Call to undefined function: tep_mail() in /home/pamelas/public_html/shop/admin/update_currencies.php on line 144 the mod file that i used was the lates one. anyone got any ideas. im going to change it back to screen output as i want to test the cron setup, but it would be nice to get the mail working. many thanks. Link to comment Share on other sites More sharing options...
Guest Posted July 5, 2007 Share Posted July 5, 2007 You can add a line of code to your admin/index.php file to run the script from that contribution. It will be ran each time you log into admin (or go to the index page). That will provide an easier way that what you are doing, since it is automatic, although not as good as using cron, since you may not visit the index page regularly. Jack Hi Jack I don't know what to add to the index.php page and not have the page time out while it is getting the currencies update. I have just made a bookmark to the file and will open that link when I want to update the currencies. I am happy with that. Link to comment Share on other sites More sharing options...
Jack_mcs Posted July 6, 2007 Share Posted July 6, 2007 Add this to the bottom of the admin/index.php file. Assuming this file is from the same contribution you are using. <?php include('update_currencies.php'); ?> Jack Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Guest Posted July 6, 2007 Share Posted July 6, 2007 Add this to the bottom of the admin/index.php file. Assuming this file is from the same contribution you are using.<?php include('update_currencies.php'); ?> Jack Hi Jack Thank you again. Mine was called currency_updater.php and I had to delete the functions that it duplicated in application_top.php. So when I log in to Admin, it updates the currencies. Link to comment Share on other sites More sharing options...
Guest Posted July 6, 2007 Share Posted July 6, 2007 Hi Jack Thank you again. Mine was called currency_updater.php and I had to delete the functions that it duplicated in application_top.php. So when I log in to Admin, it updates the currencies. Just an update, most of the time the page times out. Link to comment Share on other sites More sharing options...
Jack_mcs Posted July 7, 2007 Share Posted July 7, 2007 You may want to give this one a try. It always works for me. Jack Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Guest Posted July 7, 2007 Share Posted July 7, 2007 You may want to give this one a try. It always works for me. Jack Ok, will give this one a try. Thanks Jack. Link to comment Share on other sites More sharing options...
Guest Posted July 7, 2007 Share Posted July 7, 2007 Ok, will give this one a try. Thanks Jack. OK, tried that on my test site and just got part of the file on the screen. Will leave it at my old way. Thanks. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.