View Full Version : TNT Australia Shipping based on postcode

06-06-2007, 01:40 AM
1. Updated to include NSW consignment sql file

2. Update admin so tax class can be set in admin as well as surcharge factor

3. Removed handling fee and combined with surcharge factor

4. Added in Fuel surcharge which can be updated in Admin

5. Updated formula to reflect above changes (TNT changed to up to 10 kgs without surcharge) to:

a) [z] * a * b (for less than or equal to 10Kgs)

b) [x * (y - 10) + z] * a * b (for greater than 10kgs)

x= charge per kilo over 15kg (changed in sql table)
y= total weight (I have deducted 15 kg from this because weight charge is only over 15kg) (total weight derived from product listing)
z= consignment charge (changed in sql table)
a= surcharge factor (eg. 1.08 = 8% surcharge)
b= fuel surcharge (eg. 1.1 = 10% fuel levy)
NB. tax is now added through tep_get_tax_rate built into oscommerce.

6. Updated Installation file

More... (http://www.oscommerce.com/community/contributions,2266)