Accessing the Tool

To access the tool for importing the New Commerce Experience product prices, go to BSS > Setup > Tools and select Import New Commerce Experience Product Prices.

Open

Once the home page of the tool appears, you can witness that the tool does not require the BSS user to upload an excel file. Instead, the tool communicates directly with Microsoft through an API call and immediately fetches the prices for the New Commerce Experience products and add-ons based on the following options.

Open

• Microsoft Cloud Services Instance: This drop-down button provides the BSS user with the available MS instances for selecting the instance that the NCE is enabled. The default value is the first instance on the list.

• Market Country: This drop-down button is not configurable since it is based on the choice of the aforementioned drop-down button, as it automatically fetches the selected NCE Market Country that is tied to the previously selected instance. This field represents the final consumer country that the API call will fetch the respective prices for updating the NCE products and add-ons.

• Market Country Currency: This drop-down button contains all the currencies that you have activated in your organization. The default value is the first item on the list.

After defining the options, you can click on the Read Prices button for the tool to fetch the NCE product prices via the API call to Microsoft.

Currency Conversion for Unsupported Currencies from Microsoft

To market products in a currency that is not available in Microsoft’s excel sheet that the API call fetches automatically the prices from, the tool will guide you to do the following.
1. First select from the Market Country Currency the currency that your (final consumer) customer wishes to be billed with (e.x., BSD), which turns out to be an unsupported currency by Microsoft. Immediately afterwards, the tool displays two more fields that you can configure the currency conversion against a currency that Microsoft (MS) supports.
2. The FX Rate Of is the field that you can select your preferred currency that by default Microsoft supports (EUR) and will be used as the base for the currency conversion.

3. Once both the aforementioned currencies have been defined, you have to provide the respective Foreign Exchange rate value between the MS supported currency (EUR) to the MS unsupported currency (BSD), as shown in the screenshot below.

After specifying the options, you can click on the Read Prices button, for the tool to fetch the (EUR - supported by MS) NCE product prices via the API call to Microsoft and at the same time convert those prices to the (BSD - unsupported by MS) NCE product prices, based on the FX rate you have provided.

Loading & Importing the Prices

By pressing the "Read Prices" button, our importer will use as input the country as well as the currency defined on the Market Country and Market Country Currency drop-down lists, respectively. Then via the API call to Microsoft, the importer will search and fetch the prices for the NCE products. More specifically, once this currency is found, for each ProductID_SkuID combination, it searches for both the purchase and the sell prices, and the results are displayed in a list, such as the one that follows.

The results are displayed in a table list with the following columns:

• SKU ID: This is the unique combination of the SKU and the ID.

• Name: This is the name of the NCE product, containing the respective prefix and suffix.

• Purchase Price: This is the cost price of the product, having either monthly, annual, or both units enabled. The column is split between the current BSS value and the new value from Microsoft.

• Sales Price: This is the recommended sale price of the product, having either monthly, annual, or both units enabled. The column is split between the current BSS value and the new value from Microsoft.

• Currency: This is the previously selected Market Country Currency.

• Status: The status is based on the price difference between an existing NCE product in BSS with a newly established price for that NCE product that was fetched from the API call. The following values are applicable:

  • found: It means that the product already exists in the catalog, and no price change has been found between BSS and the latest prices from Microsoft.

  • found | price change: It means that the product already exists in the catalog, but a price change has been found between the BSS and the latest prices from Microsoft.

  • not found: It means that the product was not found in the catalog and as a result, no price update can occur.

If the current price in the BSS is different from the new price, the checkbox at the end of the line is checked. Otherwise, no update is required for this product.

To import the new prices into the BSS, select the Import Prices button. This action will update the purchase and sell prices of the selected products.

Table of Contents