Guest Posted July 19, 2007 Share Posted July 19, 2007 Yeah this is what I have Enable auspostair True Dispatch Postcode 3337 Enable Insurance False Insurance Base Cost 7.50 Insurance Addition Cost 2.00 Insurance Unit Size 100 Maximum Weight (kg) 20 Handling Fee 5.00 Parcel Height (mm) 100 Parcel Width (mm) 100 Parcel Depth (mm) 100 Shipping Zone World Zones Tax Class Australian GST Sort order of display 0 I also tried creating a new Tax Class 'International tax' Then set a new tax rate of 10% with 'world zones' selected instead of australian and choose 'international tax' from the class pulldown. Then set the tax class in the aus post mod as international tx.. But that didnt work either.. haha. (it is going to be so satisfying when I get this site up and running I tell ya what!) Quote Link to comment Share on other sites More sharing options...
Guest Posted July 19, 2007 Share Posted July 19, 2007 Yeah this is what I haveEnable auspostair True Dispatch Postcode 3337 Enable Insurance False Insurance Base Cost 7.50 Insurance Addition Cost 2.00 Insurance Unit Size 100 Maximum Weight (kg) 20 Handling Fee 5.00 Parcel Height (mm) 100 Parcel Width (mm) 100 Parcel Depth (mm) 100 Shipping Zone World Zones Tax Class Australian GST Sort order of display 0 I also tried creating a new Tax Class 'International tax' Then set a new tax rate of 10% with 'world zones' selected instead of australian and choose 'international tax' from the class pulldown. Then set the tax class in the aus post mod as international tx.. But that didnt work either.. haha. (it is going to be so satisfying when I get this site up and running I tell ya what!) OK, that is correct. Now, the international options will only show when you have a shipping address that is international. Quote Link to comment Share on other sites More sharing options...
Guest Posted July 19, 2007 Share Posted July 19, 2007 Yeah I have seperate addresses in my test account.... I know the addresses and post codes are proper international ones for their respective countries as they are actual addresses... Weird. Quote Link to comment Share on other sites More sharing options...
Guest Posted July 19, 2007 Share Posted July 19, 2007 Yeah I have seperate addresses in my test account.... I know the addresses and post codes are proper international ones for their respective countries as they are actual addresses... Weird. Ok, if you have an international one selected for the shipping address, my guess is that the country codes are not correct, or the world zones are not correct (they looked ok when I saw them), or maybe the last update last year hasn't been patched in catalog/includes/functions/general.php where $country = tep_output_string_protected($address['country']); was changed to $country = tep_output_string_protected($address['country']['title']); and it needs to be changed back to if ($country == '') $country = tep_output_string_protected($address['country']); Quote Link to comment Share on other sites More sharing options...
Guest Posted July 19, 2007 Share Posted July 19, 2007 Hmm I have found a couple of strings similar to that } elseif (isset($address['country']) && tep_not_null($address['country'])) { $country = tep_output_string_protected($address['country']); } else { $country = ''; } $postcode = tep_output_string_protected($address['postcode']); $zip = $postcode; bit further down $statecomma = ''; $streets = $street; if ($suburb != '') $streets = $street . $cr . $suburb; if ($country == '') $country = tep_output_string_protected($address['country']); if ($state != '') $statecomma = $state . ', '; $fmt = $address_format['format']; Sould I change that first one? Quote Link to comment Share on other sites More sharing options...
Guest Posted July 19, 2007 Share Posted July 19, 2007 Hmm I have found a couple of strings similar to that } elseif (isset($address['country']) && tep_not_null($address['country'])) { $country = tep_output_string_protected($address['country']); } else { $country = ''; } $postcode = tep_output_string_protected($address['postcode']); $zip = $postcode; bit further down $statecomma = ''; $streets = $street; if ($suburb != '') $streets = $street . $cr . $suburb; if ($country == '') $country = tep_output_string_protected($address['country']); if ($state != '') $statecomma = $state . ', '; $fmt = $address_format['format']; Sould I change that first one? No, that is the way it should be. If the country is ok, and the zip/post code is ok, it should work. Do you want to give an ex country an pc and I will try it? Quote Link to comment Share on other sites More sharing options...
Guest Posted July 19, 2007 Share Posted July 19, 2007 Yeah cool. I tried a UK address Bury St Edmunds, Suffolk postcode IP32 7DP and a Japanese one with postcode 546-0003 Quote Link to comment Share on other sites More sharing options...
Guest Posted July 19, 2007 Share Posted July 19, 2007 (edited) I have an idea though It could be something to do with the Australian GST In the Tax class for 'Australian GST' the 'Tax Rate' corresponding to it is for Australian Zones only. And there is no option there to make it for both. That could explain why the Prices aren't appearing with GST on them for international customers and no postage is appearing also. I just tried and added a new tax rate of 10% for world zones to correspond with the 'Australian GST' tax class. And that at least made the prices for internal customers show correctly. But it didnt fix the postage issue not showing. Edited July 19, 2007 by aussieskin Quote Link to comment Share on other sites More sharing options...
Guest Posted July 19, 2007 Share Posted July 19, 2007 (edited) Yeah cool. I tried a UK address Bury St Edmunds, Suffolk postcode IP32 7DP and a Japanese one with postcode 546-0003 Hi Fiona The good news is that it does not work for me either, so it it not pecuilar to your shop. I will have to check into it it, but it may take all weekend. Edited July 19, 2007 by Coopco Quote Link to comment Share on other sites More sharing options...
Guest Posted July 19, 2007 Share Posted July 19, 2007 Haha well it is good news in a weird kind of way. Strange though, because it is right... hmm.. I think this is one for tomorrow night! Thanks! Quote Link to comment Share on other sites More sharing options...
Guest Posted July 21, 2007 Share Posted July 21, 2007 Haha well it is good news in a weird kind of way. Strange though, because it is right... hmm.. I think this is one for tomorrow night! Thanks! Hi Fiona I had to do this. Run the sql from v3.1 Either uninstall and reinstall each module (local and international) or change the shipping zone. Once that was done, they all came up as options when they should. Funny thing is, I don't remember running the new sql on my old test site or my old shop (but I must have and ten forgot about it). Quote Link to comment Share on other sites More sharing options...
Guest Posted July 21, 2007 Share Posted July 21, 2007 Hi Fiona I had to do this. Run the sql from v3.1 Either uninstall and reinstall each module (local and international) or change the shipping zone. Once that was done, they all came up as options when they should. Funny thing is, I don't remember running the new sql on my old test site or my old shop (but I must have and ten forgot about it). And I forgot to remind you to put the payment zones back in for those payment methods that use them. One more thing, give every shipping module a unique sort order. Quote Link to comment Share on other sites More sharing options...
Guest Posted July 21, 2007 Share Posted July 21, 2007 One more thing, give every shipping module a unique sort order. The drc is down. Quote Link to comment Share on other sites More sharing options...
Guest Posted July 21, 2007 Share Posted July 21, 2007 Okay about to try this now. Is the DRC down often? And when this happens does that mean no postage rates show up at all? Damn I'm starting to think this Aus post mod wasn't such a good idea! Quote Link to comment Share on other sites More sharing options...
Guest Posted July 21, 2007 Share Posted July 21, 2007 Bugger, and I get this error: Error SQL query: CREATE TABLE IF NOT EXISTS `geo_zones` ( `geo_zone_id` int( 11 ) NOT NULL AUTO_INCREMENT , `geo_zone_name` varchar( 32 ) NOT NULL , `geo_zone_description` varchar( 255 ) NOT NULL , `last_modified` datetime default NULL , `date_added` datetime NOT NULL , PRIMARY KEY ( `geo_zone_id` ) ) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =4; MySQL said: Documentation #1064 - You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ' at line 9 Which is what I got the first time I ran this sql file, which is why I ended up running the one from a previous verison... hmmm Quote Link to comment Share on other sites More sharing options...
Guest Posted July 21, 2007 Share Posted July 21, 2007 Okay about to try this now. Is the DRC down often? And when this happens does that mean no postage rates show up at all? Damn I'm starting to think this Aus post mod wasn't such a good idea! No, its not often down, but I use my zones table as a back up. Quote Link to comment Share on other sites More sharing options...
Guest Posted July 21, 2007 Share Posted July 21, 2007 Bugger, and I get this error: Error SQL query: CREATE TABLE IF NOT EXISTS `geo_zones` ( `geo_zone_id` int( 11 ) NOT NULL AUTO_INCREMENT , `geo_zone_name` varchar( 32 ) NOT NULL , `geo_zone_description` varchar( 255 ) NOT NULL , `last_modified` datetime default NULL , `date_added` datetime NOT NULL , PRIMARY KEY ( `geo_zone_id` ) ) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =4; MySQL said: Documentation #1064 - You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ' at line 9 Which is what I got the first time I ran this sql file, which is why I ended up running the one from a previous verison... hmmm Mine says, I don't know if the capital Y makes a difference. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; Quote Link to comment Share on other sites More sharing options...
Guest Posted July 21, 2007 Share Posted July 21, 2007 Ok I just opened up the sql file which came with 3.01 and the Y is a lowercase one in there... Is that where I was meant to look? Quote Link to comment Share on other sites More sharing options...
Guest Posted July 21, 2007 Share Posted July 21, 2007 Ok I just opened up the sql file which came with 3.01 and the Y is a lowercase one in there... Is that where I was meant to look? Yes, that is the one I used (sorry for not being clear). The drc was down for about 4 minutes from my reckonning. Quote Link to comment Share on other sites More sharing options...
Guest Posted July 21, 2007 Share Posted July 21, 2007 hmm.. so is that strange? My sql file has a 'y' but the error has a 'Y' Quote Link to comment Share on other sites More sharing options...
Guest Posted July 21, 2007 Share Posted July 21, 2007 hmm.. so is that strange? My sql file has a 'y' but the error has a 'Y' It may just be the way that the error is displayed. You try changing the line to ) TYPE=MyISAM; Quote Link to comment Share on other sites More sharing options...
Guest Posted July 21, 2007 Share Posted July 21, 2007 This is the first part of the sql file from 3.01 # # Table structure for table `geo_zones` # DROP TABLE IF EXISTS `geo_zones`; CREATE TABLE IF NOT EXISTS `geo_zones` ( `geo_zone_id` int(11) NOT NULL auto_increment, `geo_zone_name` varchar(32) NOT NULL, `geo_zone_description` varchar(255) NOT NULL, `last_modified` datetime default NULL, `date_added` datetime NOT NULL, PRIMARY KEY (`geo_zone_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4; # # Dumping data for table `geo_zones` # INSERT INTO geo_zones (geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_added) VALUES ('1', 'Australian Zones', 'All Local Zones', NULL, ''); INSERT INTO geo_zones (geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_added) VALUES ('2', 'World Zones', 'All International Zones', NULL, ''); # # Table structure for table `zones_to_geo_zones` # DROP TABLE IF EXISTS `zones_to_geo_zones`; CREATE TABLE IF NOT EXISTS `zones_to_geo_zones` ( `association_id` int(11) NOT NULL auto_increment, `zone_country_id` int(11) NOT NULL, `zone_id` int(11) default NULL, `geo_zone_id` int(11) default NULL, `last_modified` datetime default NULL, `date_added` datetime NOT NULL, PRIMARY KEY (`association_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2; # # Dumping data for table `zones_to_geo_zones` # I had to restore my saved database back because the site wasnt working after I got that error. (another annoying AUs post thing I have just discovered is that it adds 10% gst onto the handling fee aswell! ahhh! thats okay though, I just made the handling fee 10%ish less than I want it to be at the end.... (and its also not adding the 10% gst to the prices for international customers - but thats not an Aus Post mod problem I dont think) If so much time and effort and brain power hadn't gone into this already I would scrap it and just go on zones! But I wont Quote Link to comment Share on other sites More sharing options...
Guest Posted July 21, 2007 Share Posted July 21, 2007 This is the first part of the sql file from 3.01 # # Table structure for table `geo_zones` # DROP TABLE IF EXISTS `geo_zones`; CREATE TABLE IF NOT EXISTS `geo_zones` ( `geo_zone_id` int(11) NOT NULL auto_increment, `geo_zone_name` varchar(32) NOT NULL, `geo_zone_description` varchar(255) NOT NULL, `last_modified` datetime default NULL, `date_added` datetime NOT NULL, PRIMARY KEY (`geo_zone_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4; # # Dumping data for table `geo_zones` # INSERT INTO geo_zones (geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_added) VALUES ('1', 'Australian Zones', 'All Local Zones', NULL, ''); INSERT INTO geo_zones (geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_added) VALUES ('2', 'World Zones', 'All International Zones', NULL, ''); # # Table structure for table `zones_to_geo_zones` # DROP TABLE IF EXISTS `zones_to_geo_zones`; CREATE TABLE IF NOT EXISTS `zones_to_geo_zones` ( `association_id` int(11) NOT NULL auto_increment, `zone_country_id` int(11) NOT NULL, `zone_id` int(11) default NULL, `geo_zone_id` int(11) default NULL, `last_modified` datetime default NULL, `date_added` datetime NOT NULL, PRIMARY KEY (`association_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2; # # Dumping data for table `zones_to_geo_zones` # I had to restore my saved database back because the site wasnt working after I got that error. (another annoying AUs post thing I have just discovered is that it adds 10% gst onto the handling fee aswell! ahhh! thats okay though, I just made the handling fee 10%ish less than I want it to be at the end.... (and its also not adding the 10% gst to the prices for international customers - but thats not an Aus Post mod problem I dont think) If so much time and effort and brain power hadn't gone into this already I would scrap it and just go on zones! But I wont Yeah, I reduced my handling fee by 10% too. Add the Australian GST to the tax zone in the shipping modules (it works out right then). I don't know why your database was wrecked, but you could try changing to ) TYPE=MyISAM; where MyISAM appears in the script. Nothing to lose at this stage. Quote Link to comment Share on other sites More sharing options...
Guest Posted July 21, 2007 Share Posted July 21, 2007 Yeah tried that just then... Got this: Error SQL query: CREATE TABLE IF NOT EXISTS `geo_zones` ( `geo_zone_id` int( 11 ) NOT NULL AUTO_INCREMENT , `geo_zone_name` varchar( 32 ) NOT NULL , `geo_zone_description` varchar( 255 ) NOT NULL , `last_modified` datetime default NULL , `date_added` datetime NOT NULL , PRIMARY KEY ( `geo_zone_id` ) ) TYPE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =4; MySQL said: Documentation #1064 - You have an error in your SQL syntax near 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ' at line 9 Add the Australian GST to the tax zone in the shipping modules (it works out right then). Yeah I did that, but in my tax rate for Australian GST it only lets me choose 'australian zones' or 'world zones' So I created a new tax rate to go in under the 'australian gst' class, but then when I added a new product it totally screwed with the tax. In the backend the price was saying $16.37 in the nett field and $20 in the gross field and in the front end it was only showing $18.87. But it only does it on the new products I add, not the existing ones... I'll figure it out at some point - Perhaps this aus post problem might have something to do with that, and once I fix this is might fix the tax problem... Quote Link to comment Share on other sites More sharing options...
Guest Posted July 21, 2007 Share Posted July 21, 2007 Yeah tried that just then...Got this: Error SQL query: CREATE TABLE IF NOT EXISTS `geo_zones` ( `geo_zone_id` int( 11 ) NOT NULL AUTO_INCREMENT , `geo_zone_name` varchar( 32 ) NOT NULL , `geo_zone_description` varchar( 255 ) NOT NULL , `last_modified` datetime default NULL , `date_added` datetime NOT NULL , PRIMARY KEY ( `geo_zone_id` ) ) TYPE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =4; MySQL said: Documentation #1064 - You have an error in your SQL syntax near 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ' at line 9 Yeah I did that, but in my tax rate for Australian GST it only lets me choose 'australian zones' or 'world zones' So I created a new tax rate to go in under the 'australian gst' class, but then when I added a new product it totally screwed with the tax. In the backend the price was saying $16.37 in the nett field and $20 in the gross field and in the front end it was only showing $18.87. But it only does it on the new products I add, not the existing ones... I'll figure it out at some point - Perhaps this aus post problem might have something to do with that, and once I fix this is might fix the tax problem... You just need to use world zones for the shipping zone, and australian gst for the tax class. In the sql, use ) TYPE=MyISAM; on its own, nothing else on the line. 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.