Uploading a 3YC Pricing File
BSS Users may upload a special 3YC Pricing File to the BSS, which will be used to retrieve prices and bill customers.
The file must be specified in the 3YC Pricing File field in the Adobe instance:
Please note that the 3YC pricing file contains only 3YC levels and tiers (12, 13 & 14, TA, TB, TC, TD, TF & TG).
Spreadsheet Requirements
The 3YC pricing file has the same format and contains the same columns as the as the pricing file which is uploaded monthly by BSS users. In addition to the contents of a regular pricing file, the Adobe 3YC Pricing File is required to have the following:
A column titled First Order Date
A column titled Last Order Date
No empty rows in the First Order Date column
No empty rows in the Last Order Date column
An error message will be displayed if any of these conditions is not met.
Date Format
Adobe uses the UTC date offset regardless of the country of each organization. The .csv file downloaded by distributors monthly should be changed to the supported type (.xlsx or .xls) to be uploaded to the Adobe instance.
Please refer to the page https://interworkscloud.atlassian.net/wiki/spaces/ICPD/pages/830768041/Adobe+VIP+MP+Volume+Discount#Revising-the-Pricing-Excel-File for instructions on how to change the format of the related columns to Date (MDY or DMY) using the text to columns function.
How the 3YC Pricing File is Used
If a customer accepts their 3YC offer within the date range specified in the 3YC pricing file (between the First Order Date and the Last Order Date), the service manager will retrieve the corresponding amounts and send them back to BSS. Otherwise, the amounts will be retrieved from the default pricing file (not 3YC).
Please note the following two cases:
If an account is committed to a license amount and qualifies for the 3YC pricing file, a new transaction order would obtain non-3YC tiers from the default non-3YC pricing file.
If an account has accepted a new or second commitment request, the start date of the previous commitment will be updated and the prices will be retrieved from the corresponding pricing file (default).
If the platform user has not uploaded the 3YC pricing file on the Adobe instance, retrieving the price for a 3YC account that qualifies for the 3YC pricing file will result in the following error message:
Unable to define product price. Please upload the 3YC pricing file.
Migration Process
The price retrieval flow described in the section above has also been applied to the migration process. The validations applied to the 3YC Pricing File will also be applied to any entities imported through the VIP MP tool in the Storefront.
If the migration process fails during the last step of the VIP MP tool (upon subscription creation) with the message ServiceError, Internal Server Error, it is possible that the 3YC pricing file has not been uploaded.