Preparing the Excel File for Each Unique Sign 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.

For the second step, once the filter is placed on the Excel file, you need to select the A column, navigate to “Data” (ribbon menu) > Text to Columns, and finalize the related wizard (Delimmited > Next > Comma > Next > Finish).

After that, you need to filter only the Adobe Sign SKUs (Product family column).

The third step of this process involves the manual creation of four new columns, namely, the Concatenated SKU, the Concatenated Product Name, the Primary/Addons, and the Usage Charge Rule, which are analyzed in the following four bullets.

The fourth step begins as soon as you complete the above-mentioned bullet points. More specifically, you have to remove any specific filters and filter only the Level 1 and Tier 1 Adobe Sign SKUs from the "Level Details Column".

For the fifth step, you need to copy and paste all columns (along with the column titles) of the filtered results to a new Excel sheet (as well as provide a new name for that newly created sheet), as depicted in the following screenshot.

This final Excel sheet must be uploaded onto the BSS products importer tool for the Adobe Sign 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 screenshot has its prices hidden for compliance reasons.

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

View file
name Adobe Sign Import Final File.xlsx height 250

The specific currencies will not be automatically activated on all Adobe Sign 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.

Rw ui textbox macro
type note
Unavailability of an Adobe Sign Product due to Order Dates The "Last Order Date" is the final date on which a product can be purchased. Correspondingly, "First Order Date" represents the first date that a customer can purchase a product. However, if an SKU is no longer available to order due to a date limitation, the order will be stopped from both BSS & Storefront while the following message will appear: “Adobe prod name” is not available for purchase from Adobe”.

Import Process

Since the products of Adobe in our BSS platform are handled as add-ons, the respective base prices along with the Sign 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 Teams & Enterprise products, please continue to the Copy of Importing/Updating Adobe Teams and Enterprise Products & Prices to BSS page.