Skip to main content
All CollectionsLogistics management
How to fill in the shipment rates file?
How to fill in the shipment rates file?
Outvio Support avatar
Written by Outvio Support
Updated over a week ago

In order to make the most out of Outvio’s many benefits, we recommend you to upload a file with your own shipping rates. This way, you can be sure that Outvio always selects the best price for a shipment.

STEP 1. Download our rates template, which is easily findable under your Courier Preferences.

Once you have opened the file, you see two different worksheets: Rates and Zones.

STEP 2. Fill in your Rates and Zones sheet.

In the Rates sheet, you need to insert the prices your courier charges you depending on the destination and weight. The numbers in the first column under the Transit times starting from 1 and running down to 300 represent the weight in kg. You can always add weights beyond 300 kg or complete it only up to a lower weight range (for example until 10 kg - although that means that for shipments of more than 10 kg if that were the case, you would have no available rate). You can also change the weights from 0.5 to 0.5 instead of 1 to 1 kg. For example, you might need to send out a shipment with a weight of 5,5 kg - this you can easily do by just inserting a new row. The Transit time shows the estimated shipment time in days.

In these cells where you have no rate (for this weight or destination), substitute “1” with “-”. It is important to fill with the hyphen symbol "-" (without the quotes) those destinations and weights for which you do not have, or you are not interested in uploading, rate.

In case of sending out your shipments throughout the peninsula, make sure to add all necessary postal code ranges for each province or region. Outvio checks the postal codes, and based on where the next shipment goes, it takes a decision which rate to use, always choosing the lowest rate. If you haven't filled in the Provincial or Regional postcodes, the system automatically selects the Domestic rate.

For example, here we show you how the rates would look for a courier that takes care of national shipments, including the peninsula and islands, for a warehouse that is situated in Barcelona.

You can see that under the cell "Province", we have inserted the range of postal codes of the province of Barcelona, under the cell "Regional" the ranges of postal codes of the provinces of Tarragona, Lleida, and Gerona. For the islands, Ceuta and Melilla, we have inserted the corresponding postal codes. We leave the domestic rates column empty, so when the destination is Spain, and the postal code is not included in any area, Outvio will apply column D (Domestic).

In the Zones sheet, you can define rates for various countries. So instead of having to copy and paste the same rate into dozens of different columns, you define a zone, and then apply the name of the zone where the rate goes.

For example, in the previous image, we see a rate file with 8 zones (Z1, Z2, Z3, Z4, Z5, Z6, Z7, and Z8). Later on, we go to the Rates sheet and enter, instead of the rate corresponding to each weight, the zone to which that country belongs, like this:

You can combine zones with specific rates. For example, imagine that in France you have a general rate that is Z1, but you have the island of Corsica with a different rate or a country or region that does not fall within any zone, such as Gibraltar. No problem, you would do it this way, combining zones described in the Zones sheet with rates directly in the Rates sheet:

Be sure to fill in the transit time information (row 7) and all necessary weights.

In case of a rate change, you can easily modify them in the Zones sheet without the need to change anything in the Rates sheet. This is the advantage of using the Zones sheet. You can, of course, leave the Zones sheet empty and copy the rates to each column separately in the Rates sheet, but then you need to take into consideration that, firstly, the table when displayed in Outvio does not look that compact, and secondly, when a rate changes, you will need to fill in many columns instead of just those in the Zones sheet.

Normally for national couriers, it tends to be more convenient to fill in the corresponding columns in the Rates sheet directly, and for international couriers or rates, fill in the Zones sheet and then copy the corresponding zone in each country. And of course, as we have seen, you can have a mix of countries with a zone rate and others with a "dedicated" rate.

Did this answer your question?