Jump to content

Archived

This topic is now archived and is closed to further replies.

Christopher Short

Shipping error with Fedex

Recommended Posts

You have 78 customers (table records?) with names in the 'state' field in the CC_addressbook?

 

Do you think manual edits to the table data would be too much for you? If so, would you like to try the admin snippet? If so, send a PM with your email address.

 

FYI: A drop-down selector may show friendly phrases as choices, but the HTML (or javascript) will send the value attribute of the <option> tag for that choice.

Share this post


Link to post
Share on other sites

You have 78 customers (table records?) with names in the 'state' field in the CC_addressbook?

 

Do you think manual edits to the table data would be too much for you? If so, would you like to try the admin snippet? If so, send a PM with your email address.

 

FYI: A drop-down selector may show friendly phrases as choices, but the HTML (or javascript) will send the value attribute of the <option> tag for that choice.

Where do I go to do this manual update? [email protected]

Share this post


Link to post
Share on other sites

When I asked you to verify if your CC_addressbook table might have a name for the 'state' field for the account you are testing with, I meant for you to use a database management utility, such as phpMyAdmin (commonly found in your hosting control panel's toolkit), to access the database CubeCart is using.

 

Looking in the CubeCart_addressbook database table, take note of the state names. Then, look in the CubeCart_geo_zone table, and note the 'id' of those states. Back in the CubeCart_addressbook table, replace the names with the respective 'id'.

Share this post


Link to post
Share on other sites

When I asked you to verify if your CC_addressbook table might have a name for the 'state' field for the account you are testing with, I meant for you to use a database management utility, such as phpMyAdmin (commonly found in your hosting control panel's toolkit), to access the database CubeCart is using.

 

Looking in the CubeCart_addressbook database table, take note of the state names. Then, look in the CubeCart_geo_zone table, and note the 'id' of those states. Back in the CubeCart_addressbook table, replace the names with the respective 'id'.

Well that explains it. I don't access my server other than through ftp. I will contact my host to see if I can access the database to look.

Share this post


Link to post
Share on other sites

"I don't access my server other than through ftp."

 

If you have a hosting provider that does not provide you with a control panel, then in the email they sent you giving you your FTP details, there should also be details on how to access your database.

 

And if your hosting provider does not at least offer you phpMyAdmin in some fashion, we will need to find you a suitable desktop app to access your database.

Share this post


Link to post
Share on other sites

When I asked you to verify if your CC_addressbook table might have a name for the 'state' field for the account you are testing with, I meant for you to use a database management utility, such as phpMyAdmin (commonly found in your hosting control panel's toolkit), to access the database CubeCart is using.

 

Looking in the CubeCart_addressbook database table, take note of the state names. Then, look in the CubeCart_geo_zone table, and note the 'id' of those states. Back in the CubeCart_addressbook table, replace the names with the respective 'id'.

Is the CubeCart_geo_zone table there as well, or is it in one of the cubecart folders?

Share this post


Link to post
Share on other sites

Thanks everyone for the help. The issue was 2 thing-My password was incorrect(have to use production one not your login one) and the database did not update prior customers to a 2 letter state code. This was thought to be the number series that a new user showed up as but I had to change all prior users to the proper state abbreviation. Thanks again for the help.

Share this post


Link to post
Share on other sites

"I had to change all prior users to the proper state abbreviation."

 

Looking in the CubeCart_addressbook database table, take note of the state names. Then, look in the CubeCart_geo_zone table, and note the 'id' of those states. Back in the CubeCart_addressbook table, replace the names (or whatever non-numeric thing may be in the state column) with the respective 'id'.

 

Please make sure there are numbers in the state column of the CC_addressbook table.

Share this post


Link to post
Share on other sites

Good morning all. I'm back in the office now (albeit with no electricity so I am working from battery). It seems to me like this issue concerns the migration of customer addresses from v3/v4 to v5. I will raise an issue to get this tested and checked. We have suffered data inconsistency on state format in a number of regions of cubecart and in particular with upgrade. 

Share this post


Link to post
Share on other sites

"I had to change all prior users to the proper state abbreviation."

 

Looking in the CubeCart_addressbook database table, take note of the state names. Then, look in the CubeCart_geo_zone table, and note the 'id' of those states. Back in the CubeCart_addressbook table, replace the names (or whatever non-numeric thing may be in the state column) with the respective 'id'.

 

Please make sure there are numbers in the state column of the CC_addressbook table.

 

 

Well, I would however I used 2 letter abbreviations as when I put the numbers in, the cart gave me the no shipping defined message. I put letters in, it works.

Good morning all. I'm back in the office now (albeit with no electricity so I am working from battery). It seems to me like this issue concerns the migration of customer addresses from v3/v4 to v5. I will raise an issue to get this tested and checked. We have suffered data inconsistency on state format in a number of regions of cubecart and in particular with upgrade. 

 

I was an upgrade from v3.

Share this post


Link to post
Share on other sites

I still have the Fedex choices available, and I was able to complete an order with the state_id numbers in the state column of _addressbook. I took it all the way to PayPal, and the cost reflects the Fedex choice on shipping.

Share this post


Link to post
Share on other sites

I am having the issue with Fed Ex that every one seems to be having on the Thread. Is there a way to fix this problem? I am not computer educated at all. Could I possibly hire some one to correct the problem and pay via paypal? Once I activate the Fed Ex Module I get the error that the others are talking about. At some point Fed Ex did work for me but I do not understand why it stopped working. I think once the SSL certificate was transfered it caused this problem possibly. I also had hostgator install something called SOAP. Thank you much in advance for any help.

Share this post


Link to post
Share on other sites

×
×
  • Create New...