Importing/Updating Adobe Products & Prices to BSS


In the interworks.cloud platform, you can import all the Adobe products under the "Adobe Services" Product Type, by utilizing the Product Importer. Since there are different preparation steps between the Adobe Sign products and the Adobe Teams/Enterprise products, you will find the pages for each preparation analysis on the linked pages that follow. However, on this page, you will also find the actions required before the import/update preparation as well as the steps after the import/updates has been performed.

Importing the Adobe Products and Base Prices in the BSS Platform


The first step is to manually import the Adobe products and their base prices to the BSS platform. To do this, one must initiate the import of the Adobe products catalog by utilizing the Excel file that is issued to all the distributors of Adobe each month.

Downloading the Official Adobe Excel File Containing Products & Base Prices

Each distributor has his own set of SKUs & prices that he sells from Adobe, which can be found in the Excel spreadsheet that can be downloaded from the "Adobe Partner Portal".
You have to log in with your credentials as a Distributor, and then you can download the Excel with the products and the prices from the indicated section:

The Excel file contains the distributor’s cost & sell base prices with no margin or markup included. 

Preparing the Excel File for Each Type of Adobe Products 

Once you acquire a copy of Adobe's official Excel file, which contains the list of the products along with their pricing, you need to make two important changes to the Excel file before continuing with the two guides that follow!

  • First, you have to remove the Adobe Stock Credit Pack (asset) products from the Excel file. The removal of the Adobe Stock Credit Pack products from the Excel file is essential because these products are created/updated automatically and receive also automatically their prices from the Get Services Definition process via the Adobe Service Manager.

  • Then, you have to sort the “Additional Detail” column of the Excel file by choosing the option “Sort A to Z”. This sorting is essential because it achieves the grouping of all the same “Part Numbers” with the “Additional Details” before the import. If this step is not performed, it might affect the next stages of the preparation of the Excel file within the two following guides (#1 & #2).

    Adobe new image for sort.png

Lastly, you have to proceed to prepare the Excel file twice by following the two different import/update guides. The first guide(1) addresses the import/update of the Adobe Teams and Adobe Enterprise products, whereas the second guide(2) addresses the import/update of the Adobe Sign products.

1. Importing/Updating Adobe Teams and Enterprise Products & Base Prices to BSS

https://interworkscloud.atlassian.net/wiki/spaces/ICPD/pages/830767114

-After the steps of the Adobe Teams and Enterprise have been completed, you can proceed to the page section “Uploading Final Prices“ and onwards.

 

2. Importing/Updating Adobe Sign Products & Base Prices to BSS

https://interworkscloud.atlassian.net/wiki/spaces/ICPD/pages/830799888

-After the steps of the Adobe Sign products have been completed, you can proceed to the page section “Uploading Final Prices“ and onwards.

Uploading Final Prices

For uploading the final prices, containing official Adobe discounts, into our system, please check the guide on the Adobe VIP MP Volume Discount page.

Updating the Adobe Products and Prices in the BSS Platform


The update of the Adobe products and prices will happen again via both the Product Importer tool and the Adobe service manager instance Pricing file field.

  • If prices have changed, by matching the respective Excel column with the annual cost & sell prices, the BSS add-on prices will be updated to the new values during the import via the Product Importer tool, but the final prices will be dictated to our systems by uploading the latest official Adobe Excel file inside the Pricing file field located under each Adobe VIP MP service manager instance, and then saving the instance after the upload.

  • If new products are added, the Importer will create them as expected since no match will be found with the existing BSS add-ons.

  • If discontinued products are introduced, then this means that the update cannot handle that situation automatically. As a result, if a set of SKUs is no longer available in the Excel file, the Importer will not deactivate these add-ons automatically (or add the Discontinued status) in BSS.
    You are responsible for cross-checking the previous Excel file with the new one to find any differences (regarding discontinued SKUs), and, accordingly, make the required manual changes in the BSS platform.

During the preparation of the update process, you need to use as identifiers the following two fields:

  • Product Code → Part Number

  • Product Type → Adobe Services

 

Assigning Add-ons to Adobe Product Container


After the Import process has finished and the Adobe products along with their prices have been added to the BSS platform as Add-ons, you have to relate all those (57+30) add-ons to the "Adobe Services" container product. The container product is the mean for publishing the Adobe products to your Storefront and accepting orders via both platforms (BSS & Storefront). To proceed with the assignment of the add-ons to the Adobe container product, you first have to locate it. Navigate to BSS > Billing > Products and on the right-hand side of the Product's List page, you can utilize the Search option by filling in the name of the product "Adobe Services". Once the product is found, its product page is loaded automatically, and from there, you can click on the Add-ons option located under the Shortcuts menu.

Then choose the Assign option in order to allocate all the relevant Adobe add-ons to this container product. Upon doing so, a pop-up window is displayed where it contains all 87 Adobe add-ons.

By clicking on the upper left checkbox, and then clicking on the Add button, all the add-ons are successfully assigned to the "Adobe Services" container product.

 

Publishing the Adobe Product with the Add-ons in Storefront


You can publish in your Storefront the Adobe products(in the form of add-ons) under the Adobe container product called "Adobe Services". 

First, make sure that each one of the 87 add-ons is published in Storefront. You can do that by gathering all the Adobe add-ons. 
Please navigate to BSS > Billing > Products and from the products' list page, select the "Advanced Search..." option located on the right-hand side of the list.

Afterwards, create the following two Advanced Search conditions:

  • Field Name: "Is Add-on" - Operator: "is equal to" - Value: "Yes"

  • Field Name: "Product Type" - Operator: "is equal to" - Value: "Adobe Services"

Click on the Search & Close button to initiate the search.

The results of the search will appear on the products' list where all the Adobe add-ons will be gathered.

Now, all you have to do is open each Adobe add-on, click on the "Storefront Settings" option, and click on the checkbox "Publish to Storefront".

After publishing all the Adobe add-ons to Storefront, you have also to publish the Adobe container product in Storefront.

The method for configuring the Basic Storefront Settings of a product, is the same followed for any other product.