How to use pricing grid ?

How to use pricing grid ?

Why using the pricing grid? 

The pricing grid can help you to bid faster on Direct business auctions by proposing directly an automated price based on different parameters.

What are the different parameters?

The parameters are defined via an excel file (csv format). 

type_parcel
country_from
postcode_from
country_to
postcode_to
tarif_min
km_min
km_max
price_per_km
fixed_price
vehicle_type

FR|DE
75
DE|RO
88

0
100
0.85

BREAK

FR

FR


0
100
0.5

FRG1












Definition of each parameter:

type_parcel : N/A
country_from : Departure country of the shipment. You can add multiple country codes separated via | (for example FR|DE). This means that the price will be calculated for shipments that have a departure place from France or Germany (You can find the list of country code here : https://www.iban.com/country-codes column Alpha 2)
postcode_from : Departure postal code of the shipment. You can add multiple country codes separated via | (For example 75|57). This means that the price will be calculated for shipments that have a departure place from 75 or 57.
country_to : Arrival country of the shipment. Same configuration than country_from
postcode_to : Departure postal code of the shipment. Same configuration than postcode_from
tarif_min : Minimum applicable price. For example: If the calculated price per km is below this price, then we will use this tarif_min
km_min : Minimum km of the applicable range
km_max : Maximum km if the applicable range
price_per_km : Price per km that will be used to calculate the final auction price (If you add ap price_per_km you should not add a fixed_price)
fixed_price : Fixed price for these parameters (If you add a fixed_price you should not add a price_per_km)
vehicle_type : vehicle type of the pricing (Accepted value : BREAK, FRG1, FRG2, FRG3, FRG4, FRGR, PL5, PL9, SEMI)
Vehicle type matching :

  1. BREAK = CAR + [1 EURO PALLET / 2M3 ]
  2. FRG1 = SMALL VAN [1 EURO PALLET / 3M3]
  3. FRG2 = VAN [4 EURO PALLETS / 6M3]
  4. FRG3 = LONG VAN [5-6 EURO PALLETS / 14M3]
  5. FRG4 = TILT/BOX VAN [8 EURO PALLETS / 20M3]
  6. FRGR = 7,5T TRUCK
  7. PL5 = 12T TRUCK
  8. PL9 = 18T TRUCK
  9. SEMI = TRAILER

Practical examples :

example 1 : I want to set pricing for my Small Van when they go from France to France for shipment under 500 km with a price of 0.5€/kms.
This is how we need to configure the CSV file : 

type_parcelcountry_frompostcode_fromcountry_topostcode_totarif_minkm_minkm_maxprice_per_kmfixed_pricevehicle_type
N/AFR
FR

05000.5
FRG1


















example 2 : I want to set for my CAR+ that when they go from France or Germany to Italy or Spain for a range of 0 to 2000km a fixed price of 1000 euros.

type_parcelcountry_frompostcode_fromcountry_topostcode_totarif_minkm_minkm_maxprice_per_kmfixed_pricevehicle_type
N/AFR|DE
FR|ES

02000
1000FRG1



















Saving the pricing grid ?

Soon as your pricing grid is ready, you will need to save it in csv format.

Saving in Numbers for Mac

You can save .CSV files in Numbers for Mac.

To save .CSV files, do the following:

  1. Open a .CSV document in Numbers for Mac.
  2. Select File.
  3. Click Export To > CSV...
  4. Click Advanced Options.
  5. Select UTF-8 as the choice for Text Encoding.
  6. Click Next.
  7. Select the save location for the file.
  8. Click Export. 

Saving in OpenOffice

You can save .CSV files in OpenOffice.

To save .CSV files, do the following:

  1. Open a .CSV document in OpenOffice.
  2. Click File.
  3. Select Save As...
  4. Set File Type as Text CSV (.csv).
  5. Click Save.
  6. If prompted, choose Keep Current Format.
  7. Ensure Character Set is set to Unicode (UTF-8). 
  8. Leave other options as their defaults.
  9. Click OK.

Saving in Microsoft Excel

You can save .CSV files in Microsoft Excel.

To save .CSV files, do the following:

  1. Open a .CSV document in Microsoft Excel.
  2. Click File.
  3. Select Save As...
  4. Select File Type as CSV UTF-8 (Comma delimited) (.csv).
  5. Click Save.
  6. If prompted, choose Keep Current Format.

How to upload the pricing grid ?

Go on this page : https://carrier.rubiwin.com/pricing-grid and use the dedicated button :



How is it used in Direct Business  ?

If you open an auction that is matching to one line of your pricing grid, a price will be automatically proposed in the field :





    • Related Articles

    • How to access my account ?

      How to start the migration? We are implementing a new login procedure: Step 1: login with your Carrier ID  and your usual password. and then you will be asked an email address and first name and last name. You will then receive an email where you ...