Exporting Exporting

Exporting

Jordan Wheelock Jordan Wheelock

Outline:

Overview

  • Exports allow you to download a CSV of all subscriptions, orders, or audit logs within a time range.

How do I set it up?

  1. Go to your Skio Dashboard
  2. Click on Subscriptions on the left-hand menu
  3. Click Export on the top menu
  4. Select the type of export you want to receive and enter your email
  5. Click Export and wait to receive the CSV in your inbox (timing can vary depending on how large the export is).
Export options

You can choose to export either active subs or inactive subs.

  • Active subs: Will include subscriptions in dunning. See Dunning for more information.
  • Inactive subs: Will include cancelled subscriptions and paused subscriptions. See Pausing Subscriptions for more information.

Subscription exports

The export will produce one row for each subscription line. Because it is possible to have multiple products (lines) on one subscription, the total number of rows will not equal the total number of subscriptions for your store.

Export fields

 

Field Name

Description

status

ACTIVE: The subscription will renew in the future on the nextBillingDate.

FAILED: The subscription is in Dunning because the last billing attempt failed.

CANCELLED: The subscription is cancelled and will not renew.

statusContext

CHURNED: The subscription was passively cancelled because we had more than the configured number of failed billing attempts.

DUNNING: The subscription is in the dunning process. This statusContext will only be present when status is equal to FAILED.

 

subscriptionLineQuantity

The quantity of products for this subscription line.

subscriptionLinePrice

The per-unit price for this subscription line. To calculate the order value for this subscription line, you must multiply subscriptionLineQuantity with subscriptionLinePrice.

 

Order exports

This export will produce one line for each order in the selected time period. This will include all recurring and new subscription orders. Each order will be one line in the file and includes the order number, total price, user email, and more. 

 

Audit log exports


The export allows selected audit log events to be downloaded as a CSV file. This will contain the date of the event, the event type (what was selected on the export page), the user email, the subscription ID, and when the subscription was created. 

Export options: 

Screenshot 2024-03-20 at 1.29.09 PM.pngScreenshot 2024-03-20 at 1.29.31 PM.png

Screenshot 2024-03-20 at 1.29.48 PM.pngScreenshot 2024-03-20 at 1.30.07 PM.pngScreenshot 2024-03-20 at 1.30.37 PM.png

Was this article helpful?

1 out of 1 found this helpful

Add comment

Please sign in to leave a comment.