How to convert the Direct Freight Express Rate Card into the MachShip format

How to convert the Direct Freight Express Rate Card into the MachShip format

If you have received your Direct Freight Express rates card in the format below then this document will outline how to convert this into the MachShip rate card csv upload format. 

FromZoneToZoneServiceCityToBasicChargeRateBreakSeqnoUpToKgsTypeFlatslidingMinimumChargeCubicConv
MELBADELEXP  $            7.50 $            0.26000KILO                  $          11.00250
MELBADELEXP  $            7.50 $          95.5000500PALLET                $          101.00250
MELBALBUEXP  $            8.00 $            0.31000KILO                  $          11.00250
MELBALICEXP  $            9.50 $            1.34000KILO                  $          11.00250
MELBBALLEXP  $            7.50 $            0.22000KILO                  $          11.00250
MELBBRISEXP  $            7.50 $            0.38000KILO                  $          11.00250
MELBBRISEXP  $            7.50 $       191.2500500PALLET                $          201.00250
MELBTASEXP  $            9.50 $            1.12000KILO                  $          11.00250
MELBTASEXPDEVONPORT $            8.50 $            0.84000KILO                  $          11.00250
MELBSYDEXP  $            7.50 $            0.3025010KILO                S $          11.00250
MELBSYDEXP  $            7.50 $            0.2950020KILO                S $          11.00250
MELBSYDEXP  $            7.50 $            0.289999930KILO                S $          11.00250


As outlined in this article every upload template needs to appear in the following format: 

CarrierRatecardServiceFrom ZoneTo ZoneReciprocalCubic ConversionBasicMinimumBreak TypeItem TypeBreak FromBreak ToPriceBreak TypeItem TypeBreak FromBreak ToPrice
                   

The fields which can be pre-set are:

Carrier - Set as DFE.

Ratecard- This will be the abbreviation for this ratecard. Generally, this would be the account code - note that this needs to be unique in the system.

Service -  Provided in the rate card from Direct Freight.

From Zone - Provided in the rate card from Direct Freight (MachShip has ensured we have mapped these up exactly).

Reciprocal - This will be indicated by your sales rep or defaulted to be N.


The known complexities are outlined below. 

1. Rates for CityTo.

When Direct Freight Express provide a suburb name in the CityTo column and when there is a zone named in the To Zone column, then they are issuing a rate to a suburb within that zone. 

The example of this is shown below:

FromZoneToZoneServiceCityToBasicChargeRateUpToKgsTypeMinimumChargeCubicConv
MELBTASEXP  $            9.50 $            1.120KILO                 $          11.00250
MELBTASEXPDEVONPORT $            8.50 $            0.840KILO                 $          11.00250

In this example, Direct Freight Express has provided a rate to the suburb of Devonport at a cheaper rate than the overall Tasmanian zone. 

The MachShip team will have set up this suburb as a subzone against Direct Freight Express and as such this will be the zone you will need to use in the To Zone column. 

The rate card import csv will appear as:

CarrierRatecardServiceFrom ZoneTo ZoneReciprocalCubic ConversionBasicMinimumBreak TypeItem TypeBreak FromBreak ToPrice
DFE EXPMELBTASN2509.511WEIGHT 0 1.12
DFE EXPMELBDEVONPORTN2508.511WEIGHT 0 0.84

MachShip will know that the item is going to the suburb of Devonport.

2. Rates with Pallet rates and Weight rates that have a different Minimum.

When Direct Freight Express provide both Pallet and Weight rate for the same From and To zone combination with a different minimum - see below:

FromZoneToZoneServiceCityToBasicChargeRateBreakSeqnoUpToKgsTypeFlatslidingMinimumChargeCubicConv
MELBADELEXP  $            7.50 $            0.26000KILO                  $          11.00250
MELBADELEXP  $            7.50 $          95.5000500PALLET                $          101.00250
MELBBRISEXP  $            7.50 $            0.38000KILO                  $          11.00250
MELBBRISEXP  $            7.50 $       191.2500500PALLET                $          201.00250

 

In the rate setup above, MachShip has to be informed when to price the pallet rate and when to price the kilo rates. The way that this has been completed in MachShip is through a carrier item type.

There have been 2 carrier item types set up for Direct Freight Express. The Item (ITM) and the Pallet (PAL). Using these item types, a user is able to help MachShip to differentiate between pricing for a pallet and pricing for an ITM. 

PLEASE MAKE SURE THAT YOU ONLY USE THE PAL and ITM ITEM TYPES WHEN THERE IS A LANE WHICH HAS PALLET RATES. FOR ALL OTHER LANES PLEASE LEAVE THE ITEM TYPE FIELD BLANK. 

The rate card will look like the below: 

CarrierRatecardServiceFrom ZoneTo ZoneReciprocalCubic ConversionBasicMinimumBreak TypeItem TypeBreak FromBreak ToPriceBreak TypeItem TypeBreak FromBreak ToPriceBreak TypeItem TypeBreak FromBreak ToPrice
DFE EXPMELBADELN2507.511WEIGHTITM0 0.26PIECESPAL01101PIECESPAL2 95.5
DFE EXPMELBBRISN2507.511WEIGHTITM0 0.38PIECESPAL01201PIECESPAL2 191.25

 

3. Rates with Weight breaks. 

When Direct Freight Express provide rates with multiple lines with different values in the break column, their rate card will appear like the below:

FromZoneToZoneServiceCityToBasicChargeRateBreakSeqnoUpToKgsTypeFlatslidingMinimumChargeCubicConv
MELBSYDEXP  $            7.50 $            0.3025010KILO                S $          11.00250
MELBSYDEXP  $            7.50 $            0.2950020KILO                S $          11.00250
MELBSYDEXP  $            7.50 $            0.289999930KILO                S $          11.00250

The number in the break column represents the Break To values and the Seqno indicates the Break number. For example: Seqno 1 is the first Kilo Break and it is from 0kg to 250kg charged as 30cents per kilo. 

The rate card will look like the below:

CarrierRatecardServiceFrom ZoneTo ZoneReciprocalCubic ConversionBasicMinimumBreak TypeItem TypeBreak FromBreak ToPriceBreak TypeItem TypeBreak FromBreak ToPriceBreak TypeItem TypeBreak FromBreak ToPrice
DFE EXPMELBADELN2507.511WEIGHT 02500.3WEIGHT 2515000.29WEIGHT 501 0.28


If you have any issues or queries please don't hesitate to contact support@machship.com 

    • Related Articles

    • How to set up the MachShip CSV Rate Card import checklist

      In order to enable the MachShip system to provide you with a price, you will need to have your carrier rate cards and then convert them into the MachShip format for upload. Below you will find a step by step checklist to ensure that you can upload ...
    • How to create a Carrier Account with Direct Freight Express

      When looking to set up a new account with Direct Freight Express you will need to contact their IT department and advise them that you are looking to despatch your account through MachShip. The Direct Freight Express IT Team can be contacted at ...
    • Common errors when uploading a Rate Card

      Below you will find a list of common errors you may experience when importing a rate card csv into MachShip and how you can resolve them. 1. Carrier does not exist or you do not have access If you see an error such as the below when importing: There ...
    • How to set up a Rate Card for Accumulative Pricing

      Accumulative pricing involves pricing each kilo, piece, km or cubic metre in its applicable weight, volume, piece or distance break. For example, if we had the below rates and an 11-kilogram consignment. From Zone To Zone Basic (inc 5 kg) 0-5 6-10 ...
    • How to set up a Rate Card for Break Pricing

      Break pricing involves finding the pricing break, pricing the entire consignment (total kilo's, piece's, km's or cubic metre's) on the highest weight, volume, piece or distance break. For example, if we had the below rates and an 11-kilogram ...