bkessler91 Posted January 16, 2013 Share Posted January 16, 2013 So I just upgraded to v5 from v3. In v3 there was a text box that would allow the customer to type in their State. Now that I have upgraded to v5 there is a drop down menu for "State" I am running into problems that customers who registered in v3 placed PA or Pa or Pa. or Penna. for Pennsylvania. Other example, Wa. or WA or Wash. for Washington I am in PA and only charge tax for PA customers. So those who typed in Pa or Pa.... v5 does not recognize, and does not apply tax to the order. Any suggestions? Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted January 16, 2013 Share Posted January 16, 2013 You could use this query to find/replace the variants with PA in the appropriate table(s) UPDATE tablename SET tablefield = replace(tablefield,"findstring","replacestring"); Quote Link to comment Share on other sites More sharing options...
bsmither Posted January 16, 2013 Share Posted January 16, 2013 It is trickier than that. I am led to believe that CC5 will understand a full state name as a temporary measure. Ideally, the various columns that store a 'zone' (state/county/province/etc) will use the zone table's 'id' index number. And I am certain that certain functions (tax, maybe others) will only use the zone's 'id' number. How many customers do you have? If less than 100, you could try to manually change the name to a number. Use a utility like phpMyAdmin, a tool commonly provided in the control panel of your hosted server account. If there are too many to handle manually (and you will need to process the addressbook and order_summary tables), I could work with you to write a script that would try to recognize state names and convert to the 'id' number. Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted January 17, 2013 Share Posted January 17, 2013 As always, Bsmither is THE authority on all things CC!! Quote Link to comment Share on other sites More sharing options...
bkessler91 Posted January 17, 2013 Author Share Posted January 17, 2013 How many customers do you have? If less than 100, you could try to manually change the name to a number. Use a utility like phpMyAdmin, a tool commonly provided in the control panel of your hosted server account. If there are too many to handle manually (and you will need to process the addressbook and order_summary tables), I could work with you to write a script that would try to recognize state names and convert to the 'id' number. 2900 customers... Quote Link to comment Share on other sites More sharing options...
bsmither Posted January 17, 2013 Share Posted January 17, 2013 "Holy c... on a cracker!" (One of my favorite lines from The Big Bang Theory.) I'll start working on a script. Please send me a Private Message with your email address. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.