Products

Overview

The Product table contains information associated with all products in CloudBilling. Products are the goods and services that are bought by a customer. In CloudBilling, products exist in an organised tree structure called Product Categories. Products that belong to the same category are grouped together using the Product Categories.

For example, consider a Microsoft NCE Licence configured in CloudBilling under All Products -> CSP Products -> NCE Licences. Here Licences is the parent category, CSP is the grandparent category, and All Products is the great-grandparent category. In the Products table, this structure is defined as:

1. ProductPath0 = All Products
2. ProductPath1 = CSP
3. ProductPath2 = NCE Licences

The Products table contains the product name and all the categories a product belongs to. Joining this table with the LineItems table can provide product-specific insights such as the product that generates the most revenue, and the most sold product category.

---

Fields

Name	Type	Description
Key	String	Primary Key - Product Table.
SourceID	String	A unique product id used in CloudBilling’s internal systems.
Name	String	The name of the product.
ProductPath0 . . . ProductPath9	String	Ten separate fields that represent the categories a product belongs to. There are only ten fields because no category structure has exceeded 10 fields yet.