SQL patch to insert the US & Non-US Shipping ?

[Rony]

As the title says. Most of the scripts I found in this forum are old and does not work with v1.5.0 ? One such old file is attached.

Here is how I want to implement shipping .....

• 1 lbs shipping cost is $5.00 inside US (including Alaska, Hawaii ...)
• 1 lbs shipping cost is $10.00 outside US

I read at many places, that creating an National & International Zones manually will take a lot of time. But these can be created quickly using a SQL-Script.

Please help.
Thanks

[Rony]

ok, I found this ..... http://www.zen-cart.com/content.php?...ne-definitions

These patches are obsolete and no longer work with v1.5.0

I request Administrators to please update these scripts so that they work with v1.5.0

Thanks

[Ajeh]

Every one of those work fine ... what problems were you having?

[jlizotte]

For what it's worth, this may or may not be his problem, I used these patches last month to add some zones. I got errors every single time. When I took a closer look at the the text I pasted into the sql patch screen, it seems that all the "values" etc were surrounded by single-quotes " ' ". When I changed them to " ` ", the unshifted character under the tilde symbol, they all flew without a problem.

Rony, try this: copy those sql patches into notepad++ or something similar. Do a search and replace. Search for " ' " (single quote), and a replace with " ` " (unshifted tilde character). That might fix you up.

Cheers!

PS This was on a 1.5.1, although that probably has nothing to do with the issue. I think it's just a translation in cut & paste process.