Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Aus Post returning incorrect postage rates


Guest

Recommended Posts

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!)

Link to comment
Share on other sites

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!)

OK, that is correct. Now, the international options will only show when you have a shipping address that is international.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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']);

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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 by aussieskin
Link to comment
Share on other sites

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 by Coopco
Link to comment
Share on other sites

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!

Link to comment
Share on other sites

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).

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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 ;

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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;

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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...

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...