"Custom MSP Pricelist" Field
- Panagiotis Papanastasiou
On this page, you will find the analysis for the Custom MSP Pricelist field of the Acronis Service Manager for MSPs along with an analysis on how to create an Excel file to upload it to the aforementioned field in case you have received special (custom) prices from your Acronis distributor.
Cloud administrators now have the option to upload custom pricing from their Acronis distributors in the “Custom MSP Pricelist” field within each Acronis Service Manager MSP instance and utilize this custom pricelist for invoicing Acronis SKUs with these custom unit cost prices.
Locating the “Custom MSP Pricelist” Field
This field allows cloud administrators to choose between utilizing the uploaded “Custom MSP Pricelist” or the default Acronis Pricelist for invoicing. If a Custom MSP Pricelist Excel file is uploaded to the respective optional field, then the default Acronis pricelist in the Acronis Service Manager will only be used to retrieve prices for SKUs that are not included in the “Custom MSP Pricelist” Excel file.
There are two instances when Acronis Usage Prices are obtained from the default Acronis Pricelist instead of the "Custom MSP Price List":
1: The "Custom MSP Price List" has not been uploaded to the Acronis instance.
2: The "Custom MSP Price List" has been uploaded, but the SKU is not present in it.
Creating a “Custom MSP Pricelist“ Excel File
To create a Custom MSP Pricelist Excel file, you’ll need to enter all the custom prices in each spreadsheet tab designated for different currencies. In each tab, the first column (Column A) should be reserved for SKU codes, while the second column (Column B) should list the custom prices based on your tier number for that specific currency. Ensure you have a separate spreadsheet for each currency you are working with.
Please refer to the table below for rules and details on how to create the Custom MSP Pricelist Excel file.
Rules for Creating a Valid “Custom MSP Pricelist“ Excel File
The following rules must be met for an Acronis Excel file to be considered valid:
Rules | Condition | Extra Clarification Notes |
|---|---|---|
1- File Format | The file format should be an Excel file (.xlsx or .xls) |
|
2- Excel File Tabs |
| Each tab corresponds to a single currency, so the more currencies you want to include inside the Excel file, the more tabs you need to create for each currency that will contain the custom price values specific to that currency. |
| Each Tab in the “Custom MSP Pricelist“ Excel file must contain at least the following 2 columns.
| When the “Tier from Acronis” field is defined in your Acronis Service Manager MSP instance, the “Column B” should contain the corresponding name associated with the Tier returned by Acronis. For example, if your Acronis Tier is “Tier 2,” then that should also be the title of “Column B.” |
The Excel file has the following format
You can also check the following example Excel file on how the “Custom MSP Pricelist“ should look without values:
Hybrid Storage Extra Charge(%)
The "Hybrid Storage Extra Charge(%)" DOES NOT APPLY when a "Custom MSP Pricelist" file is uploaded to the Acronis instance. Specifically:
Prices for Hybrid SKUs that are INCLUDED in the custom pricelist will be calculated using "Custom MSP Pricelist" file, ignoring the "Hybrid Storage Extra Charge(%)".
If a Hybrid SKU is NOT INCLUDED in the "Custom MSP Pricelist" and the "Hybrid Storage Extra Charge(%)" is greater than 0, the price will be retrieved from the default Acronis Pricelist, ignoring the "Hybrid Storage Extra Charge(%)"..
Uploading the “Custom MSP Pricelist” Excel File and Saving the Acronis Instance
When uploading the Custom MSP Pricelist Excel file to the respective field and saving the Acronis Service Manager MSP instance, the system performs a series of validations on the uploaded file, and if everything checks out, then the platform will utilize this custom pricelist to invoice the Acronis products that are included within that custom price list. Otherwise, the platform will display relevant error messages depending on the case, and until these errors are solved the system will continue utilizing the default Acronis Pricelist.
The table below outlines the execution flow of validations, illustrating the order in which each validation is conducted.
Condition | Error message | Execution Order |
|---|---|---|
The Commitment Tier is “Tier from Acronis“ and the Tier value is not defined in Acronis. Acronis has not yet defined the Tier for this MSP. | Τhe Tier from Acronis has not been defined. Please contact to Acronis. | 1 |
Empty file having size 0 KB is uploaded | The "Custom MSP Pricelist" Excel file is empty. | 2 |
Supported file format are .xls & .xlsx. | This file format “file_format“ is not supported. Please use .xls and .xlsx file format. | 3.1 |
Acronis Service Manager cannot fetch the file from the BSS portal. | The Service Manager did not manage to fetch the file from server with HTTP status code ‘{statusCode}’. | 3.2 |
The upload “Custom MSP Pricelist“ file contains one or more tabs with no data, no header & no rows. | The of "Custom MSP Pricelist" Excel file is empty. | 3.3 |
The upload “Custom MSP Pricelist“ file contains one or more tabs with invalid names. | The "Custom MSP Pricelist" Excel file contains tabs with names that are not in the supported currencies (EUR, USD, AUD, GBP, JPY, or CAD). | 3.4 |
The “Custom MSP Pricelist“Excel file should always have at least 2 columns. | The tab “Tab_name“ in “Custom MSP Pricelist“ excel file must always contain at least 2 columns. | 3.5 |
The first column found header in “Custom MSP Pricelist“ excel file should always named “SKU”. | The first column header of tab “Tab_name“ in the "Custom MSP Pricelist" Excel file, currently labeled 'header_column1', must always be named "SKU". | 3.6.1 |
The second column header in the "Custom MSP Pricelist" Excel file contains invalid values; it should be one of the following: Promo Tier, Tier 1, Tier 2, Tier 3, Tier 4, Tier 5, Tier 6, or Tier 7. | The second column header of tab “Tab_name“ in the "Custom MSP Pricelist" Excel file, currently labeled 'header_column2', is invalid. | 3.6.2 |
The “Custom MSP Pricelist“ excel file does not contain any entries. (Like the sample file, where just the headers are there) | The tab “Tab_name“ in the "Custom MSP Pricelist" Excel file is empty. | 3.7 |
Values in the SKU column of “Custom MSP Pricelist“ file are empty. It applies per row (except header) | The first column of tab “Tab_name“ in the "Custom MSP Pricelist" Excel file currently labeled ‘SKU' must always contain values (’lineX'). | 3.8.1 |
The 2nd column found in “Custom MSP Pricelist“ excel file should always have values. The following error is displayed when this column contains no values (prices) and this applies to each row. | The second column of tab “Tab_Name “ in the "Custom MSP Pricelist" Excel file currently labeled 'header_column2' must always contain numeric values(LineX) | 3.8.2 |
The "Custom MSP Pricelist" Excel file includes SKUs that appear multiple times. | The tab “Tab_name“ in the "Custom MSP Pricelist" contains the SKUs “AAA, BBB, CCC, etc“ more than once | 3.9 |
The “Commitment Tier” selected in the Acronis MSP Instance differs from the Tier specified in the “Custom MSP Pricelist“Excel file. This applies in scenarios where the the “Commitment Tier“ in Acronis MSP instance is set to “Tier from Acronis“ and Acronis returns a different Tier than the one specified in the Acronis instance. The B column should always have the correct Tier #. | Τhe “Commitment Tier” selected in the Acronis MSP Instance is different from the Tier specified in the tab “Tab_name1, Tab_name2, Tab_name 3, …..“ of “Custom MSP Pricelist“ Excel file. | 4 |
Inspecting “Usage Records” in the BSS Subscription View Page
With the Custom MSP Pricelist uploaded, the system calculates the "Estimated Cost", in the "Usage Records" tab of the BSS subscription view page, based on the custom unit price that is retrieved from the tab of the "Custom MSP Pricelist" that matches the currency of the subscription: