Skip to main content
SubscriptionFlow Docs
Import Advanced Subscriptions

Paused, Expired & Canceled Subscriptions Import

Updated expired subscriptionscancelled subscriptionspaused subscriptions

Subscriptions (1).jpg

This guide shows you how to import gift evergreen and termed subscriptions, after first successfully importing Customers, Products & Plans.

Sample File/s:

Evergreen Advanced Subscriptions Sample File

Termed Advanced Subscriptions Sample File

Step 1: File Prep

First prepare your file for import. 

Use any spreadsheet software to organize your data and export to a CSV format in the final step. For detailed guides on how to import evergreen and termed subscriptions refer to their respective guides. 

Termed Paused/Canceled/Expired Subscriptions

The following columns/fields are required for the successful import of paused/canceled/expired subscriptions that are termed. Note that the fields with a black asterisk are not required but are essential to define the paused, expired, and canceled statuses. 

Subscription
Customer id* A unique identifier tying a subscription to a specific customer.
Term Initial Period* A numeric value quantifying the term in which the subscription will be active. e.g. 12, 6, etc.
Term Initial Period Type* The unit of time that defines the initial term in which the subscription will be active. e.g. month, year, etc.
Term Start Date* A date corresponding to the day the subscription is activated and the initial term commences.
Canceled at (*) The date on which the subscription was canceled.
Paused at (*) The date at which the subscription was paused/suspended.
Resumed at (*) The date at which the subscription was resumed.
Line Items
Product id* A unique identifier tying a subscription to a specific product being purchased.
Plan id* A unique identifier tying a subscription to a specific plan that is attached to this product.

Evergreen Paused/Canceled/Expired Subscriptions

The following columns/fields are required for the successful import of paused/canceled/expired subscriptions that are evergreen. Note that the fields with a black asterisk (*) are not required but are essential to define the paused, expired, and canceled statuses. 

Subscription
Customer id* A unique identifier tying a subscription to a specific customer.
Subscription Start Date* A date at which the subscription is activated.
Canceled at (*) The date on which the subscription was canceled.
Paused at (*) The date at which the subscription was paused/suspended.
Resumed at (*) The date at which the subscription was resumed.
Line Items
Product id* A unique identifier tying a subscription to a specific product being purchased.
Plan id* A unique identifier tying a subscription to a specific plan that is attached to this product.

Step 2: File Upload

  1. Enter the ‘Subscriptions’ module from your dashboard. Click on **'**Import Subscriptions’ if you are onboarding or the 'Import' button in the top right for subsequent imports.

Screenshot 2024-04-25 at 1.03.29 PM.png

  1. Next, select the type of subscriptions you are importing. Under ‘Advanced Configurations’ select Yes for the “Are you going to import any Paused/Expired subscriptions?” option.

  1. Browse and upload your CSV file.

  1. Here is some sample data.

  1. The CSV has been uploaded. Click ‘Next’.

Upload your Files

On Data Preview & Mapping, click Analyze with AI to let AI clean your file and pre-fill the column mappings, or Skip & Map Manually to map the fields yourself.

AI Data Refinement

Step 3: Field Mapping

  1. Next, map the fields in your file to the fields inside SubscriptionFlow. (For a detailed mapping guidance go to our guide on importing termed subscriptions.) Note that the ‘Cancel at’, ‘Resume at’, and ‘Pause at’ fields are not required but should be present if applicable.

Field Mapping 

  1. Select your date format & import preferences and click ‘Next’.

Date format, Save field mapping and Next

Read our subscription import guide for a detailed breakdown of these configurations.

  1. Allow the import to complete and go back to the subscriptions module to see new paused/expired/cancelled subscriptions that were created via import.

 

Imported records

Step 4: Troubleshooting Errors

  1. If your records were not created, open Import Data (the Import button on the module list) and click History.

Import History

  1. Click on the import you want to troubleshoot.

Import History

  1. Scroll to the far right to find any errors that occurred during import that caused it to fail.

 

Import finished

And just like that you have imported paused/expired/canceled subscriptions.

Was this article helpful?0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.