Skip to main content

Order Item Data Source

Zuora

Order Item Data Source

The following Order Metrics have been deprecated. Any new customers who onboard on Orders or Orders Harmonization will not get these metrics.

  • The Order ELP and Order Item objects
  • The "Generated Reason" and "Order Item ID" fields in the Order MRR, Order TCB, Order TCV, and Order Quantity objects

Existing Orders customers who have these metrics will continue to be supported.

The Order Item feature is only available to existing Orders customers who already have access to the feature.

An order item is a sales item within an order in the context of the recurring subscription business model. It can be a unit of products or service, but defined by both quantity and term (the start and end dates).

For the one time and the recurring charge types, if an order action causes a quantity metric creation (when the delta quantity equals to or is greater than zero), an order item is created. The following order actions will create an order item for the one time and recurring charges. The other order actions will refer to an existing order item. Also, the Owner Transfer order action always creates an order item whose quantity field is zero.

  • Create Subscription
  • Terms and Conditions - Extend Term
  • Renewal
  • Update Product - Increase Quantity
  • Add product
  • Owner Transfer
  • Resume

For the usage charge type, if the order action causes a usage increase, an order item is created, and the quantity field of the order item is always set to zero. The following order actions will create an order item for the usage charges.

  • Create Subscription
  • Terms and Conditions - Extend Term
  • Renewal
  • Add product
  • Owner Transfer
  • Resume

Use this data source to report on the order items. 

For example, let’s say that you create an order containing the following order actions:

  • Order Action 1: Add a rate plan with a recurring charge with the unit price being $2 per unit per month and the quantity being 0 units. The term starts on 1/1/2018 and ends on 12/31/2018.
  • Order Action 2: Update the product and increase the quantity to 15 units per month on 4/1/2018. 
  • Order Action 3: Update the product and decrease the quantity to 12 units per month on 6/1/2018.

In this scenario, Zuora will create two order items for the order. An order item will only be created if the Quantity metric's amount equals to or greater than zero.

Order Action Start Date End Date Quantity
Order Action 1 1/1/2018 12/31/2018 0
Order Action 2 4/1/2018 12/31/2018 15

The following objects are available in the data source.

Object Description
Order Item
  • Created By ID - The Zuora user who created the order item.
  • Created Date - The date when the order item was created.
  • End Date - The order item's effective end date, aligned with the end date of an increased quantity order metrics (as a result of the Create Subscription, Renewal, Extend Term, Add Product, and Update Product order actions).
  • ID - The ID of the order item.
  • Quantity - The order item quantity. For the usage charge type, the value of this field is always zero. Also, the Owner Transfer order action always creates an order item whose Quantity field is zero.
  • Start Date - The order item's effective start date, aligned with the start date of an increased quantity order metrics (as a result of the Create Subscription, Renewal, Extend Term, Add Product, and Update Product order actions).
  • Updated By ID - The Zuora user who last updated the order item, now equals Created By ID.
  • Updated Date - The date when the order item was last updated, now equals Created Date.
Amendment The amendment that is tied to the rate plan, if applicable. 
Entity

The entity that the data relates to. Part of the Multi-entity feature. Contains the following fields:

  • Address 1
  • Address 2
  • City
  • Country
  • Created By ID
  • Created Date
  • Display Name
  • Email
  • ID
  • Name
  • Postal Code
  • State
  • Updated By ID
  • Updated Date
Order

The order you want to view the order action information for.

Order Action The order action you want to get the TCB metrics for.
Product The product information.
Product Rate Plan The rate plan coming from the product catalog.
Product Rate Plan Charge The product rate plan charge information coming from the product catalog.
Rate Plan Refers to the rate plan or pricing plan information associated the subscription.
Rate Plan Charge The charge information associated with the subscription.
Subscription

The subscription to which the rate plan is associated. Contains the following fields:

  • Auto Renew
  • Cancelled Date
  • Contract Acceptance Date
  • Contract Effective Date
  • Cpq Bundle Json ID
  • Created By ID
  • Created Date
  • Creator Account ID
  • Creator Invoice Owner ID
  • Current Term
  • Current Term Period Type
  • ID
  • Initial Term
  • Initial Term Period Type
  • Invoice Owner ID
  • Invoice Separate
  • Name
  • Notes
  • Opportunity Close Date
  • Opportunity Name
  • Original Created Date
  • Original ID
  • Previous Subscription ID
  • Quote Business Type
  • Quote Number
  • Quote Type
  • Renewal Setting
  • Renewal Term
  • Renewal Term Period Type
  • Service Activation Date
  • Status
  • Subscription End Date
  • Subscription Start Date
  • Term End Date
  • Term Start Date
  • Term Type
  • Updated By ID
  • Updated Date
  • Version