Jump to content
Latest News: (loading..)
Sign in to follow this  
aussieskin

Aus Post returning incorrect postage rates

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


Worse things happen at sea

Share this post


Link to post
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.


The Coopco Underwear Shop

 

If you live to be 100 years of age, that means you have lived for 36,525 days. Don't waste another, there aren't many left.

Share this post


Link to post
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.


Worse things happen at sea

Share this post


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


The Coopco Underwear Shop

 

If you live to be 100 years of age, that means you have lived for 36,525 days. Don't waste another, there aren't many left.

Share this post


Link to post
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?


Worse things happen at sea

Share this post


Link to post
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?


The Coopco Underwear Shop

 

If you live to be 100 years of age, that means you have lived for 36,525 days. Don't waste another, there aren't many left.

Share this post


Link to post
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


Worse things happen at sea

Share this post


Link to post
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

Worse things happen at sea

Share this post


Link to post
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

The Coopco Underwear Shop

 

If you live to be 100 years of age, that means you have lived for 36,525 days. Don't waste another, there aren't many left.

Share this post


Link to post
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!


Worse things happen at sea

Share this post


Link to post
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).


The Coopco Underwear Shop

 

If you live to be 100 years of age, that means you have lived for 36,525 days. Don't waste another, there aren't many left.

Share this post


Link to post
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.


The Coopco Underwear Shop

 

If you live to be 100 years of age, that means you have lived for 36,525 days. Don't waste another, there aren't many left.

Share this post


Link to post
Share on other sites
One more thing, give every shipping module a unique sort order.

The drc is down.


The Coopco Underwear Shop

 

If you live to be 100 years of age, that means you have lived for 36,525 days. Don't waste another, there aren't many left.

Share this post


Link to post
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!


Worse things happen at sea

Share this post


Link to post
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


Worse things happen at sea

Share this post


Link to post
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.


The Coopco Underwear Shop

 

If you live to be 100 years of age, that means you have lived for 36,525 days. Don't waste another, there aren't many left.

Share this post


Link to post
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 ;


The Coopco Underwear Shop

 

If you live to be 100 years of age, that means you have lived for 36,525 days. Don't waste another, there aren't many left.

Share this post


Link to post
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?


Worse things happen at sea

Share this post


Link to post
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.


The Coopco Underwear Shop

 

If you live to be 100 years of age, that means you have lived for 36,525 days. Don't waste another, there aren't many left.

Share this post


Link to post
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;


The Coopco Underwear Shop

 

If you live to be 100 years of age, that means you have lived for 36,525 days. Don't waste another, there aren't many left.

Share this post


Link to post
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


Worse things happen at sea

Share this post


Link to post
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.


The Coopco Underwear Shop

 

If you live to be 100 years of age, that means you have lived for 36,525 days. Don't waste another, there aren't many left.

Share this post


Link to post
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...


Worse things happen at sea

Share this post


Link to post
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.


The Coopco Underwear Shop

 

If you live to be 100 years of age, that means you have lived for 36,525 days. Don't waste another, there aren't many left.

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×