Bulk Subscription Update

Fusebill's bulk job functionality allows you to manage your recurring customer base in a bulk fashion in order to save time and improve accuracy.

Bulk Subscription Update is available as a job.

Use this functionality to submit a CSV file of specific subscriptions that you would like to edit.

The bulk subscription update allows you to edit high level subscription fields that control how the subscription is labelled and timing elements of the subscription.

You do not need to submit all subscriptions fields but you must identify the subscriptions you wish to edit by supplying a unique Fusebill generated subscription Id (available from the Subscription reporting from within Fusebill), alternatively, you can identify the subscriptions by subscription name (however you must ensure that you are setting unique subscription names as part of your business process)

Because this job operates as an edit you must specify if you wish to delete existing values in a field by submitting the special string "clear".  Any fields submitted with a blank value will be ignored by the bulk editor.

Fields that can be controlled

Subscription Name

Subscription Description

Subscription Reference

Scheduled Activation Date

Contract Start Date

Contract End Date

Expiry Periods

File Format

The Bulk Subscription update job requires the upload of a CSV file with up to 8 columns.

The file must have a header row containing at least one of the following fields

• SubscriptionId
• SubscriptionName (note that names must be unique)

Sample of a full Bulk Subscription Activation file:

 Field definitions:

Restrictions:

the file must contain at least 2 columns

the file must contain a header row with specific header names

the file cannot contain more then 1000 subscriptions

subscription ids provided must exist and belong to your account

if using subscription names instead of subscription ids then names must be unique

blank field values will be ignored

submitting the specific string "clear" must be used to set a field value to null

Date values submitted will be interpreted in your account timezone

Scheduled Activation timestamp cannot be modified on subscriptions that have already generated financial records