Direct Freight Setup

This article has moved to a new home. View the updated version

Did you know? We can setup your shipping matrix for you for a small fee. Click here to order shipping matrix setup

This support article requires the Neto Ship addon from Neto’s Addon Store.

Setting up Direct Freight as a shipping method requires several steps prior creation.

Import shipping zones

The Direct Freight zones need to be imported so that postcodes in Australia can be grouped into geographic zones.

  1. Download the Direct Freight - Shipping Zones file and save it to your computer. This file has been preloaded with onforwarding zones (identifiable by the - ONF - ## at the end of the zone name), where the ## is the onforwarding charge amount. Double check this file against your onforwarding rates provided by Direct Freight for accuracy.

  2. From the Neto Dashboard, navigate to Setup & Tools > Shipping.



  3. Select Shipping Zones.



  4. Select Import Shipping Zones.



  5. Click Choose File and upload the Direct Freight zones file downloaded in step one.



  6. Select Upload File, and the Direct Freight zones will be imported into Neto.



Preparing your data

Direct Freight will provide your rates in a csv spreadsheet which isn’t able to be imported into Neto as is. The data will need to be transposed into Neto’s template for it to be imported.

  1. Open the spreadsheet provided by Direct Freight. It should look similar to this.



  2. Some zones will have two rates listed with different Break values. Delete any of the rows that have a break of 99999. If you need to ship orders over 200kg, stop now and contact our support team for advice.



  3. Delete columns so that you are only left with the To Zone, BasicCharge, Rate, and MinimumCharge. Make a note of the CubicConv if it is anything other than 250.



  4. Download the Direct Freight On Forwarding Rates file and open it. There will be 2 columns of data, one with the zones and another with the onforwarding rate. Copy and paste the data into your rates file columns A and E, like below.



  5. You’ll now need to enter some formulas into the 3 other columns. In the screenshot examples the last row of data is 61, so we’ll be using this number in our formulas (if you last row is different, substitute in your number). In columns B & C, we want to replicate the data above, so enter =B61, and =C61 respectively.



  6. In column D we want to add the on onforwarding cost to the minimum charge. So in this field we will enter =D61+E62-E61. The subtraction on the end ensures we don’t add the previous onforwarding rate to the next zone.



  7. Copy these formulas down the page to fill in the blank columns.



  8. Scroll back to the top of the page, and select column A, and then sort A - Z. A pop up box should ask you if you want to expand the selection. Choose this and click Sort.



  9. You zones will now be sorted alphabetically, and the Basic Charge, Rate, and Minimum Charge will be populated with the prices. Check the accuracy of a few just to be sure.



  10. We’re now ready to transpose this data into the Neto rates template. Download and open the template.



  11. Copy and paste ToZone into the Zone Code and Zone Name fields.



  12. Copy and paste the BasicCharge data into the 1st Parcel field. When pasting be sure to right click and select Paste Values.



  13. Copy the data in the Rate column into the Per KG field in the Neto template. Again be sure to use Paste Values.



  14. Copy the data in the MinimumCharge field into the Minimum Charge column of the Neto template. Again be sure to use Paste Values.



  15. Finally, fill in the Courier Name (Direct Freight*), Minimum (0), Maximum (200) and Delivery Time (if provided). Save the file.



Import the shipping rates

Now that the template of rates is complete, it can be imported into Neto.

  1. From the Neto Dashboard navigate to Setup & Tools > Shipping.



  2. Select Shipping Services & Rates.



  3. In the top right corner, select Add New.



  4. Enter a Name, set the Status to Active, Charge Type to Weight/Cubic, Cubic Weight Modifier to 250, uncheck Ship to PO Box, set the tracking URL to Direct Freight, and add in your Fuel Levy % (if provided). When done, click Save.



  5. Scroll down the page and select Import Zones and Rates .CSV File [+], then Choose File to upload your rates.



  6. You’ll be given a preview of the rates. Check a few and confirm the data is correct, then Save.



Create the shipping method

The shipping method is what displays to customers on the front end of your site. To create a shipping method:

  1. From the Neto Dashboard navigate to Setup & Tools > Shipping.



  2. Select Shipping Methods.



  3. In the top right corner select Add New.



  4. Enter a Name, set the status to Active, Visible To Customer to Yes, and turn delivery to PO Boxes off, then Save.



  5. At the bottom of the page select Add Shipping Category, select the default (or your own defined shipping category), and choose Direct Freight for the rates. Check the indicated checkbox, and Save.



Was this article useful?

Be notified when this page is updated. Optional.

Last Modified: 28/09/2017 Neto Version: 6.9