Important: This functionality is available only for a Provider or Resellers acting as Operating Units.
To update prices for existing products in Product Inventory, complete these steps:
-
The Prices menu item is available in both classic panel and in UX1. Depending on the panel, complete the steps below.
-
In classic panel, go to Services > Prices and click Update prices.
-
In UX1, go to Portfolio > Prices and click Update prices.
-
-
Browse for the Excel file with the updated prices to upload. The file must meet the requirements described in this section.
-
To update product prices, select the Price parameter.
-
Click Next.
-
If any mandatory columns cannot be identified, you will be prompted to map missing columns onto the ones from the file. Do this and click Next.
-
If the information about fee type is missing you will be prompted to select the fee type to be updated for the products in the file. If you are updating tiered prices, you will be prompted to choose the pricing model to which to apply the price changes.
Important: Price updates will be applied in all products from the uploaded file to the fee type selected in this step. Make sure that all products in the file has the same fee type.
-
Review the updated prices. To display current prices, and delta between the old and new price, select the Compare with current prices checkbox.
-
After you click Finish, a task for price update will be scheduled. When the task will complete, the changes will be applied.
Notes on uploading the Excel file
The following rules are applied when uploading the Excel file:
-
When displaying products or uploading a price list, Product Inventory ignores trial subscription periods.
-
Product Inventory does not create a resource rate period. It only works with existing ones.
-
If different prices need to be applied to subscription periods, each subscription period must have a resource rate period.
-
If the same prices must be applied to subscription periods, resource rate periods can be absent, or they can exist only for certain subscription periods. The price will be applied to the existing resource rate and existing resource rate periods.
-
If a plan contains only one subscription period, a resource rate period is optional.
-
The Subscription Period parameter is optional in the imported price list. The file may have an empty value for this column or not have this column at all. If so, Product Inventory applies the same price for all resource rates and resource rate periods that match other criteria from the price list row (MPN, vendor ID, billing period, and billing model).
-
The Billing Model parameter is optional in the imported price list. The file may have an empty value for this column or not have this column at all. If so, Product Inventory applies the same price for all resource rates and resource rate periods that match other criteria from the price list row (MPN, vendor ID, billing period, and subscription period).
-
When updating prices, Product Inventory works with both resource rate periods and a resource rate. Product Inventory takes a price for the resource rate from a resource rate period with the longest subscription period. A price in the resource rate is updated only together with such a resource rate period.