Demitry Posted May 10, 2016 Share Posted May 10, 2016 Hi, I'm hoping someone has a solution for the following issue. I added the contributions for Country-State Selector and World Zones, which cover pretty much every place in the world. And I started getting a UPS error at checkout with the following message: 111286: ML is not a valid state for the specified shipment. After some troubleshooting I discovered that there are 2 records for Maryland in the database. Apparently there is a Maryland, Liberia as well, and it precedes Maryland, USA in the database and has the "ML" as the abbreviated State/Province. So what the script is doing, is searching the zones database table for the first instance of "Maryland" and using that record's State/Province 2-letter code for the shipping calculations. When instead, it should be looking for that match based on the zone_country_id. I can probably fix this problem for the Maryland, Liberia issue by changing the name of that province in the database to "Mary-land" but I would rather get a more valid code solution because there may be other duplicate instances and there are over 4K records in that zones table. If anyone has a solution, I would greatly appreciate it. Demitry Quote osCommerce: made for programmers, ...because store owners do not want to be programmers. https://trends.google.com/trends/explore?date=all&geo=US&q=oscommerce Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.