Jump to content
dynamoeffects

Freightquote.com Shipping Module Support

Recommended Posts

This is the support thread for the official Freightquote.com shipping module. The module can be downloaded here: http://addons.oscommerce.com/info/7364

 

Please report all bugs and feature requests at GitHub: http://github.com/Dy...-for-osCommerce

Edited by dynamoeffects

Please use the forums for support! I am happy to help you here, but I am unable to offer free technical support over instant messenger or e-mail.

Share this post


Link to post
Share on other sites

No MVS support just yet, but it will eventually be added.


Please use the forums for support! I am happy to help you here, but I am unable to offer free technical support over instant messenger or e-mail.

Share this post


Link to post
Share on other sites

1054 - Unknown column 'products_freightquote_enable' in 'field list'

SELECT products_freightquote_enable,products_freightquote_class,products_freightquote_length,products_freightquote_width,products_freightquote_height,products_freightquote_nmfc,products_freightquote_hzmt,products_freightquote_package_type,products_freightquote_commodity_type,products_freightquote_content_type FROM products WHERE products_id = 1095 LIMIT 1

Can you please post the SQL to update the database. I'm feeling too lazy to reverse engineer it.

 

I'm willing to help modify this for MVS if you want. I have a small amount of familiarity with the mods needed. :-"

 

Regards

Jim


See my profile for a list of my addons and ways to get support.

Share this post


Link to post
Share on other sites

I should have mentioned that your embedded table mods failed because my database is set to read/write only. You might add a warning for those of us who practice basic security. Anyway, I did the mods manually, so ignore the post.

 

Regards

Jim


See my profile for a list of my addons and ways to get support.

Share this post


Link to post
Share on other sites

For anyone else with the same database update issue as kymation, the code to do a manual database update can be found here: http://wiki.github.com/DynamoEffects/Freightquote.com-for-osCommerce/manual-database-update


Please use the forums for support! I am happy to help you here, but I am unable to offer free technical support over instant messenger or e-mail.

Share this post


Link to post
Share on other sites

I have the module installed and testing was working fine, but now I am receiving this error: "The pickup date 5/31/2010 is not a date our carriers service. Please select a regular business day for pickup"

 

I am logged in as : xmltest@Freightquote.com

Pass: XML

Service type: LTL

 

Any thoughts?

Share this post


Link to post
Share on other sites

If you're in the US, that date is a holiday. Maybe Freightquote recognizes that and does not consider it a business day. If that's the case, the solution is going to be messy.

 

Regards

Jim


See my profile for a list of my addons and ways to get support.

Share this post


Link to post
Share on other sites

I added this module and have all my products enabled for it and weights set and nothing shows up when I reach the shipping info in the shopping cart. No error - the shipping method text shows up, but the box the quote is supposed to go is empty. Any thoughts? Thanks!

Share this post


Link to post
Share on other sites

It sounds like cURL isn't working on your server. Contact your host's support channel and make sure that cURL is installed and accessible from your account.


Please use the forums for support! I am happy to help you here, but I am unable to offer free technical support over instant messenger or e-mail.

Share this post


Link to post
Share on other sites

For anyone else with the same database update issue as kymation, the code to do a manual database update can be found here: http://wiki.github.com/DynamoEffects/Freightquote.com-for-osCommerce/manual-database-update

 

just tried your solution, but i got this message

 

Error Code: 1146

Table 'geo4wdparts_magento.orders' doesn't exist

 

looking at the magento tables I noticed that the orders table doesn't exist , we are using Magento ver. 1.3.2.4

 

hope you can give me a hand.

 

-Andres

Share this post


Link to post
Share on other sites

Any Freightquote account used with this interface must first be activated for API access. If you are getting an "Invalid username or password" message when requesting a quote from Freightquote using this module, this is likely the cause. Call Freightquote at 800.323.5441 and request activation of your account. I spoke to CariAnn Steward at x1574; others may also be able to do this.


See my profile for a list of my addons and ways to get support.

Share this post


Link to post
Share on other sites

I've modified this module to work with MVS. The download can be found here, and the support thread is here.

 

Thanks to Freightquote and Brian Burton for the original module.

 

Regards

Jim


See my profile for a list of my addons and ways to get support.

Share this post


Link to post
Share on other sites

After I installed everything I get this error message whenever trying to check out. Any ideas?

 

 

Fatal error: Call to undefined function: array_diff_key() in /homepages/45/d353995726/htdocs/catalog/includes/modules/shipping/freightquote.php on line 464

Share this post


Link to post
Share on other sites

I got the above issue fixed that I mentioned but now I have another problem...

 

It sounds like cURL isn't working on your server. Contact your host's support channel and make sure that cURL is installed and accessible from your account.

 

I'm having the same information and when I go to check the server information it says...

 

CURL support enabled

CURL Information libcurl/7.15.5 OpenSSL/0.9.8o zlib/1.2.3 libidn/0.6.5

 

And when in the checkout screen with debug on it says...

 

Freightquote.com

DEBUG: No shipping rates or errors were returned from Freightquote.com, so no shipping option is being returned.

Edited by ZachMayfield

Share this post


Link to post
Share on other sites

Wow,This is how we are going to have to ship our stores products is with ltl freight and we have decided to use freightquote for integrating shipping into oscart.Now I dont have to figure it all out for myself.Thank You for this thread.Im sure it will save me a day or two looking for answers.

Share this post


Link to post
Share on other sites

Is anyone still using this contribution. I cannot get this contribution to work at all. All I get is a invalid password/username error.

 

And one rep at freightquote states my account is enabled for API use...

Edited by Pr0ject

Share this post


Link to post
Share on other sites

I'm using the MVS modified version and it's still working. You probably need to call Freightquote again.

 

Regards

Jim


See my profile for a list of my addons and ways to get support.

Share this post


Link to post
Share on other sites

Here is my problem. I have installed the contribution in a fresh site and everything seems to be working, except for the FQ interface in /admin/categories.php. I put all the package information in the FQ section in Catalog -> Categories, hit Preview and then Update. I go back into that same item and the "Enable with Freightquote:" is un-checked and all of the dimensions boxes say "0". Just for fun, I have gone into the Products database and manually edit the product and it looks good. I can checkout and all of the FQ stuff works just fine. When I go and edit that product again and change a dimension, it will not save the updated size. What can I do to fix this?

 

Scott

Share this post


Link to post
Share on other sites

It sounds like you made a mistake in editing your admin/categories.php, probably in the top part of that file. Check your edits carefully. A comparison program (such as Meld) will help a lot.

 

Regards

Jim


See my profile for a list of my addons and ways to get support.

Share this post


Link to post
Share on other sites

I checked 3 times and I get the same results.

 

I got it to work, but I had to add a lot of code like this:

 

 if ($action == 'new_product') {
   $parameters = array('products_name' => '',
				   'products_description' => '',
				   'products_url' => '',
				   'products_id' => '',
				   'products_quantity' => '',
				   'products_model' => '',
				   'products_image' => '',
				   'products_price' => '',
				   'products_weight' => '',
				   'products_freightquote_enable' => '',
				   'products_freightquote_class' => '',
				   'products_freightquote_length' => '',
				   'products_freightquote_width' => '',
				   'products_freightquote_height' => '',
				   'products_freightquote_nmfc' => '',
				   'products_freightquote_hzmt' => '',
				   'products_freightquote_package_type' => '',
				   'products_freightquote_commodity_type' => '',
				   'products_freightquote_class' => '',
				   'products_freightquote_content_type' => '',
				   'products_date_added' => '',
				   'products_last_modified' => '',
				   'products_date_available' => '',
				   'products_status' => '',
					   'products_tax_class_id' => '',
				   'manufacturers_id' => '');
   //---Freightquote Modification START ---//
   $parameters = $freightQuote->mergePostParameters($parameters);
   //---Freightquote Modification END ---//

 

Scott

Edited by partsace

Share this post


Link to post
Share on other sites

I have just learned that Freightquote now limits the use of this module to 100 quotes per month, making the module useless.

 

Regards

Jim


See my profile for a list of my addons and ways to get support.

Share this post


Link to post
Share on other sites

I have just learned that Freightquote now limits the use of this module to 100 quotes per month, making the module useless.

 

Regards

Jim

 

I've been using freightquote successfully for a few months now.  If you show that you have a need for more than 100 quotes a month, they will up the limits.  I'm a happy customer!  The best part is its free :)

Share this post


Link to post
Share on other sites

So I've been using this module for 9 or so months now and I can't complain... it is serving my needs since I deal mostly with large freight.

 

However, i have found one bug I was hoping someone could help me with.  If a customer mistakenly types in an invalid zip code, after 1 minute freightquote times out and returns an error.  This error is handled correctly in the freightquote.php module, however, with the error is passed back to checkout_shipping.php, it appears to simply call "tep_session_unregister('shipping'); 

 

At that point the checkout_shipping.php page is simply stuck.  No error message to the customer letting them know they entered in an invalid zip code.

 

SO... my question is this:

 

1) Is there a way to validate a zip code when entered?

 

OR

 

2) Is there a way to handle this more gracefully and simply print a message to the screen letting the customer know what is going on?

 

Any advice would be appreciated!

Thanks!

Edited by phi148

Share this post


Link to post
Share on other sites

That's a tough one. The module is doing what it should when it gets an error, but osCommerce is not being helpful. I believe that the module could be modified to push out a message, but I haven't tried to do this.

 

Checking the Zip code is also tricky. There is a USPS interface for address checking, but it requires a lot of work to set up, and there is no osCommerce module to do this. it would be possible, but would take a lot of coding. Probably easier to get the module to spit out a real error message.

 

Regards

Jim


See my profile for a list of my addons and ways to get support.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×