Multiple Format for Rate sheet Update

Release date: August 09, 2022


The following is the advantage of having Multiple Ratesheet Upload in NeuTrafiX


Role

Advantage

NeuTrafiX 

·  NeuTrafiX will have an advance capability to process price list offering from Seller

Buyer

·  More updated destinations from the Sellers to be choose.

Seller

·  Reduce the amount of error caused by manual update to upload offering on Neutrafix portal.

·  Increase opportunity to sell more destination 

·  Increase good experience for the Seller when uploading price offering.

·  Gain more money as the Buyer can access and purchase more route and new destination from the Seller.



Routes edit will be two major features in one page, the Seller Rate sheet Upload Feature (Pic 1.2 Rate Sheet Upload) and The Required Settings (Pic 1.1 Required Setting)


Pic 1.2.1 Rate Sheet Upload (SIP Route)




Pic 1.2.2 Rate Sheet Upload (SMPP Route)



Pic 1.2.3 Rate Sheet Upload Validation (SMPP Route)



Pic 1.2.4 Rate Sheet Upload Validation (SIP Route)



●   On the Seller Rate Sheet Upload feature we divide into some features on the tab : Upload Tariff, Update Tariff (feature appeared just for SMPP Route), Email Tariff, and Setting.

●   Upload Tariff : will be same with the existing feature that NeuTrafiX has right now, sellers could upload their tariff with the template that they could download it below the browse button (Pic 1.2 Rate Sheet Upload). Seller may allow to upload their own format by activate their format from the setting feature. After the system success process the new tariff the page will show the validation page, with this page the system need seller to validate the tariff that they just uploaded, if the seller agree with the data, they could click “update” button and if not they could click “cancel” button.


○      Upload Tariff : Browse the file from their local machine

○      Download Template (Below the Upload Tariff) : Seller can download the default template from Neutrafix, the template will similar with the Neutrafix has right now but we need to remove the unnecessary column.

○      Delete Existing Rates During Upload : Seller can delete the existing rate and replace it with the new rate

○      Upload Tariff MCCMNC : To upload tariff for MCCMNC 

○      Download Template (Below the Upload Tariff MCCMNC) 

○      Sender ID list : List of the sender ID




                                                                                                Pic 1.3 Update Tariff


●  Update Tariff : Seller could update their tariff without upload the file, to update the rate without upload, seller could click on the “Update Tariff” tab and add value on the field. System will limit the row that can be updated on the system, 10 rows per-update, means 10 rates could be updated on the system in one sequence. This feature will appear just only for the SMPP route.


○ MCCMNC : Seller will put the MCCMNC value if they just want to update based on the MCCMNC value and empty the prefix, but seller also could update the Prefix and MCCMNC

○Effective From : date when record becomes active, sample date: '2015-01-01 01:01:01'. For rates that don`t have 'Forbidden' or 'Discontinued' flag, rates can only be updated after 48 hours. Special value supported: ASAP. If ASAP is specified as value, the rate will become immediately blocked if 'Forbidden' or 'Discontinued' flag is set, and now + 48 hours for rates with traffic allowed

○ Price 1 : price per minute for first billing interval, sample : 0.0523

Ratesheet Upload using Email





Pic 1.4.1 Email Tariff (Voice/SIP Route)



Pic 1.4.2 Email Tariff (SMPP Route)


●Email tariff : Besides Upload Tariff and Update Tariff, seller also could email the tariff to Neutrafix Rate Email from their system. The Neutrafix will process the email and put the new rate based on the tariff from the attached file. System will automatically update and check their email to update the tariff. (Pic 1.4 Email Tariff)

○Use Format : If the seller already have the template format that active from the other Routes Name.



○ Email Sender : The valid email sender, could be have multi value separated by comma, if there is an email from this email address and sent to voice@rates.neutrafix.net for SIP product and sms@rates.neutrafix.net for SMPP product, system will check the email subject and attached file name, and if all valid the system will update the tariff based on the attached file and if there is an error, system will reply to the sender, main email, sell rate email, and finance email for the details.

○ Email Subject : The default email subject, consist of the Specific code, Seller Name, Route Name and the rate type (a to z or partial). The customer send an email from “Email Sender” and sent to voice@rates.neutrafix.net or sms@rates.neutrafix.net with the subject that already mentioned on the “Email Subject”, system will update based on the Route Name that mentioned on the subject (example Silver-SG), system will check the attached file name, and if all valid the system will update the tariff based on the attached file and if there is an error, system will reply to the sender, main email, sell rate email, and finance email the details. Partner can choose the rate type, they may choose the partial or a to z rate, partial means that the system will change the partial rate from the partner route, a to z means that the system will change all the rate from the route.


○ Email Sender : The valid email sender, if there is an email from this email address and sent to voice@rates.neutrafix.net or sms@rates.neutrafix.net, system will check the email subject and attached file name, and if all valid the system will update the tariff based on the attached file and if there is an error, system will reply to the sender, main email, sell rate email, and finance email the details.


○Attached File Name : The valid attached file name, if there is an email from “Email Sender” and sent to voice@rates.neutrafix.net or sms@rates.neutrafix.net with the subject that already mentioned on the “Email Subject”, using correct attached file name, system will update the tariff based on the attached file and if there is an error, system will reply to the sender, main email, sell rate email and finance email the details.

○ Reply the Email : as the system process the tariff from the attached file, the system also reply the email with the details of error (Pic 1.6 Email Reply Error) or just a success notification that the rate already updated 


                

                                                                (Pic 1.5 Email Reply Success)




Pic 1.6 Email Reply Error






Pic 1.7.1 Setting (SMPP Route)




Pic 1.7.2 Setting (SIP Route)




As a seller, you have the option to either upload your tariff directly or email it to us in your own template. Please customize your template using the form provided on the left side. Enter the Excel row and column reference into the respective fields, and the system will then analyze your tariff based on the template you've established.

You have the option to upload files in XLS, CSV, or XLSX formats. To activate your personalized template, ensure to tick the 'activate' checkbox.

There is also the option to enable the "Auto Adjust Fee" feature. Once activated, the system will automatically incorporate the transaction fee into your selling rate.

Please be aware that the "Effective From" field requires both a date and time. If you only enter a date without specifying a time, the system will default to a time of 00:00:00. 

The Interval 1/N feature is specifically designed for situations where your uploaded rate sheets use a single column to represent time increments, such as 1/1 or 60/60. When this option is activated, it will automatically divide these increments into separate Interval1 and IntervalN columns.

The "Use Destination Default Intervals" function is created to automatically populate the necessary billing intervals for each dial code, adhering to the Neutrafix standard format. This feature can be particularly useful if the sheet you're uploading doesn't contain any values for billing intervals, also known as time increments.

Activate the "Enforce Past Dates ASAP" feature if your rate sheet potentially includes rates with effective dates in the past. Since the system doesn't accept past dates, enabling this option will automatically set the effective date to "ASAP". This ensures successful uploading of the rate in these instances.

The fields "Discontinued Default Value" and "Forbidden Default Value" are mandatory for Neutrafix to determine which rates should be blocked or discontinued. If your rate sheets lack columns for these values, you can set a default value of 0 (disabled) or 1 (enabled) for the uploaded tariff.


  • Setting on Prefix & MCCMNC : The system will support number separators ( , comma)( ; Semicolon)( - dash)
  • Comma & Semicolon Separator : the comma and semicolon separator will separate the between the number, for example 628211; 628212 or 628211, 628212 will produce two numbers 628211 and 628212
  • Dash separator : the dash separator will produce the number range in between of two numbers, for example if the rate sheet provide the numbers in range between 628211-628215 will produce 5 numbers 628211, 628212, 628213, 628214, 628215.
  • Setting on Date Format : the user should define the date format by select the format on the form, the system will provide some format (MM/dd/yyyy; yyyy/MM/dd; MM/dd/yyyy; dd-MMM-yyyy; MMM d,yyyy; dd-MM-YY). Pic 1.7.3 Setting Date Format


 Pic 1.7.3 Setting Date Format