3YC Product Pricing

Owned by Oleg Melnykov (Deactivated)
Last updated: Feb 08, 2024 by Panagiotis Papanastasiou
3 min read

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:

3ycpf-20240116-075332.png

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.

Please note that modifying the Excel columns First Order Date & Last Order Date to display the correct type and format is the responsibility of the BSS user.

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 qualifies for the 3YC pricing file, but only for licenses, a transaction order retrieves prices from the 3YC pricing as well. If the related SKUs are not available in the 3YC pricing file, the non-3YC amounts will be retrieved by the external pricing mechanism.

  • If an account has accepted a new or second commitment request, the start date of the existing commitment will not change, and the prices will be retrieved from the 3YC pricing file.

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.