Is there a functioning FedEx module for 1.3.8a?

cpowell1:

WHERE products_id = " . $product['id']

> 
> replace with:
> 
> ```
WHERE products_id = " . (int)$product['id']

I also just replaced:

$data .= '116,"' . $this->num_pieces . '"'; // Total number of pieces

> 
> with
> 
> ```
$data .= '116,"' . $shipping_num_boxes . '"'; // Total number of pieces

I'm still not sure if it's working right because I'm having issues accessing my client's account on the FedEx site. But at least it's giving me rates now that are closer to reality. (Before I did that second replace, I got a quote of $238.25 for shipping a half-pound box that happened to have 25 small items in it.)

Before adding the above mods, my FedEx quotes were too high. With the mods added in, the quotes are too low.
I compared the quotes to FedEx's website on the shipping estimater.

JTheed:

Before adding the above mods, my FedEx quotes were too high. With the mods added in, the quotes are too low.

I compared the quotes to FedEx's website on the shipping estimater.

I lost the ability to log into to my client's FedEx data on the FedEx website in the middle of my testing so I can't verify that the quotes I'm getting now are correct.

The rates quoted when you have an account number ARE lower than the ones you get when you use their estimator without an account number, so make sure you're logged in to that account and using the correct account number when comparing on the FedEx shipping estimator.

cpowell1:

The rates quoted when you have an account number ARE lower than the ones you get when you use their estimator without an account number, so make sure you're logged in to that account and using the correct account number when comparing on the FedEx shipping estimator.

I tried again logging into their website using our account number and all of the Cart's estimates are still lower except 1st Overnight. The lowers ones range from almost 4.00 to just under 1.00.

Here are the differences Cart vs Website

1st Overnight 61.84 vs 60.55
Priority Overnight 31.58 vs 35.30
Standard Overnight 27.60 vs 29.85
2 Day 18.34 vs 19.29
Express Saver 16.75 vs 17.52
Home N/A vs 7.97

One package weighing 8 lbs going to a location 35 miles away.

Also, how do we get FedEx Home Delivery on to the Cart?

I found that if you go to the My Fedex page once you are logged in, you will get a List of prices and a Your Prices List. The Your prices are lower than the carts, so all is well. Thanks for that tip cpowell1.

Anyone know about the FedEx Home though?

JTheed:

I found that if you go to the My Fedex page once you are logged in, you will get a List of prices and a Your Prices List. The Your prices are lower than the carts, so all is well. Thanks for that tip cpowell1.

Anyone know about the FedEx Home though?

FedEx home seems to show if you're shipping to someone who doesn't have a company name entered.

As for the rates, I did notice they were lower on the FedEx site ("Your Prices") than on the cart estimate. I still haven't regained my access to the client account so I haven't been able to test more, but it's curious that it's returning different prices to the cart. Maybe they build in a profit? :smile:

phastings:

hi. i'm running 1.3.8a with fexed mod 1.4.1. i was having the problem of fedex not showing up on the checkout page. i did the table1->table fix but now i'm getting the error below. any ideas?
thank. paul.

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':8156325fdbe48dbd415939aa043c72ba LIMIT 1' at line 1
in:
[SELECT products_length, products_width, products_height, products_ready_to_ship, product_is_always_free_shipping FROM zen_products WHERE products_id = 33:8156325fdbe48dbd415939aa043c72ba LIMIT 1]

phastings , did you find a resolution for this problem?
I seem to be having the same issue after adding ASA:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':8cd9a94c8d0f51585a4ef83d1ea93746 LIMIT 1' at line 1
in:
[SELECT products_length, products_width, products_height, products_ready_to_ship, product_is_always_free_shipping FROM zen_products WHERE products_id = 560:8cd9a94c8d0f51585a4ef83d1ea93746 LIMIT 1]

I confirmed your observation that the error occurs when adding products to the cart which have attributes.

Considering a possible add on conflict , I also have Stock by Attributes installed

The source of the problem is with fedexexpress.php and fedexground.php function _getDimensions()
( even though I have this option disabled .. )

for now I just added return false; at the beginning to disable the SQL script which has remedied the problem.
I'm sure there's other ways to disable the function (( just comment it ) but I don't know how to fix the syntax error if I needed to use the function.. , I've spent enough time on this problem already .. If anyone has found a better way to correct this error , please let me know.

jonprecise:

The source of the problem is with fedexexpress.php and fedexground.php function _getDimensions()
( even though I have this option disabled .. )

for now I just added return false; at the beginning to disable the SQL script which has remedied the problem.
I'm sure there's other ways to disable the function (( just comment it ) but I don't know how to fix the syntax error if I needed to use the function.. , I've spent enough time on this problem already .. If anyone has found a better way to correct this error , please let me know.
Are people getting this error with the version on the Numinix website?

numinix:

Are people getting this error with the version on the Numinix website?
You shouldn't be getting this error with v1.4.3 released over a month ago...

Numinix first off, great contribution. I am hoping that what I am trying to do will work... One of the biggest setbacks in shipping prices with ZC is "Drop-Shipping". I know, I know, I said the D-word, please read on, I promise I'm not asking for a mod to be made :)

I decided that the easiest way for me to acheive the desired rates without SUPER custom coding, would be to add a couple of fields to the products table. I added: products_origin_zip , products_origin_city , products_origin_state , and products_origin_addr.

My only hurdle is how to grab the values of those fields and send them through the fedex shipping mod in place of MODULE_SHIPPING_FEDEX_GROUND_ADDRESS_1, MODULE_SHIPPING_FEDEX_GROUND_CITY, MODULE_SHIPPING_FEDEX_GROUND_POSTAL. And will it still come back with rates or will it not work because those values won't match my shipping values on the fedex account itself??

I think that if this is able to be done, then voila... drop-ship shipping rates would be solved. Well, if we could pass the above data on a per item basis so that if Product A had x origin and Product B had y origin, total shipping would be (prdA shipping) + (prdB shipping).

Installed v1.4.3 on ZC v1.3.8. Everything seems to be working, but my rates are off. For instance, a 1lb FedEx Home package to zone 1 should be 4.57 + 2.05 residential surcharge + .23 fuel surcharge , for a total of 6.85. I'm showing 8.80 on the shipping estimator. The correct account number is being used.

Think I figured it out. My test item is a couple hundred dollars and it's using that to set insurance rates. However, I don't want to do this as I don't use FedEx insurance. Any way to turn that off?

S U C C E S S

FedEx was **NOT **showing up in either the Shipping Estimator **OR **Checkout. After double checking everything I had done, searching all of the threads, I asked FedEx.

I was told to remove all dashes from account number and phone number AND to remove all periods from addresses.

Did so and all problems solved. :clap:

Thanks to all here AND to the great folks at FedEx.

fred

swingandmiss:

Think I figured it out. My test item is a couple hundred dollars and it's using that to set insurance rates. However, I don't want to do this as I don't use FedEx insurance. Any way to turn that off?

In your setup for both Fedex modules, just set the "Insurance" to NONE - think this should work for ya.

popsshop:

In your setup for both Fedex modules, just set the "Insurance" to NONE - think this should work for ya.

It is set to NONE and I'm still getting insurance added to the rate.

I just want to double check.

My Fedex plugin is working just fine. I just got a letter from Fedex that they are discontinuing support of Fedex Ship Manager API solutions.

We are unaffected by this, right? I don't have to do anything?

I tried the fix and removed all the dashes from the fed ex info and telephone number and niw when I add something to the cart, I get:

1054 Unknown column 'products_length' in 'field list'
in:
[SELECT products_length, products_width, products_height, products_ready_to_ship, product_is_always_free_shipping FROM zen_products WHERE products_id = 16 LIMIT 1]

Any suggestions?

thank you,

betty

Nevermind on that error, I just upgraded to 1.43 and it disappeared.

One thung remainging though on the shipping estimator, despite the fact I have the mod set to Lbs. it si showing the weight in Kgs. Is there a way to fix this?

thank you again,

betty

I just installed FedEx Add-on and its not returning any rates..:(

I signed up for an account on FedEx and put all the info, I also double checked not to have dashes and dots in the phone number, acount # and address.

Anyone has any idea why it might be?

For cURL Path and Proxy, I have NONE

bettysue:

Nevermind on that error, I just upgraded to 1.43 and it disappeared.

One thung remainging though on the shipping estimator, despite the fact I have the mod set to Lbs. it si showing the weight in Kgs. Is there a way to fix this?

thank you again,

betty

Edit the includes/extra-configures/shipping_units.php file:

change to: