I've been struggling with this for a while now and I'm getting pretty desperate. Hopefully someone can give me some ideas for a solution.
I built a store, spent months painfully uploading products, designing the front-end, adding bells and whistles, only to find that the real-time shipping rates are broken.
UPS, FedEx, USPS, etc… all return a 401 error instead of a shipping cost.
Well, after checking every possible combination of settings in the admin panel (trust me, I've ticked and un-ticked every box) I went to CS Cart support.
Support says it's a server error. So I checked all the server settings (hostGator) and everything checks out. There are no firewalls or filters that are blocking the transmission of data to any of the shipping service providers, and especially nothing blocking ALL of them.
Support still insists that it's a problem with the server, so I got a new server, WiredTree, upgraded to v2.2.2, transferred the site and the same issue. Shipping's broke.
Support maintains that it cannot be a problem with my Cs Cart. So I installed a fresh copy of CS Cart, tested the shipping and Hey Presto! It works!
I overwrote the fresh CS Cart files with my own and the shipping still worked!
Then I uploaded my database… and it broke again. I'm back to getting the super-helpful “error n/a” message when I test the shipping method from the admin panel and the
[quote]“Sorry, it seems that we have no shipping options available for your location. Please check your shipping address and contact us if everything is okay. We'll see what we can do about it.”[/quote]
error on the front-end.
Next, I tried overwriting the database with blank tables, backing up each table individually and restoring them one at a time, checking each time to see when the shipping would break. I got about half-way when the entire site crashed; obviously some tables are dependent upon one another and if I can't access the admin panel, I can't check to see which one is breaking my shipping.
Other things I've already tried:
uninstalling all third-party addons
compared all the PHP and TPL files on my server with the fresh ones
playing with locations, localizations (They're correct)
getting first-hand confirmation that the usernames and passwords are correct from the shipping providers
eating right and staying healthy
[*]not eating right and drinking too much
nothing seems to work.
The way I understand it, a CS Cart script sends an XML file to UPS (or whoever) with my AccessLicenceNumber, UserId, Password, RateRequest etc… and UPS sends back a number, which CS Cart plugs into a template to display. Somewhere in my database is an evil gremlin that is preventing this exchange.
How do I find and kill it?
Why does a fresh install work but when I upload my database everything turns to crap?
I love CS Cart and I have used it for several other projects with awesome support and very little problems. Why is CS Cart support replying to every ticket message with “it's the server” or “have you tried changing mysql to mysqli?” Basically blowing me off.
too long, didn't read: something in my database is breaking the real-time shipping… how fix?