ozpost shipping module

RodG:

Nothing amiss there.

Perhaps.

Oh, just to confirm, you did tun the script from your store and not your localhost, didn't you?
The reason I ask is because the script results are contradicting the error messages you reported.

Cheers
Rod

Hi Rod,

Problem fixed itself overnight. Don't know why.

Cheers,

Peter

Peter Homann:

Hi Rod,

Problem fixed itself overnight. Don't know why.

Me neither. Nothing changed this end.

Cheers
Rod

RodG:

It is working for me.

Test product: http://www.solarcampingaustralia.com.au/index.php?main_page=product_info&products_id=144
Destination: Sydney 2000
FW satchel $11.20
FW labels $12.20

If still having a problem please provide a link to the product you are using for testing, as well as the destination postcode/suburb being used and I'll look into it further.

Cheers
Rod

http://www.solarcampingaustralia.com.au/index.php?main_page=product_info&products_id=222
to 5045
I had to leave it on sunshine cost so not to loose orders
i tested it again today and if i put to to wide bay fastway not working, but still ok on sunshine cost. i will pm login so you can change to wide bay for testing
sunshine cost is close to wide bay so there should be no big problem for now

vandiermen:

i will pm login so you can change to wide bay for testing

Please don't take this personally, it is a general comment/request to anyone seeking help, especially from me. Please, please, please never ever send me login details for any site unless I specifically ask for them (which will be a very rare occurrence and usually equates to a chargeable job).

The reason is simple. Security!

Yes, I know many people feel they can trust me with this data, and it is true, you can.
What can't be trusted is the possibility of this same information from being leaked, sniffed or otherwise compromised after it has been sent.
OK, the risks are small, but they do exist. They won't exist at all if it wasn't sent needlessly.

The other reason I don't like having other peoples login details is because if I never have them I can never be accused of leaking them in the off chance the site gets hacked via a weak password.

Simply put, whilst I appreciate the faith involved in providing the details in the first place, I don't want the extra responsibilities that comes with it.

End of rant.... Now where were we?

vandiermen:

i tested it again today and if i put to to wide bay fastway not working, but still ok on sunshine cost.

Problem solved (and I haven't even looked at your pm yet). <smiles>

Who would have thought that the FastWay code for "Wide Bay" would be "BDB"? It seems that I've managed to code it as "WDB".

I've taken care of this one serverside by testing for 'WDB' and converting it to the 'BDB' expected by the FastWay servers.

Cheers
Rod

RodG:

I've taken care of this one serverside by testing for 'WDB' and converting it to the 'BDB' expected by the FastWay servers.

I just wanted to say thanks. :-)
it's working

Out of curiosity, will you be adding DHL?

wakeleymb:

Out of curiosity, will you be adding DHL?

Not in the foreseeable future.

Their current web interface doesn't allow for data scraping, and their XML toolkit is only available to DHL account holders.

Ask me again in another 6 months. Things change.

Cheers
Rod

Hi Rod,

Cant reply to you via PM because your mailbox is full. ,

Anyway, i Couldn't remember the file names because im not in front of the computer (update_product.php). :-) Nothing wrong with your module, but autotweet stopped working in the update_product.php file so trying to figure it out.

RodG:

Not in the foreseeable future.

Their current web interface doesn't allow for data scraping, and their XML toolkit is only available to DHL account holders.

Ask me again in another 6 months. Things change.

Cheers
Rod

wakeleymb:

Cant reply to you via PM because your mailbox is full.

Must take care of that.

wakeleymb:

Anyway, i Couldn't remember the file names because im not in front of the computer (update_product.php). :-) Nothing wrong with your module, but autotweet stopped working in the update_product.php file so trying to figure it out.

The ozpost updates could cause this if you have made changes to the file(s) after installing ozpost. If this is the case there are a couple of solutions that will prevent you from losing them during the ozpost updates.

Solution A:

1. Uninstall ozpost. (just the admin keypress. No need to remove files).
2. Make your changes.
3. Re-install ozpost.

Solution B:

1. With ozpost installed, locate the file you need to modify then select the _restore version of the file (eg: update_product.php_restore).
   2 Modify this _restore file.
   3 Uninstall/reinstall the ozpost module (again, just the admin keypresses, no need to mess with the files).

Cheers
Rod

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

hrinfo:

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?

hrinfo:

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').

hrinfo:

. 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.

hrinfo:

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

Hi Rod,

The links to the products are:

1. http://www.gasshop.com.au/index.php?main_page=advanced_search_result&search_in_description=1&keyword=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?main_page=advanced_search_result&search_in_description=1&keyword=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

hrinfo:

The links to the products are:

1. http://www.gasshop.com.au/index.php?main_page=advanced_search_result&search_in_description=1&keyword=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

hrinfo:

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)

hrinfo:

2. http://www.gasshop.com.au/index.php?main_page=advanced_search_result&search_in_description=1&keyword=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!

hrinfo:

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.

hrinfo:

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

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

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

rstevenson:

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

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." :blink:

Musta been some cache hanging around.

Rob

rstevenson:

Musta been some cache hanging around.

Yeah, that'd be my guess too.

Cheers
Rod

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?

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?

What version of ozpost are you using?
What version of ZenCart?

Cheers
Rod