We would like to create a custom Magento shipping rate module that allows us to use the exact cart weight and set the shipping rate as follows:
A CSV file would be put into the module folder that contains the following columns:
Country code(A), state(B), postcode(C), basic rate(D), rate per kg(E), min rate(F), call charge(G), fuel levy(H), extra rate(J)
The module would work out the shipping rate as follows after matching up the user’s country, state and postcode to the relevant line of the CSV:
X=Total Cart Weight
IF Y F, THEN Z=Y
Shipping Price =(G+((Z)*H))*J
This is for an Australian website, which is why a module like this will give us a good amount of control over the price of shipping.
This work must be created as a module which can be easily installed and removed.
Payment/Milestone will only be released after the project has been accepted.