Versions Compared

Old Version 19

changes.mady.by.user Oleg Melnykov

Saved on

compared with

New Version Current

changes.mady.by.user Panagiotis Papanastasiou

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Excerpt
This tool facilitates the update of all Microsoft 365 license-based products with prices from the official Microsoft partner center excel Partner Center Excel file. The process ensures that each month, the CSP catalog is maintained up-to-date.


Rw ui textbox macro
typenote

We advise to avoid Firefox browser for running the update prices tool and use the Chrome browser instead. We are facing some issues with Firefox that they will be solved soon.


Downloading the Latest Official Price List

Customers can obtain the latest Excel file for the license-based services which containing the official price list by accessing the Microsoft Partner Center. By navigating to the Pricing section and selecting the License-based services for the month that you would like to update the prices for.

Image Added


Accessing the tool

To access the tool, navigate to BSS Setup > Tools and open the Update Product Prices tool.

Image RemovedImage Added


Update Product Prices


  1. On the browser screen select 'Browse' and  and locate the Partner Center price excel file for the month you wish to update. The system also accepts custom excel files.

    Image RemovedImage Added

    1. Fill in the fields and click on 'Read Prices':

      Image RemovedImage Added

    2. Microsoft Cloud Services Instance: Select the instance for O365 services you want to update

    3. Excel Sheet: Select the excel sheet containing the currency information you need

    4. Currency: The currency of the system

    5. OfferID Column: The column of the product code (by default set to E based on standard MS excel file, but also capable of accepting custom excel files)

    6. Purchase Price Column (List Price): The Microsoft list price(by default set to J based on standard MS excel file, but also capable of accepting custom excel files). 

    7. Sales Price Column (ERP Price): The Microsoft ERP price (by default set to K based on standard MS excel file, but also capable of accepting custom excel files)

      Rw ui textbox macro
      typeinfo

      If the 'Browse' button  button is not available, then you might not have sufficient rights to run Flash content at your browser. To change this, navigate at your browser's 'Content' settings  settings and add an exception for the BSS URL!


  2. The system will read the file and proceed to display the results. The process matches the SKU's from the excel file vs the SKU's that are linked to the selected instance and then proceeds to also match the price information. So, the cases are: products that have been matched in both the system and the file, products that exist in the file, but not in the system and products that exist in the system and not in the file. The process will display the prices for both file and system where available.

    Image RemovedImage Added

    1. OfferID: the MS SKU

    2. Name: The name of the product

    3. Purchase Price: The list price in both the excel file and the system

    4.  Sales Price: The ERP price in both excel and system

    5. Status: The system displays here the result of reconciliation

  3. Clicking 'Import Prices' will update the system with the displayed prices

    Image RemovedImage Added


Table of Contents

Table of Contents
excludeTable of Contents



Watch Here The Related Training Video

Widget Connector
urlhttps://www.youtube.com/watch?v=-5mTST9Lr6o

* For full-screen video playback, please click on the Youtube  icon located next to the Fullscreen  option at the bottom right corner.