Uploading the updated rates of Vendors

 

Aram Gabrielyan

Intarnet / Switzernet

2008-02-08

 

 

When a vendor sends a rate modification notice the following has to be done.

 

  1. Go to the vendor’s tariffs and download the CVS file. Chose “All” to download and inspect entire tariff.

 

 

  1. After download is complete change the rates in the downloaded file

2.1. you must put exact tariff name (see the excel sheet attached to this guide) [csv]

2.2. you must change the effective date to a date in a future point in time

2.3. you must make sure that the same destination is not repeated in the file (verify by prefix column)

2.4. the rate must be changed in all 4 columns: First Price, Next Price, Off-peak First Price, Off-peak Next Price

2.5. save this file on your hard drive

2.6. if as a result of a rate change the preference of the route changes you must change the preference in the two columns accordingly

 

Please refer to the CVS file [csv].

 

 

 

  1. Upload the file back to billing

 

 

 

  1. If the modification of rates is for an existing destination to the given vendor always use Replace option. If it is a new destination to for this vendor, meaning if the destination was not in the downloaded file use option “Add”. It is recommended to do modifications in one step and additions in another step to avoid duplications in the tariffs.

 

 

 

*   *   *