Austnt Module

[gavinmcmillan]

Hi everyone

 

Has anyone had any problems with this module producing the wrong price? im not too sure why it is doing it.

 

The formula for working out the shipping price works out the correct postage (when done with a calculator) however it produces the wrong amount in the website.

 

I have the login box, the display weight and the sts contributions installed.

 

Does anyone have any ideas?

 

Regards

Gavin McMillan

Edited April 8, 2005 by gavinmcmillan

[Guest]

Hi everyone

 

Has anyone had any problems with this module producing the wrong price? im not too sure why it is doing it.

 

The formula for working out the shipping price works out the correct postage (when done with a calculator) however it produces the wrong amount in the website.

 

I have the login box, the display weight and the sts contributions installed.

 

Does anyone have any ideas?

 

Regards

Gavin McMillan

<{POST_SNAPBACK}>

 

When you say the wrong amount, what is it? Higher, lower, random.

[gavinmcmillan]

When you say the wrong amount, what is it? Higher, lower, random.

<{POST_SNAPBACK}>

 

Hi

 

It seems to be random, sometimes its higher, sometimes its lower. It looks like maybe something else is being passed to the wrong place or interfering with it.

 

Im not too sure.

 

Any ideas?

[Guest]

Hi

 

It seems to be random, sometimes its higher, sometimes its lower. It looks like maybe something else is being passed to the wrong place or interfering with it.

 

Im not too sure.

 

Any ideas?

<{POST_SNAPBACK}>

 

 

Have you set the correct settings in Configuration menu, Shipping/Packaging. Most specifically the "Pakage Tare weight". I have mine for the Aus post module set to 0.3.

 

Also have you got it set with or without GST. Should be GST included for local.

[gavinmcmillan]

Have you set the correct settings in Configuration menu, Shipping/Packaging. Most specifically the "Pakage Tare weight".  I have mine for the Aus post module set to 0.3.

 

Also have you got it set with or without GST. Should be GST included for local.

<{POST_SNAPBACK}>

 

I have set the shipping tare weight to 0 for now well i try to get it working, i have also disabled larger packages % increase for now. here is an example of what im trying to do (weights etc)

 

the total package is 25kg

the charge per kilo is 0.54 the consignment charge is 14.10

so it looks like this:

 

(0.54*(25-15)+14.10)*1.1*1.1 +5.00=$28.60

(please correct me if im wrong)

 

The website shows the cost of shipping for this weight as $37.06

 

Another example:

 

the total package is 10kg

the charge per kilo is still 0.54 and the consignment is 14.10

(because it is under 15 kg the calculation should look like this)

14.1*1.1*1.1+5.00= 22.06

(please correct me if im wrong)

 

The website shows the cost of shipping as $33.79

 

Any ideas whats up with it?

[gavinmcmillan]

Perhaps i have worked it out wrong and the website amount is correct? if someone could let me know it would be much apreciated!

[Guest]

Gavin

Whats this bit "(25-15)"

 

 

John

[gavinmcmillan]

Gavin

Whats this bit "(25-15)"

John

<{POST_SNAPBACK}>

 

the 25-15 bit is for working out weights that are over 15kg so its like this

 

the total package weight is 25kg, you take away 15kg because the first 15kg is covered in the consignment charge. and any weight after 15kg is charged at $0.54 per kg.

 

Hope that makes sense!

 

Gavin

[geoffwin]

the 25-15 bit is for working out weights that are over 15kg so its like this

 

the total package weight is 25kg, you take away 15kg because the first 15kg is covered in the consignment charge. and any weight after 15kg is charged at $0.54 per kg.

 

Hope that makes sense!

 

Gavin

<{POST_SNAPBACK}>

 

Max Australia POst will ship is 20Kg

Where are you getting the figures from for the calculation ? the auspost module jumps over to Auspost to do the calculation.

 

suggestion

zero the admin tare weight, reset max package to 20kg

create a product with a known weight eg 10kg - the module uses the entered weight of the product.

use the module and check by going to the auspost site, if the error is 10% it is GST problem

 

Geoff

[geoffwin]

Max Australia POst will ship is 20Kg

Where are you getting the figures from for the calculation ? the auspost module jumps over to Auspost to do the calculation.

 

suggestion

zero the admin tare weight, reset max package to 20kg

create a product with a known weight eg 10kg - the module uses the entered weight of the product.

use the module and check by going to the auspost site, if the error is 10% it is GST problem

 

Geoff

<{POST_SNAPBACK}>

 

sorry about that, should have read more closely NOT Auspost at all

 

Geoff

[gavinmcmillan]

Max Australia POst will ship is 20Kg

Where are you getting the figures from for the calculation ? the auspost module jumps over to Auspost to do the calculation.

 

suggestion

zero the admin tare weight, reset max package to 20kg

create a product with a known weight eg 10kg - the module uses the entered weight of the product.

use the module and check by going to the auspost site, if the error is 10% it is GST problem

 

Geoff

<{POST_SNAPBACK}>

 

I cant use the Auspost module because i will be shipping products that weigh well over 20 kg, im trying to get the AusTNT shipping module working as I have been in touch with them and they can do basically any weight we ask for.

 

I have zeroed the admin tare weight and set the max package weight to 200 so it wont intefere with my testing. I am still calculating differnt costs for postage than the website.

[geoffwin]

I cant use the Auspost module because i will be shipping products that weigh well over 20 kg, im trying to get the AusTNT shipping module working as I have been in touch with them and they can do basically any weight  we ask for.

 

I have zeroed the admin tare weight and set the max package weight to 200 so it wont intefere with my testing. I am still calculating differnt costs for postage than the website.

<{POST_SNAPBACK}>

 

what TNT module are you using ?

 

Geoff

[Guest]

Geoff

 

This one:

http://www.oscommerce.com/community/contributions,2266

 

Was just about to post for you.

[gavinmcmillan]

Geoff

 

This one:

http://www.oscommerce.com/community/contributions,2266

 

Was just about to post for you.

<{POST_SNAPBACK}>

 

Yes, thats the one. Its tricky, i still cant work it out, the code looks like it should work and the equation does work. Im just not sure why the website is putting out the amounts it is!!

 

Thanks for you help so far guys!!!!

[geoffwin]

Geoff

 

This one:

http://www.oscommerce.com/community/contributions,2266

 

Was just about to post for you.

<{POST_SNAPBACK}>

 

Ok I assume that you have worked out the bug for under 15kg that was quoted.

 

In the orignal Swadling code for TOLL I had to go and change the "surcharge" configeration was well

cat : includes : modules : shipping TNT module

 

about line 27

 

//More options can be added later for Express, Overnight etc when someone codes it.

$this->types = array('Toll Off-Peak' => 'std');

 

// Change this surcharge factor to increase your profit margin on freight

$this->surcharge_factor = 1.1;

}

 

surcharge factor was mucking me up

 

Geoff

Edited April 11, 2005 by geoffwin

[gavinmcmillan]

Ok I assume that you have worked out the bug for under 15kg that was quoted.

 

In the orignal Swadling code for TOLL I had to go and change the "surcharge" configeration was well

cat : includes : modules : shipping TNT module

 

about line 27

 

//More options can be added later for Express, Overnight etc when someone codes it.

      $this->types = array('Toll Off-Peak' => 'std');

 

      // Change this surcharge factor to increase your profit margin on freight

      $this->surcharge_factor = 1.1;

    }

 

surcharge factor was mucking me up

 

Geoff

<{POST_SNAPBACK}>

 

Yes all of that part works (apart from displaying the wrong amount. my code is the same as yours (above). from what i can work out (not very good a programming) but something seems to go wrong when the final amount is passed onto the checkout_shipping.php page however im not very good at programming and could be wrong.

 

Gavin

[Guest]

It is a poor coding job and does not even offer a sort order.

 

I've had a bit of a look at the code but I just don't have time at them moment to try and sort it out.

 

I believe your close to the mark in regards to the way the calculation is worked out.

You could try using something like excel to test the formula.

[gavinmcmillan]

It is a poor coding job and does not even offer a sort order.

 

I've had a bit of a look at the code but I just don't have time at them moment to try and sort it out.

 

I believe your close to the mark in regards to the way the calculation is worked out.

You could try using something like excel to test the formula.

<{POST_SNAPBACK}>

 

I put the formula into Excell and it worked, it has to be something to do with the way it is passed to the other pages.

[geoffwin]

I put the formula into Excell and it worked, it has to be something to do with the way it is passed to the other pages.

<{POST_SNAPBACK}>

 

In that code example I gave try changing the surcharge amount from 1.1 to 1.0

 

I think you also need to remember that you are not querying TNT directly (am I correct here ?) but using an approximation of their costing that is using a modified TOLL courier example.

 

The calculation you gave as the example is "almost" out by 10% may be coincidence ??

 

Geoff

[geoffwin]

In that code example I gave try changing the surcharge amount from 1.1 to 1.0

 

I think you also need to remember that you are not querying TNT directly (am I correct here ?) but using an approximation of their costing that is using a modified TOLL courier example.

 

The calculation you gave as the example is "almost" out by 10% may be coincidence ??

 

Geoff

<{POST_SNAPBACK}>

 

I think I need to go back to bed

[geoffwin]

I think I need to go back to bed

<{POST_SNAPBACK}>

 

you have incorporated the sql into your database ?

 

Are the consignment prices per kg and the consignment charges within that info current ? there is no reference to a consignment rate of .54 that I can see ?

[gavinmcmillan]

In that code example I gave try changing the surcharge amount from 1.1 to 1.0

 

I think you also need to remember that you are not querying TNT directly (am I correct here ?) but using an approximation of their costing that is using a modified TOLL courier example.

 

The calculation you gave as the example is "almost" out by 10% may be coincidence ??

 

Geoff

<{POST_SNAPBACK}>

 

That is true, it is not Querying TNT directly. I have checked the values in my database to make sure i have the right consignment charge and charge per kilo and it is all correct. I changed the surcharge to 1.0 and now it is closer to the right amount but still not correct.

 

for example, a product that is 10kg being shipped to sydney australia from Adelaide is:

 

14.10*1.1+5.00=$20.51

 

14.1 is the consignment charge

1.1 is GST

and 5.00 is the handling fee.

 

The site produced $17.54

 

Is there anything i can do to try and narrow the problem down?

[gavinmcmillan]

I have checked all of the rates with TNT, they are just around the corner from me and they are up to date as of last week. The consignment charge for sending from where i am to sydney is $14.10 for the first 15kg and anything over 15kg is charged at $0.54 per kilo.

[geoffwin]

That is true, it is not Querying TNT directly. I have checked the values in my database to make sure i have the right consignment charge and charge per kilo and it is all correct. I changed the surcharge to 1.0 and now it is closer to the right amount but still not correct.

 

for example, a product that is 10kg being shipped to sydney australia from Adelaide is:

 

14.10*1.1+5.00=$20.51

 

14.1 is the consignment charge

1.1 is GST

and 5.00 is the handling fee.

 

The site produced $17.54

 

Is there anything i can do to try and narrow the problem down?

<{POST_SNAPBACK}>

 

I can only suggest that you check the DB figures again and ensure they are correct for the postcode and zone as applied by TNT

 

The figures in the downloaded module for Adelaide were

 

INSERT INTO `toll_rates` VALUES ('ADL', '0.49', '19.90'); This is a fair bit different from yours.

 

I would also check to make sure that GST is not being charged twice on the shipping, once during the TNT calculation and again by OSc on the checkout page.

 

Geoff

[gavinmcmillan]

I can only suggest that you check the DB figures again and ensure they are correct for the postcode and zone as applied by TNT

 

The figures in the downloaded module for Adelaide were

 

INSERT INTO `toll_rates` VALUES ('ADL', '0.49', '19.90'); This is a fair bit different from yours.

 

I would also check to make sure that GST is not being charged twice on the shipping, once during the TNT calculation and again by OSc on the checkout page.

 

Geoff

<{POST_SNAPBACK}>

 

It is different because the default is set up for a shop in sydney. You need to change the prices to match the pricing from the city you are in. when posting from Adelaide to Sydney it costs 14.10 where as posting within adelaide it costs 11.95, you need to make sure that you have the prices for your local TNT otherwise you will be using prices that are quoted for a differnt city.