Is there a functioning FedEx module for 1.3.8a?

Quote:

---

Originally Posted by cpowell1

Code:

---

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

---

replace with:

Code:

---

WHERE products_id = " . (int)$product['id']

---

I also just replaced:

Code:

---

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

---

with

Code:

---

$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.

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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?

Quote:

---

Originally Posted by 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:

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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?

Quote:

---

Originally Posted by 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).