We are an Australian Online Retailer. We use a CSV Shipping File with price tiers to certain locations, to Australia's 16500 postcodes/suburbs.
We are wanting to simplify our shipping at the front end with Flat Rate Table Rates, for UX.
So working from our Freight CSV Weekly Invoices, and other data, we are wanting to create a simple Table Rate that we can display on each product page of our website, that is easy to understand, and has the functionality to recoup our average courier spend.
We require metro areas to be subsidised, with outer metro areas, and regional to be more expensive. We want to drive conversion to the main metro areas, and get that web traffic converting much higher, without losing our shirt!
We have all the required data, that needs to be collated and condensed into one easy CSV file for the back end, and a simple table rate for the front end (product page)
Also where possible we would like to utilise bulky items surcharges on selected products, so we can further cheapen our CSV file across the main stream of products. We have all data available to make the job smooth and easy!