Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Fedex Zone Contrib version 2.0 ready


wasson65

Recommended Posts

Hi all, Tim here.

 

Thanks to help from another user (Josh!), there is a new release of the Fedex Zone Contrib, available here:

http://www.oscommerce.com/community/contributions,490

 

The fixes are:

2003 rate tables now used (Thanks Josh)

Added some indexes to the tables

Fixed bug where shipments broken into multiple packages would not get the quotes multiplied properly.

Fixed bug where the handling charge wasn't getting added to the total (Thanks Josh)

Added Fedex Icon (Thanks Josh)

Added the description of the number of boxes x the weight to the output.

 

Enjoy!

 

Tim

Link to comment
Share on other sites

  • Replies 145
  • Created
  • Last Reply

Top Posters In This Topic

Are the rate tables quoting for fed ex express, or fedex ground ??

 

Also, in order to get the correct rates to Alasks, hawaii, & puerto rico - which field needs to be removed from the table ??

 

Thanks Tim!

 

Jason

Link to comment
Share on other sites

Are the rate tables quoting for fed ex express, or fedex ground ??

 

Also, in order to get the correct rates to Alasks, hawaii, & puerto rico - which field needs to be removed from the table ??

 

Thanks Tim!

 

Jason

 

When you convert the pdf to text, there are 3 sets of 2 columns (6 total) of data for most of the zip codes, but for the Alaska, Hawaii, and Puerto Rico zip codes there are 3 sets of 3 columns each.

 

The order of the columns in a set for AK, Hawaii, and PR is

zip code range - ground zone - non-ground zone

 

You'll want to remove the ground zone column, to leave 3 sets of 2 columns each.

 

Does this make sense?

 

Tim

Link to comment
Share on other sites

Yep, that makes sense.  So, i'm guessing this is for fedex express rates, these tables do not calculate ground rates ??

 

They will calc ground and express based on the zone. But for Alaska and Hawaii and Puerto Rico, the ground rates are not accurate because the ground zone is different from the express zone.

Link to comment
Share on other sites

Perfect, its working now - it took a bit of time to clean out the puerto rico, and the extra column, but the script ran perfectly.

 

I took out puerto rico, as it assigned a zone of *, as that's what was listed in the PDF - * says to consult fedex.com for rates - i figured why leave it in the table..took it out.

 

Thanks :)

Link to comment
Share on other sites

Any ideas anyone? Im getting the following error

Warning: Invalid argument supplied for foreach() in /usr/www/users/plogix/store/admin/buildfedexdata.php on line 103

 

Warning: Invalid argument supplied for foreach() in /usr/www/users/plogix/store/admin/buildfedexdata.php on line 126

 

Im using MS1 on a linux machine.

 

Thanks

Link to comment
Share on other sites

  • 3 weeks later...

So, it appears that the prices this Mod generates are all for shipping to businesses?

 

Can anybody out there tell me what percentage they add in to the calculations (as per the mod's instructions) to make up for the additional cost of shipping to residential on a regular basis?

 

I think I'm seeing differences between the script and Fedex.com of about 3-5%, but wanted to confirm with others who may already be making sales with this.

 

Thanks!

 

-= Dave =-

Link to comment
Share on other sites

I believe this is what you are looking for:

 

 

 

// change this surcharge factor to cover the gas surcharge from fedex, or to bury packaging costs

// As of 2/2003, 1.045 was the surcharge factor that Fedex was using.

     $this->surcharge_factor = 1.045;

   }

 

It is in catalog/includes/modules/shipping/fedexzipzones.php at about line 36.

Link to comment
Share on other sites

Well, yes, I knew about that.

 

Trouble is, that figure, combined with the rates extracted from the downloadable PDF file, gives you the rates for shipping via FedEx to another business.

 

In many cases, if you are shipping to a residence, the ACTUAL rate that is applied is quite a bit higher. So, it seems that if one is selling to consumers, one is going to have to add in some sort of "fudge factor" to take this into account, or one is going to be providing estimates that are too low... and therefore be losing money.

 

I was curious as to how much of a markup people were using for this "fudge factor".

 

Thanks!

 

-= Dave =-

Link to comment
Share on other sites

Thanks for spotting that. Why use business rates instead of residential rates when we ship mostly to residential customers? Rates are significantly higher especially for higher priced and heavier items. Thanks for pointing that out.

 

I skimmed over your topic because I figured that I was covered by the handling charge... but why not get it right the first time!

 

Thanks again.

Link to comment
Share on other sites

I guess it is sort of obvious that I have not made a sale using FedEx yet and I have a bit of research to do but I have looked at the rate tables.

 

If they are using business rates instead of home delivery rates it is easy enough to download the home delivery rate charts, remove the $ signs, compare the formats and use them (if they are available for download).

 

If they are not avaialable just bump up your handling fee or surcharge factor to compensate. It all depends upon your avaerage dollar value and weight per package shipped.

Link to comment
Share on other sites

I get an

 

Warning: Invalid argument supplied for foreach() in /includes/modules/shipping/fedexzipzones.php on line 110

 

Error, and I know its not over 150 pounds and I still get the error. Anyone know why or a solution?

 

Thanks,

Kevin

Link to comment
Share on other sites

it also causes that error when i try sending from 29303 to 44890 (willard, OH)

 

000-003            NA           299                   3    458-495             4           786-787                5

004-005            4            300-306               2    496-563             5           788                    6

010-046            5            307                   3    564-567             6           789                    5

047                6            308-309               2    568-569            NA           790-797                6

048-069            5            310                   3    570-5715                        798-799                7

070-105            4            311                   2    572-587             6           800-812                6

106                5            312-322               3    588-597             7           813-816                7

107-118            4            323-329               4    598-599             8           817-819               NA

119-126            5            330-332               5    600-609             4           820                    6

127                4            333-349               4    610-612             5           8217

128-136            5            350-353               3    613-622             4           822                    6

137-143            4            354-355               4    623                 5           823-832                7

144-146            5            356-363               3    624-633             4           833                    8

147-227            4            364-367               4    634-635             5           834                    7

228-229            3            368                   3    636-639             4           835-838                8

230-237            4            369                   4    640-653             5           839                   NA

238-2413                        370-374               3    654-655             4           840-853                7

242                2            375                   4    656-676             5           854                    8

243-253            3            376-379               2    677-679             6           855-863                7

254                4            380-384               4    680-689             5           864                    8

255-259            3            385                   3    690-693             6           865                    7

260                4            386-397               4    694-699            NA           866-869               NA

261-262            3            398                   3    700-702             4           870-872                6

263-265            4            399                   2    703                 5           873-874                7

266                3            400-402               4    704                 4           875-877                6

267                4            403-409               3    705-714             5           878-880                7

268                3            410                   4    715                NA           881-884                6

269                NA           411-418               3    716                 4           885                    7

270-274            2            419                  NA    717-719             5           886-888               NA

275-278            3            420                   4    720-725             4           889-966                8

279                4            421-422               3    726-738             5           970-994                8

280-282            2            423-424               4    739                 6

283-285            3            425-427               3    740-768             5

286-293            2            428-429              NA    769                 6

294                3            430-455               4    770-779             5

295-298            2            456-457               3    780-785             6

006-007                    *                             96744                        10                            96797                       10                

008                       NA                             96745-96757                  12                            96798-96800                 12                

009                        *                             96758-96759                  10                            96801-96863                 10                

96700                     12                             96760-967611

                                                                                        2                            96864-96899                 12                

967011

                          0                             96762                        10                            969                         NA                

96702-96705               12                             96763-96774                  12                            99500                       11                 

96706-96707               10                             96775                        10                            99501-99524                  9                 

96708                     12                             96776-967811

                                                                                        2                            99525-99539                 11                 

96709                     10                             96782                        10                            99540                        9                 

96710                     12                             96783-96785                  12                            99541-99566                 11                 

96711-96712               10                             96786                        10                            99567                        9                 

96713-96716               12                             96787-96788                  12                            99568-99576                 11                 

96717                     10                             96789                        10                            99577                        9                 

96718-96729               12                             96790                        12                            99578-99999                 11                 

96730-967311

                          0                             96791-96792                  10                 

96732-96733               12                             96793                        12                 

96734                     10                             96794-96795                  10                 

96735-96743               12                             96796                        12                

Link to comment
Share on other sites

  • 3 weeks later...

The surcharge for FedEx Ground to a residential address is a flat $1.40 accordingto the FedEx web site. Note that FedEx Home Delivery is different than FedEx Ground with the residential surcharge. Home Delivery has extra services available like late delivery and prearranged drop-off times, and is more expensive.

 

It would be totally cool if the following could be added to the contrib:

1) A flat surcharge amount for the residential surcharge (it isn't a percentage amount) (separate from the Osc shipping surcharge, since I'd use that for packaging costs for any carrier).

2) Detect if the customer's "Company" field is blank or not and automatically display the business or residential rates accordingly.

 

- Adam

Link to comment
Share on other sites

When you convert the pdf to text, there are 3 sets of 2 columns (6 total) of data for most of the zip codes, but for the Alaska, Hawaii, and Puerto Rico zip codes there are 3 sets of 3 columns each.

 

The order of the columns in a set for AK, Hawaii, and PR is

zip code range - ground zone - non-ground zone

 

You'll want to remove the ground zone column, to leave 3 sets of 2 columns each.

 

Tim

 

Tim, Looking at the pdf generated by FedEx, it looks like the second column is FedEx Express and the 3rd column is FedEx Ground, the reverse of what you say above.

 

Also, questions:

1) I don't have the mentioned pdf-txt converter. If I convert using Acrobat to an rtf, and then convert that to txt, it comes out nicely but it is 1 set of two columns -- will that work ok?

2) For the zip codes with NA or *, should these be left as-is or the whole line removed? Will there be a problem if a zip code range is missing or will it just not show up as a shipping option if someone enters one of those codes.

 

Thanks,

Adam

Link to comment
Share on other sites

  • 3 weeks later...

Hi. I got the 110 error as well. I think what is causing the problem is the Zone_Locator.txt file. I polished the file some and got it working. You just need to be careful with the Zone_Locator.txt file.

 

I looked through the file catalog/includes/modules/shipping/fedexzipzones.php . I notice that at the beginning of the file

 

// class methods

 

function quote($method = '') {

 

global $order, $shipping_weight, $shipping_num_boxes;

 

$rounded_weight = round($shipping_weight,0);

 

During the rounding of weight process, any number below 1.5 is rounded to 1.0 and any number above 1.5 is rounded to 2.0, which does not sounds right to me. If I have to ship a 1.4lb package, it will be rounded off to 1lb (but Fedex will charge us rate at 2lb), which means customer is paying less shipping.

 

The fix to this is to replace the round command to ceil

 

// class methods

 

function quote($method = '') {

 

global $order, $shipping_weight, $shipping_num_boxes;

 

$rounded_weight = ceil($shipping_weight);

 

This will round off 1<weight<=2 to 2lb.

 

Hope that this help.

Link to comment
Share on other sites

  • 1 year later...
Hi. I got the 110 error as well. I think what is causing the problem is the Zone_Locator.txt file. I polished the file some and got it working. You just need to be careful with the Zone_Locator.txt file.

Hi, i've been trying to get this contribution to work for hours now but I keep getting this error:

 

Warning: Invalid argument supplied for foreach() in /home/gforceau/public_html/store/includes/modules/shipping/fedexzipzones.php on line 110

 

This is what my Zone_Locater.txt file:

 

000-003 NA
004-005 8
010-324 8
325 7
326-349 8
350-359 7
360-363 8
364-367 7
368 8
369-372 7
373-374 8
375 7
376-379 8
380-397 7
398-399 8
400-402 7
403-418 8
419 NA
420-424 7
425-426 8
427 7
428-429 NA
430-459 8
460-466 7
467-468 8
469 7
470 8
471-472 7
473 8
474-479 7
480-497 8
498-499 7
500-503 6
504 7
505 6
506-507 7
508-516 6
517-519 NA
520-560 7
5616
562-567 7
568-569 NA
570-5816
582 7
583-588 6
589 NA
590-5915
592-595 6
596-599 5
600-639 7
640-649 6
650-652 7
653 6
654-655 7
656-676 6
677-679 5
680-692 6
693 5
694-699 NA
700-709 7
710-711 6
712-717 7
718-719 6
720-725 7
726-738 6
739 5
740-789 6
790-794 5
795-796 6
797-812 5
813 4
814-838 5
839 NA
840-853 4
854 3
855-863 4
864 3
865 4
866-869 NA
870-872 5
873-874 4
875-878 5
879 4
880-885 5
886-888 NA
889-892 3
893-898 4
899 NA
900-933 2
934 3
935 2
936-939 3
940-966 4
970-986 5
987 4
988-994 5
96700 12
96701 10
96702-96705 12
96706-96707 10
96708 12
96709 10
96710 12
96711-96712 10
96713-96716 12
96717 10
96718-96729 12
96730-96731 10
96732-96733 12
96734 10
96735-96743 12
96744 10
96745-96757 12
96758-96759 10
96760-96761 12
96762 10
96763-96774 12
96775 10
96776-96781 12
96782 10
96783-96785 12
96786 10
96787-96788 12
96789 10
96790 12
96791-96792 10
96793 12
96794-96795 10
96796 12
96797 10
96798-96800 12
96801-96863 10
96864-96899 12
99500 11
99501-99524 9
99525-99539 11
99540 9
99541-99566 11
99567 9
99568-99576 11
99577 9
99578-99999 11

 

I would really appreciate some help, because as it stands now my customers can't get select FedEx as the shipping type and that the only shipping I'm offering!

 

--Adam

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...