In the interworks.cloud platform, you can import the Adobe Teams and Adobe Enterprise products under the "Adobe Services" Product Type, by utilizing the Product Importer. This is a different import action than that of the import of Adobe Sign products via the Product Importer, since the following import analysis addresses only the Adobe Teams and Adobe Enterprise products, along with their available three year commitment options.

Preparing the Excel File for Each Unique Product 

The first step of editing the Excel file, is first to open it and create a filter for the whole Excel file, by selecting the whole table of the file and clicking on the Data tab while selecting the Filter option. By doing that, you will be helped later on during the following preparation steps.

Then, you need to remove the Adobe Sign SKUs from the Product Family column, so as to be left with all the other product families.

For the second step, once the filter is placed on the Excel file, you need to add two new columns, named Concatenated SKU (1) and Concatenated Product Name (2):

• Concatenated SKU: This new column must contain the different codes (representing the respective levels) of each unique SKU. 
  1. Since we have no automated way to make this distinction, this responsibility lies upon the BSS user. 

     The distributor must 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). Please also note that the extra licenses of the three year commitment option along with the existing license SKUs are depicted under the Level Detail column with the annotation 1, 2, 3, 4 and 12, 13, 14, respectively. These must also be included for each unique product, that are available:

     

     _{The screenshot is taken before the addition of the two new columns.}

     Once each unique product is found, the BSS user must add to the Concatenated SKU column their concatenated values, separated by a comma “,”. The concatenation formula for this column, after its creation, is the following: =CONCATENATE(I2;",";I3;",";I4;",";I5;",";I6;",";I7;",";I8) where I stands for the column with the Part Number. The formula numbers next to the letters correspond to the number of the row. You can change the formula respectively so that the letters and numbers match the respective columns. Also, please note that since the introduction of the three year commitment option, the concatenation formula has changed from four values to seven values.  

     

     _{The screenshot is taken before the addition of the two new columns.}

     The final Concatenated SKU column must look like the following screenshot.

     

     _{The screenshot is taken after the addition of the two new columns.}

• Concatenated Product Name: This new column must contain the combinations of the Product Family names and the Additional Detail names where the former indicates the TLP MIGRATION products and the INTRO FYF offer products. 
  
  1. Since we have no automated way to make this distinction, this responsibility lies upon the BSS user. 

     The distributor must filter the Additional Detail column (marked values in yellow color) only for the products TLP MIGRATION and INTRO FYF, by clicking on the Additional Detail column drop-down filter (arrow) and selecting the two aforementioned product descriptions and then clicking on the OK button.

     

     _{The screenshot is taken before the addition of the two new columns.}

     Once the list is filtered for each unique product combination, the BSS user will need to first copy all those filtered results from all the columns and rows and paste them exactly at the end of the list.
     

     After pasting the filtered results exactly below the filterest list, and since the filtered results skip rows in the Excel file, the BSS user must now be extra careful in manually deleting the initial filtered results (blue-colored numbers) line by line without affecting the in-between non-filtered rows or the copied ones.

     Once the careful deletion of the rows with the blue-colored numbers is complete, the BSS user needs to click on the Additional Detail column drop-down filter (arrow) and remove the filter by selecting the (Select All) checkbox option. If everything was done correctly, the non-filtered results and the copied filtered results must be displayed on the Excel spreadsheet, and no blank rows must be present within those data. If there are blank rows between the rows, please carefully delete them.

     When all the above steps are completed, the BSS user must add to the Concatenated Product Name column their concatenated values, separated by a comma “,”. The concatenation formula for this column, after its creation, is the following: =CONCATENATE(K2;" ";"(";R2;")") where K stands for the column with the Product Family names and R stands for the column with the Additional Detail names. The formula numbers next to the letters correspond to the number of the row. You can change the formula respectively so that the letters and numbers match the respective columns.

     

     _{The screenshot is taken before the addition of the two new columns.}

     The final Concatenated Product Name column must look like the following screenshot.

     

     _{The screenshot is taken after the addition of the two new columns.}

The third step of the Excel file preparation, is to add a new column named Primary/Addon.

This final Excel sheet must be uploaded onto the BSS products importer tool for the Adobe Teams & Enterprise Products to be updated in your catalog each month. The upload also provides the BSS platform with the default base prices (not the final prices) without applying any discount levels. Please note that you are responsible to check every month if the Adobe's Excel file has any changes regarding new or discontinued products in order to be able to manually address those changes in your Adobe catalog each month.

Final Excel Results

This is what the final form of a prepared Excel file for import looks like.

The following Excel file example named Adobe Products Example.xlsx has undergone such a preparation. The file has its prices removed for compliance reasons.

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.

 To return to the parent page containing an analysis of how you can upload the final prices on the Adobe products and many more actions, such as publishing the Adobe Product Container along with the add-ons to the Storefront, please continue to the Importing/Updating Adobe Products & Prices to BSS - Main#Uploading-Final-Prices page.

 To proceed to the preparation and import guide for the Adobe Sign products, please continue to the Importing/Updating Adobe Sign Products & Prices to BSS page.