Automating Subscription Reports

If you run the same subscription reports on a recurring basis, Ordergroove can save you time and send them to you automatically. 

 

 


Request automatic reports

Please reach out to help@ordergroove.com or let your Ordergroove contact know what fields you would like to include in your report from the list below. The subscription report will be uploaded daily onto the Ordergroove SFTP. 

Customization

You can also add a filter to narrow the export down to a specific group of your subscriptions. Let Ordergroove know if you want to add a filter, here are a few common examples.

  • Filter by Subscription Status: Live, Canceled, or All
  • Only include recent subscriptions: Created less than X days in the past
  • Only include older subscriptions: Created more than X days in the past

File Format & Available Fields

Your reports are generated as a CSV spreadsheet file containing the fields listed below. All reports follow the same naming convention: [client_name]_subscription_MMDDYYYYHHMMSS.csv.

FIELD NAME

MAPPING/DEFINITIONS  SAMPLE DATA

DATA TYPE

SAMPLE DATA

Merchant

Merchant's Name

String, up to 80 characters

Andy’s Vitamins

Ordergroove User ID

Customer ID in Ordergroove system

Int, up to 11 characters

988432

Merchant User ID

Customer ID in merchant system

String, up to 128 characters

941874

Create Date

Subscription creation date (MM/DD/YYYY)

Date, exactly 10 characters

01/09/2016

Create Time

Subscription creation time (MM/DD/YYYY HH:MM:SS)

Datetime, exactly 19 characters

01/09/2016 13:10:38

Start Date

Subscription start date (MM/DD/YYYY)

Date, exactly 10 characters

01/09/2016

Customer Status

Displays if the subscription was created by a new or existing subscriber

String, up to 128 characters

Existing

Subscription ID

Subscription ID in Ordergroove system

String, up to 40 characters

1610827

Offer ID

Offer ID in Ordergroove system

Int, up to 11 numbers

1436

Merchant Order ID

Order ID in merchant system

String, up to 80 characters

7059431

Guest Checkout

Was guest checkout used to create a subscription? (Y / N)

String, up to 128 characters

N

Email Address

Subscriber's e-mail address

String, up to 128 characters

john.doe@ordergroove.com

First Name

Subscriber's first name

String, up to 128 characters

john

Last Name

Subscriber's last name

String, up to 128 characters

doe

Product

Product name

String, up 10 1024 characters

Raw Hazelnuts - 1 pound bag

Product ID

Product ID

Int, up to 11 numbers

3064-09

SKU

Product SKU

String, up to 64 characters

3064-09

Frequency

Subscription order placement frequency (in days)

Smallint, up to 6 characters

28

Reminder

Subscription order reminder prior to order placement (in days)

Smallint, up to 6 characters

10

Status

Is the subscription is active or inactive?

String, up to 128 characters

Active

Quantity

Number of units within a subscription

Smallint, up to 5 characters

1

Price

Product price

Decimal, up to 99999999.99

12.99

Discount Price

Discount price for the product

Decimal, up to 99999999.99

12.99

24 Hour Cancel

Was the subscription canceled within 24 hours of creation time? (Y / N)

String, up to 128 characters

N

Cancel Date

Date subscription was canceled (MM/DD/YYYY)

Date, exactly 10 characters

02/09/2016

Cancel Reason

Reason subscription was canceled (Numbered code)

String, up to 512 characters

2|Has too many of product

Orders Placed

Number of orders placed over the life of the subscription (includes failed orders)

String

0

Last Order Date

Last order date of the subscription (MM/DD/YYYY) (includes failed orders)

Date, exactly 10 characters

02/09/2016

Public Subscription ID

Public Subscription ID in Ordergroove system

NOTE: This is not a default field so please inform Ordergroove if you would like it included

String, up to 40 characters

e1a84a68539a4b4ea85f2861cc63522f

Next Order Date

The date of the next upcoming order for the subscription (MM/DD/YYYY)

NOTE: This is not a default field so please inform Ordergroove if you would like it included

Date, exactly 10 characters

02/09/2021

Update Date 

The last date that the subscription was updated
(MM/DD/YYYY)

Date, exactly 10 characters

08/09/2022

Update Time

The last date and time that the subscription was updated
(MM/DD/YYYY HH:MM:SS)

Datetime, exactly 19 characters

08/09/2022 13:10:38