curtisblackwell Posted July 31, 2013 Posted July 31, 2013 Where I'm At My custom theme is more-or-less built. I'm charging for shipping using weight ranges and a single carrier. I input all the weight ranges for that carrier. I input the fees for every zone and weight range. I updated the zones' names and added a few to reflect the carrier's pricing (it's not by continent). I'm now updating the zones for individual countries. I've only updated two countries so far, one a long time ago (it works properly) and about an hour ago (it's not working properly). I set the US to Zone 5 Special, which has an ID of 9. On the front end, after I it displays a shipping price equivalent to that of Zone 2 which has an ID of 2 and was the original zone it was assigned to. Things I've Tried/Checked In the dir app/cache, I deleted everything except index.php (smarty/ and class_index.php). I checked the database to make sure it's correctly set, it appears to be so. In the ps_country table, The US has an id_zone of 9, which matches the id_zone for Zone 5 Special in the ps_zone table. I searched Google. So… Now what? I'm not sure what else to check/try. Is there a database cache somewhere that I'm not aware of? Am I missing something in the process of setting up countries, zones, and weight ranges? Any help is appreciated. Share this post Link to post Share on other sites More sharing options...
curtisblackwell Posted July 31, 2013 Posted July 31, 2013 Ah. States have to be set to the proper zone as well. Is there a quick way to update every state for a country w/o an SQL statement? Preferably via the backend. Share this post Link to post Share on other sites More sharing options...
curtisblackwell Posted July 31, 2013 Posted July 31, 2013 SQL Update Statement UPDATE table SET column = value WHERE other_column = other_value More Specifically UPDATE ps_state SET id_zone = 9 WHERE id_country = 21; Share this post Link to post Share on other sites More sharing options...
PascalVG Posted July 31, 2013 Posted July 31, 2013 Hi Curtis, Thanks for solving your own question I know it sometimes helps to sit down and 'explain' it to someone and then it gives you the solution after doing so! Are there any loose ends left, or is this topic solved? I'll mark it as solved, but please don't hesitate to ask if there are some small pains left. pascal. Share this post Link to post Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now