Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Version History

Version 1 Next »

In the interworks.cloud platform, you can import the Adobe products under the "Adobe Services" Product Type, by utilizing the Product Importer.


Importing the Adobe Products and Base Prices in the BSS Platform

The first step is to manually import to the BSS platform the Adobe products along with their prices. For doing 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.

Changing Products to Add-ons Prior to Import/Update

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. 

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 open the Excel file and add a new column named primary/addon. For each row of the excel file containing a product, you have to populate each field with the boolean value of "1" in order for the Product Importer to import the products as add-ons in the BSS. This action, of adding products as add-ons to the BSS platform, is performed due to how Adobe manages subscription cancellations.

Preparing the Excel File for Each Unique Product 

You need to continue editing the excel file in order to add in it, two new columns named:

Concatenated SKU: Which must contain the different codes (representing the respective levels) of each unique SKU. The concatenation formula is the following: =CONCATENATE(I2;",";I3;",";I4;",";I5)

Concatenated Product Name: Which must contain the combinations of names between the TLP products and the intro offers products. The concatenation formula is the following: =CONCATENATE(K610;" ";"(";R610;")")

Since we have no automated way to make this distinction, this responsibility lies upon the BSS user. 
The distributor will identify each unique product and its levels by taking into consideration the following excel columns; Product Family, Language, and Level detail (marked values in yellow color):

Once each unique product is found, the BSS user will need to add a column with their concatenated values, separated by a comma “,” and also keep only the highest price (Level 1 price) for upload. (marked values in green color)

The highest base price will need to be uploaded as it will be the default price without applying any discount levels.

Final Excel Results

The specific currencies will not be automatically activated on all Adobe products without the BSS user having to perform this action manually. This action is done via the Products Importer, as analyzed below, because we expect the currencies to be enabled in the product, as shown below, but also provide a basic sell & cost price for this currency.

Import Process

Since the products of Adobe in our BSS platform are handled as add-ons, the respective base prices along with the products can be easily imported as follows:
Under the Billing > Products section on our BSS, click on the "Import" button and select "Import Products".


On the pop-up window, click on Browse and locate the latest Excel file containing the current Month's product prices. 
Upon uploading the Excel sheet, under the first step of the import process, you select the values of the fields related to:

  • The Excel Sheet (dist_vipmpc_<currency>_<monthYEAR>), 
  • The currency (Your Currency), 
  • The product type category (Common Product Type),
  • The product type (Adobe Services),
  • And the pricing type (Recurring charge - Prepaid), as illustrated in the following image.    

    Click on the Next button to continue.

On the second step of the import process, you must match the columns of the Excel file with the target fields by creating a mapping.
Make sure that you populate the target field values as depicted in the following image.


Click on the Next button after selecting the proper values for each target field.  


On the third step of the import process, you are required to confirm the import by setting the "Responsible User" as well as the "Permission rule" based on which the process will be initiated.

Lastly, after finishing the import, inside the import report page, click on Close.

After the import, you will be able to see the added products having all the relevant base prices.

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.
    It is your responsibility to cross-check 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) 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 57 Adobe add-ons.


By clicking on the upper left checkbox, and then click 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 57 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 at 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 and click on the "Storefront Settings" option and then click on the checkbox "Publish to Storefront".


After publishing all the Adobe add-ons to Storefront you have to also 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.



Table of Contents

  • No labels