ozpost shipping module

[hrinfo]

Hi Rod,

I hope you got airconditioning :-). I am testing the ozpost for a new client using the e-go.com.au shipping option. Unfortunately everything is out of line with the quotes that e-go.com.au provides on their web site. Let me explain:

1. OZPOST V3.4.1
2. When adding items ozpost shows on our example the total cost of shipping as $74 to Perth (includes $5 P&H) (can send you all details if want)
3. On e-go site shows as follows:
a. add items individually total cost :$103
b. Add items as one big carton cost: $132
4. Also to confuse things further someone already ordered the same products that we tested and they were quoted and paid for shipping on checkout only $48 . I thought that this may have been a problem of connecting to server but then I realised that the module is setup to charge $25 per kg and the item was a total of 17 kilos that could not have been either.

Any ideas why such big differences on the prices to start with and what happen with the $48? If you need access or further please let me know.

As always thanks for the grat work :-)

Regards

Tassos

[RodG]

2. When adding items ozpost shows on our example the total cost of shipping as $74 to Perth (includes $5 P&H) (can send you all details if want)
3. On e-go site shows as follows:
a. add items individually total cost :$103
b. Add items as one big carton cost: $132

Please provide a link to the example items. Left to chance I'll never pick the right one(s).

Also, when adding items on the e-go site, are you adding to the item dimensions as well as the weight?

What dimensions/weight are you entering on the e-go site, and do these match the weight/dimensions that you've entered into the shopping cart?

4. Also to confuse things further someone already ordered the same products that we tested and they were quoted and paid for shipping on checkout only $48

Also e-go? Was this *exactly* $48, or are you rounding? (quite often, in order to figure out what is going on I need to use *exact* figures. otherwise the best I can do is say 'it might be thism or it might be that').

. I thought that this may have been a problem of connecting to server

Don't forget, we run 3 different servers on 3 different networks, so if you ever have a problem connecting to all of them, you probably have something a lot more seriously amiss than just the ozpost shipping module.

Any ideas why such big differences on the prices to start with and what happen with the $48?

At the moment the only idea I have is that your weights and/or dimensions are not what you think they are.. IOW, the data you are entering into the e-go webpage isn't the same as what is being sent to the ozpost server(s) for the same product(s). This is why I need a link to the product(s) as well as the information you are entering @e-go.

Cheers
Rod

[hrinfo]

Hi Rod,

The links to the products are:
1. http://www.gasshop.com.au/index.php?...d=8412&x=0&y=0
Web site product info:
Weight: 1.5 kg Dimensions: 12cm H x 45cm L x 45cm W

Dimensions given on e-go:
Weight: 2 kg Dimensions: 12cm H x 45cm D x 45cm W (e-go has no length and it calls it Depth)

2. http://www.gasshop.com.au/index.php?...=8493&x=12&y=3
Web site product info:
Weight: 15.5 kg Dimensions: 79cm H x 61cm L x 19cm W
Dimensions given on e-go:
Weight: 15 kg Dimensions: 79cm H x 61cm D x 45cm W (e-go has no length and it calls it Depth)

On e-go I am using "carton" as Goods Type and Express freight Australia wide from PENRITH, 2750 to SOUTH GUILDFORD, 6055 . This is the same information as per customer on the order.

The exact amount on the order was $48.51

I hope didn't I miss something :-)

Thank you

Tassos

[RodG]

The links to the products are:
1. http://www.gasshop.com.au/index.php?...d=8412&x=0&y=0
Web site product info:
Weight: 1.5 kg Dimensions: 12cm H x 45cm L x 45cm W

The server is receiving 1.65kg 122mm x 452mm x 452mm. After rounding up (to protect the merchant) the quote requested is for a parcel 2kg 13cm x 46cm x 46cm.
The quote returned from both ozpost and e-go is $21.18

Dimensions given on e-go:
Weight: 2 kg Dimensions: 12cm H x 45cm D x 45cm W (e-go has no length and it calls it Depth)

Produces a quote of $19.58 (A little less than the ozpost quote due to the dimensions being rounded up)

2. http://www.gasshop.com.au/index.php?...=8493&x=12&y=3
Web site product info:
Weight: 15.5 kg Dimensions: 79cm H x 61cm L x 19cm W
Dimensions given on e-go:
Weight: 15 kg Dimensions: 79cm H x 61cm D x 45cm W (e-go has no length and it calls it Depth)

The server is recieving
weight=17.050kg
height=193mm
width=612mm
length=792mm

After rounding up the quote requested is for a parcel 18kg 80cm x 62cm x 20cm.
The quote returned from both ozpost and e-go is $59.46

Spot the difference!

The exact amount on the order was $48.51

I'll be needing the product and delivery info for whatever it was that produced this.

I hope didn't I miss something :-)

The TARE weights and dimensions are causing ozpost to quote a little higher than if you entered the 'raw' data into e-go, and the rounding up of dimensions may also cause ozpost to quote a little higher. The only thing I see that would cause underquoting is the apparent discrepancy in the dimensions of the Weber Kettle.

Other than this, things appear to be working correctly.

Cheers
Rod

[hrinfo]

Hi Rod,

My sincere apologies for all that. After your reply I remembered the debug function of the OZpost module . I turned it on and realised how it calculates multiply items( which is similar to what you said ). After using the info from the debug the amount was exact the same :-)

I am still not sure what happen with the $48 but now I am worried if the client did something stupid and then realised, fixed it and never told me. In anycase it was worth the excersise as now I got an even better understanding of how ozpost with e-go works :-)

Anyway my apologies again and as always you have been a great help :-)

Regards

Tassos

[rstevenson]

Hi Rod,

An odd one for you. I created a new site for our favourite horsey shop, for some new products. It was a clean install of 1.3.9h, without any of the old data for products or customers. In other words, a fresh start. Nevertheless, the product input fields contain the "products_height, products_length, products_width" fields, which I think come only from OzPost. The OzPost files were uploaded as usual (v2.0.5) because I thought J wanted it, but when its Install button was clicked I got a warning about cURL not working. I left it at that as the site was in limbo at the time. Now J is entering, or trying to enter, new products and is getting the following warning...

1054 Unknown column 'products_height' in 'field list'
in:
[insert into products (products_quantity, products_type, products_model,
products_price, products_date_available, products_weight, products_height,
products_length, products_width, products_status, products_virtual,
products_tax_class_id, manufacturers_id, products_quantity_order_min,
products_quantity_order_units, products_priced_by_attribute,
product_is_free, product_is_call, products_quantity_mixed,
product_is_always_free_shipping, products_qty_box_status,
products_quantity_order_max, products_sort_order, products_discount_type,
products_discount_type_from, products_price_sorter, products_image,
products_date_added, master_categories_id) values ('10', '1', '125685',
'80', null, '0', '0', '0', '0', '1', '0', '0', '0', '1', '1', '0', '0', '0',
'1', '0', '1', '0', '0', '0', '0', '0', '', now(), '4')]
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.

I tried carefully removing all the files, either completely or in some cases replacing them with the stock ZC files, to no avail.

I'm guessing the DB was modified during the incomplete OzPost install. But I can't hit the Remove button because it's not fully installed. J has decided not to use OzPost this time, preferring free shipping. So how do I get rid of the three dimension fields and the incorrect SQL command during creation of new products?

Rob

[RodG]

I tried carefully removing all the files, either completely or in some cases replacing them with the stock ZC files, to no avail.

You must've missed:

/admin/includes/languages/english/product.php
/admin/includes/modules/update_product.php
/admin/includes/modules/product/collect_info.php

Restore from ZenCart originals

Cheers
Rod

[rstevenson]

Yeah, I thought that too Rod. Since the fields still appeared I must have missed those files (even though I had just dealt with them.) So I did it again, and the fields still showed. So I came here and asked. Then, about 12 hours later, J emailed to say, "Whatever you did it is all fixed now."

Musta been some cache hanging around.

Rob

[RodG]

Musta been some cache hanging around.

Yeah, that'd be my guess too.

Cheers
Rod

[louisapple]

hi all, i installed the australian post modular recently but when i enable only regular post, it works properly. but when enable express post then even select regular post the system only charge postage as express post. Anyone using this module have this problem?