Paula Moss Posted July 4, 2006 Posted July 4, 2006 My postage is not calculating correctly and I think I know the problem. I am having problems with the auspost sql part. I know how and where to run this. (In my PhpAdmin>SQL section.) But, I do not know exactly what I am to edit this part to. In the SQL file it has all of this info: # # Table structure for table `geo_zones` # DROP TABLE IF EXISTS geo_zones; CREATE TABLE geo_zones ( geo_zone_id int(11) NOT NULL auto_increment, geo_zone_name varchar(32) NOT NULL default '', geo_zone_description varchar(255) NOT NULL default '', last_modified datetime default NULL, date_added datetime NOT NULL default '', PRIMARY KEY (geo_zone_id) ) TYPE=MyISAM; # # 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 zones_to_geo_zones ( association_id int(11) NOT NULL auto_increment, zone_country_id int(11) NOT NULL default '0', zone_id int(11) default NULL, geo_zone_id int(11) default NULL, last_modified datetime default NULL, date_added datetime NOT NULL default '', PRIMARY KEY (association_id) ) TYPE=MyISAM; # # Dumping data for table `zones_to_geo_zones` # INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES ('', 1, NULL, 2, 'NULL', ''); AND SO ON.... In the sample file it has this info: # # Dumping data for table `geo_zones` # INSERT INTO geo_zones VALUES (3, 'Auspost AIR', 'Australia Post Air Destinations', NULL, ''); INSERT INTO geo_zones VALUES (4, 'Auspost ECONOMY', 'Australia Post Economy Destinations', NULL, ''); INSERT INTO geo_zones VALUES (5, 'Auspost SEA', 'Australia Post Sea Destinations', NULL, ''); # # Dumping data for table `zones_to_geo_zones` # INSERT INTO zones_to_geo_zones VALUES ('', 38, 0, 3, NULL, ''); INSERT INTO zones_to_geo_zones VALUES ('', 153, 0, 3, NULL, ''); INSERT INTO zones_to_geo_zones VALUES ('', 223, 0, 3, NULL, ''); INSERT INTO zones_to_geo_zones VALUES ('', 153, 0, 4, NULL, ''); INSERT INTO zones_to_geo_zones VALUES ('', 222, 0, 4, NULL, ''); INSERT INTO zones_to_geo_zones VALUES ('', 223, 0, 4, NULL, ''); INSERT INTO zones_to_geo_zones VALUES ('', 81, 0, 5, NULL, ''); INSERT INTO zones_to_geo_zones VALUES ('', 222, 0, 5, NULL, ''); The options I have are Air, Economy, Sea, Parcel Post and Express Post. So, what exactly am I too edit and what text should I put where?? Quote
Guest Posted July 4, 2006 Posted July 4, 2006 My postage is not calculating correctly and I think I know the problem. I am having problems with the auspost sql part. I know how and where to run this. (In my PhpAdmin>SQL section.) But, I do not know exactly what I am to edit this part to. In the SQL file it has all of this info: # # Table structure for table `geo_zones` # DROP TABLE IF EXISTS geo_zones; CREATE TABLE geo_zones ( geo_zone_id int(11) NOT NULL auto_increment, geo_zone_name varchar(32) NOT NULL default '', geo_zone_description varchar(255) NOT NULL default '', last_modified datetime default NULL, date_added datetime NOT NULL default '', PRIMARY KEY (geo_zone_id) ) TYPE=MyISAM; # # 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 zones_to_geo_zones ( association_id int(11) NOT NULL auto_increment, zone_country_id int(11) NOT NULL default '0', zone_id int(11) default NULL, geo_zone_id int(11) default NULL, last_modified datetime default NULL, date_added datetime NOT NULL default '', PRIMARY KEY (association_id) ) TYPE=MyISAM; # # Dumping data for table `zones_to_geo_zones` # INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES ('', 1, NULL, 2, 'NULL', ''); AND SO ON.... In the sample file it has this info: # # Dumping data for table `geo_zones` # INSERT INTO geo_zones VALUES (3, 'Auspost AIR', 'Australia Post Air Destinations', NULL, ''); INSERT INTO geo_zones VALUES (4, 'Auspost ECONOMY', 'Australia Post Economy Destinations', NULL, ''); INSERT INTO geo_zones VALUES (5, 'Auspost SEA', 'Australia Post Sea Destinations', NULL, ''); # # Dumping data for table `zones_to_geo_zones` # INSERT INTO zones_to_geo_zones VALUES ('', 38, 0, 3, NULL, ''); INSERT INTO zones_to_geo_zones VALUES ('', 153, 0, 3, NULL, ''); INSERT INTO zones_to_geo_zones VALUES ('', 223, 0, 3, NULL, ''); INSERT INTO zones_to_geo_zones VALUES ('', 153, 0, 4, NULL, ''); INSERT INTO zones_to_geo_zones VALUES ('', 222, 0, 4, NULL, ''); INSERT INTO zones_to_geo_zones VALUES ('', 223, 0, 4, NULL, ''); INSERT INTO zones_to_geo_zones VALUES ('', 81, 0, 5, NULL, ''); INSERT INTO zones_to_geo_zones VALUES ('', 222, 0, 5, NULL, ''); The options I have are Air, Economy, Sea, Parcel Post and Express Post. So, what exactly am I too edit and what text should I put where?? do not run the sample file, use the other. Quote
Paula Moss Posted July 4, 2006 Author Posted July 4, 2006 do not run the sample file, use the other. So, I run exactly this? 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, ''); and then this? INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES ('', 1, NULL, 2, 'NULL', ''); (of course I know that the zones_to_geo_zones has much more than that one line.) Or do I run them both at the same time? So, it looks like this: 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, ''); INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES ('', 1, NULL, 2, 'NULL', ''); Quote
Guest Posted July 4, 2006 Posted July 4, 2006 So, I run exactly this? 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, ''); and then this? INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES ('', 1, NULL, 2, 'NULL', ''); (of course I know that the zones_to_geo_zones has much more than that one line.) Or do I run them both at the same time? So, it looks like this: 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, ''); INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES ('', 1, NULL, 2, 'NULL', ''); Either. I usually just browse to the file on my pc and run the lot. Quote
Paula Moss Posted July 4, 2006 Author Posted July 4, 2006 Either. I usually just browse to the file on my pc and run the lot. Thank you very much. I have done that, but the postage costs is still not calculating correctly. I don't know what else to do. Getting very frustrated here! :'( What else should I be looking at to get the correct postage to show up? Quote
Paula Moss Posted July 4, 2006 Author Posted July 4, 2006 I had a look and it is calculating the GST for the postage and for the sales all at one time at the end in the order confirmation. YAY!! Really glad that it is working, but.... Is there a way for it to show the GST in the shipping method? So, that it shows $6.80 for the express post parcel instead of the $6.18 pre-GST price? Quote
Guest Posted July 4, 2006 Posted July 4, 2006 I had a look and it is calculating the GST for the postage and for the sales all at one time at the end in the order confirmation. YAY!! Really glad that it is working, but.... Is there a way for it to show the GST in the shipping method? So, that it shows $6.80 for the express post parcel instead of the $6.18 pre-GST price? In the modules, I have tax class set to none, so that it shows full price. Quote
Paula Moss Posted July 4, 2006 Author Posted July 4, 2006 In the modules, I have tax class set to none, so that it shows full price. Ok, did that and now the GST shows up in the order confirmation for the subtotals. Which is great, but the shipping price is still showing as $6.18 and now no tax is calculated for the shipping. So, now instead of getting $6.80 I will be getting only $6.18 for the shipping. Quote
Guest Posted July 4, 2006 Posted July 4, 2006 Ok, did that and now the GST shows up in the order confirmation for the subtotals. Which is great, but the shipping price is still showing as $6.18 and now no tax is calculated for the shipping. So, now instead of getting $6.80 I will be getting only $6.18 for the shipping. It should be showing full shipping cost. Try changing order total modules in admin thus Shipping 3 Sub-Total 2 Tax 1 Total 5 Can't remember where else Quote
Paula Moss Posted July 4, 2006 Author Posted July 4, 2006 It should be showing full shipping cost. Try changing order total modules in admin thus Shipping 3 Sub-Total 2 Tax 1 Total 5 Can't remember where else Thank you very much for your help! I tried what you suggested but that didn't work either. No worries! I am happy enough with leaving the total modules at 2,1,3,4. It adds the GST for the shipping and for the sales all together. But that's ok. I'm just over the moon that it IS working! :thumbsup: Quote
Paula Moss Posted July 4, 2006 Author Posted July 4, 2006 Ok, the international postage prices are coming up a tad bit short. It looks like the amount that would be the GST, or 10% of the postage price is not being added. For example, airmail postage on my page says it costs $12.27 when on the Auspost site it says it should cost $13.50. A difference of $1.23, exactly 10% or the amount for GST. I do have the tax class set to none for air, express air and sea mail. I even tried to turn it on but still no luck. I managed to finally get my domestic postage working, now I have this little problem. Quote
New 
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.
Note: Your post will require moderator approval before it will be visible.