networkdad Posted October 23, 2002 Share Posted October 23, 2002 I'm almost done installing my first oscommerce install. One of the last things i have to do is fix the fedex shipping module. The current error is: Error: Service temporarily unavailable. Please contact store owner if you wish to use this service. I've got the fedex module enabled. I'm using snapshot 2.2 dated 10-16-02. I've seen there are some issues here using fedex, but that will be my only shipping option for now. What have you done to fix or get around this so it works? THanks! ~Jason Link to comment Share on other sites More sharing options...
Rainguy Posted October 23, 2002 Share Posted October 23, 2002 As far as I know this is still broke and someone has to wite a new php file for the Fedex API. I don't know what the current staus of this is but, hope there is a fix soon. Link to comment Share on other sites More sharing options...
networkdad Posted October 23, 2002 Author Share Posted October 23, 2002 Thank you, i came to the same conclusion after much searching. Link to comment Share on other sites More sharing options...
donato Posted October 23, 2002 Share Posted October 23, 2002 i still cannot believe that this is still unresolved... both fedex and ups, two of the largest shipping companies and OSC is not compatible with them... sorry not to sound too negaitive here...just really fustrated. Link to comment Share on other sites More sharing options...
networkdad Posted October 23, 2002 Author Share Posted October 23, 2002 I'm sure the developers are working on a solution...I had planned on bringing live a new shopping cart, but i need to have fedex be an option for shipping. Link to comment Share on other sites More sharing options...
wasson65 Posted November 18, 2002 Share Posted November 18, 2002 I just put a new Fedex Shipping module in the Contributions section, you can get it here: http://www.oscommerce.com/downloads.php/co...ions,683/type,2 It doesn't use Fedex's api at all, it figures everything based on their published rate tables stored in a local db table, so it's fast too. Hope this helps, Tim Link to comment Share on other sites More sharing options...
networkdad Posted November 18, 2002 Author Share Posted November 18, 2002 Awesome, thank you! I'll be testing that out later today for sure.. Link to comment Share on other sites More sharing options...
donato Posted November 21, 2002 Share Posted November 21, 2002 WOW! thanks Tim... i too will be testing this out later this weekend... but before i begin, I was wondering, would this work even with a non-US store address? I have a canadian address and unable to use the UPS mod b/c of this...will this mod have the same characteristics? Link to comment Share on other sites More sharing options...
twinmoons Posted November 22, 2002 Share Posted November 22, 2002 Is it possible to adapt this to FedEx Ground? Alas the old FedEx module doesn't work anymore :( Link to comment Share on other sites More sharing options...
twinmoons Posted November 22, 2002 Share Posted November 22, 2002 Oh, and another question, how can you calculate the gas surcharge that FedEx is charging. From what I understand, that isn't part of the rates in the tables. Link to comment Share on other sites More sharing options...
twinmoons Posted November 22, 2002 Share Posted November 22, 2002 Hi Tim, In installed the module per the instructions. Everything went ok in admin and imported the data, but when I place an order and go to checkout, I get this error: 1064 - You have an error in your SQL syntax near '>= pcode_from and <= pcode_to' at line 4 SELECT * FROM fedex_pcode_to_zone_xref WHERE >= pcode_from and <= pcode_to Link to comment Share on other sites More sharing options...
wasson65 Posted November 22, 2002 Share Posted November 22, 2002 Yes, this module can do the ground, but I didn't put those tables in, just didn't get them in yet. I'll try to get around to that very soon. Link to comment Share on other sites More sharing options...
wasson65 Posted November 22, 2002 Share Posted November 22, 2002 Hi Tim, In installed the module per the instructions. Everything went ok in admin and imported the data, but when I place an order and go to checkout, I get this error: 1064 - You have an error in your SQL syntax near '>= pcode_from and <= pcode_to' at line 4 SELECT * FROM fedex_pcode_to_zone_xref WHERE >= pcode_from and <= pcode_to OK, the query is missing the zipcode. It should read something like: SELECT * FROM fedex_pcode_to_zone_xref WHERE 90210 >= pcode_from and 90210 <= pcode_to So the query isn't seeing the zip code. Are you running 2.2 and if so, how old is it? I suspect the problem is that you are running a version of 2.2 prior to Nov 1, when the new checkout code went in. Link to comment Share on other sites More sharing options...
wasson65 Posted November 22, 2002 Share Posted November 22, 2002 Oh, and another question, how can you calculate the gas surcharge that FedEx is charging. From what I understand, that isn't part of the rates in the tables. Short answer: I'm not. I just figure what the rates are from the tables. We might need to think about making a "fudge factor" that gets added to all fedex rates, maybe a percentage or a flat number, to account for this. How big a number is the surcharge, and does it fluctuate? Anyone have a good idea on the magnitude of the charge and how it's created? Tim Link to comment Share on other sites More sharing options...
twinmoons Posted November 22, 2002 Share Posted November 22, 2002 In regards to the surcharge, it's actually pretty big. I know for ground, it's somewhere over $1, and I don't think it's a constant figure. It might be a percentage, but I don't remember FedEx stating what it is. If it's a percentage then I guess you can just multiply the whole table by it and add. About my osC version, it's definitely older than Nov 1. In fact it might be from some time in LAST november. Any way to get it to work with the older 2.2 code? Thanks! Link to comment Share on other sites More sharing options...
wasson65 Posted November 22, 2002 Share Posted November 22, 2002 In regards to the surcharge, it's actually pretty big. I know for ground, it's somewhere over $1, and I don't think it's a constant figure. It might be a percentage, but I don't remember FedEx stating what it is. If it's a percentage then I guess you can just multiply the whole table by it and add. About my osC version, it's definitely older than Nov 1. In fact it might be from some time in LAST november. Any way to get it to work with the older 2.2 code? Thanks! Hmm, sounds like the surcharge is something we'll need to account for somehow. I'll go to the fedex site and check a few different size packages going across the US and see what it comes out to. This would be a good time for me to put the ground info in as well. Then I'll try to come up with a strategy to fudge this number somehow. I guess first I'd better define what I'd consider success, and that is be able to reasonably (not exactly) account for the gas surcharge in most cases. I don't want to spend a week trying to reverse-engineer some funky multi-termed polynomial. As far as backporting to the older code, that's on the back burner for me at this point. I've got a couple pressing projects, and am kinda tied up at this point. In this thread http://www.oscommerce.com/forums/viewtopic.php...p?p=80132#80132 CookieBytes is thinking about using EasyPopulate to move data from pre Nov1 to post Nov1 code, it might be something to think about. Link to comment Share on other sites More sharing options...
twinmoons Posted November 22, 2002 Share Posted November 22, 2002 Sounds great. I'll check out that thread about pre-Nov 1 code porting. Thanks! Link to comment Share on other sites More sharing options...
wasson65 Posted November 22, 2002 Share Posted November 22, 2002 Sounds great. I'll check out that thread about pre-Nov 1 code porting. Thanks! Don't thank me too quickly, I'm troubleshooting a problem with getting the csv files to download in windows-land.... So hang out until I let people know it's up and running. Tim Link to comment Share on other sites More sharing options...
twinmoons Posted November 22, 2002 Share Posted November 22, 2002 I was able to download the CSV file for Ground. If you are still having trouble with it, please let me know and I can send you the CSV file. Link to comment Share on other sites More sharing options...
wasson65 Posted November 22, 2002 Share Posted November 22, 2002 Sounds great. I'll check out that thread about pre-Nov 1 code porting. Thanks! OK, I turned in a new EasyPopulate, it has workarounds in case you run into downloading errors on your site. You can get it here: http://www.oscommerce.com/downloads.php/co...ions,705/type,3 Hope this helps Tim Link to comment Share on other sites More sharing options...
wasson65 Posted November 22, 2002 Share Posted November 22, 2002 I was able to download the CSV file for Ground. If you are still having trouble with it, please let me know and I can send you the CSV file. It will most likely be sometime next week when I do this. I'm buried right now with clients, but this is something I'd like to get fixed.... I'll probably try to lump it in with the surcharge fudge factor fix. Tim Link to comment Share on other sites More sharing options...
webdesignpro Posted November 24, 2002 Share Posted November 24, 2002 I also installed the Fedex mod, but even using the sample zip code data, I'm getting the checkout errors. My snapshot is from about a month ago. What can I do to fix this? -- Harold Corbin Link to comment Share on other sites More sharing options...
wasson65 Posted November 24, 2002 Share Posted November 24, 2002 I also installed the Fedex mod, but even using the sample zip code data, I'm getting the checkout errors. My snapshot is from about a month ago. What can I do to fix this? The fedex module expects to have the post Nov-1 checkout code, so anything before that will have problems. Tim Link to comment Share on other sites More sharing options...
webdesignpro Posted November 24, 2002 Share Posted November 24, 2002 I've made far too many modifications to this installation to download a newer snapshot to reinstall. Perhaps I can just compare the checkout files for changes. Would this work, and which files should I compare? -- Harold Corbin Link to comment Share on other sites More sharing options...
twinmoons Posted November 24, 2002 Share Posted November 24, 2002 Well, I've got the same dilemma. I've made way too many mods and have no idea what to change to get the new checkout to work. But I've installed a couple of versions on a test server and am trying to compare changes in the files. This is going to be a long process, but I don't know of any better way. 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.