AUSTPost module

[ionebusiness]

Hi Rod

I think I may have found a bug but just wondered if you were aware of it.

With versions of MySQL lower than 5.0.3, as you know you are limited to varchars with a max length of 255. On a couple of stores I've developed this has caused problems with the 'orders_total' table in the 'title' column whereby the html was being truncated and not terminating properly. This makes the invoices display incorrectly on certain browsers.

I'm just upgrading the databases to 5.0.3 as we speak and am going to run an alter table on that column to increase its size. Hopefully, that should sort the problem.

Thought you should know if you didn't already.

Cheers

[RodG]

Hi Rod

I think I may have found a bug but just wondered if you were aware of it.

With versions of MySQL lower than 5.0.3, as you know you are limited to varchars with a max length of 255. On a couple of stores I've developed this has caused problems with the 'orders_total' table in the 'title' column whereby the html was being truncated and not terminating properly. This makes the invoices display incorrectly on certain browsers.

I'm just upgrading the databases to 5.0.3 as we speak and am going to run an alter table on that column to increase its size. Hopefully, that should sort the problem.

Thought you should know if you didn't already.

Cheers

Oooeerr, thanks for letting me know about this one. No, I wasn't aware of it.

Thanks.

Rod

[cadforte]

I modified the Austpost Improved Module so that when using free shipping it gives regular post parcel rate for free, and subtracts that rate (including handling fees & properly displaying the modified ones) from the other option (i.e. Express or 3kg Satchel.) When not using free shipping it works normally.

This took a LOT of work. I will share this if requested. I did a quick once through with the letters but since I don't ship any I didn't thoroughly check it. I will if I get a good enough request.

[ionebusiness]

Oooeerr, thanks for letting me know about this one. No, I wasn't aware of it.

Thanks.

Rod

Hi Rod

I'm looking for the module I need to modify in order to change the actual concatenation of the html that gets inserted into the orders_total.title column. Can you point me in the right direction? I've got clients who can't upgrade to MySQL 5 so I'm intending to take off the first Australia Post logo from the html and just leave them with the shipping option instead to see if that does the trick for them.

Cheers
Andy

[RodG]

Hi Rod

I'm looking for the module I need to modify in order to change the actual concatenation of the html that gets inserted into the orders_total.title column. Can you point me in the right direction?

The easiest/safest/best way to do this is to edit:

/includes/languages/english/modules/shipping/austpost.php

Once you open the file into an editor it will be quite obvious what you need to change. :-)

Cheers
Rod.

[cadforte]

Has anyone figured out how to make the order total cost text line up with the images (or make the text that is part of the shipping method center vertically with the images instead of the bottom)? The best I could do was to center the cost text but the title text was still aligned with the bottom of the images, making it look sloppy.

This seems very complex to me to be done properly. I doubt I will get a response unless it has been done before, easily enough. Thanks regardless.

[cadforte]

Hi Rod

I'm looking for the module I need to modify in order to change the actual concatenation of the html that gets inserted into the orders_total.title column. Can you point me in the right direction? I've got clients who can't upgrade to MySQL 5 so I'm intending to take off the first Australia Post logo from the html and just leave them with the shipping option instead to see if that does the trick for them.

Cheers
Andy

It's in the shipping module, in include/modules/shipping/austpost.php. Good luck, it is unlikely you will be able to fix it from there, unless you remove the images altogether and have a decent understanding of PHP; it is a very complex module. I just posted a simple question in the same ballpark. (The order total generator file is tpl_module_order_totals.php.) You can remove the entire shipping title and replace it with a generic one perhaps.

Well, just removing that one header image, on second reading, that is much more possible - still a decent basic of PHP would be necessary.

Good luck.

[lucky__starre]

I'm on version 1.3.7 & am on the almost newest version of the Auspost module, it has been working pretty good up till now, however I received an order today that threw me, the person ordered a number of small items that calculate as a large letter (up to 125g) & then the last item was larger & would normally be classified as a parcel item, however it has calculated the order as a large letter (up to 250g).

The smaller items all have their dimensions & weights entered in the product info fields, however I only have the weight entered for the larger item.

I tested it myself & if I put the large item in the cart first it calculates postage correctly, but as the last item it doesn't, does anyone know why this would happen?

Hey Rod, just wondering if you've had the chance to check this out for me as yet?

Katie
www.live2knit.com.au

[RodG]

Hey Rod, just wondering if you've had the chance to check this out for me as yet?

Katie
www.live2knit.com.au

Yes, I have actually. It doesn't look like it going to be all that difficult to fix and I was hoping to email you a patched version of the code for testing last weekend. However, hardware issues got the better of me.

Hopefully this coming weekend will be more productive.

Cheers
Rod

[Webmyster]

Hi RodG!

I've just installed the script following your instructions as per install.txt and I am getting this following error during Estimation of postage cost window thing: ERROR:Unable to obtain a valid quote from the Australia Post Server.
You may still checkout using this method and we will contact you with postage costs as soon as possible.

Also does this scrip allow the buyer to select which postage method they'd like for example can the buyer select Express Post (for extra $$) instead of standard post?

And finally can this script be configured so that there is only a one time cost of 5.50 (parcel) and anything the customer adds after that is simply an extra dollar or two instead of adding 5.50 regardless of the item because I can quite easily fit heaps in my normal 5.50 parcel.

What I am talking about can be seen on this website i stumbled across: whitersmile.com.au/products-prices.html

Add a product and see how it only charges you a one time fee of 7.70 for express and you can add a few smaller items without incuring another 7.70$ charge.

Thanks mate