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. |
Updated about 3 years ago