Printable View
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 :smile:
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
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.Quote:
Originally Posted by anaesthesiac
Cheers
Rod
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)
Also consider same customer sells jewelery, rings and DVD's etc
All ozpost settings are left at their default settings.
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?
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.
Quote:
Originally Posted by ferreirabraga
upgrade to 'ozpost'
Ensure your ISP offers php5 support (most do)
No, not really. Exactly what is the problem? No quote? incorrect quote? Other?Quote:
Originally Posted by oavs
Does your ISP have php5 installed? (this is required)
Enter anything you like, 'ozpost' ignores those settings. http://www.zen-cart.com/forum/images...s/big_grin.gifQuote:
Originally Posted by oavs
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.