Items — Associated Subscriptions

The Items - Associated Subscriptions export contains information about all subscription add-ons created from a saved item in your catalog during a period of time.

This export only reports on add-ons that are currently attached to renewing, future start, last billing period, and paused subscriptions. If an add-on has been removed from a subscription, or if a subscription has expired or has been canceled, the subscription will not be included in the export.

Time Range Filter

This export includes all RENEWING, FUTURE START, LAST BILLING PERIOD, and PAUSED subscriptions with a saved item add-on created during the selected timeframe. Uses the "subscription_add_on_created_at" date in the export.

Export Contents

Column Name

Example

Description

item_id

l20fl6bek3mp

The system-generated unique internal identifier of the saved item used to create this add-on.

item_name

Pink Sweater

The name of the saved item used to create this add-on. This is also the add-on name, which will appear on the customer's invoice.

item_code

pink_sweater

The unique Recurly identifier of the saved item used to create this add-on. This is also the add-on code.

external_sku

PS1234

The optional external SKU of the saved item used to create this add-on.

item_status

enabled

The status of the item in your Recurly catalog. Can be "enabled" or "disabled".

plan_code

platinum

The unique Recurly identifier of the plan associated with this subscription.

plan_name

Platinum Plan

The current name of the plan associated with this subscription.

subscription_id

3c42a34d1442f840

The system-generated unique internal identifier for the subscription that offers this item as an add-on.

subscription_add_on
_quantity

1

The number of add-ons added to the subscription for this item.

subscription_add_on
_unit_amount_in_cents

600

The cost (in cents) of a unit of the add-on on the subscription. Can differ from the default cost of a unit of the add-on on the plan, or from the default price of the item.

subscription_add_on
_currency

USD

The currency being charged with this subscription.

subscription_add_on
_created_at

2020-02-07 10:18:34 MST

The date/time the add-on was created. Used for date range filter.

subscription_add_on
_modified_at

2020-02-07 10:18:34 MST

The date/time the add-on was last modified.