Upload tariff CSV

You can use a tariff upload form to upload your call rates, instead of entering them manually. You can also use an upload form to update existing tariff entries.

Note: When uploading information to Smile via CSV, files must be uploaded in the following order:
  1. Destination
  2. Prefix
  3. Tariff
The CSV file must contain the following fields:
  • Destination Name
  • Call Type
  • Flagfall Rate
  • Per Unit Rate
  • Minimum Charge
  • Maximum Charge
  • Start Date
  • Decimal Places
  • Rounding Type
  • Charging Units
  • Charging Increment
  • Tariff Type Id
  • Plan
Destination
If there are no tariffs for a destination, then all fields must be filled. If there are tariffs for a existing destination and a field is empty, the value for that field will not be updated or overwritten.
The destination must be configured against the service of the plan schedule item, plan or service you are uploading for. For more information, see Destinations.
Call Type
The call type must be the same as the default tariff that you are trying to override:
  • D—Data
  • S—SMS
  • M—MMS
  • X—Fax
  • W—WAP
  • F—Forward Voice
  • V—Voice
  • E—Video Call
  • C—Event Count
  • I—Imported Charge
  • U—Unknown
Flagfall Rate
Excluding tax.
Per Unit Rate
Excluding tax.
Minimum and maximum charge
To set a minimum or maximum charge to null, the field must be filled with null.
Start date
Start date format is dd/MM/yyyy.
Decimal Places
The decimal place length entered must match the format of the values entered for Per Unit Rate, Minimum Charge and Maximum Charge.
Rounding type
The rounding type must be one of the following:
  • 0—none
  • 1—up
  • 2—down
  • 3—half up
  • 4—half even
For more information, see Rounding modes.
Tariff type id
The tariff type Id is the identification code for a tariff type. The Id must be a tariff type applicable to the service and company that you are uploading for. The tariff type ID is displayed in the type summary list on the service Tariff types tab.
Plan
The plan code may be excluded. If it is included and null, the tariff will be configured. The plan code is located on the plan Settings tab.
Tip: To update the rates for existing tariffs, Download tariff CSV, update the required rates, then Upload tariff CSV. Only the updated fields with be changed in Smile.

This task explains how to upload a tariff CSV file.

  1. On the Destinations tab, click Upload tariff CSV...
    The Tariff Upload page is displayed.
  2. Click Choose File.
    A file explorer window is displayed.
  3. Navigate to and select the file to upload. Click Choose.
    The Tariff Upload page is displayed.
  4. Click Upload.
    The Destinations tab is displayed.