fedex zones v2.1 fedex_pcode_to_zone_xref

[hilldog]

Hi,

 

Installed the Fedex_Zones_V2.1 module into oscommerce 2.2ms2 on linux apache server.

 

Downloaded and modified fedex shipping.pdf to fedex Zone_Locator.txt

 

Everything pretty much OK, except "no zone for zip code" when test order generated using fedex shipping method.

 

Checked fedex_pcode_to_zone_xref table, and found a lot of zeroes:

INSERT INTO fedex_pcode_to_zone_xref VALUES (1, 0, 0, 0);

INSERT INTO fedex_pcode_to_zone_xref VALUES (2, 0, 0, 0);

.

.

.

 

Modified buildfedexdata.php to echo sql= statements, this is what the browser displayed:

INSERT INTO fedex_pcode_to_zone_xref VALUES (1, 00400, 00599, 1);

INSERT INTO fedex_pcode_to_zone_xref VALUES (2, 01000, 01199, 2);

.

.

.

 

Copied, modified, the echo statements to sql statements:

INSERT INTO fedex_pcode_to_zone_xref VALUES (1, 00400, 00599, 1);

INSERT INTO fedex_pcode_to_zone_xref VALUES (2, 01000, 01199, 2);

.

.

.

Inserted the statements to a .sql file;

dropped original fedex_pcode_to_zone_xref table

recreated fedex_pcode_to_zone_xref table using fat-fingered file.

table created OK, contents consistent with modified sql statements.

 

All seems OK, but am wondering:

1. anyone else had same problem?

2. any way to validate shipping figures calculated by fedex module?

 

Thanks!

Steve

[Guest]

I used fedex direct contribution, then all had to do is put in the account #, address, zipcode and then when a customer goes to checkout, it pulls the info from the fedex site based upon your actual discount they give you, and displays the price on the page for the customer to choose shipping method.

[Guest]

I just replaced our old store with a new MS2 version and am trying to get things working again. I tried adding the Fedex Direct contribution, but cannot get it to successfully poll Fedex. Keep getting the "curl cannot connect with Feex server..." error. Checked the config of the server with the ISP/host and phpInfo and curl and openSSL are both installed and properly configured (or so they say).

 

So then I thought just to get Fedex working, I would install the Fedex Zone Shipping Calc contribution. At first I got the same message about no zip code match, etc., and by looking in the database table created, I saw that the script diod not populate the zip code ranges with data - all zeros for the zip code ranges and zone ID in the fedex_pcode_to_zone_xref table.

 

So then I manually entered data in that table, but now I do not get anything at all in the checkout window -- no error message, no logo, nothing. And I am using a zip code that I know is now in the table. But I get no options, text or anything in the checkout window.

 

I've tried turning the module off and on, tried turning off the UPS and USPS modules, still get nothing.

 

Anyone have any ideas what I might be missing in the setup or install of this module? It seemed pretty easy to set up,but it doesn't display anything at all when enabled.