⚠️ Note! This feature is only available in the new Blazor interface!
To adjust rates in bulk, for example, at the end of the year, you can export your rates and modify them in Excel. Then, you can use the import functionality to upload your new rates into Zero Friction.
Exporting Tariffs
Where to Find the Export Function?
You can export tariffs via Configuration > Billing > Products.
How Does the Export Work?
Select a Date: Choose the date for which you want an overview of active tariffs.
Download the File: The generated Excel file contains a list of all products active on the selected date.
Contents of the Excel File
The file contains:
A "current" row: Leave this unchanged; it will be ignored during import.
A "new" row: Fill in the new tariff details here, including the start date.
💡 Tip: If an existing tariff period has a start and end date, the new period’s dates will be automatically filled. For example:
Current period: 01/01/2024 - 01/01/2025.
New period: 01/01/2025 - 01/01/2026 (length of the current period is carried over).
Importing Tariffs
How to Prepare Your CSV File
Adjust Tariffs: Fill in the new tariffs in the "new" rows of the Excel file you exported.
Save the File as CSV: Ensure the file is in the correct format.
⚠️ Important:
Use a comma as the decimal separator.
Use a dot for thousands separators.
Ensure dates are correctly formatted.
The CSV must have “ANSI” encoding (This is the default when you save the file with Excel)
Go to Configuration > Billing > Import Tariffs and click on Upload.
Supported Tariff Types
Currently, we support:
Currently, we support:
Unit prices.
Tariff conditions.
❌ Not supported: Formula-based tariffs.
What Happens After Uploading?
Validation: Zero Friction checks the file for errors. If issues are found, the status changes to "problems found." Download the file to review and correct errors.
Approval: After a successful upload, tariffs are locked until you manually approve the upload.
Changes: Need to make changes? Cancel the upload or approve it and make manual adjustments in Zero Friction.
Note: Only unapproved uploads can be reverted.
Note: Only unapproved uploads can be reverted.