AUSTPost module

[anaesthesiac]

Thanks a lot for the info, i am new to ZenCart and have only worked with the graphic side of design before, this is an amazing system but aside from HTML and a tiny bit of PHP it kinda gets over my head.

I appreciate you taking the time to respond, i'll install the new module and hopefully the system will be functioning again.

cheers

[anaesthesiac]

I've installed the OZPOST module, but in my ADMIN section i can't add or change products. By installing the outdated AUSPOST addon i think i've damaged something, i get this error message any time i try to add or change a product:

1146 Table 'sitesynt_sukastore.geo_zones' doesn't exist<br />in:<br />[select SUM(tax_rate) as tax_rate
from (tax_rates tr
left join zones_to_geo_zones za
ON tr.tax_zone_id = za.geo_zone_id
left join geo_zones tz ON tz.geo_zone_id = tr.tax_zone_id )
WHERE (za.zone_country_id IS NULL
OR za.zone_country_id = 0
OR za.zone_country_id = '13')
AND (za.zone_id IS NULL OR za.zone_id = 0
OR za.zone_id = '185')
AND tr.tax_class_id = '1'
GROUP BY tr.tax_priority]

If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

My question now is, can i fix this? or do i need to re-install ZenCart? It has affected the products in the ADMIN section and on the WEBSITE itself.

Any advice would be appreciated.

Cheers
Shayne

[RodG]

By installing the outdated AUSPOST addon i think i've damaged something, i get this error message any time i try to add or change a product:
<snip>
1146 Table 'sitesynt_sukastore.geo_zones' doesn't exist<br />in:<br
My question now is, can i fix this? or do i need to re-install ZenCart? It has affected the products in the ADMIN section and on the WEBSITE itself.

Any advice would be appreciated.

Cheers
Shayne

You shouldn't need to re-install zen-cart, but you certainly do need to uninstall the original AusPost module, along with any other changes or patches that you applied (or attempted to apply) when installing it.

Cheers
Rod

[oavs]

RodG please helllpp.

I have uninstalled AustPost and installed OzPost.

I have products weighing and measuring differently so I enter the L/H/W in cm and W in kgs in all product descriptions as below. Is there any adjustments I need to make it work?

For example what settings should I be entering in the CONFIG>Shipping/Packing?

Your help would be much appreciated as always. I hope you get this.

Many thanks

Product Item 1.
Dimensions folded
Height 200 mm ( 8 in.) 20.cm
Length 1000 mm ( 39.5 in.)100cm
Width 310 mm ( 12 in.) 31.cm
Weight: 7.7kgs
Freight should be around from (as reported by my client)

SYD - BRS = $29 (Item 1)
SYD - SYD = $24 (Item 1)
SYD - PERTH = 65(Item 1)
SYD - HOBART = 65 (Item 1)
SYD - MELB =29 (Item 1)
SYD - DARWIN 106 (Item 1)
----------------------------------------------

Freight should be around from (as reported by my client)

Product Item 2.
Dimensions folded
Height 370 mm ( 8 in.) 37cm
Length 1400 mm ( 39.5 in.)140cm
Width 375 mm ( 12 in.) 37.5cm
Weight: 13.6kgs
Freight should be around from

SYD - BRS = $38 (Item 2)
SYD - SYD = $31 (Item 2)
SYD - PERTH = 91(Item 2)
SYD - HOBART = 103 (Item 2)
SYD - MELB =38 (Item 2)
SYD - DARWIN 155 (Item 2)

[oavs]

Also consider same customer sells jewelery, rings and DVD's etc

All ozpost settings are left at their default settings.

[oavs]

To add to my problem, I also have products that Australia Post can't handle. Such as trampolines. 4 different sizes and weights!


One of smallest Trampoline 8ft :
Packaging Dimensions (cm) (kg) *
Length = 133
Width = 42
Height = 24
Weight = 45


Trampoline 10ft
Packaging Dimensions (cm) (kg) *
Length = 126
Width = 44
Height = 30
Weight = 50

Trampoline 12ft
Packaging Dimensions (cm) (kg) *
Length = 148
Width = 44
Height = 32
Weight = 61

etc.

How can I have them co exists. How can I have the Item 1 and 2 working with Australia post and have the trampolines work at different rates?

[ferreirabraga]

I have a funny issue.
I'm using zencart 1.3.8 and the last austpost version.
I'm not using Weight: 0, Height:0 ,Length :0, Width: 0 in the product.
When I unchecked the options 500gm Satchels 3kg Satchels 500gm Express Satchels 3kg Express Satchels .

I got the 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.

and also if I change my Parcel Weight format from gms to Kgs.

Shipping Methods:
Letters (Aust), Letters (O/seas), Regular Parcel, Insured Parcel (Aust), Registered (Aust), Registered (O/seas), Express (Aust), Express (O/seas), Cash on Delivery, AIR, Insured AIR, SEA, Insured SEA, ECI Documents, ECI Merchandise
Handling Fee - regular parcel 10.00
Handling Fee - Registered post 7.00
Handling Fee - Express post 10.00
Handling Fee - Overseas post 8.00
Handling Fee - Letters 2.00
Handling Fee - Prepaid Satchels 4.00
Handling Fee - Prepaid Express Satchels 5.00
Handling Fee - ECI Documents 10.00
Handling Fee - ECI Merchandise 10.00
Handling Fee - COD 12.00
Handling Fee - Insured parcels 2.00
Hide Handling Fees No
Default Parcel Dimensions 15,15,14
Parcel Weight format gms
Hide parcel rates if letter sized Yes
Use cURL No
Postage Delay (days). 0
Sort order of display. 1
Tax Class Taxable Goods

Any advice wil be appreciate.

[RodG]

I have a funny issue.
I'm using zencart 1.3.8 and the last austpost version.
I'm not using Weight: 0, Height:0 ,Length :0, Width: 0 in the product.
When I unchecked the options 500gm Satchels 3kg Satchels 500gm Express Satchels 3kg Express Satchels .

I got the 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.

and also if I change my Parcel Weight format from gms to Kgs.

Shipping Methods:
Letters (Aust), Letters (O/seas), Regular Parcel, Insured Parcel (Aust), Registered (Aust), Registered (O/seas), Express (Aust), Express (O/seas), Cash on Delivery, AIR, Insured AIR, SEA, Insured SEA, ECI Documents, ECI Merchandise
Handling Fee - regular parcel 10.00
Handling Fee - Registered post 7.00
Handling Fee - Express post 10.00
Handling Fee - Overseas post 8.00
Handling Fee - Letters 2.00
Handling Fee - Prepaid Satchels 4.00
Handling Fee - Prepaid Express Satchels 5.00
Handling Fee - ECI Documents 10.00
Handling Fee - ECI Merchandise 10.00
Handling Fee - COD 12.00
Handling Fee - Insured parcels 2.00
Hide Handling Fees No
Default Parcel Dimensions 15,15,14
Parcel Weight format gms
Hide parcel rates if letter sized Yes
Use cURL No
Postage Delay (days). 0
Sort order of display. 1
Tax Class Taxable Goods

Any advice wil be appreciate.

upgrade to 'ozpost'

Ensure your ISP offers php5 support (most do)

[RodG]

RodG please helllpp.

I have uninstalled AustPost and installed OzPost.

I have products weighing and measuring differently so I enter the L/H/W in cm and W in kgs in all product descriptions as below. Is there any adjustments I need to make it work?

No, not really. Exactly what is the problem? No quote? incorrect quote? Other?

Does your ISP have php5 installed? (this is required)

For example what settings should I be entering in the CONFIG>Shipping/Packing?

Enter anything you like, 'ozpost' ignores those settings. http://www.zen-cart.com/forum/images...s/big_grin.gif

[rick99]

Hi,

I installed OZPOST a month or so ago and all was working fine. I have found out today that I am getting the connection error in the title. After searching through previous post, I have checked my weights and measurements, nothing has changed since it was working. I turned the module off and then on again but the problem persist.

What is slightly different from the post I read earlier, is when I have 1 item in the cart, the estimator gives the option of 500gm satchel and express 500gm but zero postage charge. If there is more than 1 item the error is displayed.

The estimator is displaying the correct measurements and weights on the screen so I am assuming I have a connection problem, but as I have not changed anything could anyone please direct me in how I can ascertain if connectivity is my problem.

Thanks.