You can export Product Inventory data to an Excel file for analysis or to update prices:
-
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 Export.
-
In UX1, go to Portfolio > Prices and click Export.
Optionally, select a vendor, if you want to export products only for one vendor.
-
-
Click Finish to download an Excel file with the Product Inventory data.
Note: In Product Inventory, you can see only products that are published. The exported file contains both published and not published products. The Active column in the exported file helps you understand whether the product is published: True means published, False means not published.
The exported file will contain the information about the products offered by this account. In this table you can find the list of columns in the exported file and their description.
| Column Name | Column Description | Example Value |
|---|---|---|
| MPN | Manufacturer Part Number (MPN) is a unique identifier of the product, which is typically obtained from a vendor. | 806ge7a9-bc50-4271-bc8b-351c2a1c07fd
|
| Application | The name of the application that is used to provide the resource associated with the MPN. | Sample Service Activation
|
| Product | Name of a product, which is taken from the service plan. | VPS Cloud - Antivirus - Service Activation Project
|
| Billing Period | Product billing period. | 1 month
|
| Subscription Period | Product subscription period. | 1 year
|
| UOM | Product units of measurement. | unit-hours |
| Price Currency | The default currency of this reseller. | USD
|
| Price | Product price. | 4.68
|
| Fee Type | Product fee type. Can be Setup, Recurring, or Overuse | Recurring
|
| Subscriptions | The number of active subscriptions that include this product. | 87
|
| Seats | The number of product seats. | 125
|
| Active | Indicates, whether all service plans that include this resource are published. | False
|
The exported price list file name uses the following format: <Account_ID>-Price-list-<Date>-<Vendor_ID>.xlsx, where:
- <Account_ID>: ID of an account for which the price list is exported,
- <Date>: The date when the price list is exported in the dd-mm-yyyy format,
- <Vendor_ID>: ID of a specific vendor if selected during exporting.