FexEx Zones and Canada address errors...

[sf7804]

I am having a problem whenever a customer in Canada tries to place an order, they get an error from the FexEx zones contrib...

 

For example:

1064 - You have an error in your SQL syntax near '2P2 >= pcode_from and M5V 2P2 <= pcode_to' at line 4



SELECT * FROM fedex_pcode_to_zone_xref WHERE M5V 2P2 >= pcode_from and M5V 2P2 <= pcode_to



[TEP STOP]

 

Is there a simple way to edit the FedEx zones to by-pass that shipping option when shipping to canada and just use the USPS rates (which is already set up)?

[Guest]

Try this before //Tim's new code....

 

// If the country is not the United States then error out

 $ctry = $order->delivery['country_id'];

  if ( $ctry != '223' ){

   // something is wrong, this is not the US

 $this->quotes['error'] = MODULE_SHIPPING_FEDEXZIPZONES_INVALID_ZONE;

    	 return $this->quotes;

     }

[Guest]

Need to add the title and icon for the FedEx line when an error occurs (like non US zipcodes :wink: ). Search in catalog/includes/modules/shipping/fedexzipzones.php for:

 

$this->quotes['error'] =

 

And add this after...

 

$this->quotes['module'] = MODULE_SHIPPING_FEDEXZIPZONES_TEXT_TITLE;

$this->quotes['icon'] = tep_image($this->icon, $this->title);

[Theodorb]

Sorry but all that does is give the person a nice error message, but still does not allow to ship to Canada using Fedex zone.

 

I would really be interested in a solution that would allow me to use Fedex to ship to Canada, heck internation.

 

Not trying to be lippy just frustrated in trying to find a way for OSC to ship to Canada and the rest of the world from the US.

 

TY

Theo

[Guest]

1. The easiest approach is to take Sarah's suggestion above and use USPS Methods contribution for International orders. The error handling code above at least allows your Canadian customer to checkout.

 

2. Do the above but also install the Manual Order Entry contribution and change the shipping charges to Fedex Rates after checkout and refund the difference ... or perform the order entry for your client and bill them the cost plus Fedex.

 

3. Take the FedEx contribution and substitute the tables with the Canadian tables. The challenge is that Canadian zipcodes are not numeric like the US but alpha-numeric.